APPS.ECE_TRADING_PARTNERS_PUB dependencies on HZ_PARTY_SITES

Line 278: hz_party_sites hps

274: TO_CHAR(NULL) region_3
275: FROM ce_bank_branches_v cbb,
276: hz_contact_points hcp,
277: hz_locations hzl,
278: hz_party_sites hps
279: WHERE NVL(UPPER(hcp.edi_ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND
280: NVL(UPPER(cbb.address_line1),' ') LIKE NVL(UPPER(cp_address_line1_in),'%') AND
281: NVL(UPPER(cbb.address_line2),' ') LIKE NVL(UPPER(cp_address_line2_in),'%') AND
282: NVL(UPPER(cbb.address_line3),' ') LIKE NVL(UPPER(cp_address_line3_in),'%') AND

Line 321: hz_party_sites hps

317: FROM ce_bank_branches_v cbb,
318: ece_tp_details etd,
319: hz_contact_points hcp,
320: hz_locations hzl,
321: hz_party_sites hps
322: WHERE NVL(UPPER(hcp.edi_ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND
323: hcp.edi_tp_header_id = etd.tp_header_id AND
324: etd.document_id = UPPER(cp_transaction_type) AND
325: NVL(UPPER(etd.translator_code),' ') LIKE NVL(UPPER(cp_tp_translator_code),'%') AND

Line 432: hz_party_sites pts

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
436: NVL(UPPER(cas.ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%')

Line 553: hz_party_sites pts,

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
557: NVL(UPPER(cas.ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND

Line 676: hz_party_sites pts,

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
680: WHERE nvl(cas.org_id,-99) = NVL(cp_org_id_in,nvl(cas.org_id,-99)) AND

Line 888: hz_party_sites hps

884: x_region_3_out
885: FROM ce_bank_branches_v cbb,
886: hz_contact_points hcp,
887: hz_locations hzl,
888: hz_party_sites hps
889: WHERE cbb.branch_party_id = p_address_id_in AND
890: hcp.owner_table_id = cbb.branch_party_id AND
891: hcp.owner_table_name = 'HZ_PARTIES' AND
892: hcp.contact_point_type = 'EDI' AND

Line 1333: hz_party_sites pts,

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:
1337: WHERE cas.party_site_id = pts.party_site_id AND

Line 1448: FROM hz_party_sites pts,

1444: x_country_out,
1445: x_region_1_out,
1446: x_region_2_out,
1447: x_region_3_out
1448: FROM hz_party_sites pts,
1449: hz_locations loc
1450: WHERE pts.location_id = loc.location_id
1451: AND pts.party_site_id = r_addr_rec.party_site_id;
1452:

Line 1502: FROM hz_party_sites pts,

1498: x_country_out,
1499: x_region_1_out,
1500: x_region_2_out,
1501: x_region_3_out
1502: FROM hz_party_sites pts,
1503: hz_locations loc
1504: WHERE pts.location_id = loc.location_id
1505: AND pts.party_site_id = r_addr_rec.party_site_id;
1506:

Line 1541: FROM hz_party_sites pts,

1537: INTO
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));