APPS.WMS_CROSS_DOCK_PVT dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

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 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