APPS.WSH_MAPPING_DATA dependencies on HZ_PARTY_SITES

Line 134: HZ_PARTY_SITES HPS

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

Line 155: HZ_PARTY_SITES HPS,

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

Line 657: FROM hz_party_sites hps,

653: /* Patchset I: Locations Project. Joining with wsh_locations_hz_v */
654: CURSOR phone_fax_cur(l_line_type VARCHAR2) IS
655: SELECT hcp.raw_phone_number,
656: hcp.url
657: FROM hz_party_sites hps,
658: hz_contact_points hcp,
659: wsh_locations_hz_v wlhz
660: WHERE HCP.CONTACT_POINT_TYPE = 'PHONE'
661: AND HCP.PHONE_LINE_TYPE=l_line_type

Line 662: AND HCP.OWNER_TABLE_NAME = 'HZ_PARTY_SITES'

658: hz_contact_points hcp,
659: wsh_locations_hz_v wlhz
660: WHERE HCP.CONTACT_POINT_TYPE = 'PHONE'
661: AND HCP.PHONE_LINE_TYPE=l_line_type
662: AND HCP.OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
663: AND HPS.PARTY_SITE_ID = HCP.OWNER_TABLE_ID
664: AND wlhz.wsh_location_id = p_loc_id
665: AND wlhz.source_location_id = hps.location_id
666: ORDER BY hcp.primary_flag desc;

Line 841: HZ_PARTY_SITES HPS,

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

Line 901: HZ_PARTY_SITES HPS,

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