VIEW: APPS.MTL_ONHAND_QUANTITIES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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