[Home] [Help]
55: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
150: ,mil.SUGGESTED_CUBIC_AREA
151: ,mil.SUGGESTED_WEIGHT
152: ,mil.LOCATION_SUGGESTED_UNITS
153: ,mil.rowid
154: from MTL_ITEM_LOCATIONS mil
155: ,MTL_SECONDARY_INVENTORIES msei
156: where mil.organization_id(+) = msei.organization_id
157: and mil.subinventory_code(+) = msei.secondary_inventory_name
158: and NVL(msei.disable_date, sysdate+1) > sysdate
200: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
295: ,mil.SUGGESTED_CUBIC_AREA
296: ,mil.SUGGESTED_WEIGHT
297: ,mil.LOCATION_SUGGESTED_UNITS
298: ,mil.rowid
299: from MTL_ITEM_LOCATIONS mil
300: ,MTL_SECONDARY_INVENTORIES msei
301: where mil.organization_id(+) = msei.organization_id
302: and mil.subinventory_code(+) = msei.secondary_inventory_name
303: and NVL(msei.disable_date, sysdate+1) > sysdate
344: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
439: ,mil.SUGGESTED_CUBIC_AREA
440: ,mil.SUGGESTED_WEIGHT
441: ,mil.LOCATION_SUGGESTED_UNITS
442: ,mil.rowid
443: from MTL_ITEM_LOCATIONS mil
444: ,MTL_SECONDARY_INVENTORIES msei
445: where mil.organization_id(+) = msei.organization_id
446: and mil.subinventory_code(+) = msei.secondary_inventory_name
447: and NVL(msei.disable_date, sysdate+1) > sysdate
490: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
585: ,mil.SUGGESTED_CUBIC_AREA
586: ,mil.SUGGESTED_WEIGHT
587: ,mil.LOCATION_SUGGESTED_UNITS
588: ,mil.rowid
589: from MTL_ITEM_LOCATIONS mil
590: ,MTL_SECONDARY_INVENTORIES msei
591: ,MTL_ITEM_SUB_INVENTORIES misi
592: where mil.organization_id(+) = msei.organization_id
593: and mil.organization_id=g_organization_id ---bug8425620 8665549
636: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
731: ,mil.SUGGESTED_CUBIC_AREA
732: ,mil.SUGGESTED_WEIGHT
733: ,mil.LOCATION_SUGGESTED_UNITS
734: ,mil.rowid
735: from MTL_ITEM_LOCATIONS mil
736: ,MTL_SECONDARY_INVENTORIES msei
737: ,MTL_ITEM_SUB_INVENTORIES misi
738: where mil.organization_id(+) = msei.organization_id
739: and mil.organization_id=g_organization_id ---bug8425620 8665549
784: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
879: ,mil.SUGGESTED_CUBIC_AREA
880: ,mil.SUGGESTED_WEIGHT
881: ,mil.LOCATION_SUGGESTED_UNITS
882: ,mil.rowid
883: from MTL_ITEM_LOCATIONS mil
884: ,MTL_SECONDARY_INVENTORIES msei
885: ,MTL_ITEM_SUB_INVENTORIES misi
886: where mil.organization_id(+) = msei.organization_id
887: and mil.organization_id=g_organization_id ---bug8425620 8665549
934: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
1029: ,mil.SUGGESTED_CUBIC_AREA
1030: ,mil.SUGGESTED_WEIGHT
1031: ,mil.LOCATION_SUGGESTED_UNITS
1032: ,mil.rowid
1033: from MTL_ITEM_LOCATIONS mil
1034: ,MTL_SECONDARY_INVENTORIES msei
1035: ,MTL_ITEM_SUB_INVENTORIES misi
1036: ,MTL_SECONDARY_LOCATORS msl
1037: where mil.organization_id = msei.organization_id
1085: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
1180: ,mil.SUGGESTED_CUBIC_AREA
1181: ,mil.SUGGESTED_WEIGHT
1182: ,mil.LOCATION_SUGGESTED_UNITS
1183: ,mil.rowid
1184: from MTL_ITEM_LOCATIONS mil
1185: ,MTL_SECONDARY_INVENTORIES msei
1186: ,MTL_ITEM_SUB_INVENTORIES misi
1187: ,MTL_SECONDARY_LOCATORS msl
1188: where mil.organization_id = msei.organization_id
1237: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
1332: ,mil.SUGGESTED_CUBIC_AREA
1333: ,mil.SUGGESTED_WEIGHT
1334: ,mil.LOCATION_SUGGESTED_UNITS
1335: ,mil.rowid
1336: from MTL_ITEM_LOCATIONS mil
1337: ,MTL_SECONDARY_INVENTORIES msei
1338: ,MTL_ITEM_SUB_INVENTORIES misi
1339: ,MTL_SECONDARY_LOCATORS msl
1340: where mil.organization_id = msei.organization_id