APPS.WSH_MAPPING_DATA dependencies on HZ_PARTY_SITES

Line 135: HZ_PARTY_SITES HPS

131: SELECT HCSU.LOCATION, HCSU.CONTACT_ID
132: FROM HZ_CUST_SITE_USES_ALL HCSU,
133: HZ_CUST_ACCT_SITES_ALL HCAS,
134: HZ_CUST_ACCOUNTS HCA,
135: HZ_PARTY_SITES HPS
136: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
137: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
138: AND HCAS.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
139: AND HCSU.SITE_USE_CODE = 'SHIP_TO'

Line 156: HZ_PARTY_SITES HPS,

152: p_org_id IN NUMBER) is
153: SELECT HCSU.LOCATION, HCSU.CONTACT_ID
154: FROM HZ_CUST_SITE_USES_ALL HCSU,
155: HZ_CUST_ACCT_SITES_ALL HCAS,
156: HZ_PARTY_SITES HPS,
157: HZ_CUST_ACCOUNTS HCA,
158: HZ_CUST_ACCT_RELATE_ALL HCAR
159: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
160: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID

Line 659: FROM hz_party_sites hps,

655: /* Patchset I: Locations Project. Joining with wsh_locations_hz_v */
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

Line 664: AND HCP.OWNER_TABLE_NAME = 'HZ_PARTY_SITES'

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'
665: AND HPS.PARTY_SITE_ID = HCP.OWNER_TABLE_ID
666: AND wlhz.wsh_location_id = p_loc_id
667: AND wlhz.source_location_id = hps.location_id
668: ORDER BY hcp.primary_flag desc;

Line 843: HZ_PARTY_SITES HPS,

839: SELECT HCSU.LOCATION --bug 3920178 , HP.PARTY_NAME, HP.PARTY_NUMBER
840: FROM
841: HZ_CUST_SITE_USES_ALL HCSU,
842: HZ_CUST_ACCT_SITES_ALL HCAS,
843: HZ_PARTY_SITES HPS,
844: HZ_CUST_ACCOUNTS HCA,
845: HZ_PARTIES HP,
846: WSH_LOCATIONS WL1
847: WHERE

Line 903: HZ_PARTY_SITES HPS,

899: p_org_id IN NUMBER) is
900: SELECT HCSU.LOCATION
901: FROM HZ_CUST_SITE_USES_ALL HCSU,
902: HZ_CUST_ACCT_SITES_ALL HCAS,
903: HZ_PARTY_SITES HPS,
904: HZ_CUST_ACCOUNTS HCA,
905: HZ_CUST_ACCT_RELATE_ALL HCAR
906: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
907: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID

Line 1401: hz_party_sites hps

1397: SELECT hcsu.location
1398: FROM hz_cust_site_uses_all hcsu,
1399: hz_cust_acct_sites_all hcas,
1400: hz_cust_accounts hca,
1401: hz_party_sites hps
1402: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
1403: AND hcas.party_site_id = hps.party_site_id
1404: AND hcas.cust_account_id = hca.cust_account_id
1405: AND hcsu.site_use_code = 'SHIP_TO'

Line 1421: hz_party_sites hps,

1417: c_org_id IN NUMBER) IS
1418: SELECT hcsu.location
1419: FROM hz_cust_site_uses_all hcsu,
1420: hz_cust_acct_sites_all hcas,
1421: hz_party_sites hps,
1422: hz_cust_accounts hca,
1423: hz_cust_acct_relate_all hcar
1424: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
1425: AND hcas.party_site_id = hps.party_site_id