DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 128: oe_order_headers_all ooh,

124:
125: SELECT ooh.order_number, ool.line_number, wwtt.transaction_temp_id, wwtt.task_type_id
126: bulk collect INTO l_source_header, l_line_number, l_temp_id, l_task_type_id
127: FROM oe_order_lines_all ool,
128: oe_order_headers_all ooh,
129: wms_waveplan_tasks_temp wwtt
130: WHERE ool.line_id = wwtt.reference_id
131: AND ooh.header_id = ool.header_id
132: AND wwtt.reference = 'ORDER_LINE_ID'

Line 3051: || ', oe_order_headers_all ooh'

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
3051: || ', oe_order_headers_all ooh'
3052: || ', oe_order_lines_all ool';
3053: ELSIF wms_plan_tasks_pvt.g_from_requisition_header_id IS NOT NULL
3054: OR wms_plan_tasks_pvt.g_to_requisition_header_id IS NOT NULL THEN
3055: l_inbound_from := l_inbound_from