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_LE_COST_TYPES

Object Details

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

The CST_LE_COST_TYPES table holds information about the legal entity/cost type associations.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_LE_COST_TYPES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEGAL_ENTITY COST_TYPE_ID
CST_LE_COST_TYPES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATE_ACCT_ENTRIES
CST_LE_COST_TYPES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POST_TO_GL

Columns

Name	Datatype	Length	Mandatory	Comments
LEGAL_ENTITY	NUMBER	(15)	Yes	The organization_id of the legal entity
COST_TYPE_ID	NUMBER		Yes	The identifier of the cost type that will be associated with the legal entity.
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
PRIMARY_COST_METHOD	NUMBER		Yes	Primary cost method obtained from lookups
PAC_RATES_COST_TYPE_ID	NUMBER		Yes	Cost type identifier that will serve as rates
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
REQUEST_ID	NUMBER			Extended Who column
PROGRAM_APPLICATION_ID	NUMBER			Extended Who column
PROGRAM_ID	NUMBER			Extended Who column
PROGRAM_UPDATE_DATE	DATE			Extended Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
CREATE_ACCT_ENTRIES	VARCHAR2	(1)		Option that allows the user to create accounting entries for periodic costing
ACCOUNTING_LIBRARY_ID	NUMBER			Identifier of the accounting library that is to be used to create accounting distributions for the Legal Entity,Cost Type combination
POST_TO_GL	VARCHAR2	(1)		Option that allows the user to post accounting entries to General Ledger
GL_TRANSFER_ALLOW_OVERRIDE	VARCHAR2	(1)		Option that allows the user to change the default values for program parameters when transfer to General Ledger process is submitted
GL_TRANSFER_MODE	VARCHAR2	(1)		General Ledger Interface Transfer Summary Level
GL_TRANSFER_SUBMIT_JOURNAL_IMP	VARCHAR2	(1)		Option for submitting Journal Import to Oracle General Ledger at the same time as the transfer to General Ledger process
RESTRICT_DOC_FLAG	NUMBER			Determines if the Documents (Invoices and RTVs) are to be restricted by the Process upto date when the acquisition cost is calculated
TRANSFER_COST_FLAG	VARCHAR2	(1)		Column used to identify legal entity/cost type for interorg transfer
ITERATION_PROC_FLAG	VARCHAR2	(1)		iteration process as an option in Periodic Absorption Cost Processor
MATERIAL_RELIEF_ALGORITHM	NUMBER		Yes	Algorithm used for relieving material value

Query Text

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


SELECT LEGAL_ENTITY
,      COST_TYPE_ID
,      SET_OF_BOOKS_ID
,      PRIMARY_COST_METHOD
,      PAC_RATES_COST_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATE_ACCT_ENTRIES
,      ACCOUNTING_LIBRARY_ID
,      POST_TO_GL
,      GL_TRANSFER_ALLOW_OVERRIDE
,      GL_TRANSFER_MODE
,      GL_TRANSFER_SUBMIT_JOURNAL_IMP
,      RESTRICT_DOC_FLAG
,      TRANSFER_COST_FLAG
,      ITERATION_PROC_FLAG
,      MATERIAL_RELIEF_ALGORITHM
FROM BOM.CST_LE_COST_TYPES;

Dependencies

[top of page]

BOM.CST_LE_COST_TYPES does not reference any database object

BOM.CST_LE_COST_TYPES is referenced by following:

BOM: CST_LE_COST_TYPES#