APPS.WMS_CROSS_DOCK_PVT dependencies on OE_ORDER_LINES_ALL

Line 1603: select 1 from oe_order_lines_all oel

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 (
1603: select 1 from oe_order_lines_all oel
1604: where oel.line_id = wdd.source_line_id
1605: and nvl(oel.project_id,-9999) = nvl(l.project_id,-9999)
1606: and nvl(oel.task_id,-9999) = nvl(l.task_id,-9999)
1607: );

Line 1741: from oe_order_lines_all

1737: END IF;
1738: -- get damand source type
1739: select Nvl(order_source_id,1)
1740: into l_order_source_id
1741: from oe_order_lines_all
1742: where line_id = l_demand_info.oe_line_id;
1743:
1744: IF (l_debug = 1) THEN
1745: mydebug('dem src'||l_demand_source_type);