Thursday, 12 March 2020

Letter of Undertaking India Localization Oracle Cloud

select jieud.*  from
xle_etb_profiles  xep,
hz_parties  hp,
ZX_PARTY_TAX_PROFILE zptp,
ZX_REGISTRATIONS   zr,
JA_IN_EXPORT_LUT_HEADER jieuh,
JA_IN_EXPORT_LUT_DETAIL jieud
where xep.party_id=hp.party_id
and hp.party_id=zptp.party_id
and zptp.PARTY_TAX_PROFILE_ID=zr.PARTY_TAX_PROFILE_ID
and zr.REGISTRATION_ID=jieuh.REGISTRATION_ID
and jieuh.LETTER_UNDERTAKING_ID=jieud.LETTER_UNDERTAKING_ID