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


VIEW: APPS.PA_AEL_GL_EI_MRC_V

Object Details
Object Name: PA_AEL_GL_EI_MRC_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER

SET_OF_BOOKS_ID NUMBER (15)
ORG_ID NUMBER (15)
TRX_CLASS_NAME VARCHAR2 (80)
TRX_CLASS VARCHAR2 (30)
TRX_TYPE_NAME VARCHAR2 (80)
TRX_TYPE_C VARCHAR2 (30)
TRX_NUMBER_DISPLAYED VARCHAR2 (40)
TRX_NUMBER_N NUMBER

TRX_DATE DATE

COMMENTS VARCHAR2 (240)
TRX_HDR_TABLE CHAR (2)
TRX_HDR_ID NUMBER

ACCT_LINE_TYPE_NAME VARCHAR2 (80)
ACCT_LINE_TYPE VARCHAR2 (30)
CODE_COMBINATION_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
ENTERED_DR NUMBER

ENTERED_CR NUMBER

ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_RATE NUMBER

CURRENCY_USER_CONVERSION_TYPE VARCHAR2 (30)
PA_EMPLOYEE_NUM VARCHAR2 (30)
PA_EMPLOYEE_NAME VARCHAR2 (240)
PA_SUPPLIER_NUM VARCHAR2 (30)
PA_SUPPLIER_NAME VARCHAR2 (240)
ACCOUNTING_DATE DATE

PA_TRANSFER_TO_GL VARCHAR2 (0)
SOURCE_TABLE CHAR (2)
SOURCE_ID NUMBER

AEL_TABLE CHAR (3)
AEL_ID NUMBER

AE_LINE_REFERENCE VARCHAR2 (120)
AE_LINE_REFERENCE_INTERNAL VARCHAR2 (120)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PA_PROJECT_NUM VARCHAR2 (25)
PA_PROJECT_ID NUMBER (15)
PA_PROJECT_NAME VARCHAR2 (30)
PA_TASK_NUM VARCHAR2 (25)
PA_TASK_NAME VARCHAR2 (20)
PA_EI_EV_ORG VARCHAR2 (240)
PA_NL_RESOURCE_ORG VARCHAR2 (240)
PA_NL_RESOURCE VARCHAR2 (250)
PA_EI_EV_TYPE VARCHAR2 (30)
PA_EVENT_NUM NUMBER

PA_QUANTITY NUMBER

PA_UOM VARCHAR2 (80)
PA_PERIOD_DATE DATE

PA_GL_TRANSFER_DATE DATE

PA_CUSTOMER_NUMBER NUMBER

PA_CUSTOMER_NAME VARCHAR2 (0)
PA_AGREEMENT_NUM VARCHAR2 (0)
PA_ACCRUE_THRU_DATE DATE

PA_DRI_NUMBER NUMBER

PA_TRANS_ID NUMBER

PA_LINE_NUMBER NUMBER

TRANSFER_SYSTEM_NAME VARCHAR2 (80)
TRANSFER_SYSTEM VARCHAR2 (80)
GL_TRANSFER_STATUS_NAME VARCHAR2 (80)
GL_TRANSFER_STATUS VARCHAR2 (30)
GL_TRANSFER_FROM_TO_NAME VARCHAR2 (80)
TRANSFER_STATUS_DETAIL_NAME VARCHAR2 (250)
ACCOUNTING_COMPLETE VARCHAR2 (30)
ACCOUNTING_COMPLETE_NAME VARCHAR2 (80)
PA_VIEW_LABOR_COST VARCHAR2 (30)
JE_HEADER_ID NUMBER (15)
JE_LINE_NUM NUMBER (15)
PRVDR_ORGANIZATION_NAME VARCHAR2 (240)
RECVR_ORGANIZATION_NAME VARCHAR2 (240)
PRVDR_OU_NAME VARCHAR2 (240)
RECVR_OU_NAME VARCHAR2 (240)
CC_TYPE_NAME VARCHAR2 (80)
CC_TYPE VARCHAR2 (30)
CC_PROC_METHOD_NAME VARCHAR2 (80)
CC_PROC_METHOD VARCHAR2 (30)
Query Text

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


SELECT APPLICATION_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      TRX_CLASS_NAME
,      TRX_CLASS
,      TRX_TYPE_NAME
,      TRX_TYPE_C
,      TRX_NUMBER_DISPLAYED
,      TRX_NUMBER_N
,      TRX_DATE
,      COMMENTS
,      TRX_HDR_TABLE
,      TRX_HDR_ID
,      ACCT_LINE_TYPE_NAME
,      ACCT_LINE_TYPE
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_USER_CONVERSION_TYPE
,      PA_EMPLOYEE_NUM
,      PA_EMPLOYEE_NAME
,      PA_SUPPLIER_NUM
,      PA_SUPPLIER_NAME
,      ACCOUNTING_DATE
,      PA_TRANSFER_TO_GL
,      SOURCE_TABLE
,      SOURCE_ID
,      AEL_TABLE
,      AEL_ID
,      AE_LINE_REFERENCE
,      AE_LINE_REFERENCE_INTERNAL
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PA_PROJECT_NUM
,      PA_PROJECT_ID
,      PA_PROJECT_NAME
,      PA_TASK_NUM
,      PA_TASK_NAME
,      PA_EI_EV_ORG
,      PA_NL_RESOURCE_ORG
,      PA_NL_RESOURCE
,      PA_EI_EV_TYPE
,      PA_EVENT_NUM
,      PA_QUANTITY
,      PA_UOM
,      PA_PERIOD_DATE
,      PA_GL_TRANSFER_DATE
,      PA_CUSTOMER_NUMBER
,      PA_CUSTOMER_NAME
,      PA_AGREEMENT_NUM
,      PA_ACCRUE_THRU_DATE
,      PA_DRI_NUMBER
,      PA_TRANS_ID
,      PA_LINE_NUMBER
,      TRANSFER_SYSTEM_NAME
,      TRANSFER_SYSTEM
,      GL_TRANSFER_STATUS_NAME
,      GL_TRANSFER_STATUS
,      GL_TRANSFER_FROM_TO_NAME
,      TRANSFER_STATUS_DETAIL_NAME
,      ACCOUNTING_COMPLETE
,      ACCOUNTING_COMPLETE_NAME
,      PA_VIEW_LABOR_COST
,      JE_HEADER_ID
,      JE_LINE_NUM
,      PRVDR_ORGANIZATION_NAME
,      RECVR_ORGANIZATION_NAME
,      PRVDR_OU_NAME
,      RECVR_OU_NAME
,      CC_TYPE_NAME
,      CC_TYPE
,      CC_PROC_METHOD_NAME
,      CC_PROC_METHOD
FROM APPS.PA_AEL_GL_EI_MRC_V;

Dependencies

[top of page]

APPS.PA_AEL_GL_EI_MRC_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
SynonymGL_DAILY_CONVERSION_TYPES
SynonymGL_IMPORT_REFERENCES
SynonymGL_JE_HEADERS
SynonymGL_JE_LINES
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPA_CC_DIST_LINES_ALL
SynonymPA_COST_DISTRIBUTION_LINES_ALL
SynonymPA_EXPENDITURES_ALL
SynonymPA_EXPENDITURE_COMMENTS
SynonymPA_EXPENDITURE_ITEMS_ALL
SynonymPA_EXPENDITURE_TYPES
SynonymPA_IMPLEMENTATIONS_ALL
SynonymPA_MC_CC_DIST_LINES_ALL
SynonymPA_MC_COST_DIST_LINES_ALL
SynonymPA_MC_EXP_ITEMS_ALL
SynonymPA_NON_LABOR_RESOURCES
SynonymPA_PROJECTS_ALL
PL/SQL PackagePA_SECURITY - show dependent code
SynonymPA_SYSTEM_LINKAGES
SynonymPA_TASKS
SynonymPA_TRANSACTION_SOURCES
SynonymPER_ALL_PEOPLE_F
ViewPO_VENDORS
PL/SQL PackageXLA_UTIL - show dependent code
SchemaPUBLIC
SynonymDUAL
APPS.PA_AEL_GL_EI_MRC_V is referenced by following:

SchemaAPPS
ViewXLA_PA_AEL_EI_MRC_GL_V