DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 104: oe_order_headers_all ooh,

100:
101: SELECT ooh.order_number, ool.line_number, wwtt.transaction_temp_id, wwtt.task_type_id
102: bulk collect INTO l_source_header, l_line_number, l_temp_id, l_task_type_id
103: FROM oe_order_lines_all ool,
104: oe_order_headers_all ooh,
105: wms_waveplan_tasks_temp wwtt
106: WHERE ool.line_id = wwtt.reference_id
107: AND ooh.header_id = ool.header_id
108: AND wwtt.reference = 'ORDER_LINE_ID'

Line 2970: || ', oe_order_headers_all ooh'

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'
2971: || ', oe_order_lines_all ool';
2972: ELSIF wms_plan_tasks_pvt.g_from_requisition_header_id IS NOT NULL
2973: OR wms_plan_tasks_pvt.g_to_requisition_header_id IS NOT NULL THEN
2974: l_inbound_from := l_inbound_from