84: ,base.LOCATOR_ID
85: ,msi.PRIMARY_UOM_CODE
86: ,mptdtv.TRANSACTION_UOM ) order_by_string
87: from MTL_LOT_NUMBERS mln
88: ,MTL_SYSTEM_ITEMS msi
89: ,WMS_TRX_DETAILS_TMP_V mptdtv
90: ,(
91: select msn.current_organization_id organization_id
92: ,msn.inventory_item_id
191: ,base.LOCATOR_ID
192: ,msi.PRIMARY_UOM_CODE
193: ,mptdtv.TRANSACTION_UOM ) order_by_string
194: from MTL_LOT_NUMBERS mln
195: ,MTL_SYSTEM_ITEMS msi
196: ,WMS_TRX_DETAILS_TMP_V mptdtv
197: ,(
198: select msn.current_organization_id organization_id
199: ,msn.inventory_item_id
327: ,base.LOCATOR_ID
328: ,msi.PRIMARY_UOM_CODE
329: ,mptdtv.TRANSACTION_UOM ) order_by_string
330: from MTL_LOT_NUMBERS mln
331: ,MTL_SYSTEM_ITEMS msi
332: ,WMS_TRX_DETAILS_TMP_V mptdtv
333: ,(
334: select msn.current_organization_id organization_id
335: ,msn.inventory_item_id
460: ,base.LOCATOR_ID
461: ,msi.PRIMARY_UOM_CODE
462: ,mptdtv.TRANSACTION_UOM ) order_by_string
463: from MTL_LOT_NUMBERS mln
464: ,MTL_SYSTEM_ITEMS msi
465: ,WMS_TRX_DETAILS_TMP_V mptdtv
466: ,(
467: SELECT x.organization_id organization_id
468: ,x.inventory_item_id inventory_item_id