eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_EXTRACT_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 2680: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;

2676: l_legal_contact_party_name xle_legal_contacts_v.contact_name%TYPE;
2677: l_bank_id NUMBER;
2678: l_bank_branch_id NUMBER;
2679: l_bank_account_num NUMBER;
2680: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;
2681: l_legal_contact_title xle_legal_contacts_v.title%TYPE;
2682: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;
2683: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%TYPE;
2684: l_activity_code xle_firstparty_information_v.activity_code%TYPE;

Line 2684: l_activity_code xle_firstparty_information_v.activity_code%TYPE;

2680: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;
2681: l_legal_contact_title xle_legal_contacts_v.title%TYPE;
2682: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;
2683: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%TYPE;
2684: l_activity_code xle_firstparty_information_v.activity_code%TYPE;
2685: l_sub_activity_code xle_firstparty_information_v.activity_code%TYPE;
2686: l_inception_date DATE;
2687: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;
2688: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;

Line 2685: l_sub_activity_code xle_firstparty_information_v.activity_code%TYPE;

2681: l_legal_contact_title xle_legal_contacts_v.title%TYPE;
2682: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;
2683: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%TYPE;
2684: l_activity_code xle_firstparty_information_v.activity_code%TYPE;
2685: l_sub_activity_code xle_firstparty_information_v.activity_code%TYPE;
2686: l_inception_date DATE;
2687: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;
2688: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;
2689: l_legal_auth_address_line3 xle_legalauth_v.address3%TYPE;

Line 2743: FROM xle_firstparty_information_v xle_firstpty

2739: -- xle_cont.contact_legal_id,
2740: -- xle_cont.title,
2741: -- xle_cont.job_title
2742: -- xle_cont.role
2743: FROM xle_firstparty_information_v xle_firstpty
2744: -- xle_legal_contacts_v xle_cont
2745: WHERE xle_firstpty.legal_entity_id = c_rep_entity_id;
2746: -- xle_firstpty.legal_entity_id = xle_cont.entity_id(+)
2747: