DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on PO_LINES_ALL

Line 388: po_lines_all pl,

384: BULK COLLECT INTO l_source_header, l_line_number, l_temp_id,
385: l_task_type_id
386: FROM po_line_locations_all pll,
387: po_headers_all ph,
388: po_lines_all pl,
389: wms_waveplan_tasks_temp wwtt
390: WHERE pll.line_location_id = wwtt.reference_id
391: AND pll.po_line_id = pl.po_line_id
392: AND ph.po_header_id = pl.po_header_id

Line 5223: l_from_generic := l_from_generic || ', po_lines_all pl';

5219: l_from_generic || ', po_line_locations_all pll';
5220: END IF;
5221:
5222: l_from_generic := l_from_generic || ', po_headers_all ph';
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';