[Home] [Help] [Dependency Information]
Object Name: | MTL_MOQD_BACKUP# |
---|---|
Object Type: | VIEW |
Owner: | INV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
DATE_RECEIVED | DATE | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
PRIMARY_TRANSACTION_QUANTITY | NUMBER | |||
SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
REVISION | VARCHAR2 | (3) | ||
LOCATOR_ID | NUMBER | |||
CREATE_TRANSACTION_ID | NUMBER | |||
UPDATE_TRANSACTION_ID | NUMBER | |||
LOT_NUMBER | VARCHAR2 | (30) | ||
ORIG_DATE_RECEIVED | DATE | |||
COST_GROUP_ID | NUMBER | |||
CONTAINERIZED_FLAG | NUMBER | |||
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER | |||
ONHAND_QUANTITIES_ID | NUMBER | |||
ORGANIZATION_TYPE | NUMBER | |||
OWNING_ORGANIZATION_ID | NUMBER | |||
OWNING_TP_TYPE | NUMBER | |||
PLANNING_ORGANIZATION_ID | NUMBER | |||
PLANNING_TP_TYPE | NUMBER | |||
TRANSACTION_UOM_CODE | VARCHAR2 | (3) | ||
TRANSACTION_QUANTITY | NUMBER | |||
SECONDARY_UOM_CODE | VARCHAR2 | (3) | ||
SECONDARY_TRANSACTION_QUANTITY | NUMBER | |||
IS_CONSIGNED | NUMBER | |||
SUMMARIZED_FLAG | VARCHAR2 | (1) | ||
REQUEST_ID | NUMBER | |||
USER_ID | NUMBER | |||
CONSOLIDATION_DATE | DATE | |||
ROW_ID | VARCHAR2 | (64) | ||
STATUS_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, DATE_RECEIVED
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PRIMARY_TRANSACTION_QUANTITY
, SUBINVENTORY_CODE
, REVISION
, LOCATOR_ID
, CREATE_TRANSACTION_ID
, UPDATE_TRANSACTION_ID
, LOT_NUMBER
, ORIG_DATE_RECEIVED
, COST_GROUP_ID
, CONTAINERIZED_FLAG
, PROJECT_ID
, TASK_ID
, ONHAND_QUANTITIES_ID
, ORGANIZATION_TYPE
, OWNING_ORGANIZATION_ID
, OWNING_TP_TYPE
, PLANNING_ORGANIZATION_ID
, PLANNING_TP_TYPE
, TRANSACTION_UOM_CODE
, TRANSACTION_QUANTITY
, SECONDARY_UOM_CODE
, SECONDARY_TRANSACTION_QUANTITY
, IS_CONSIGNED
, SUMMARIZED_FLAG
, REQUEST_ID
, USER_ID
, CONSOLIDATION_DATE
, ROW_ID
, STATUS_ID
FROM INV.MTL_MOQD_BACKUP#;
|
|
|