APPS.OPI_DBI_WMS_WAA_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 707: ,mtl_secondary_inventories sinv

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
711: ,1,wdth.source_subinventory_code

Line 788: ,mtl_secondary_inventories sinv

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
792: AND tasks.organization_id = sinv.organization_id

Line 1236: ,mtl_secondary_inventories sinv

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
1240: AND decode(wdth.task_type

Line 1316: ,mtl_secondary_inventories sinv

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
1320: AND wdth.organization_id = sinv.organization_id