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

TABLE: GMI.IC_CYCL_ERR

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


Cycle Count Error Table. This table contains the error log for items that had a problem during the cycle count posting.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IC_CYCL_ERR_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCYCLE_ID
ColumnITEM_ID
ColumnWHSE_CODE
ColumnLOT_ID
ColumnLOCATION
Columns
Name Datatype Length Mandatory Comments
CYCLE_ID NUMBER (10) Yes Surrogate key identifying the cycle.
ITEM_ID NUMBER
Yes Surrogate key identifying for the item counted.
WHSE_CODE VARCHAR2 (4) Yes Warehouse in which this item was counted.
LOT_ID NUMBER (10) Yes Surrogate key for the lot/sublot counted.
LOCATION VARCHAR2 (16) Yes Location in which the item was counted.
CYCLE_NO VARCHAR2 (32) Yes Number of the cycle.
ITEM_NO VARCHAR2 (32) Yes Item Number.
ERR_MSG VARCHAR2 (70) Yes Error message describing why the item was rejected during the posting attempt.
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 CYCLE_ID
,      ITEM_ID
,      WHSE_CODE
,      LOT_ID
,      LOCATION
,      CYCLE_NO
,      ITEM_NO
,      ERR_MSG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM GMI.IC_CYCL_ERR;

Dependencies

[top of page]

GMI.IC_CYCL_ERR does not reference any database object

GMI.IC_CYCL_ERR is referenced by following:

SchemaAPPS
SynonymIC_CYCL_ERR