DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on HZ_PARTY_SITES

Line 10521: HZ_PARTY_SITES PARTY_SITE,

10517:
10518: CURSOR c_ship_to_site_use(c_location_id IN NUMBER) IS
10519: SELECT SITE.SITE_USE_ID
10520: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
10521: HZ_PARTY_SITES PARTY_SITE,
10522: HZ_LOCATIONS LOC,
10523: HZ_CUST_SITE_USES_ALL SITE
10524: WHERE
10525: SITE.SITE_USE_CODE = 'SHIP_TO'

Line 10648: hz_party_sites hps,

10644:
10645: CURSOR c_get_shipto_cust_from_loc (p_location_id IN NUMBER) IS
10646: SELECT hcas.cust_account_id
10647: FROM wsh_locations wl,
10648: hz_party_sites hps,
10649: hz_cust_acct_sites_all hcas
10650: WHERE wl.wsh_location_id = p_location_id
10651: AND wl.location_source_code = 'HZ'
10652: AND wl.source_location_id = hps.location_id