[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
192: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
193: ,base.LOCATOR_ID
194: ,base.PROJECT_ID
195: ,base.TASK_ID
196: from MTL_ITEM_LOCATIONS omil
197: ,MTL_SECONDARY_INVENTORIES omsei
198: ,MTL_LOT_NUMBERS mln
199: ,MTL_SYSTEM_ITEMS msi
200: ,WMS_TRX_DETAILS_TMP_V mptdtv
289: ,mil.SUGGESTED_CUBIC_AREA
290: ,mil.SUGGESTED_WEIGHT
291: ,mil.LOCATION_SUGGESTED_UNITS
292: ,mil.rowid
293: from MTL_ITEM_LOCATIONS mil
294: ,MTL_SECONDARY_INVENTORIES msei
295: where mil.organization_id(+) = msei.organization_id
296: and mil.subinventory_code(+) = msei.secondary_inventory_name
297: and NVL(msei.disable_date, sysdate+1) > sysdate
328: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
329: ,base.LOCATOR_ID
330: ,base.PROJECT_ID
331: ,base.TASK_ID
332: from MTL_ITEM_LOCATIONS omil
333: ,MTL_SECONDARY_INVENTORIES omsei
334: ,MTL_LOT_NUMBERS mln
335: ,MTL_SYSTEM_ITEMS msi
336: ,WMS_TRX_DETAILS_TMP_V mptdtv
425: ,mil.SUGGESTED_CUBIC_AREA
426: ,mil.SUGGESTED_WEIGHT
427: ,mil.LOCATION_SUGGESTED_UNITS
428: ,mil.rowid
429: from MTL_ITEM_LOCATIONS mil
430: ,MTL_SECONDARY_INVENTORIES msei
431: where mil.organization_id(+) = msei.organization_id
432: and mil.subinventory_code(+) = msei.secondary_inventory_name
433: and NVL(msei.disable_date, sysdate+1) > sysdate
466: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
467: ,base.LOCATOR_ID
468: ,base.PROJECT_ID
469: ,base.TASK_ID
470: from MTL_ITEM_LOCATIONS omil
471: ,MTL_SECONDARY_INVENTORIES omsei
472: ,MTL_LOT_NUMBERS mln
473: ,MTL_SYSTEM_ITEMS msi
474: ,WMS_TRX_DETAILS_TMP_V mptdtv
563: ,mil.SUGGESTED_CUBIC_AREA
564: ,mil.SUGGESTED_WEIGHT
565: ,mil.LOCATION_SUGGESTED_UNITS
566: ,mil.rowid
567: from MTL_ITEM_LOCATIONS mil
568: ,MTL_SECONDARY_INVENTORIES msei
569: ,MTL_ITEM_SUB_INVENTORIES misi
570: where mil.organization_id(+) = msei.organization_id
571: and mil.organization_id=g_organization_id ---bug8425620 8665549
604: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
605: ,base.LOCATOR_ID
606: ,base.PROJECT_ID
607: ,base.TASK_ID
608: from MTL_ITEM_LOCATIONS omil
609: ,MTL_SECONDARY_INVENTORIES omsei
610: ,MTL_LOT_NUMBERS mln
611: ,MTL_SYSTEM_ITEMS msi
612: ,WMS_TRX_DETAILS_TMP_V mptdtv
701: ,mil.SUGGESTED_CUBIC_AREA
702: ,mil.SUGGESTED_WEIGHT
703: ,mil.LOCATION_SUGGESTED_UNITS
704: ,mil.rowid
705: from MTL_ITEM_LOCATIONS mil
706: ,MTL_SECONDARY_INVENTORIES msei
707: ,MTL_ITEM_SUB_INVENTORIES misi
708: where mil.organization_id(+) = msei.organization_id
709: and mil.organization_id=g_organization_id ---bug8425620 8665549
744: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
745: ,base.LOCATOR_ID
746: ,base.PROJECT_ID
747: ,base.TASK_ID
748: from MTL_ITEM_LOCATIONS omil
749: ,MTL_SECONDARY_INVENTORIES omsei
750: ,MTL_LOT_NUMBERS mln
751: ,MTL_SYSTEM_ITEMS msi
752: ,WMS_TRX_DETAILS_TMP_V mptdtv
841: ,mil.SUGGESTED_CUBIC_AREA
842: ,mil.SUGGESTED_WEIGHT
843: ,mil.LOCATION_SUGGESTED_UNITS
844: ,mil.rowid
845: from MTL_ITEM_LOCATIONS mil
846: ,MTL_SECONDARY_INVENTORIES msei
847: ,MTL_ITEM_SUB_INVENTORIES misi
848: where mil.organization_id(+) = msei.organization_id
849: and mil.organization_id=g_organization_id ---bug8425620 8665549
886: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
887: ,base.LOCATOR_ID
888: ,base.PROJECT_ID
889: ,base.TASK_ID
890: from MTL_ITEM_LOCATIONS omil
891: ,MTL_SECONDARY_INVENTORIES omsei
892: ,MTL_LOT_NUMBERS mln
893: ,MTL_SYSTEM_ITEMS msi
894: ,WMS_TRX_DETAILS_TMP_V mptdtv
983: ,mil.SUGGESTED_CUBIC_AREA
984: ,mil.SUGGESTED_WEIGHT
985: ,mil.LOCATION_SUGGESTED_UNITS
986: ,mil.rowid
987: from MTL_ITEM_LOCATIONS mil
988: ,MTL_SECONDARY_INVENTORIES msei
989: ,MTL_ITEM_SUB_INVENTORIES misi
990: ,MTL_SECONDARY_LOCATORS msl
991: where mil.organization_id = msei.organization_id
1029: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
1030: ,base.LOCATOR_ID
1031: ,base.PROJECT_ID
1032: ,base.TASK_ID
1033: from MTL_ITEM_LOCATIONS omil
1034: ,MTL_SECONDARY_INVENTORIES omsei
1035: ,MTL_LOT_NUMBERS mln
1036: ,MTL_SYSTEM_ITEMS msi
1037: ,WMS_TRX_DETAILS_TMP_V mptdtv
1126: ,mil.SUGGESTED_CUBIC_AREA
1127: ,mil.SUGGESTED_WEIGHT
1128: ,mil.LOCATION_SUGGESTED_UNITS
1129: ,mil.rowid
1130: from MTL_ITEM_LOCATIONS mil
1131: ,MTL_SECONDARY_INVENTORIES msei
1132: ,MTL_ITEM_SUB_INVENTORIES misi
1133: ,MTL_SECONDARY_LOCATORS msl
1134: where mil.organization_id = msei.organization_id
1173: OPEN p_cursor FOR select base.SUBINVENTORY_CODE
1174: ,base.LOCATOR_ID
1175: ,base.PROJECT_ID
1176: ,base.TASK_ID
1177: from MTL_ITEM_LOCATIONS omil
1178: ,MTL_SECONDARY_INVENTORIES omsei
1179: ,MTL_LOT_NUMBERS mln
1180: ,MTL_SYSTEM_ITEMS msi
1181: ,WMS_TRX_DETAILS_TMP_V mptdtv
1270: ,mil.SUGGESTED_CUBIC_AREA
1271: ,mil.SUGGESTED_WEIGHT
1272: ,mil.LOCATION_SUGGESTED_UNITS
1273: ,mil.rowid
1274: from MTL_ITEM_LOCATIONS mil
1275: ,MTL_SECONDARY_INVENTORIES msei
1276: ,MTL_ITEM_SUB_INVENTORIES misi
1277: ,MTL_SECONDARY_LOCATORS msl
1278: where mil.organization_id = msei.organization_id