eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GMI.IC_CYCL_HDR

Object Details

Object Name:	IC_CYCL_HDR
Object Type:	TABLE
Owner:	GMI
FND Design Data:	GMI.IC_CYCL_HDR
Subobject Name:
Status:	VALID

This table contains the cycle header information. It will define the warehouse for which the count is taking place.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IC_CYCL_HDR_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CYCLE_ID
IC_CYCL_HDR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGN_CODE CYCLE_NO CYCLE_SOURCE
IC_CYCL_HDR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
CYCLE_ID	NUMBER	(10)	Yes	Unique key identifying the cycle.
CYCLE_NO	VARCHAR2	(32)	Yes	Number or name of the cycle.
CYCLE_SOURCE	NUMBER	(5)	Yes	Source. 0=Physical inventory, 1=Cycle count.
CYCLE_DESC	VARCHAR2	(70)	Yes	Description of the cycle.
WHSE_CODE	VARCHAR2	(4)	Yes	Warehouse in which the cycle count takes place.
ORGN_CODE	VARCHAR2	(4)	Yes	Organization for which the cycle is defined.
PRINT_COUNT	NUMBER	(5)	Yes	Number of times count sheet/tags have been printed.
PRINT_FORMAT	NUMBER	(5)	Yes	Print format. 0=Regular count sheet, 1=Print tags, 2=Print bulk tags.
UPDATE_METHOD	NUMBER	(5)	Yes	Not currently used.
CYCLESTART_DT	DATE		Yes	Cycle count start date.
CYCLESCHESEND_DT	DATE		Yes	Not currently used.
CYCLEEND_DT	DATE		Yes	Cycle count end date.
ACTUALSTART_DT	DATE		Yes	Not currently used.
INCLCTL_IND	NUMBER	(5)	Yes	Control group inclusion indicator. 0=Do not include control group items, 1=Include control group items.
INCLSUPER_IND	NUMBER	(5)	Yes	Super cycle inclusion indicator. 0=Do not include supercycle items, 1=Include supercycle items.
INCLEXCEPT_IND	NUMBER	(5)	Yes	Exception items inclusion indicator. 0=Do not include exception items, 1=Include exception items.
IN_USE	NUMBER	(10)		Not currently used
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	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.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
EXCLZERO_IND	NUMBER	(1)	Yes	Excel zero indicator
EXCLNEG_IND	NUMBER	(1)	Yes	Excel negative indicator

Query Text

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


SELECT CYCLE_ID
,      CYCLE_NO
,      CYCLE_SOURCE
,      CYCLE_DESC
,      WHSE_CODE
,      ORGN_CODE
,      PRINT_COUNT
,      PRINT_FORMAT
,      UPDATE_METHOD
,      CYCLESTART_DT
,      CYCLESCHESEND_DT
,      CYCLEEND_DT
,      ACTUALSTART_DT
,      INCLCTL_IND
,      INCLSUPER_IND
,      INCLEXCEPT_IND
,      IN_USE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      DELETE_MARK
,      TEXT_CODE
,      LAST_UPDATE_LOGIN
,      EXCLZERO_IND
,      EXCLNEG_IND
FROM GMI.IC_CYCL_HDR;

Dependencies

[top of page]

GMI.IC_CYCL_HDR does not reference any database object

GMI.IC_CYCL_HDR is referenced by following:

APPS: IC_CYCL_HDR