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

VIEW: APPS.OKL_AEL_GL_TRX_V

Object Details
Object Name: OKL_AEL_GL_TRX_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AEL_GL_TRX_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
PA_PROJECT_NAME VARCHAR2 (120) Yes Contract Number
ITEM_DESCRIPTION VARCHAR2 (1995)
Product Description
BOM_DEPARTMENT_CODE DATE

Contract Start Date
BOM_DEPARTMENT_NAME DATE

Contract End date
ASSET_DESCRIPTION VARCHAR2 (30) Yes Contract status
PA_CUSTOMER_NAME VARCHAR2 (360) Yes Party name
PA_AGREEMENT_NUM VARCHAR2 (120) Yes Contract number
TRX_HDR_ID NUMBER
Yes Primary key column
TRX_NUMBER_DISPLAYED VARCHAR2 (30) Yes Transaction Number. If user does not specify a value, it is generated through a sequence
TRX_HDR_CURRENCY VARCHAR2 (150)
Currency code
TRX_DATE DATE
Yes Transaction date
TRX_LINE_TYPE_NAME VARCHAR2 (30) Yes Transaction status code. Points to FND lookup OKL_TRANSACTION_STATUS
CC_TYPE_NAME VARCHAR2 (150)
User entered description
COST_TYPE_NAME VARCHAR2 (150)
End date
PO_ORDER_TYPE VARCHAR2 (150)
Internal code for the stream type.
PO_ORDER_NUMBER VARCHAR2 (4000)
Stream Type Purpose
TRX_CLASS VARCHAR2 (30) Yes Transaction type class. Points to FND lookup OKL_TRANSACTION_TYPE_CLASS
TRX_CLASS_NAME VARCHAR2 (4000)
Transaction class
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 idenification number
DOC_SEQUENCE_VALUE NUMBER (15)
Document Sequence Value
AEL_TABLE CHAR (6)
Name of the Accounting Entry 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)
User currency conversion date
DOC_SEQUENCE_ID NUMBER

Document sequence identification number
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 User journal entry category
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 PA_PROJECT_NAME
,      ITEM_DESCRIPTION
,      BOM_DEPARTMENT_CODE
,      BOM_DEPARTMENT_NAME
,      ASSET_DESCRIPTION
,      PA_CUSTOMER_NAME
,      PA_AGREEMENT_NUM
,      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_TRX_V;

Dependencies

[top of page]

APPS.OKL_AEL_GL_TRX_V references the following:

SchemaAPPS
SynonymGL_DAILY_CONVERSION_TYPES
SynonymGL_IMPORT_REFERENCES
ViewGL_JE_CATEGORIES_VL
SynonymHZ_PARTIES
SynonymOKC_K_HEADERS_ALL_B
SynonymOKC_K_HEADERS_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_K_HEADERS
SynonymOKL_PRODUCTS
ViewOKL_STRM_TYPE_V
SynonymOKL_TRX_CONTRACTS_ALL
SynonymOKL_TRX_TYPES_B
SynonymOKL_TXL_CNTRCT_LNS_ALL
APPS.OKL_AEL_GL_TRX_V is referenced by following:

SchemaAPPS
ViewXLA_OKL_AEL_GL_TRX_V