APPS.WMS_PLAN_TASKS_PVT dependencies on OE_ORDER_LINES_ALL

Line 127: FROM oe_order_lines_all ool,

123: END IF;
124:
125: SELECT ooh.order_number, ool.line_number, wwtt.transaction_temp_id, wwtt.task_type_id
126: bulk collect INTO l_source_header, l_line_number, l_temp_id, l_task_type_id
127: FROM oe_order_lines_all ool,
128: oe_order_headers_all ooh,
129: wms_waveplan_tasks_temp wwtt
130: WHERE ool.line_id = wwtt.reference_id
131: AND ooh.header_id = ool.header_id

Line 3052: || ', oe_order_lines_all ool';

3048: ELSIF wms_plan_tasks_pvt.g_from_rma_header_id IS NOT NULL
3049: OR wms_plan_tasks_pvt.g_to_rma_header_id IS NOT NULL THEN
3050: l_inbound_from := l_inbound_from
3051: || ', oe_order_headers_all ooh'
3052: || ', oe_order_lines_all ool';
3053: ELSIF wms_plan_tasks_pvt.g_from_requisition_header_id IS NOT NULL
3054: OR wms_plan_tasks_pvt.g_to_requisition_header_id IS NOT NULL THEN
3055: l_inbound_from := l_inbound_from
3056: || ', rcv_shipment_headers rsh'

Line 3368: || ', (SELECT COUNT(line_id) line_sum, header_id FROM oe_order_lines_all ';

3364: OR wms_plan_tasks_pvt.g_to_number_of_order_lines IS NOT NULL
3365: THEN
3366: l_from_outbound :=
3367: l_from_outbound
3368: || ', (SELECT COUNT(line_id) line_sum, header_id FROM oe_order_lines_all ';
3369:
3370: IF wms_plan_tasks_pvt.g_customer_id IS NOT NULL
3371: THEN
3372: l_from_outbound :=