APPS.WSH_MAPPING_DATA dependencies on HZ_CONTACT_POINTS

Line 660: hz_contact_points hcp,

656: CURSOR phone_fax_cur(l_line_type VARCHAR2) IS
657: SELECT hcp.raw_phone_number,
658: hcp.url
659: FROM hz_party_sites hps,
660: hz_contact_points hcp,
661: wsh_locations_hz_v wlhz
662: WHERE HCP.CONTACT_POINT_TYPE = 'PHONE'
663: AND HCP.PHONE_LINE_TYPE=l_line_type
664: AND HCP.OWNER_TABLE_NAME = 'HZ_PARTY_SITES'

Line 1212: HZ_CONTACT_POINTS PHONE_CONTACT,

1208: HREL.PARTY_ID
1209: from HZ_CUST_ACCOUNT_ROLES HCAR,
1210: HZ_RELATIONSHIPS HREL,
1211: HZ_ORG_CONTACTS HOC,
1212: HZ_CONTACT_POINTS PHONE_CONTACT,
1213: HZ_PARTIES PER_CONTACT
1214: WHERE HCAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
1215: AND HREL.PARTY_ID = HCAR.PARTY_ID
1216: AND HCAR.ROLE_TYPE = 'CONTACT'

Line 1231: FROM HZ_CONTACT_POINTS

1227: AND PHONE_CONTACT.PRIMARY_FLAG(+) = 'Y';
1228:
1229: cursor l_ship_to_site_ph_csr(p_owner_tbl_id IN NUMBER) is
1230: SELECT RAW_PHONE_NUMBER
1231: FROM HZ_CONTACT_POINTS
1232: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
1233: AND OWNER_TABLE_ID = p_owner_tbl_id
1234: AND CONTACT_POINT_TYPE = 'PHONE'
1235: AND PHONE_LINE_TYPE = 'GEN';

Line 2736: HZ_CONTACT_POINTS PHONE_CONTACT,

2732: HREL.PARTY_ID
2733: from HZ_CUST_ACCOUNT_ROLES HCAR,
2734: HZ_RELATIONSHIPS HREL,
2735: HZ_ORG_CONTACTS HOC,
2736: HZ_CONTACT_POINTS PHONE_CONTACT,
2737: HZ_PARTIES PER_CONTACT
2738: WHERE HCAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
2739: AND HREL.PARTY_ID = HCAR.PARTY_ID
2740: AND HCAR.ROLE_TYPE = 'CONTACT'

Line 2755: FROM HZ_CONTACT_POINTS

2751: AND PHONE_CONTACT.PRIMARY_FLAG(+) = 'Y';
2752:
2753: cursor l_ship_to_site_ph_csr(p_owner_tbl_id IN NUMBER) is
2754: SELECT RAW_PHONE_NUMBER
2755: FROM HZ_CONTACT_POINTS
2756: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
2757: AND OWNER_TABLE_ID = p_owner_tbl_id
2758: AND CONTACT_POINT_TYPE = 'PHONE'
2759: AND PHONE_LINE_TYPE = 'GEN';