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

TABLE: GMI.IC_STAT_RPT

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


Intrastat reporting table. This table is used for Intrastat reports. As designed, it writes out recordst like a flat-file.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IC_STAT_RPTI0 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSEQ_NO
ColumnITEM_ID
ColumnLOT_ID
ColumnTRANS_ID
Columns
Name Datatype Length Mandatory Comments
SEQ_NO NUMBER
Yes Sequence number used to differentiate multiple countries of origin/destination for the same item.
TRANS_ID NUMBER (10) Yes FK- as found in ic_tran_pnd and ic_tran_cmp.
ITEM_ID NUMBER
Yes FK- surrogate key to item master table.
LOT_ID NUMBER
Yes FK- surrogate key to lot master table 0 - Not lot controlled >1 - Lot_id for the item
ISTAT_QTY NUMBER
Yes Used for multiple ctry of origin or destination which make up 1 inventory transaction.
CTRY_ORIGIN VARCHAR2 (4) Yes Valid county destination as found in sy_geog_mst.geog_code.
CTRY_DEST VARCHAR2 (4) Yes Valid county destination as found in sy_geog_mst.geog_code.
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
TRANS_CNT NUMBER

Not currently used
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
Query Text

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


SELECT SEQ_NO
,      TRANS_ID
,      ITEM_ID
,      LOT_ID
,      ISTAT_QTY
,      CTRY_ORIGIN
,      CTRY_DEST
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRANS_CNT
,      LAST_UPDATE_LOGIN
FROM GMI.IC_STAT_RPT;

Dependencies

[top of page]

GMI.IC_STAT_RPT does not reference any database object

GMI.IC_STAT_RPT is referenced by following:

SchemaAPPS
SynonymIC_STAT_RPT