Skip to content

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

TABLE: GMI.IN_ITEM_MST

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


EC Item Supplemental Details. This table contains Item related Intrastat details.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IN_ITEM_MST_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnITEM_ID
Columns
Name Datatype Length Mandatory Comments
ITEM_ID NUMBER (10) Yes FK - as used in ic_item_mst
PROCESSED_IND VARCHAR2 (1) Yes Indicates if item is for process / repair
CTRY_OF_ORIGIN VARCHAR2 (3)
Valid country code as found in in_ctry_mst
SUPPLEMENTAL_UM VARCHAR2 (4)
Supplemental unit of measure code as found in sy_uoms_mst (or blank)
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
TRANS_CNT NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Yes used to logically delete row
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
Query Text

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


SELECT ITEM_ID
,      PROCESSED_IND
,      CTRY_OF_ORIGIN
,      SUPPLEMENTAL_UM
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
FROM GMI.IN_ITEM_MST;

Dependencies

[top of page]

GMI.IN_ITEM_MST does not reference any database object

GMI.IN_ITEM_MST is referenced by following:

SchemaGMI
ViewIN_ITEM_MST#