DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 81: FROM po_line_locations_all pll,

77: l_task_type_id task_type_id_type;
78: BEGIN
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

Line 2961: l_inbound_from := l_inbound_from || ', po_line_locations_all pll';

2957: /* inbound specific from */
2958: IF wms_plan_tasks_pvt.g_from_po_header_id IS NOT NULL
2959: OR wms_plan_tasks_pvt.g_to_po_header_id IS NOT NULL THEN
2960: IF p_is_completed_rec = 0 THEN
2961: l_inbound_from := l_inbound_from || ', po_line_locations_all pll';
2962: END IF;
2963:
2964: l_inbound_from := l_inbound_from
2965: || ', po_headers_all ph'