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

VIEW: APPS.OKL_AEL_GL_CTR_V

Object Details
Object Name: OKL_AEL_GL_CTR_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AEL_GL_CTR_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 to uniquely identify a contract
BOM_DEPARTMENT_CODE DATE

Contract start date
BOM_DEPARTMENT_NAME DATE

Contract end date
ITEM_DESCRIPTION VARCHAR2 (1995)
Description of the product
PA_AGREEMENT_NUM VARCHAR2 (120)
Contract Number
ASSET_DESCRIPTION VARCHAR2 (30) Yes Contract Status
PA_CUSTOMER_NAME VARCHAR2 (360) Yes Customer Name
TRX_HDR_ID NUMBER
Yes Unique transaction identifier
TRX_NUMBER_DISPLAYED VARCHAR2 (30) Yes Displayed unique transaction identification number
TRX_HDR_CURRENCY VARCHAR2 (150)
Transaction Currency
TRX_DATE DATE
Yes Date on Which Transaction occured
TRX_LINE_TYPE_NAME VARCHAR2 (30) Yes Transaction Line Type
CC_TYPE_NAME VARCHAR2 (150) Yes Accounting Template Name
COST_TYPE_NAME VARCHAR2 (150)
Formula Name
PO_ORDER_TYPE VARCHAR2 (150) Yes Stream type name
PO_ORDER_NUMBER VARCHAR2 (4000)
Stream Type purpose
TRX_CLASS VARCHAR2 (30) Yes Transaction Class Code
TRX_CLASS_NAME VARCHAR2 (4000)
Transaction Class Name
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 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 PA_PROJECT_NAME
,      BOM_DEPARTMENT_CODE
,      BOM_DEPARTMENT_NAME
,      ITEM_DESCRIPTION
,      PA_AGREEMENT_NUM
,      ASSET_DESCRIPTION
,      PA_CUSTOMER_NAME
,      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_CTR_V;

Dependencies

[top of page]

APPS.OKL_AEL_GL_CTR_V references the following:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
SynonymGL_IMPORT_REFERENCES
ViewGL_JE_CATEGORIES_VL
SynonymOKC_K_HEADERS_B
SynonymOKC_K_PARTY_ROLES_B
PL/SQL PackageOKC_UTIL - show dependent code
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
ViewOKL_K_HDRS_FULL_UV
ViewOKL_STRM_TYPE_V
SynonymOKL_TRX_CONTRACTS_ALL
SynonymOKL_TRX_TYPES_B
SynonymOKL_TXL_CNTRCT_LNS_ALL
ViewOKX_PARTIES_V
APPS.OKL_AEL_GL_CTR_V is referenced by following:

SchemaAPPS
ViewXLA_OKL_AEL_GL_CTR_V