Product: | INV - Inventory |
---|---|
Description: | View of items owned, planned and physically belonging to the same inventory organization |
Implementation/DBA Data: | APPS.MTL_ONHAND_QUANTITIES |
SELECT MOQD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MOQD.ORGANIZATION_ID ORGANIZATION_ID
, MOQD.DATE_RECEIVED DATE_RECEIVED
, MOQD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MOQD.LAST_UPDATED_BY LAST_UPDATED_BY
, MOQD.CREATION_DATE CREATION_DATE
, MOQD.CREATED_BY CREATED_BY
, MOQD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MOQD.PRIMARY_TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, MOQD.SUBINVENTORY_CODE SUBINVENTORY_CODE
, MOQD.REVISION REVISION
, MOQD.LOCATOR_ID LOCATOR_ID
, MOQD.CREATE_TRANSACTION_ID CREATE_TRANSACTION_ID
, MOQD.UPDATE_TRANSACTION_ID UPDATE_TRANSACTION_ID
, MOQD.LOT_NUMBER LOT_NUMBER
, MOQD.ORIG_DATE_RECEIVED ORIG_DATE_RECEIVED
, MOQD.COST_GROUP_ID COST_GROUP_ID
, MOQD.CONTAINERIZED_FLAG CONTAINERIZED_FLAG
, MOQD.PROJECT_ID PROJECT_ID
, MOQD.TASK_ID TASK_ID
, MOQD.SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, MOQD.SECONDARY_TRANSACTION_QUANTITY SECONDARY_TRANSACTION_QUANTITY
, MOQD.STATUS_ID
FROM MTL_ONHAND_QUANTITIES_DETAIL MOQD
WHERE MOQD.IS_CONSIGNED = 2