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
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