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_PERD_BAL

Object Details

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

Inventory period balances. Stores the ending balance, consumption,
and yield for closed inventory periods.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IC_PERD_BAL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FISCAL_YEAR PERIOD WHSE_CODE ITEM_ID LOT_ID LOCATION
IC_PERD_BAL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERD_BAL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERIOD_ID	NUMBER	(10)	Yes	Surrogate key of the period.
LOT_ID	NUMBER	(10)	Yes	Surrogate key of the lot, if any, for this item.
WHSE_CODE	VARCHAR2	(4)	Yes	Warehouse which contains the item balances.
LOCATION	VARCHAR2	(16)	Yes	Location in the warehouse, if any, which contains the balance.
ITEM_ID	NUMBER	(10)	Yes	Surrogate key for the item.
FISCAL_YEAR	VARCHAR2	(4)	Yes	Name of the inventory calendar.
PERIOD	NUMBER	(5)	Yes	Inventory period for which the balance is stored.
LOCT_ONHAND	NUMBER		Yes	Period ending balance of lot/item in primary UOM of an item.
LOCT_ONHAND2	NUMBER			Period ending balance of lot/item in secondary UOM of an item, for dual UOM items.
LOCT_USAGE	NUMBER		Yes	Consumption of the item in production during the period, in the primary inventory UOM of an item.
LOCT_USAGE2	NUMBER			Consumption of the item in production during the period, in the secondary inventory UOM of an item, for dual UOM items.
LOCT_YIELD	NUMBER		Yes	Yield of the item from production during the period, in the primary inventory UOM of an item.
LOCT_YIELD2	NUMBER			Yield of the item from production during the period, in the secondary inventory UOM of an item, for dual UOM items.
LOCT_VALUE	NUMBER		Yes	Value of loct_usage. Equals loct_usage*accounting cost.
LOT_STATUS	VARCHAR2	(4)		Status of the lot.
QCHOLD_RES_CODE	VARCHAR2	(4)		Reason code associated with the lot status.
LOG_END_DATE	DATE		Yes	Last time Inventory Close was run.
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
GL_POSTED_IND	NUMBER	(5)		GL Posted Indicator
PERD_BAL_ID	NUMBER	(15)		Unique Surrogate Key
MIGRATED_IND	NUMBER	(5)		Indicates if row is migrated or not
PERIOD_BALANCE_ID	NUMBER	(15)		Unique identifier for the new period balances table

Query Text

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


SELECT PERIOD_ID
,      LOT_ID
,      WHSE_CODE
,      LOCATION
,      ITEM_ID
,      FISCAL_YEAR
,      PERIOD
,      LOCT_ONHAND
,      LOCT_ONHAND2
,      LOCT_USAGE
,      LOCT_USAGE2
,      LOCT_YIELD
,      LOCT_YIELD2
,      LOCT_VALUE
,      LOT_STATUS
,      QCHOLD_RES_CODE
,      LOG_END_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      GL_POSTED_IND
,      PERD_BAL_ID
,      MIGRATED_IND
,      PERIOD_BALANCE_ID
FROM GMI.IC_PERD_BAL;

Dependencies

[top of page]

GMI.IC_PERD_BAL does not reference any database object

GMI.IC_PERD_BAL is referenced by following:

GMI: IC_PERD_BAL#