DBA Data[Home] [Help]

APPS.OPI_DBI_WMS_WAA_PKG dependencies on WMS_OP_PLANS_B

Line 786: ,wms_op_plans_b wop

782: ,( woiph.plan_execution_end_date
783: - woiph.plan_execution_start_date)*24 plan_elapsed_time
784: FROM opi_dbi_wms_tasks_stg tasks
785: ,wms_op_plan_instances_hist woiph
786: ,wms_op_plans_b wop
787: ,mtl_system_items_b msi
788: ,mtl_secondary_inventories sinv
789: WHERE tasks.op_plan_instance_id = woiph.op_plan_instance_id
790: AND woiph.operation_plan_id = wop.operation_plan_id

Line 1314: ,wms_op_plans_b wop

1310: - wopih.plan_execution_start_date)*24 plan_elapsed_time
1311: FROM wms_dispatched_tasks_history wdth
1312: ,opi_dbi_conc_prog_run_log log
1313: ,wms_op_plan_instances_hist wopih
1314: ,wms_op_plans_b wop
1315: ,mtl_system_items_b msi
1316: ,mtl_secondary_inventories sinv
1317: WHERE wdth.op_plan_instance_id = wopih.op_plan_instance_id
1318: AND wopih.operation_plan_id = wop.operation_plan_id