APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on OE_ORDER_LINES_ALL

Line 411: FROM oe_order_lines_all ool,

407: SELECT ooh.order_number, ool.line_number, wwtt.transaction_temp_id,
408: wwtt.task_type_id
409: BULK COLLECT INTO l_source_header, l_line_number, l_temp_id,
410: l_task_type_id
411: FROM oe_order_lines_all ool,
412: oe_order_headers_all ooh,
413: wms_waveplan_tasks_temp wwtt
414: WHERE ool.line_id = wwtt.reference_id
415: AND ooh.header_id = ool.header_id

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

4160: OR p_to_number_of_order_lines IS NOT NULL
4161: THEN
4162: l_from_outbound :=
4163: l_from_outbound
4164: || ', (SELECT COUNT(line_id) line_sum, header_id FROM oe_order_lines_all ';
4165:
4166: IF p_customer_id IS NOT NULL
4167: THEN
4168: l_from_outbound :=

Line 5228: l_from_generic := l_from_generic || ', oe_order_lines_all ool';

5224: ELSIF p_from_rma_header_id IS NOT NULL
5225: OR p_to_rma_header_id IS NOT NULL
5226: THEN
5227: l_from_generic := l_from_generic || ', oe_order_headers_all ooh';
5228: l_from_generic := l_from_generic || ', oe_order_lines_all ool';
5229: ELSIF p_from_requisition_header_id IS NOT NULL
5230: OR p_to_requisition_header_id IS NOT NULL
5231: THEN
5232: l_from_generic := l_from_generic || ', rcv_shipment_headers rsh';