[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
198: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
293: ,mil.SUGGESTED_CUBIC_AREA
294: ,mil.SUGGESTED_WEIGHT
295: ,mil.LOCATION_SUGGESTED_UNITS
296: ,mil.rowid
297: from MTL_ITEM_LOCATIONS mil
298: ,MTL_SECONDARY_INVENTORIES msei
299: where mil.organization_id(+) = msei.organization_id
300: and mil.subinventory_code(+) = msei.secondary_inventory_name
301: and NVL(msei.disable_date, sysdate+1) > sysdate
340: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
435: ,mil.SUGGESTED_CUBIC_AREA
436: ,mil.SUGGESTED_WEIGHT
437: ,mil.LOCATION_SUGGESTED_UNITS
438: ,mil.rowid
439: from MTL_ITEM_LOCATIONS mil
440: ,MTL_SECONDARY_INVENTORIES msei
441: where mil.organization_id(+) = msei.organization_id
442: and mil.subinventory_code(+) = msei.secondary_inventory_name
443: and NVL(msei.disable_date, sysdate+1) > sysdate
484: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
579: ,mil.SUGGESTED_CUBIC_AREA
580: ,mil.SUGGESTED_WEIGHT
581: ,mil.LOCATION_SUGGESTED_UNITS
582: ,mil.rowid
583: from MTL_ITEM_LOCATIONS mil
584: ,MTL_SECONDARY_INVENTORIES msei
585: ,MTL_ITEM_SUB_INVENTORIES misi
586: where mil.organization_id(+) = msei.organization_id
587: and mil.subinventory_code(+) = msei.secondary_inventory_name
628: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
723: ,mil.SUGGESTED_CUBIC_AREA
724: ,mil.SUGGESTED_WEIGHT
725: ,mil.LOCATION_SUGGESTED_UNITS
726: ,mil.rowid
727: from MTL_ITEM_LOCATIONS mil
728: ,MTL_SECONDARY_INVENTORIES msei
729: ,MTL_ITEM_SUB_INVENTORIES misi
730: where mil.organization_id(+) = msei.organization_id
731: and mil.subinventory_code(+) = msei.secondary_inventory_name
774: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
869: ,mil.SUGGESTED_CUBIC_AREA
870: ,mil.SUGGESTED_WEIGHT
871: ,mil.LOCATION_SUGGESTED_UNITS
872: ,mil.rowid
873: from MTL_ITEM_LOCATIONS mil
874: ,MTL_SECONDARY_INVENTORIES msei
875: ,MTL_ITEM_SUB_INVENTORIES misi
876: where mil.organization_id(+) = msei.organization_id
877: and mil.subinventory_code(+) = msei.secondary_inventory_name
922: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
1017: ,mil.SUGGESTED_CUBIC_AREA
1018: ,mil.SUGGESTED_WEIGHT
1019: ,mil.LOCATION_SUGGESTED_UNITS
1020: ,mil.rowid
1021: from MTL_ITEM_LOCATIONS mil
1022: ,MTL_SECONDARY_INVENTORIES msei
1023: ,MTL_ITEM_SUB_INVENTORIES misi
1024: ,MTL_SECONDARY_LOCATORS msl
1025: where mil.organization_id = msei.organization_id
1071: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
1166: ,mil.SUGGESTED_CUBIC_AREA
1167: ,mil.SUGGESTED_WEIGHT
1168: ,mil.LOCATION_SUGGESTED_UNITS
1169: ,mil.rowid
1170: from MTL_ITEM_LOCATIONS mil
1171: ,MTL_SECONDARY_INVENTORIES msei
1172: ,MTL_ITEM_SUB_INVENTORIES misi
1173: ,MTL_SECONDARY_LOCATORS msl
1174: where mil.organization_id = msei.organization_id
1221: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
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
1316: ,mil.SUGGESTED_CUBIC_AREA
1317: ,mil.SUGGESTED_WEIGHT
1318: ,mil.LOCATION_SUGGESTED_UNITS
1319: ,mil.rowid
1320: from MTL_ITEM_LOCATIONS mil
1321: ,MTL_SECONDARY_INVENTORIES msei
1322: ,MTL_ITEM_SUB_INVENTORIES misi
1323: ,MTL_SECONDARY_LOCATORS msl
1324: where mil.organization_id = msei.organization_id