APPS.WMS_CROSS_DOCK_PVT dependencies on OE_ORDER_LINES_ALL

Line 1322: select 1 from oe_order_lines_all oel

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 (
1322: select 1 from oe_order_lines_all oel
1323: where oel.line_id = wdd.source_line_id
1324: and nvl(oel.project_id,-9999) = nvl(l.project_id,-9999)
1325: and nvl(oel.task_id,-9999) = nvl(l.task_id,-9999)
1326: );

Line 1450: from oe_order_lines_all

1446: END IF;
1447: -- get damand source type
1448: select Nvl(order_source_id,1)
1449: into l_order_source_id
1450: from oe_order_lines_all
1451: where line_id = l_demand_info.oe_line_id;
1452:
1453: IF (l_debug = 1) THEN
1454: mydebug('dem src'||l_demand_source_type);