APPS.INV_LABEL_PVT8 dependencies on HZ_PARTY_SITES

Line 1074: FROM hz_party_sites hps, hz_locations hl, hz_contact_points hcp

1070: CURSOR c_phone_fax(p_location_id NUMBER, p_type VARCHAR2) IS
1071: SELECT hcp.phone_country_code||decode(hcp.phone_country_code, NULL, '',' ')||
1072: decode(hcp.phone_area_code,NULL,'','(')||hcp.phone_area_code||decode(hcp.phone_area_code,NULL,'',')')||
1073: hcp.phone_number customer_site_tel_number
1074: FROM hz_party_sites hps, hz_locations hl, hz_contact_points hcp
1075: WHERE hps.location_id = hl.location_id
1076: AND hcp.owner_table_name = 'HZ_PARTY_SITES'
1077: AND hcp.owner_table_id = hps.party_site_id
1078: AND (((hcp.phone_line_type IN ('PHONE','GEN')) AND (p_type = 'PHONE')) OR

Line 1076: AND hcp.owner_table_name = 'HZ_PARTY_SITES'

1072: decode(hcp.phone_area_code,NULL,'','(')||hcp.phone_area_code||decode(hcp.phone_area_code,NULL,'',')')||
1073: hcp.phone_number customer_site_tel_number
1074: FROM hz_party_sites hps, hz_locations hl, hz_contact_points hcp
1075: WHERE hps.location_id = hl.location_id
1076: AND hcp.owner_table_name = 'HZ_PARTY_SITES'
1077: AND hcp.owner_table_id = hps.party_site_id
1078: AND (((hcp.phone_line_type IN ('PHONE','GEN')) AND (p_type = 'PHONE')) OR
1079: ((hcp.phone_line_type IN ('FAX')) AND (p_type = 'FAX')))
1080: AND hps.location_id = p_location_id;