DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 412: oe_order_headers_all ooh,

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
416: AND wwtt.REFERENCE = 'ORDER_LINE_ID'

Line 5227: l_from_generic := l_from_generic || ', oe_order_headers_all ooh';

5223: l_from_generic := l_from_generic || ', po_lines_all pl';
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