APPS.WMS_PLAN_TASKS_PVT dependencies on OE_ORDER_LINES_ALL

Line 103: FROM oe_order_lines_all ool,

99: END IF;
100:
101: SELECT ooh.order_number, ool.line_number, wwtt.transaction_temp_id, wwtt.task_type_id
102: bulk collect INTO l_source_header, l_line_number, l_temp_id, l_task_type_id
103: FROM oe_order_lines_all ool,
104: oe_order_headers_all ooh,
105: wms_waveplan_tasks_temp wwtt
106: WHERE ool.line_id = wwtt.reference_id
107: AND ooh.header_id = ool.header_id

Line 2971: || ', oe_order_lines_all ool';

2967: ELSIF wms_plan_tasks_pvt.g_from_rma_header_id IS NOT NULL
2968: OR wms_plan_tasks_pvt.g_to_rma_header_id IS NOT NULL THEN
2969: l_inbound_from := l_inbound_from
2970: || ', oe_order_headers_all ooh'
2971: || ', oe_order_lines_all ool';
2972: ELSIF wms_plan_tasks_pvt.g_from_requisition_header_id IS NOT NULL
2973: OR wms_plan_tasks_pvt.g_to_requisition_header_id IS NOT NULL THEN
2974: l_inbound_from := l_inbound_from
2975: || ', rcv_shipment_headers rsh'

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

3255: OR wms_plan_tasks_pvt.g_to_number_of_order_lines IS NOT NULL
3256: THEN
3257: l_from_outbound :=
3258: l_from_outbound
3259: || ', (SELECT COUNT(line_id) line_sum, header_id FROM oe_order_lines_all ';
3260:
3261: IF wms_plan_tasks_pvt.g_customer_id IS NOT NULL
3262: THEN
3263: l_from_outbound :=