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

VIEW: BOM.CST_AE_HEADERS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
AE_HEADER_ID NUMBER (15) Yes
ACCOUNTING_EVENT_ID NUMBER
Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
LEGAL_ENTITY_ID NUMBER (15) Yes
COST_GROUP_ID NUMBER
Yes
COST_TYPE_ID NUMBER
Yes
AE_CATEGORY VARCHAR2 (30)
PERIOD_ID NUMBER
Yes
PERIOD_NAME VARCHAR2 (15) Yes
ACCOUNTING_DATE DATE
Yes
GL_TRANSFER_FLAG VARCHAR2 (1) Yes
GL_TRANSFER_RUN_ID NUMBER

DESCRIPTION VARCHAR2 (240)
GL_TRANSFER_ERROR_CODE VARCHAR2 (240)
ACCT_EVENT_SOURCE_TABLE VARCHAR2 (10)
ORGANIZATION_ID NUMBER
Yes
ACCOUNTING_ERROR_CODE VARCHAR2 (30)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
PROGRAM_UPDATE_DATE DATE

PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
REQUEST_ID NUMBER (15)
CROSS_CURRENCY_FLAG VARCHAR2 (1)
GL_REVERSAL_FLAG VARCHAR2 (1)
Query Text

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


SELECT AE_HEADER_ID
,      ACCOUNTING_EVENT_ID
,      SET_OF_BOOKS_ID
,      LEGAL_ENTITY_ID
,      COST_GROUP_ID
,      COST_TYPE_ID
,      AE_CATEGORY
,      PERIOD_ID
,      PERIOD_NAME
,      ACCOUNTING_DATE
,      GL_TRANSFER_FLAG
,      GL_TRANSFER_RUN_ID
,      DESCRIPTION
,      GL_TRANSFER_ERROR_CODE
,      ACCT_EVENT_SOURCE_TABLE
,      ORGANIZATION_ID
,      ACCOUNTING_ERROR_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      CROSS_CURRENCY_FLAG
,      GL_REVERSAL_FLAG
FROM BOM.CST_AE_HEADERS#;

Dependencies

[top of page]

BOM.CST_AE_HEADERS# references the following:

SchemaBOM
TableCST_AE_HEADERS
BOM.CST_AE_HEADERS# is referenced by following:

SchemaAPPS
SynonymCST_AE_HEADERS