DBA Data[Home] [Help]

APPS.WMS_RULE_8 dependencies on MTL_SYSTEM_ITEMS

Line 60: ,MTL_SYSTEM_ITEMS msi

56: ,base.LOCATOR_ID
57: ,base.PROJECT_ID
58: ,base.TASK_ID
59: from MTL_ITEM_LOCATIONS omil
60: ,MTL_SYSTEM_ITEMS msi
61: ,WMS_TRX_DETAILS_TMP_V mptdtv
62: ,(
63: select msei.secondary_inventory_name subinventory_code --changed
64: ,mil.inventory_location_id locator_id

Line 205: ,MTL_SYSTEM_ITEMS msi

201: ,base.LOCATOR_ID
202: ,base.PROJECT_ID
203: ,base.TASK_ID
204: from MTL_ITEM_LOCATIONS omil
205: ,MTL_SYSTEM_ITEMS msi
206: ,WMS_TRX_DETAILS_TMP_V mptdtv
207: ,(
208: select msei.secondary_inventory_name subinventory_code --changed
209: ,mil.inventory_location_id locator_id

Line 349: ,MTL_SYSTEM_ITEMS msi

345: ,base.LOCATOR_ID
346: ,base.PROJECT_ID
347: ,base.TASK_ID
348: from MTL_ITEM_LOCATIONS omil
349: ,MTL_SYSTEM_ITEMS msi
350: ,WMS_TRX_DETAILS_TMP_V mptdtv
351: ,(
352: select msei.secondary_inventory_name subinventory_code --changed
353: ,mil.inventory_location_id locator_id

Line 495: ,MTL_SYSTEM_ITEMS msi

491: ,base.LOCATOR_ID
492: ,base.PROJECT_ID
493: ,base.TASK_ID
494: from MTL_ITEM_LOCATIONS omil
495: ,MTL_SYSTEM_ITEMS msi
496: ,WMS_TRX_DETAILS_TMP_V mptdtv
497: ,(
498: select msei.secondary_inventory_name subinventory_code -- changed
499: ,mil.inventory_location_id locator_id

Line 641: ,MTL_SYSTEM_ITEMS msi

637: ,base.LOCATOR_ID
638: ,base.PROJECT_ID
639: ,base.TASK_ID
640: from MTL_ITEM_LOCATIONS omil
641: ,MTL_SYSTEM_ITEMS msi
642: ,WMS_TRX_DETAILS_TMP_V mptdtv
643: ,(
644: select msei.secondary_inventory_name subinventory_code -- changed
645: ,mil.inventory_location_id locator_id

Line 789: ,MTL_SYSTEM_ITEMS msi

785: ,base.LOCATOR_ID
786: ,base.PROJECT_ID
787: ,base.TASK_ID
788: from MTL_ITEM_LOCATIONS omil
789: ,MTL_SYSTEM_ITEMS msi
790: ,WMS_TRX_DETAILS_TMP_V mptdtv
791: ,(
792: select msei.secondary_inventory_name subinventory_code -- changed
793: ,mil.inventory_location_id locator_id

Line 939: ,MTL_SYSTEM_ITEMS msi

935: ,base.LOCATOR_ID
936: ,base.PROJECT_ID
937: ,base.TASK_ID
938: from MTL_ITEM_LOCATIONS omil
939: ,MTL_SYSTEM_ITEMS msi
940: ,WMS_TRX_DETAILS_TMP_V mptdtv
941: ,(
942: select mil.subinventory_code subinventory_code
943: ,mil.inventory_location_id locator_id

Line 1090: ,MTL_SYSTEM_ITEMS msi

1086: ,base.LOCATOR_ID
1087: ,base.PROJECT_ID
1088: ,base.TASK_ID
1089: from MTL_ITEM_LOCATIONS omil
1090: ,MTL_SYSTEM_ITEMS msi
1091: ,WMS_TRX_DETAILS_TMP_V mptdtv
1092: ,(
1093: select mil.subinventory_code subinventory_code
1094: ,mil.inventory_location_id locator_id

Line 1242: ,MTL_SYSTEM_ITEMS msi

1238: ,base.LOCATOR_ID
1239: ,base.PROJECT_ID
1240: ,base.TASK_ID
1241: from MTL_ITEM_LOCATIONS omil
1242: ,MTL_SYSTEM_ITEMS msi
1243: ,WMS_TRX_DETAILS_TMP_V mptdtv
1244: ,(
1245: select mil.subinventory_code subinventory_code
1246: ,mil.inventory_location_id locator_id