DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on PO_LINE_LOCATIONS_TRX_V

Line 105: FROM po_line_locations_trx_v pll,--CLM Changes, using CLM views instead of base tables

101: -- End of Code added for Bug#8467334
102:
103: SELECT ph.segment1, pl.line_num, wwtt.transaction_temp_id, wwtt.task_type_id
104: bulk collect INTO l_source_header, l_line_number, l_temp_id, l_task_type_id
105: FROM po_line_locations_trx_v pll,--CLM Changes, using CLM views instead of base tables
106: po_headers_trx_v ph,
107: po_lines_trx_v pl,
108: wms_waveplan_tasks_temp wwtt
109: WHERE pll.line_location_id = wwtt.reference_id

Line 3042: l_inbound_from := l_inbound_from || ', po_line_locations_trx_v pll';

3038: /* inbound specific from */
3039: IF wms_plan_tasks_pvt.g_from_po_header_id IS NOT NULL
3040: OR wms_plan_tasks_pvt.g_to_po_header_id IS NOT NULL THEN
3041: IF p_is_completed_rec = 0 THEN
3042: l_inbound_from := l_inbound_from || ', po_line_locations_trx_v pll';
3043: END IF;
3044:
3045: l_inbound_from := l_inbound_from
3046: || ', po_headers_trx_v ph'--CLM Changes, using CLM views instead of base tables