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 2219: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;

2215: l_legal_contact_party_name xle_legal_contacts_v.contact_name%TYPE;
2216: l_bank_id NUMBER;
2217: l_bank_branch_id NUMBER;
2218: l_bank_account_num NUMBER;
2219: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;
2220: l_legal_contact_title xle_legal_contacts_v.title%TYPE;
2221: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;
2222: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%TYPE;
2223: l_activity_code xle_firstparty_information_v.activity_code%TYPE;

Line 2223: l_activity_code xle_firstparty_information_v.activity_code%TYPE;

2219: l_taxpayer_id xle_firstparty_information_v.REGISTRATION_NUMBER%TYPE;
2220: l_legal_contact_title xle_legal_contacts_v.title%TYPE;
2221: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;
2222: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%TYPE;
2223: l_activity_code xle_firstparty_information_v.activity_code%TYPE;
2224: l_sub_activity_code xle_firstparty_information_v.activity_code%TYPE;
2225: l_inception_date DATE;
2226: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;
2227: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;

Line 2224: l_sub_activity_code xle_firstparty_information_v.activity_code%TYPE;

2220: l_legal_contact_title xle_legal_contacts_v.title%TYPE;
2221: --l_legal_contact_job_title xle_legal_contacts_v.job_title%TYPE;
2222: l_legal_contact_job_title varchar2(13);--xle_legal_contacts_v.role%TYPE;
2223: l_activity_code xle_firstparty_information_v.activity_code%TYPE;
2224: l_sub_activity_code xle_firstparty_information_v.activity_code%TYPE;
2225: l_inception_date DATE;
2226: l_legal_contact_party_num xle_legal_contacts_v.contact_legal_id%TYPE;
2227: l_legal_auth_address_line2 xle_legalauth_v.address2%TYPE;
2228: l_legal_auth_address_line3 xle_legalauth_v.address3%TYPE;

Line 2282: FROM xle_firstparty_information_v xle_firstpty

2278: -- xle_cont.contact_legal_id,
2279: -- xle_cont.title,
2280: -- xle_cont.job_title
2281: -- xle_cont.role
2282: FROM xle_firstparty_information_v xle_firstpty
2283: -- xle_legal_contacts_v xle_cont
2284: WHERE xle_firstpty.legal_entity_id = c_rep_entity_id;
2285: -- xle_firstpty.legal_entity_id = xle_cont.entity_id(+)
2286: