[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_SECONDARY_INVENTORIES omsei
61: ,MTL_LOT_NUMBERS mln
62: ,MTL_SYSTEM_ITEMS msi
63: ,WMS_TRX_DETAILS_TMP_V mptdtv
152: ,mil.SUGGESTED_CUBIC_AREA
153: ,mil.SUGGESTED_WEIGHT
154: ,mil.LOCATION_SUGGESTED_UNITS
155: ,mil.rowid
156: from MTL_ITEM_LOCATIONS mil
157: ,MTL_SECONDARY_INVENTORIES msei
158: where mil.organization_id(+) = msei.organization_id
159: and mil.subinventory_code(+) = msei.secondary_inventory_name
160: and NVL(msei.disable_date, sysdate+1) > sysdate
190: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
191: ,base.LOCATOR_ID
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
287: ,mil.SUGGESTED_CUBIC_AREA
288: ,mil.SUGGESTED_WEIGHT
289: ,mil.LOCATION_SUGGESTED_UNITS
290: ,mil.rowid
291: from MTL_ITEM_LOCATIONS mil
292: ,MTL_SECONDARY_INVENTORIES msei
293: where mil.organization_id(+) = msei.organization_id
294: and mil.subinventory_code(+) = msei.secondary_inventory_name
295: and NVL(msei.disable_date, sysdate+1) > sysdate
324: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
325: ,base.LOCATOR_ID
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
421: ,mil.SUGGESTED_CUBIC_AREA
422: ,mil.SUGGESTED_WEIGHT
423: ,mil.LOCATION_SUGGESTED_UNITS
424: ,mil.rowid
425: from MTL_ITEM_LOCATIONS mil
426: ,MTL_SECONDARY_INVENTORIES msei
427: where mil.organization_id(+) = msei.organization_id
428: and mil.subinventory_code(+) = msei.secondary_inventory_name
429: and NVL(msei.disable_date, sysdate+1) > sysdate
460: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
461: ,base.LOCATOR_ID
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
557: ,mil.SUGGESTED_CUBIC_AREA
558: ,mil.SUGGESTED_WEIGHT
559: ,mil.LOCATION_SUGGESTED_UNITS
560: ,mil.rowid
561: from MTL_ITEM_LOCATIONS mil
562: ,MTL_SECONDARY_INVENTORIES msei
563: ,MTL_ITEM_SUB_INVENTORIES misi
564: where mil.organization_id(+) = msei.organization_id
565: and mil.subinventory_code(+) = msei.secondary_inventory_name
596: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
597: ,base.LOCATOR_ID
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
693: ,mil.SUGGESTED_CUBIC_AREA
694: ,mil.SUGGESTED_WEIGHT
695: ,mil.LOCATION_SUGGESTED_UNITS
696: ,mil.rowid
697: from MTL_ITEM_LOCATIONS mil
698: ,MTL_SECONDARY_INVENTORIES msei
699: ,MTL_ITEM_SUB_INVENTORIES misi
700: where mil.organization_id(+) = msei.organization_id
701: and mil.subinventory_code(+) = msei.secondary_inventory_name
734: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
735: ,base.LOCATOR_ID
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
831: ,mil.SUGGESTED_CUBIC_AREA
832: ,mil.SUGGESTED_WEIGHT
833: ,mil.LOCATION_SUGGESTED_UNITS
834: ,mil.rowid
835: from MTL_ITEM_LOCATIONS mil
836: ,MTL_SECONDARY_INVENTORIES msei
837: ,MTL_ITEM_SUB_INVENTORIES misi
838: where mil.organization_id(+) = msei.organization_id
839: and mil.subinventory_code(+) = msei.secondary_inventory_name
874: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
875: ,base.LOCATOR_ID
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
971: ,mil.SUGGESTED_CUBIC_AREA
972: ,mil.SUGGESTED_WEIGHT
973: ,mil.LOCATION_SUGGESTED_UNITS
974: ,mil.rowid
975: from MTL_ITEM_LOCATIONS mil
976: ,MTL_SECONDARY_INVENTORIES msei
977: ,MTL_ITEM_SUB_INVENTORIES misi
978: ,MTL_SECONDARY_LOCATORS msl
979: where mil.organization_id = msei.organization_id
1015: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
1016: ,base.LOCATOR_ID
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
1112: ,mil.SUGGESTED_CUBIC_AREA
1113: ,mil.SUGGESTED_WEIGHT
1114: ,mil.LOCATION_SUGGESTED_UNITS
1115: ,mil.rowid
1116: from MTL_ITEM_LOCATIONS mil
1117: ,MTL_SECONDARY_INVENTORIES msei
1118: ,MTL_ITEM_SUB_INVENTORIES misi
1119: ,MTL_SECONDARY_LOCATORS msl
1120: where mil.organization_id = msei.organization_id
1157: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
1158: ,base.LOCATOR_ID
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
1254: ,mil.SUGGESTED_CUBIC_AREA
1255: ,mil.SUGGESTED_WEIGHT
1256: ,mil.LOCATION_SUGGESTED_UNITS
1257: ,mil.rowid
1258: from MTL_ITEM_LOCATIONS mil
1259: ,MTL_SECONDARY_INVENTORIES msei
1260: ,MTL_ITEM_SUB_INVENTORIES misi
1261: ,MTL_SECONDARY_LOCATORS msl
1262: where mil.organization_id = msei.organization_id