APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on HZ_CUST_ACCT_SITES_ALL

Line 10520: FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE,

10516: AND wdd.ship_to_site_use_id IS NOT NULL;
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

Line 10649: hz_cust_acct_sites_all hcas

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
10653: AND hps.party_site_id = hcas.party_site_id;

Line 10659: hz_cust_acct_sites_all hcas

10655:
10656: CURSOR c_get_shipto_cust_from_dlvy(p_delivery_id IN NUMBER) IS
10657: SELECT distinct hcas.cust_account_id
10658: FROM hz_cust_site_uses_all hcsu,
10659: hz_cust_acct_sites_all hcas
10660: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
10661: AND hcsu.site_use_id IN (SELECT DISTINCT wdd.ship_to_site_use_id
10662: FROM wsh_delivery_details wdd,
10663: wsh_delivery_assignments wda