APPS.WSH_IB_UI_RECON_GRP dependencies on WSH_INBOUND_DEL_LINES_TEMP

Line 3302: -- the global temporary table wsh_inbound_del_lines_temp.

3298: l_pr_corr_rtv_count NUMBER := 0;
3299: l_corr_rtv_out_rec WSH_RCV_CORR_RTV_TXN_PKG.corr_rtv_out_rec_type;
3300:
3301: -- This cursor is used to obtain the matched delivery details from
3302: -- the global temporary table wsh_inbound_del_lines_temp.
3303: -- Please refer to the file WSHILTMP.sql for details about this table
3304: -- definition.
3305: cursor l_inbound_del_det_temp_csr is
3306: select delivery_detail_id,

Line 3342: from wsh_inbound_del_lines_temp;

3338: picked_quantity2,
3339: picked_quantity picked_quantity_db,
3340: picked_quantity2 picked_quantity2_db,
3341: dd_last_update_date
3342: from wsh_inbound_del_lines_temp;
3343:
3344: -- { IB-Phase-2
3345: cursor l_get_ship_from_of_header_csr is
3346: select ship_from_location_id

Line 3449: update wsh_inbound_del_lines_temp

3445:
3446:
3447: IF l_header_ship_from_loc_id IS NOT NULL
3448: THEN
3449: update wsh_inbound_del_lines_temp
3450: set ship_from_location_id = l_header_ship_from_loc_id
3451: where ship_from_location_id is null
3452: or ship_from_location_id = WSH_UTIL_CORE.C_NULL_SF_LOCN_ID;
3453: END IF;