APPS.ECE_TRADING_PARTNERS_PUB dependencies on HZ_PARTIES

Line 127: hz_parties pt

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
130: AND ca.party_id = pt.party_id;
131: ELSIF p_address_type = G_SUPPLIER THEN

Line 288: hcp.owner_table_name = 'HZ_PARTIES' AND

284: NVL(UPPER(hzl.address_lines_phonetic),' ') LIKE NVL(UPPER(cp_address_line_alt_in),'%') AND
285: NVL(UPPER(cbb.city),' ') LIKE NVL(UPPER(cp_city_in),'%') AND
286: NVL(UPPER(cbb.zip),' ') LIKE NVL(UPPER(cp_zip_in),'%') AND
287: hcp.owner_table_id = cbb.branch_party_id AND
288: hcp.owner_table_name = 'HZ_PARTIES' AND
289: hcp.contact_point_type = 'EDI' AND
290: hps.party_id = cbb.branch_party_id AND
291: hps.identifying_address_flag = 'Y' AND
292: hzl.location_id = hps.party_id;

Line 327: hcp.owner_table_name = 'HZ_PARTIES' 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
326: hcp.owner_table_id = cbb.branch_party_id AND
327: hcp.owner_table_name = 'HZ_PARTIES' AND
328: hcp.contact_point_type = 'EDI' AND
329: hps.party_id = cbb.branch_party_id AND
330: hps.identifying_address_flag = 'Y' AND
331: hzl.location_id = hps.party_id;

Line 679: hz_parties pt

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
681: -- cas.cust_acct_site_id = NVL(cp_address_id_in,cas.cust_acct_site_id) AND
682: NVL(UPPER(cas.ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND
683: NVL(UPPER(loc.address1),' ') LIKE NVL(UPPER(cp_address_line1_in),'%') AND

Line 891: hcp.owner_table_name = 'HZ_PARTIES' AND

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
893: hps.party_id = cbb.branch_party_id AND
894: hps.identifying_address_flag = 'Y' AND
895: hzl.location_id = hps.party_id;

Line 2910: hz_parties pt,

2906: select cas.cust_account_id,
2907: cas.cust_acct_site_id
2908: from hz_cust_acct_sites cas,
2909: hz_cust_accounts ca,
2910: hz_parties pt,
2911: ece_tp_details etd
2912: where
2913: etd.translator_code = p_translator_code
2914: and cas.ece_tp_location_code = p_location_code_ext

Line 2941: and hcp.owner_table_name = 'HZ_PARTIES'

2937: etd.translator_code = p_translator_code
2938: and hcp.edi_ece_tp_location_code = p_location_code_ext
2939: and etd.tp_header_id = hcp.edi_tp_header_id
2940: and hcp.owner_table_id = cbb.branch_party_id
2941: and hcp.owner_table_name = 'HZ_PARTIES'
2942: and hcp.contact_point_type = 'EDI';
2943:
2944: BEGIN
2945:

Line 3135: hz_parties pt,

3131: select cas.cust_account_id,
3132: cas.cust_acct_site_id
3133: from hz_cust_acct_sites cas,
3134: hz_cust_accounts ca,
3135: hz_parties pt,
3136: ece_tp_headers eth
3137: where
3138: eth.tp_reference_ext1 = p_reference_ext1
3139: and eth.tp_reference_ext2 = p_reference_ext2

Line 3164: and hcp.owner_table_name = 'HZ_PARTIES'

3160: eth.tp_reference_ext1 = p_reference_ext1
3161: and eth.tp_reference_ext2 = p_reference_ext2
3162: and eth.tp_header_id = hcp.edi_tp_header_id
3163: and hcp.owner_table_id = cbb.branch_party_id
3164: and hcp.owner_table_name = 'HZ_PARTIES'
3165: and hcp.contact_point_type = 'EDI';
3166:
3167: BEGIN
3168:

Line 3377: and hcp.owner_table_name = 'HZ_PARTIES'

3373: where
3374: cbb.branch_party_id = p_entity_address_id
3375: and hcp.edi_tp_header_id = ec.tp_header_id
3376: and hcp.owner_table_id = cbb.branch_party_id
3377: and hcp.owner_table_name = 'HZ_PARTIES'
3378: and hcp.contact_point_type = 'EDI';
3379:
3380: BEGIN
3381: