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: TableCLN.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: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CLN_CST_DTLS_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnGROUP_ID
Columns
Name Datatype Length Mandatory 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:

SchemaAPPS
SynonymCLN_CST_DTLS_TEMP