APPS.OPI_DBI_WMS_WAA_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 706: ,mtl_system_items_b msi

702: WHEN wdth.task_type in (2,8) THEN wdth.dest_subinventory_code
703: END subinventory_code
704: ,wdth.transaction_temp_id transaction_temp_id
705: from wms_dispatched_tasks_history wdth
706: ,mtl_system_items_b msi
707: ,mtl_secondary_inventories sinv
708: where wdth.inventory_item_id = msi.inventory_item_id
709: AND wdth.organization_id = msi.organization_id
710: AND decode(wdth.task_type

Line 787: ,mtl_system_items_b msi

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
791: AND tasks.subinventory_code = sinv.secondary_inventory_name

Line 1235: ,mtl_system_items_b msi

1231: ,nvl(wdth.is_parent,'Y') is_parent
1232: ,wdth.source_subinventory_code subinventory_code
1233: ,wdth.transaction_temp_id transaction_temp_id
1234: from wms_dispatched_tasks_history wdth
1235: ,mtl_system_items_b msi
1236: ,mtl_secondary_inventories sinv
1237: ,opi_dbi_conc_prog_run_log log
1238: where wdth.inventory_item_id = msi.inventory_item_id
1239: AND wdth.organization_id = msi.organization_id

Line 1315: ,mtl_system_items_b msi

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
1319: AND wdth.dest_subinventory_code = sinv.secondary_inventory_name