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
64: ,(
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
161: and NVL(mil.disable_date, sysdate+1) > sysdate
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
201: ,(
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
298: and NVL(mil.disable_date, sysdate+1) > sysdate
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
337: ,(
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
434: and NVL(mil.disable_date, sysdate+1) > sysdate
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
475: ,(
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
572: and mil.subinventory_code(+) = msei.secondary_inventory_name
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
613: ,(
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
710: and mil.subinventory_code(+) = msei.secondary_inventory_name
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
753: ,(
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
850: and mil.subinventory_code(+) = msei.secondary_inventory_name
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
895: ,(
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
992: and mil.organization_id=g_organization_id ---bug8425620 8665549
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
1038: ,(
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
1135: and mil.organization_id=g_organization_id ---bug8425620 8665549
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
1182: ,(
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
1279: and mil.organization_id=g_organization_id ---bug8425620 8665549