APPS.WMS_RULE_11 dependencies on MTL_SYSTEM_ITEMS

Line 62: ,MTL_SYSTEM_ITEMS msi

58: ,base.TASK_ID
59: from MTL_ITEM_LOCATIONS omil
60: ,MTL_SECONDARY_INVENTORIES omsei
61: ,MTL_LOT_NUMBERS mln
62: ,MTL_SYSTEM_ITEMS msi
63: ,WMS_TRX_DETAILS_TMP_V mptdtv
64: ,(
65: select msei.secondary_inventory_name subinventory_code --changed
66: ,mil.inventory_location_id locator_id

Line 197: ,MTL_SYSTEM_ITEMS msi

193: ,base.TASK_ID
194: from MTL_ITEM_LOCATIONS omil
195: ,MTL_SECONDARY_INVENTORIES omsei
196: ,MTL_LOT_NUMBERS mln
197: ,MTL_SYSTEM_ITEMS msi
198: ,WMS_TRX_DETAILS_TMP_V mptdtv
199: ,(
200: select msei.secondary_inventory_name subinventory_code --changed
201: ,mil.inventory_location_id locator_id

Line 331: ,MTL_SYSTEM_ITEMS msi

327: ,base.TASK_ID
328: from MTL_ITEM_LOCATIONS omil
329: ,MTL_SECONDARY_INVENTORIES omsei
330: ,MTL_LOT_NUMBERS mln
331: ,MTL_SYSTEM_ITEMS msi
332: ,WMS_TRX_DETAILS_TMP_V mptdtv
333: ,(
334: select msei.secondary_inventory_name subinventory_code --changed
335: ,mil.inventory_location_id locator_id

Line 467: ,MTL_SYSTEM_ITEMS msi

463: ,base.TASK_ID
464: from MTL_ITEM_LOCATIONS omil
465: ,MTL_SECONDARY_INVENTORIES omsei
466: ,MTL_LOT_NUMBERS mln
467: ,MTL_SYSTEM_ITEMS msi
468: ,WMS_TRX_DETAILS_TMP_V mptdtv
469: ,(
470: select msei.secondary_inventory_name subinventory_code -- changed
471: ,mil.inventory_location_id locator_id

Line 603: ,MTL_SYSTEM_ITEMS msi

599: ,base.TASK_ID
600: from MTL_ITEM_LOCATIONS omil
601: ,MTL_SECONDARY_INVENTORIES omsei
602: ,MTL_LOT_NUMBERS mln
603: ,MTL_SYSTEM_ITEMS msi
604: ,WMS_TRX_DETAILS_TMP_V mptdtv
605: ,(
606: select msei.secondary_inventory_name subinventory_code -- changed
607: ,mil.inventory_location_id locator_id

Line 741: ,MTL_SYSTEM_ITEMS msi

737: ,base.TASK_ID
738: from MTL_ITEM_LOCATIONS omil
739: ,MTL_SECONDARY_INVENTORIES omsei
740: ,MTL_LOT_NUMBERS mln
741: ,MTL_SYSTEM_ITEMS msi
742: ,WMS_TRX_DETAILS_TMP_V mptdtv
743: ,(
744: select msei.secondary_inventory_name subinventory_code -- changed
745: ,mil.inventory_location_id locator_id

Line 881: ,MTL_SYSTEM_ITEMS msi

877: ,base.TASK_ID
878: from MTL_ITEM_LOCATIONS omil
879: ,MTL_SECONDARY_INVENTORIES omsei
880: ,MTL_LOT_NUMBERS mln
881: ,MTL_SYSTEM_ITEMS msi
882: ,WMS_TRX_DETAILS_TMP_V mptdtv
883: ,(
884: select mil.subinventory_code subinventory_code
885: ,mil.inventory_location_id locator_id

Line 1022: ,MTL_SYSTEM_ITEMS msi

1018: ,base.TASK_ID
1019: from MTL_ITEM_LOCATIONS omil
1020: ,MTL_SECONDARY_INVENTORIES omsei
1021: ,MTL_LOT_NUMBERS mln
1022: ,MTL_SYSTEM_ITEMS msi
1023: ,WMS_TRX_DETAILS_TMP_V mptdtv
1024: ,(
1025: select mil.subinventory_code subinventory_code
1026: ,mil.inventory_location_id locator_id

Line 1164: ,MTL_SYSTEM_ITEMS msi

1160: ,base.TASK_ID
1161: from MTL_ITEM_LOCATIONS omil
1162: ,MTL_SECONDARY_INVENTORIES omsei
1163: ,MTL_LOT_NUMBERS mln
1164: ,MTL_SYSTEM_ITEMS msi
1165: ,WMS_TRX_DETAILS_TMP_V mptdtv
1166: ,(
1167: select mil.subinventory_code subinventory_code
1168: ,mil.inventory_location_id locator_id