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_PHYS_CNT

Object Details

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

Table in which count results from physical inventory and cycle counts
are stored.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IC_PHYS_CNT_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CYCLE_ID COUNT_NO ITEM_ID WHSE_CODE LOT_ID LOCATION

Columns

Name	Datatype	Length	Mandatory	Comments
CYCLE_ID	NUMBER	(10)	Yes	Surrogate key for the cycle.
COUNT_NO	NUMBER	(10)	Yes	Cycle number.
ITEM_ID	NUMBER	(10)	Yes	Surrogate to the item being counted.
WHSE_CODE	VARCHAR2	(4)	Yes	Warehouse in which count is taken.
LOT_ID	NUMBER	(10)	Yes	Surrogate key to the lot/sublot being counted.
LOCATION	VARCHAR2	(16)	Yes	Location at which count is taken.
GRADE_CODE	VARCHAR2	(4)		Grade of the material.
COUNT_DATE	DATE		Yes	Date on which count is taken.
PERPQTY_1	NUMBER		Yes	Qty counted, expressed in the primary UOM of an item.
PERPQTY_2	NUMBER			Qty counted, expressed in the secondary UOM of an item, if dual UOM controlled..
COUNT_PERSON	NUMBER	(15)	Yes	Operator code of person entering count.
FINALCOUNT_IND	NUMBER	(5)	Yes	Indicates final count. 0=No; 1=Yes.
REASON_CODE	VARCHAR2	(4)		Reason for excessive variation, if required.
TRANS_CNT	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
FOUND_ITEM_INDICATOR	NUMBER	(1)		Indicates that this item is newly discovered in this cycle.

Query Text

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


SELECT CYCLE_ID
,      COUNT_NO
,      ITEM_ID
,      WHSE_CODE
,      LOT_ID
,      LOCATION
,      GRADE_CODE
,      COUNT_DATE
,      PERPQTY_1
,      PERPQTY_2
,      COUNT_PERSON
,      FINALCOUNT_IND
,      REASON_CODE
,      TRANS_CNT
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      DELETE_MARK
,      TEXT_CODE
,      LAST_UPDATE_LOGIN
,      FOUND_ITEM_INDICATOR
FROM GMI.IC_PHYS_CNT;

Dependencies

[top of page]

GMI.IC_PHYS_CNT does not reference any database object

GMI.IC_PHYS_CNT is referenced by following:

GMI: IC_PHYS_CNT#