APPS.WMS_CROSS_DOCK_PVT dependencies on WSH_DELIVERY_DETAILS

Line 941: FROM wsh_delivery_details wdd

937: SELECT 2
938: , inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
939: , wdd.source_line_id
940: INTO l_source_type_id, l_source_header_id, l_source_line_id
941: FROM wsh_delivery_details wdd
942: WHERE wdd.delivery_detail_id = l_backorder_delivery_detail_id;
943: EXCEPTION
944: WHEN OTHERS THEN
945: IF (l_debug = 1) THEN

Line 1239: mydebug('***Calling wsh_delivery_details_grp.delivery_detail_action***');

1235:
1236: -- {{ call wsh_delivery_autocreate.delivery_detail_action }}
1237:
1238: IF (l_debug = 1) THEN
1239: mydebug('***Calling wsh_delivery_details_grp.delivery_detail_action***');
1240: mydebug('l_rec_attr_tab(1).delivery_detail_id = '||l_rec_attr_tab(1).delivery_detail_id );
1241: mydebug('l_action_prms.action_code = '||l_action_prms.action_code);
1242: mydebug('l_action_prms.delivery_id = '||l_action_prms.delivery_id);
1243: END IF;

Line 1245: wsh_delivery_details_grp.delivery_detail_action

1241: mydebug('l_action_prms.action_code = '||l_action_prms.action_code);
1242: mydebug('l_action_prms.delivery_id = '||l_action_prms.delivery_id);
1243: END IF;
1244:
1245: wsh_delivery_details_grp.delivery_detail_action
1246: (
1247: -- Standard Parameters
1248: p_api_version_number => 1.0,
1249: p_init_msg_list => fnd_api.g_false,

Line 1262: mydebug('***After calling wsh_delivery_details_grp.delivery_detail_action***');

1258: x_action_out_rec => l_action_out_rec
1259: );
1260:
1261: IF (l_debug = 1) THEN
1262: mydebug('***After calling wsh_delivery_details_grp.delivery_detail_action***');
1263: mydebug('x_return_status = '||l_return_status);
1264: mydebug('x_msg_count = '||l_msg_count);
1265: mydebug('x_msg_data = '||l_msg_data);
1266: END IF;

Line 1598: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t, wsh_delivery_details_ob_grp_v wdd

1594: SELECT
1595: l.line_id, l.backorder_delivery_detail_id,l.inventory_item_id,Nvl(crossdock_type,1)
1596: ,l.transaction_source_type_id,l.txn_source_id
1597: INTO l_mo_line_id,l_del_id,l_item_id,l_crossdock_type,l_transaction_source_type_id,l_txn_supply_source_id
1598: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t, wsh_delivery_details_ob_grp_v wdd
1599: WHERE t.transaction_temp_id=l_temp_id
1600: AND l.backorder_delivery_detail_id = wdd.delivery_detail_id
1601: AND t.move_order_line_id=l.line_id
1602: AND exists (

Line 2062: FROM Wsh_delivery_details

2058: WHERE delivery_detail_id=l_del_id;
2059:
2060: /*9695544.added below query*/
2061: SELECT requested_quantity INTO l_wdd_req_qty
2062: FROM Wsh_delivery_details
2063: WHERE delivery_detail_id=l_del_id;
2064:
2065: l_wdd_staged_qty := 0 ; --9695544
2066:

Line 2484: FROM wsh_delivery_details_ob_grp_v

2480: mydebug('Getting del detail id...');
2481: END IF;
2482: begin
2483: SELECT delivery_detail_id INTO l_lpn_del_detail_id
2484: FROM wsh_delivery_details_ob_grp_v
2485: WHERE lpn_id=l_transfer_lpn_id
2486: AND ROWNUM=1;
2487: EXCEPTION
2488: WHEN NO_DATA_FOUND THEN

Line 2532: FROM wsh_delivery_details

2528: -- should only be checked if there is another loop (lpn has a parent)
2529: IF ( parent_lpn_rec.parent_lpn_id IS NOT NULL ) THEN
2530: BEGIN
2531: SELECT 1 INTO l_ret
2532: FROM wsh_delivery_details
2533: WHERE lpn_id = parent_lpn_rec.lpn_id;
2534: EXCEPTION
2535: WHEN NO_DATA_FOUND THEN
2536: IF (l_debug = 1) THEN