APPS.INV_TRANSFER_ORDER_PVT dependencies on WSH_DELIVERY_DETAILS

Line 2363: FROM wsh_delivery_Details

2359: SELECT 1
2360: INTO l_unstaged_so_exists
2361: FROM dual
2362: WHERE EXISTS ( SELECT delivery_Detail_id
2363: FROM wsh_delivery_Details
2364: WHERE source_line_id = p_source_line_id
2365: AND released_status in ( 'B','R','S'));
2366: EXCEPTION
2367: WHEN NO_DATA_FOUND THEN

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

2385:
2386: SELECT 1
2387: INTO l_unstaged_so_exists
2388: FROM DUAL
2389: WHERE EXISTS( SELECT /*+ index(wsh_delivery_details WSH_DELIVERY_DETAILS_N3) */ delivery_detail_id
2390: FROM wsh_delivery_details
2391: WHERE source_line_id = p_source_line_id
2392: AND (released_status IN ('B','R','S')));
2393: EXCEPTION

Line 2390: FROM wsh_delivery_details

2386: SELECT 1
2387: INTO l_unstaged_so_exists
2388: FROM DUAL
2389: WHERE EXISTS( SELECT /*+ index(wsh_delivery_details WSH_DELIVERY_DETAILS_N3) */ delivery_detail_id
2390: FROM wsh_delivery_details
2391: WHERE source_line_id = p_source_line_id
2392: AND (released_status IN ('B','R','S')));
2393: EXCEPTION
2394: WHEN NO_DATA_FOUND THEN

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

4583: END IF;
4584:
4585: BEGIN
4586: /* BUG 5570553 added the index hint with the suggestion of apps performance team */
4587: SELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/
4588: delivery_detail_id, source_header_id, source_line_id
4589: INTO l_delivery_detail_id, l_source_header_id, l_source_line_id
4590: FROM wsh_delivery_details WDD
4591: WHERE WDD.move_order_line_id = l_mmtt_rec.move_order_line_id

Line 4590: FROM wsh_delivery_details WDD

4586: /* BUG 5570553 added the index hint with the suggestion of apps performance team */
4587: SELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/
4588: delivery_detail_id, source_header_id, source_line_id
4589: INTO l_delivery_detail_id, l_source_header_id, l_source_line_id
4590: FROM wsh_delivery_details WDD
4591: WHERE WDD.move_order_line_id = l_mmtt_rec.move_order_line_id
4592: AND WDD.move_order_line_id IS NOT NULL
4593: AND WDD.released_status = 'S'
4594: FOR UPDATE NOWAIT;

Line 4688: FROM wsh_delivery_details wdd

4684: AND lpn_id=l_shipping_attr(1).transfer_lpn_id;
4685:
4686: SELECT wdd.released_status,wdd.delivery_detail_id
4687: INTO l_status_code,l_container_delivery_det_id
4688: FROM wsh_delivery_details wdd
4689: WHERE wdd.container_name =l_container_name
4690: AND wdd.released_status = 'X'; -- ER : 6845650
4691:
4692: if l_status_code ='C' then

Line 4736: /*UPDATE WSH_DELIVERY_DETAILS

4732: END IF;
4733: END IF;
4734:
4735:
4736: /*UPDATE WSH_DELIVERY_DETAILS
4737: SET CONTAINER_NAME=l_new_container_name,
4738: lpn_id=NULL,
4739: last_update_date=sysdate,
4740: last_updated_by=fnd_global.user_id,