DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on XLE_REGISTRATIONS

Line 131: , xle_registrations xle_reg

127: IS
128: SELECT xle_auth.city tax_office_location
129: ,xle_auth.address3 tax_office_code
130: FROM XLE_FIRSTPARTY_INFORMATION_V xfpiv
131: , xle_registrations xle_reg
132: , xle_legalauth_v xle_auth
133: WHERE xle_reg.source_id = xfpiv.legal_entity_id
134: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'
135: AND xle_auth.legalauth_id (+) = xle_reg.issuing_authority_id