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: BOM.CST_INV_LAYERS

Object Details

Object Name:	CST_INV_LAYERS
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_INV_LAYERS
Subobject Name:
Status:	VALID

CST_INV_LAYERS stores the inventory layers for each receipt transaction. One inventory layer is created for each receipt into inventory. The inventory layers are created within an organization, item and cost group. The quantity and cost information is stored for the inventory layer.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_INV_LAYERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INV_LAYER_ID
CST_INV_LAYERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LAYER_ID INV_LAYER_ID
CST_INV_LAYERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAYER_ID TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_ID TRANSACTION_SOURCE
CST_INV_LAYERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAYER_ID LAYER_QUANTITY

Columns

Name	Datatype	Length	Mandatory	Comments
LAYER_ID	NUMBER		Yes	Layer identifier
INV_LAYER_ID	NUMBER		Yes	Inventory layer identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Item identifier
CREATION_QUANTITY	NUMBER		Yes	Inventory layer creation quantity
LAYER_QUANTITY	NUMBER		Yes	Current inventory layer quantity
LAYER_COST	NUMBER		Yes	Inventory layer cost
CREATE_TRANSACTION_ID	NUMBER		Yes	Transaction which created this layer
TRANSACTION_ACTION_ID	NUMBER			Transaction action identifier
TRANSACTION_SOURCE_ID	NUMBER			Transaction source identifier
TRANSACTION_SOURCE_TYPE_ID	NUMBER			Transaction source type identifier
TRANSACTION_SOURCE	VARCHAR2	(240)		Transaction source number
UNBURDENED_COST	NUMBER			Item unit cost minus this level material overhead
BURDEN_COST	NUMBER			This level material overhead
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
REQUEST_ID	NUMBER			Standard who column
PROGRAM_APPLICATION_ID	NUMBER			Standard who column
PROGRAM_ID	NUMBER			Standard who column
PROGRAM_UPDATE_DATE	DATE			Standard who column

Query Text

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


SELECT LAYER_ID
,      INV_LAYER_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      CREATION_QUANTITY
,      LAYER_QUANTITY
,      LAYER_COST
,      CREATE_TRANSACTION_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_SOURCE
,      UNBURDENED_COST
,      BURDEN_COST
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.CST_INV_LAYERS;

Dependencies

[top of page]

BOM.CST_INV_LAYERS does not reference any database object

BOM.CST_INV_LAYERS is referenced by following:

APPS: CST_INV_LAYERS