DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on PO_LINES_ALL

Line 83: po_lines_all pl,

79: SELECT ph.segment1, pl.line_num, wwtt.transaction_temp_id, wwtt.task_type_id
80: bulk collect INTO l_source_header, l_line_number, l_temp_id, l_task_type_id
81: FROM po_line_locations_all pll,
82: po_headers_all ph,
83: po_lines_all pl,
84: wms_waveplan_tasks_temp wwtt
85: WHERE pll.line_location_id = wwtt.reference_id
86: AND pll.po_line_id = pl.po_line_id
87: AND ph.po_header_id = pl.po_header_id

Line 2966: ||', po_lines_all pl';

2962: END IF;
2963:
2964: l_inbound_from := l_inbound_from
2965: || ', po_headers_all ph'
2966: ||', po_lines_all pl';
2967: ELSIF wms_plan_tasks_pvt.g_from_rma_header_id IS NOT NULL
2968: OR wms_plan_tasks_pvt.g_to_rma_header_id IS NOT NULL THEN
2969: l_inbound_from := l_inbound_from
2970: || ', oe_order_headers_all ooh'