APPS.WMS_CROSS_DOCK_PVT dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

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

1313: SELECT
1314: l.line_id, l.backorder_delivery_detail_id,l.inventory_item_id,Nvl(crossdock_type,1)
1315: ,l.transaction_source_type_id,l.txn_source_id
1316: INTO l_mo_line_id,l_del_id,l_item_id,l_crossdock_type,l_transaction_source_type_id,l_txn_supply_source_id
1317: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t, wsh_delivery_details_ob_grp_v wdd
1318: WHERE t.transaction_temp_id=l_temp_id
1319: AND l.backorder_delivery_detail_id = wdd.delivery_detail_id
1320: AND t.move_order_line_id=l.line_id
1321: AND exists (

Line 2128: FROM wsh_delivery_details_ob_grp_v

2124: mydebug('Getting del detail id...');
2125: END IF;
2126: begin
2127: SELECT delivery_detail_id INTO l_lpn_del_detail_id
2128: FROM wsh_delivery_details_ob_grp_v
2129: WHERE lpn_id=l_transfer_lpn_id
2130: AND ROWNUM=1;
2131: EXCEPTION
2132: WHEN NO_DATA_FOUND THEN