DBA Data[Home] [Help] [Dependency Information]

VIEW: BOM.CST_LE_COST_TYPES#

Object Details
Object Name: CST_LE_COST_TYPES#
Object Type: VIEW
Owner: BOM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY NUMBER (15) Yes
COST_TYPE_ID NUMBER
Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
PRIMARY_COST_METHOD NUMBER
Yes
PAC_RATES_COST_TYPE_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

CREATE_ACCT_ENTRIES VARCHAR2 (1)
ACCOUNTING_LIBRARY_ID NUMBER

POST_TO_GL VARCHAR2 (1)
GL_TRANSFER_ALLOW_OVERRIDE VARCHAR2 (1)
GL_TRANSFER_MODE VARCHAR2 (1)
GL_TRANSFER_SUBMIT_JOURNAL_IMP VARCHAR2 (1)
RESTRICT_DOC_FLAG NUMBER

TRANSFER_COST_FLAG VARCHAR2 (1)
ITERATION_PROC_FLAG VARCHAR2 (1)
MATERIAL_RELIEF_ALGORITHM NUMBER
Yes
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# references the following:

SchemaBOM
TableCST_LE_COST_TYPES
BOM.CST_LE_COST_TYPES# is referenced by following:

SchemaAPPS
SynonymCST_LE_COST_TYPES