APPS.INV_TRANSFER_ORDER_PVT dependencies on WSH_DELIVERY_DETAILS

Line 2350: FROM wsh_delivery_Details

2346: SELECT 1
2347: INTO l_unstaged_so_exists
2348: FROM dual
2349: WHERE EXISTS ( SELECT delivery_Detail_id
2350: FROM wsh_delivery_Details
2351: WHERE source_line_id = p_source_line_id
2352: AND released_status in ( 'B','R','S'));
2353: EXCEPTION
2354: WHEN NO_DATA_FOUND THEN

Line 2376: WHERE EXISTS( SELECT /*+ index(wsh_delivery_details WSH_DELIVERY_DETAILS_N3) */ delivery_detail_id

2372:
2373: SELECT 1
2374: INTO l_unstaged_so_exists
2375: FROM DUAL
2376: WHERE EXISTS( SELECT /*+ index(wsh_delivery_details WSH_DELIVERY_DETAILS_N3) */ delivery_detail_id
2377: FROM wsh_delivery_details
2378: WHERE source_line_id = p_source_line_id
2379: AND (released_status IN ('B','R','S')));
2380: EXCEPTION

Line 2377: FROM wsh_delivery_details

2373: SELECT 1
2374: INTO l_unstaged_so_exists
2375: FROM DUAL
2376: WHERE EXISTS( SELECT /*+ index(wsh_delivery_details WSH_DELIVERY_DETAILS_N3) */ delivery_detail_id
2377: FROM wsh_delivery_details
2378: WHERE source_line_id = p_source_line_id
2379: AND (released_status IN ('B','R','S')));
2380: EXCEPTION
2381: WHEN NO_DATA_FOUND THEN

Line 4251: SELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/

4247: END IF;
4248:
4249: BEGIN
4250: /* BUG 5570553 added the index hint with the suggestion of apps performance team */
4251: SELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/
4252: delivery_detail_id, source_header_id, source_line_id
4253: INTO l_delivery_detail_id, l_source_header_id, l_source_line_id
4254: FROM wsh_delivery_details WDD
4255: WHERE WDD.move_order_line_id = l_mmtt_rec.move_order_line_id

Line 4254: FROM wsh_delivery_details WDD

4250: /* BUG 5570553 added the index hint with the suggestion of apps performance team */
4251: SELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/
4252: delivery_detail_id, source_header_id, source_line_id
4253: INTO l_delivery_detail_id, l_source_header_id, l_source_line_id
4254: FROM wsh_delivery_details WDD
4255: WHERE WDD.move_order_line_id = l_mmtt_rec.move_order_line_id
4256: AND WDD.move_order_line_id IS NOT NULL
4257: AND WDD.released_status = 'S'
4258: FOR UPDATE NOWAIT;

Line 4352: FROM wsh_delivery_details wdd

4348: AND lpn_id=l_shipping_attr(1).transfer_lpn_id;
4349:
4350: SELECT wdd.released_status,wdd.delivery_detail_id
4351: INTO l_status_code,l_container_delivery_det_id
4352: FROM wsh_delivery_details wdd
4353: WHERE wdd.container_name =l_container_name
4354: AND wdd.released_status = 'X'; -- ER : 6845650
4355:
4356: if l_status_code ='C' then

Line 4400: /*UPDATE WSH_DELIVERY_DETAILS

4396: END IF;
4397: END IF;
4398:
4399:
4400: /*UPDATE WSH_DELIVERY_DETAILS
4401: SET CONTAINER_NAME=l_new_container_name,
4402: lpn_id=NULL,
4403: last_update_date=sysdate,
4404: last_updated_by=fnd_global.user_id,