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: CLN.CLN_CST_DTLS_TEMP

Object Details

Object Name:	CLN_CST_DTLS_TEMP
Object Type:	TABLE
Owner:	CLN
FND Design Data:	CLN.CLN_CST_DTLS_TEMP
Subobject Name:
Status:	VALID

This table is a temporary table used for storing records which can be later used for running the costing concurrent request

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CLN_CST_DTLS_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	GROUP_ID

Columns

Name	Datatype	Length	Comments
INVENTORY_ITEM_ID	NUMBER		Unique ID for the item
GROUP_ID	NUMBER		Group ID used for running the costing concurrent request in batch
ORGANIZATION_ID	NUMBER		Organization ID
RESOURCE_ID	NUMBER		Resource ID
USAGE_RATE_OR_AMOUNT	NUMBER		Usage Rate or Amount
ITEM_COST	NUMBER		Item Cost
COST_ELEMENT_ID	NUMBER		Cost Element ID
COST_TYPE	VARCHAR2	(10)	Cost Type
PROCESS_FLAG	NUMBER		Process flag
ITEM_NUMBER	VARCHAR2	(81)	Item Number
MFG_PART_NUM	VARCHAR2	(30)	Mfg Part Number

Query Text

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


SELECT INVENTORY_ITEM_ID
,      GROUP_ID
,      ORGANIZATION_ID
,      RESOURCE_ID
,      USAGE_RATE_OR_AMOUNT
,      ITEM_COST
,      COST_ELEMENT_ID
,      COST_TYPE
,      PROCESS_FLAG
,      ITEM_NUMBER
,      MFG_PART_NUM
FROM CLN.CLN_CST_DTLS_TEMP;

Dependencies

[top of page]

CLN.CLN_CST_DTLS_TEMP does not reference any database object

CLN.CLN_CST_DTLS_TEMP is referenced by following:

CLN: CLN_CST_DTLS_TEMP#