DBA Data[Home] [Help]

APPS.WMS_RULE_11 dependencies on MTL_LOT_NUMBERS

Line 61: ,MTL_LOT_NUMBERS mln

57: ,base.PROJECT_ID
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

Line 196: ,MTL_LOT_NUMBERS mln

192: ,base.PROJECT_ID
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

Line 330: ,MTL_LOT_NUMBERS mln

326: ,base.PROJECT_ID
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

Line 466: ,MTL_LOT_NUMBERS mln

462: ,base.PROJECT_ID
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

Line 602: ,MTL_LOT_NUMBERS mln

598: ,base.PROJECT_ID
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

Line 740: ,MTL_LOT_NUMBERS mln

736: ,base.PROJECT_ID
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

Line 880: ,MTL_LOT_NUMBERS mln

876: ,base.PROJECT_ID
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

Line 1021: ,MTL_LOT_NUMBERS mln

1017: ,base.PROJECT_ID
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

Line 1163: ,MTL_LOT_NUMBERS mln

1159: ,base.PROJECT_ID
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