DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on WMS_OP_OPERTN_INSTANCES_HIST

Line 216: FROM WMS_OP_OPERTN_INSTANCES_HIST wooih,

212: AND plans_tasks = wms_plan_tasks_pvt.g_plan_task_types(2)) wwtt
213: WHERE wooi.source_task_id = wwtt.transaction_temp_id
214: UNION ALL
215: SELECT wooih.operation_sequence,wwtt.transaction_temp_id
216: FROM WMS_OP_OPERTN_INSTANCES_HIST wooih,
217: (SELECT transaction_temp_id
218: FROM wms_waveplan_tasks_temp
219: WHERE status_id = 6
220: AND plans_tasks = wms_plan_tasks_pvt.g_plan_task_types(2)) wwtt