DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on WMS_OP_OPERTN_INSTANCES_HIST

Line 192: FROM WMS_OP_OPERTN_INSTANCES_HIST wooih,

188: AND plans_tasks = wms_plan_tasks_pvt.g_plan_task_types(2)) wwtt
189: WHERE wooi.source_task_id = wwtt.transaction_temp_id
190: UNION ALL
191: SELECT wooih.operation_sequence,wwtt.transaction_temp_id
192: FROM WMS_OP_OPERTN_INSTANCES_HIST wooih,
193: (SELECT transaction_temp_id
194: FROM wms_waveplan_tasks_temp
195: WHERE status_id = 6
196: AND plans_tasks = wms_plan_tasks_pvt.g_plan_task_types(2)) wwtt