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.ECE_TRADING_PARTNERS_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 125: FROM hz_cust_acct_sites_all cas,

121: SELECT cas.cust_account_id,pt.party_name, --Bug 2722334
122: ca.account_number
123: INTO x_entity_id_out,x_tp_location_name_out,
124: x_translator_code_out
125: FROM hz_cust_acct_sites_all cas,
126: hz_cust_accounts ca,
127: hz_parties pt
128: WHERE cas.cust_acct_site_id = x_address_id_out
129: AND cas.cust_account_id = ca.cust_account_id

Line 431: hz_cust_acct_sites_all cas ,

427:
428: /* Bug 2551002
429: cas.party_site_id = pts.party_site_id AND
430: pts.location_id = hrl.location_id;
431: hz_cust_acct_sites_all cas ,
432: hz_party_sites pts
433: WHERE nvl(cas.org_id,-99) = NVL(cp_org_id_in,nvl(cas.org_id,-99)) AND
434: Bug2422787
435: hrl.location_id = NVL(UPPER(cp_address_id_in,hrl.location_id) AND

Line 552: FROM hz_cust_acct_sites_all cas,

548: loc.country country,
549: TO_CHAR(NULL) region_1,
550: TO_CHAR(NULL) region_2,
551: TO_CHAR(NULL) region_3
552: FROM hz_cust_acct_sites_all cas,
553: hz_party_sites pts,
554: hz_locations loc
555: WHERE nvl(cas.org_id,-99) = NVL(cp_org_id_in,nvl(cas.org_id,-99)) AND
556: -- cas.cust_acct_site_id = NVL(cp_address_id_in,cas.cust_acct_site_id) AND

Line 578: FROM hz_cust_acct_sites_all cas

574: SELECT cas.org_id org_id,
575: cas.cust_acct_site_id address_id,
576: cas.ece_tp_location_code tp_location_code,
577: cas.party_site_id party_site_id
578: FROM hz_cust_acct_sites_all cas
579: WHERE nvl(cas.org_id,-99) = NVL(cp_org_id_in,nvl(cas.org_id,-99)) AND
580: NVL(UPPER(cas.ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') ;
581:
582: -- Bug 2708573

Line 630: FROM hz_cust_acct_sites_all cas,

626: SELECT cas.org_id org_id,
627: cas.cust_acct_site_id address_id,
628: cas.ece_tp_location_code tp_location_code,
629: cas.party_site_id party_site_id
630: FROM hz_cust_acct_sites_all cas,
631: ece_tp_details etd
632: WHERE nvl(cas.org_id,-99) = NVL(cp_org_id_in,nvl(cas.org_id,-99)) AND
633: NVL(UPPER(cas.ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND
634: cas.tp_header_id = etd.tp_header_id AND

Line 675: FROM hz_cust_acct_sites_all cas,

671: loc.country country,
672: TO_CHAR(NULL) region_1,
673: TO_CHAR(NULL) region_2,
674: TO_CHAR(NULL) region_3
675: FROM hz_cust_acct_sites_all cas,
676: hz_party_sites pts,
677: hz_locations loc,
678: hz_cust_accounts ca,
679: hz_parties pt

Line 1332: FROM hz_cust_acct_sites_all cas,

1328: x_country_out,
1329: x_region_1_out,
1330: x_region_2_out,
1331: x_region_3_out
1332: FROM hz_cust_acct_sites_all cas,
1333: hz_party_sites pts,
1334: hz_locations loc
1335:
1336:

Line 1542: hz_cust_acct_sites_all cas

1538: x_org_id_out,
1539: x_address_id_out,
1540: x_tp_location_code_out
1541: FROM hz_party_sites pts,
1542: hz_cust_acct_sites_all cas
1543: WHERE cas.party_site_id = pts.party_site_id
1544: AND pts.location_id = r_addr_rec.location_id
1545: AND nvl(cas.org_id,-99) = nvl(p_org_id_in,nvl(cas.org_id,-99));
1546: