DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on HZ_PARTY_SITES

Line 10717: HZ_PARTY_SITES PARTY_SITE,

10713:
10714: CURSOR c_ship_to_site_use(c_location_id IN NUMBER) IS
10715: SELECT SITE.SITE_USE_ID
10716: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
10717: HZ_PARTY_SITES PARTY_SITE,
10718: HZ_LOCATIONS LOC,
10719: HZ_CUST_SITE_USES_ALL SITE
10720: WHERE
10721: SITE.SITE_USE_CODE = 'SHIP_TO'

Line 10844: hz_party_sites hps,

10840:
10841: CURSOR c_get_shipto_cust_from_loc (p_location_id IN NUMBER) IS
10842: SELECT hcas.cust_account_id
10843: FROM wsh_locations wl,
10844: hz_party_sites hps,
10845: hz_cust_acct_sites_all hcas
10846: WHERE wl.wsh_location_id = p_location_id
10847: AND wl.location_source_code = 'HZ'
10848: AND wl.source_location_id = hps.location_id