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

VIEW: APPS.OKL_AEL_GL_AST_V

Object Details
Object Name: OKL_AEL_GL_AST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AEL_GL_AST_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSET_NUMBER VARCHAR2 (15) Yes Asset number
PA_PERIOD_DATE DATE
Yes Date the asset was placed in service
ASSET_DESCRIPTION VARCHAR2 (210) Yes Reference field for the asset category descriptive flexfield. Contains the concatenated segment values from the category key flexfield
PA_PROJECT_NAME VARCHAR2 (120) Yes Contract (RFP,Proposal etc.) Legal Identifier.
COST_ELEMENT_NAME VARCHAR2 (1)
Indiactes where the asset line is active or inactive
CC_PROC_METHOD_NAME VARCHAR2 (240)
Supplier name
ITEM_DESCRIPTION VARCHAR2 (70)
Corporate Book
TRX_HDR_ID NUMBER
Yes Primary key column
TRX_NUMBER_DISPLAYED NUMBER

Transaction Number
TRX_HDR_CURRENCY VARCHAR2 (3) Yes Transaction Currency
TRX_DATE DATE
Yes Transaction Date
TRX_LINE_TYPE_NAME VARCHAR2 (0)
Transaction status
CC_TYPE_NAME VARCHAR2 (150) Yes Template Name
COST_TYPE_NAME VARCHAR2 (150)
Formula Name
PO_ORDER_TYPE VARCHAR2 (150) Yes Stream type
PO_ORDER_NUMBER VARCHAR2 (4000)
Stream Type Purpose
TRX_CLASS VARCHAR2 (30) Yes Transaction type class
TRX_CLASS_NAME VARCHAR2 (4000)
Transaction type class Description
ACCOUNTED_DR NUMBER

Accounted Debit Amount
ACCOUNTED_CR NUMBER

Accounted Credit Amount
JE_HEADER_ID NUMBER (15) Yes Journal entry header defining column
JE_LINE_NUM NUMBER (15) Yes Journal entry line number
APPLICATION_ID NUMBER

Unique Application identification number
SET_OF_BOOKS_ID NUMBER
Yes Accounting books defining column
ORG_ID NUMBER

Operating Unit Identifier
AEH_ID NUMBER
Yes Accounting Event Header Identification number
AEL_ID NUMBER
Yes Accounting Event Line Identification number
ACCT_LINE_TYPE VARCHAR2 (30) Yes Accounting Line Type
THIRD_PARTY_ID NUMBER

Third Party Identification number
DOC_SEQUENCE_VALUE NUMBER (15)
Document Sequence Value
AEL_TABLE CHAR (6)
Name of Accounting Event Lines Table
ENTERED_DR NUMBER

Entered Debit Amount
ENTERED_CR NUMBER

Entered Credit Amount
CODE_COMBINATION_ID NUMBER
Yes Key flexfield combination defining column
CURRENCY_CODE VARCHAR2 (3) Yes Currency Code
CURRENCY_CONVERSION_DATE DATE

Currency conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion Rate
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion Type
CURRENCY_USER_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion Type User name
DOC_SEQUENCE_ID NUMBER

Document Sequence Identifier
GL_TRANSFER_STATUS VARCHAR2 (3) Yes General Ledger Transfer status
JE_CATEGORY VARCHAR2 (90) Yes Journal Entry Category
ACCOUNTING_DATE DATE
Yes Date on which the transaction is accounted
USER_JE_CATEGORY_NAME VARCHAR2 (25) Yes Journal Entry Category user name
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
REQUEST_ID NUMBER (15)
Concurrent Manager column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager column
PROGRAM_ID NUMBER (15)
Concurrent Manager column
PROGRAM_UPDATE_DATE DATE

Concurrent Manager column
ACCOUNTING_EVENT_NUMBER NUMBER (15) Yes Accounting Event Number
ACCOUNTING_EVENT_TYPE VARCHAR2 (30) Yes Accounting Event Type
ACCOUNTING_LINE_NUMBER NUMBER (15) Yes Accounting Line Number
AEH_ACCOUNTING_ERROR_CODE VARCHAR2 (90)
Accounting Event Header Accounting Error code
AEL_ACCOUNTING_ERROR_CODE VARCHAR2 (90)
Accounting Event Line Accounting Error code
SOURCE_ID NUMBER
Yes Source Identification Number
SOURCE_TABLE VARCHAR2 (90) Yes Name of source table
Query Text

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


SELECT ASSET_NUMBER
,      PA_PERIOD_DATE
,      ASSET_DESCRIPTION
,      PA_PROJECT_NAME
,      COST_ELEMENT_NAME
,      CC_PROC_METHOD_NAME
,      ITEM_DESCRIPTION
,      TRX_HDR_ID
,      TRX_NUMBER_DISPLAYED
,      TRX_HDR_CURRENCY
,      TRX_DATE
,      TRX_LINE_TYPE_NAME
,      CC_TYPE_NAME
,      COST_TYPE_NAME
,      PO_ORDER_TYPE
,      PO_ORDER_NUMBER
,      TRX_CLASS
,      TRX_CLASS_NAME
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      JE_HEADER_ID
,      JE_LINE_NUM
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      AEH_ID
,      AEL_ID
,      ACCT_LINE_TYPE
,      THIRD_PARTY_ID
,      DOC_SEQUENCE_VALUE
,      AEL_TABLE
,      ENTERED_DR
,      ENTERED_CR
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_USER_CONVERSION_TYPE
,      DOC_SEQUENCE_ID
,      GL_TRANSFER_STATUS
,      JE_CATEGORY
,      ACCOUNTING_DATE
,      USER_JE_CATEGORY_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ACCOUNTING_EVENT_NUMBER
,      ACCOUNTING_EVENT_TYPE
,      ACCOUNTING_LINE_NUMBER
,      AEH_ACCOUNTING_ERROR_CODE
,      AEL_ACCOUNTING_ERROR_CODE
,      SOURCE_ID
,      SOURCE_TABLE
FROM APPS.OKL_AEL_GL_AST_V;

Dependencies

[top of page]

APPS.OKL_AEL_GL_AST_V references the following:

SchemaAPPS
SynonymFA_ADDITIONS_B
SynonymFA_BOOKS
SynonymGL_DAILY_CONVERSION_TYPES
SynonymGL_IMPORT_REFERENCES
ViewGL_JE_CATEGORIES_VL
SynonymOKC_K_HEADERS_B
SynonymOKC_K_LINES_B
SynonymOKC_K_PARTY_ROLES_B
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
SynonymOKL_ACC_EVENTS_ALL
SynonymOKL_AE_HEADERS_ALL
SynonymOKL_AE_LINES_ALL
SynonymOKL_AE_TEMPLATES_ALL
SynonymOKL_FORMULAE_B
SynonymOKL_STRM_TYPE_B
SynonymOKL_TRX_ASSETS
SynonymOKL_TRX_TYPES_B
SynonymOKL_TXL_ASSETS_B
ViewPO_VENDORS
APPS.OKL_AEL_GL_AST_V is referenced by following:

SchemaAPPS
ViewXLA_OKL_AEL_GL_AST_V