382: SELECT ph.segment1, pl.line_num, wwtt.transaction_temp_id,
383: wwtt.task_type_id
384: BULK COLLECT INTO l_source_header, l_line_number, l_temp_id,
385: l_task_type_id
386: FROM po_line_locations_trx_v pll,--CLM Changes, using CLM views instead of base tables
387: po_headers_trx_v ph,
388: po_lines_trx_v pl,
389: wms_waveplan_tasks_temp wwtt
390: WHERE pll.line_location_id = wwtt.reference_id
6003: THEN
6004: IF i = 1
6005: THEN
6006: l_from_generic :=
6007: l_from_generic || ', po_line_locations_trx_v pll';
6008: END IF;
6009:
6010: l_from_generic := l_from_generic || ', po_headers_trx_v ph';--CLM Changes, using CLM views instead of base tables
6011: l_from_generic := l_from_generic || ', po_lines_trx_v pl';