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 6015: l_from_generic := l_from_generic || ', oe_order_headers_all ooh';

6011: l_from_generic := l_from_generic || ', po_lines_trx_v pl';
6012: ELSIF p_from_rma_header_id IS NOT NULL
6013: OR p_to_rma_header_id IS NOT NULL
6014: THEN
6015: l_from_generic := l_from_generic || ', oe_order_headers_all ooh';
6016: l_from_generic := l_from_generic || ', oe_order_lines_all ool';
6017: ELSIF p_from_requisition_header_id IS NOT NULL
6018: OR p_to_requisition_header_id IS NOT NULL
6019: THEN