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 203: ,MTL_SYSTEM_ITEMS msi

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

Line 345: ,MTL_SYSTEM_ITEMS msi

341: ,base.LOCATOR_ID
342: ,base.PROJECT_ID
343: ,base.TASK_ID
344: from MTL_ITEM_LOCATIONS omil
345: ,MTL_SYSTEM_ITEMS msi
346: ,WMS_TRX_DETAILS_TMP_V mptdtv
347: ,(
348: select msei.secondary_inventory_name subinventory_code --changed
349: ,mil.inventory_location_id locator_id

Line 489: ,MTL_SYSTEM_ITEMS msi

485: ,base.LOCATOR_ID
486: ,base.PROJECT_ID
487: ,base.TASK_ID
488: from MTL_ITEM_LOCATIONS omil
489: ,MTL_SYSTEM_ITEMS msi
490: ,WMS_TRX_DETAILS_TMP_V mptdtv
491: ,(
492: select msei.secondary_inventory_name subinventory_code -- changed
493: ,mil.inventory_location_id locator_id

Line 633: ,MTL_SYSTEM_ITEMS msi

629: ,base.LOCATOR_ID
630: ,base.PROJECT_ID
631: ,base.TASK_ID
632: from MTL_ITEM_LOCATIONS omil
633: ,MTL_SYSTEM_ITEMS msi
634: ,WMS_TRX_DETAILS_TMP_V mptdtv
635: ,(
636: select msei.secondary_inventory_name subinventory_code -- changed
637: ,mil.inventory_location_id locator_id

Line 779: ,MTL_SYSTEM_ITEMS msi

775: ,base.LOCATOR_ID
776: ,base.PROJECT_ID
777: ,base.TASK_ID
778: from MTL_ITEM_LOCATIONS omil
779: ,MTL_SYSTEM_ITEMS msi
780: ,WMS_TRX_DETAILS_TMP_V mptdtv
781: ,(
782: select msei.secondary_inventory_name subinventory_code -- changed
783: ,mil.inventory_location_id locator_id

Line 927: ,MTL_SYSTEM_ITEMS msi

923: ,base.LOCATOR_ID
924: ,base.PROJECT_ID
925: ,base.TASK_ID
926: from MTL_ITEM_LOCATIONS omil
927: ,MTL_SYSTEM_ITEMS msi
928: ,WMS_TRX_DETAILS_TMP_V mptdtv
929: ,(
930: select mil.subinventory_code subinventory_code
931: ,mil.inventory_location_id locator_id

Line 1076: ,MTL_SYSTEM_ITEMS msi

1072: ,base.LOCATOR_ID
1073: ,base.PROJECT_ID
1074: ,base.TASK_ID
1075: from MTL_ITEM_LOCATIONS omil
1076: ,MTL_SYSTEM_ITEMS msi
1077: ,WMS_TRX_DETAILS_TMP_V mptdtv
1078: ,(
1079: select mil.subinventory_code subinventory_code
1080: ,mil.inventory_location_id locator_id

Line 1226: ,MTL_SYSTEM_ITEMS msi

1222: ,base.LOCATOR_ID
1223: ,base.PROJECT_ID
1224: ,base.TASK_ID
1225: from MTL_ITEM_LOCATIONS omil
1226: ,MTL_SYSTEM_ITEMS msi
1227: ,WMS_TRX_DETAILS_TMP_V mptdtv
1228: ,(
1229: select mil.subinventory_code subinventory_code
1230: ,mil.inventory_location_id locator_id