APPS.INV_LABEL_PVT8 dependencies on HZ_PARTY_SITES

Line 506: , hz_party_sites party_site

502: SELECT acct_site.cust_acct_site_id cust_site_id
503: from wsh_delivery_details wdd
504: , wsh_delivery_assignments wda
505: , hz_cust_site_uses_all hcsua
506: , hz_party_sites party_site
507: --, hz_loc_assignments loc_assign --13683119
508: , hz_locations loc
509: , hz_cust_acct_sites_all acct_site
510: where wdd.delivery_detail_id = wda.delivery_detail_id

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

1168: CURSOR c_phone_fax(p_location_id NUMBER, p_type VARCHAR2) IS
1169: SELECT hcp.phone_country_code||decode(hcp.phone_country_code, NULL, '',' ')||
1170: decode(hcp.phone_area_code,NULL,'','(')||hcp.phone_area_code||decode(hcp.phone_area_code,NULL,'',')')||
1171: hcp.phone_number customer_site_tel_number
1172: FROM hz_party_sites hps, hz_locations hl, hz_contact_points hcp
1173: WHERE hps.location_id = hl.location_id
1174: AND hcp.owner_table_name = 'HZ_PARTY_SITES'
1175: AND hcp.owner_table_id = hps.party_site_id
1176: AND (((hcp.phone_line_type IN ('PHONE','GEN')) AND (p_type = 'PHONE')) OR

Line 1174: AND hcp.owner_table_name = 'HZ_PARTY_SITES'

1170: decode(hcp.phone_area_code,NULL,'','(')||hcp.phone_area_code||decode(hcp.phone_area_code,NULL,'',')')||
1171: hcp.phone_number customer_site_tel_number
1172: FROM hz_party_sites hps, hz_locations hl, hz_contact_points hcp
1173: WHERE hps.location_id = hl.location_id
1174: AND hcp.owner_table_name = 'HZ_PARTY_SITES'
1175: AND hcp.owner_table_id = hps.party_site_id
1176: AND (((hcp.phone_line_type IN ('PHONE','GEN')) AND (p_type = 'PHONE')) OR
1177: ((hcp.phone_line_type IN ('FAX')) AND (p_type = 'FAX')))
1178: AND hps.location_id = p_location_id;