[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
BOM.CST_LE_COST_TYPES does not reference any database object
BOM.CST_LE_COST_TYPES is referenced by following:
|
|
|