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

TABLE: GMI.IC_DECM_MST

Object Details
Object Name: IC_DECM_MST
Object Type: TABLE
Owner: GMI
FND Design Data: TableGMI.IC_DECM_MST
Subobject Name:
Status: VALID


Store information about records in IC_LOCT_INV whose decimal quantities have been reset to tolerance levels.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IC_DECM_MST_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOG_ID
Columns
Name Datatype Length Mandatory Comments
LOG_ID NUMBER
Yes Primary key
ITEM_ID NUMBER (10) Yes Surrogate key for the item
WHSE_CODE VARCHAR2 (4) Yes Warehouse in which the item is located
LOT_ID NUMBER (10) Yes Surrogate key for the lot
LOCATION VARCHAR2 (16) Yes Location of the item
LOCT_ONHAND NUMBER
Yes Adjusted quantity of the item/lot/sublot expressed in the primary unit of measure for the item
LOCT_ONHAND2 NUMBER

Adjusted secondary quantity of the item/lot/sublot expressed in the secondary unit of measure for the item, for dual UOM items
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOG_ID
,      ITEM_ID
,      WHSE_CODE
,      LOT_ID
,      LOCATION
,      LOCT_ONHAND
,      LOCT_ONHAND2
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM GMI.IC_DECM_MST;

Dependencies

[top of page]

GMI.IC_DECM_MST does not reference any database object

GMI.IC_DECM_MST is referenced by following:

SchemaAPPS
SynonymIC_DECM_MST