DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on PO_HEADERS_TRX_V

Line 106: po_headers_trx_v ph,

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
110: AND pll.po_line_id = pl.po_line_id

Line 3046: || ', po_headers_trx_v ph'--CLM Changes, using CLM views instead of base tables

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
3047: ||', po_lines_trx_v pl';
3048: ELSIF wms_plan_tasks_pvt.g_from_rma_header_id IS NOT NULL
3049: OR wms_plan_tasks_pvt.g_to_rma_header_id IS NOT NULL THEN
3050: l_inbound_from := l_inbound_from