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.EC_TRADING_PARTNER_PVT dependencies on HZ_CUST_ACCT_SITES

Line 35: from hz_cust_acct_sites cas,

31:
32: cursor ra_add is
33: select cas.cust_account_id ,
34: cas.cust_acct_site_id
35: from hz_cust_acct_sites cas,
36: hz_cust_accounts ca,
37: hz_parties pt,
38: ece_tp_details etd
39: where

Line 280: from hz_cust_acct_sites cas,

276:
277: cursor ra_add is
278: select cas.cust_account_id ,
279: cas.cust_acct_site_id
280: from hz_cust_acct_sites cas,
281: hz_cust_accounts ca,
282: hz_parties pt,
283: ece_tp_headers eth
284: where

Line 516: from hz_cust_acct_sites cas,

512: select
513: cas.ece_tp_location_code,
514: ec.tp_reference_ext1,
515: ec.tp_reference_ext2
516: from hz_cust_acct_sites cas,
517: ece_tp_headers ec
518: where
519:
520: ec.tp_header_id = cas.tp_header_id

Line 742: from ece_tp_details tpd,hz_cust_acct_sites cas

738: x_tp_detail_id NUMBER;
739:
740: cursor type_customer is
741: select tpd.tp_detail_id
742: from ece_tp_details tpd,hz_cust_acct_sites cas
743: where tpd.tp_header_id = cas.tp_header_id
744: and tpd.document_id = p_transaction_type
745: and tpd.document_type = nvl(p_transaction_subtype,tpd.document_type)
746: and cas.cust_acct_site_id = p_entity_id;