DBA Data[Home] [Help] [Dependency Information]

TABLE: INV.MTL_MOQD_BACKUP

Object Details
Object Name: MTL_MOQD_BACKUP
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_MOQD_BACKUP
Subobject Name:
Status: VALID


This is used to keep the backup of Inventory onhand table while running Consolidate Inventory Onhand Quantities program.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_MOQD_BACKUP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnROW_ID
MTL_MOQD_BACKUP_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnSUMMARIZED_FLAG
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ORGANIZATION_ID NUMBER

Organization identifier
DATE_RECEIVED DATE

Date received
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PRIMARY_TRANSACTION_QUANTITY NUMBER

Transaction quantity in the primary unit of measure of the item
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory code
REVISION VARCHAR2 (3)
Item revision code
LOCATOR_ID NUMBER

Locator identifier
CREATE_TRANSACTION_ID NUMBER

Transaction identifier of the transaction that created this row
UPDATE_TRANSACTION_ID NUMBER

Transaction identifier of the transaction that last updated this row
LOT_NUMBER VARCHAR2 (30)
Lot number
ORIG_DATE_RECEIVED DATE

Date originally recieved
COST_GROUP_ID NUMBER

Cost Group ID - Used by WMS only
CONTAINERIZED_FLAG NUMBER

Containerized Flag
PROJECT_ID NUMBER

Project Id
TASK_ID NUMBER

Task Id
ONHAND_QUANTITIES_ID NUMBER

Sequence Column for the rows based on MTL_ONHAND_QUANTITIES_S
ORGANIZATION_TYPE NUMBER

Organization Type. The values are based on MTL_TP_TYPES lookup.
OWNING_ORGANIZATION_ID NUMBER

Owning organization identifier
OWNING_TP_TYPE NUMBER

Owning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.
PLANNING_ORGANIZATION_ID NUMBER

Planning organization identifier
PLANNING_TP_TYPE NUMBER

Planning Trading Partner Type. The values are based on MTL_TP_TYPES lookup.
TRANSACTION_UOM_CODE VARCHAR2 (3)
Transaction unit of measure which created this transaction
TRANSACTION_QUANTITY NUMBER

Transaction quantity
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary unit of measure that may have been used to do the material transaction
SECONDARY_TRANSACTION_QUANTITY NUMBER

Secondary quantity
IS_CONSIGNED NUMBER

Check if the row is owned, planned and physically belongs to the inventory organization. If it is 1 then this material is consigned
SUMMARIZED_FLAG VARCHAR2 (1)
Summary Flag
REQUEST_ID NUMBER

Request ID of the concurrent program
USER_ID NUMBER

Standard WHO
CONSOLIDATION_DATE DATE

Date of running concurrent program for consolidating MOQD records
ROW_ID VARCHAR2 (64)
Row ID of MOQD table
Query Text

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
FROM INV.MTL_MOQD_BACKUP;

Dependencies

[top of page]

INV.MTL_MOQD_BACKUP does not reference any database object

INV.MTL_MOQD_BACKUP is referenced by following:

SchemaAPPS
SynonymMTL_MOQD_BACKUP