DBA Data[Home] [Help]

APPS.ECE_TRADING_PARTNERS_PUB dependencies on HZ_CONTACT_POINTS

Line 276: hz_contact_points hcp,

272: TO_CHAR(NULL) region_1,
273: TO_CHAR(NULL) region_2,
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

Line 319: hz_contact_points hcp,

315: TO_CHAR(NULL) region_2,
316: TO_CHAR(NULL) region_3
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

Line 886: hz_contact_points hcp,

882: x_region_1_out,
883: x_region_2_out,
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

Line 2935: hz_contact_points hcp

2931: cursor ap_bank is
2932: select cbb.branch_party_id
2933: from ce_bank_branches_v cbb,
2934: ece_tp_details etd,
2935: hz_contact_points hcp
2936: where
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

Line 3158: hz_contact_points hcp

3154: cursor ap_bank is
3155: select cbb.bank_party_id address_id
3156: from ce_bank_branches_v cbb,
3157: ece_tp_headers eth,
3158: hz_contact_points hcp
3159: where
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

Line 3372: hz_contact_points hcp

3368: select hcp.edi_ece_tp_location_code,
3369: ec.tp_reference_ext1,
3370: ec.tp_reference_ext2
3371: from ece_tp_headers ec, ce_bank_branches_v cbb,
3372: hz_contact_points hcp
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