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

TABLE: GMI.IC_CYCL_DTL

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


This table contains the frozen inventory balanaces upon starting a count.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IC_CYCL_DTL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_ID
ColumnWHSE_CODE
ColumnLOT_ID
ColumnLOCATION
ColumnCYCLE_ID
ColumnCOUNT_NO
Columns
Name Datatype Length Mandatory Comments
ITEM_ID NUMBER (10) Yes Surrogate key for the item to be counted.
WHSE_CODE VARCHAR2 (4) Yes Warehouse in which the item is counted.
LOT_ID NUMBER (10) Yes Surrogate key for the lot/sublot counted.
LOCATION VARCHAR2 (16) Yes Location in which the item is counted.
CYCLE_ID NUMBER (10) Yes Surrogate key for the cycle.
COUNT_NO NUMBER (10) Yes Cycle number.
FROZENQTY_1 NUMBER
Yes Quantity onhand when the cycle was started, in the primary UOM of an item.
FROZENQTY_2 NUMBER

Quantity onhand when the cycle was started, in the secondary UOM of an item, if dual UOM controlled.
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
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 ITEM_ID
,      WHSE_CODE
,      LOT_ID
,      LOCATION
,      CYCLE_ID
,      COUNT_NO
,      FROZENQTY_1
,      FROZENQTY_2
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      DELETE_MARK
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
FROM GMI.IC_CYCL_DTL;

Dependencies

[top of page]

GMI.IC_CYCL_DTL does not reference any database object

GMI.IC_CYCL_DTL is referenced by following:

SchemaGMI
ViewIC_CYCL_DTL#