eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_XLA_REVENUE_LINES_V

Object Details

Object Name:	PA_XLA_REVENUE_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_XLA_REVENUE_LINES_V
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
APPLICATION_ID	NUMBER
REVENUE_ENTITY_CODE	CHAR	(7)
EVENT_ID	NUMBER	(15)
LINE_NUMBER	NUMBER
PDR_DRAFT_REV_NUM_CREDITED	NUMBER	(15)
LEDGER_ID	NUMBER	(15)
REVENUE_FIRST_DIST_ID	NUMBER
REVENUE_SECOND_DIST_ID	NUMBER	(15)
CR_REVENUE_FIRST_DIST_ID	NUMBER
CR_REVENUE_SECOND_DIST_ID	NUMBER
PROJECT_ID	NUMBER	(15)
PDR_DRAFT_REV_NUM	NUMBER	(15)
TASK_ID	NUMBER
EXPENDITURE_ITEM_ID	NUMBER
PRDL_LINE_NUM	NUMBER
PERDL_EVENT_ID	NUMBER
PERDL_LINE_NUM	NUMBER
ACCT_AMOUNT	NUMBER
PDR_UBR_CCID	NUMBER
PDR_UER_CCID	NUMBER
PDR_REALIZED_GAINS_CCID	NUMBER
PDR_REALIZED_LOSSES_CCID	NUMBER
PRDL_CODE_COMBINATION_ID	NUMBER
PERDL_CODE_COMBINATION_ID	NUMBER
PRDL_LINE_NUM_REVERSED	NUMBER
PERDL_LINE_NUM_REVERSED	NUMBER
REVENUE_DISTRIBUTION_TYPE	VARCHAR2	(25)
PERSON_ID	NUMBER
EMPLOYEE_NUMBER	VARCHAR2	(30)
EXPENDITURE_ORGANIZATION_ID	NUMBER
NL_RES_ORGANIZATION_ID	NUMBER
NON_LABOR_RESOURCE	VARCHAR2	(20)
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(3)
EXPENDITURE_TYPE	VARCHAR2	(30)
PEI_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
PEI_ATTRIBUTE1	VARCHAR2	(150)
PEI_ATTRIBUTE2	VARCHAR2	(150)
PEI_ATTRIBUTE3	VARCHAR2	(150)
PEI_ATTRIBUTE4	VARCHAR2	(150)
PEI_ATTRIBUTE5	VARCHAR2	(150)
PEI_ATTRIBUTE6	VARCHAR2	(150)
PEI_ATTRIBUTE7	VARCHAR2	(150)
PEI_ATTRIBUTE8	VARCHAR2	(150)
PEI_ATTRIBUTE9	VARCHAR2	(150)
PEI_ATTRIBUTE10	VARCHAR2	(150)
REV_EVENT_TYPE	VARCHAR2	(30)
REV_EVENT_ORG_ID	NUMBER
PERDL_EVENT_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
PERDL_EVENT_ATTRIBUTE1	VARCHAR2	(150)
PERDL_EVENT_ATTRIBUTE2	VARCHAR2	(150)
PERDL_EVENT_ATTRIBUTE3	VARCHAR2	(150)
PERDL_EVENT_ATTRIBUTE4	VARCHAR2	(150)
PERDL_EVENT_ATTRIBUTE5	VARCHAR2	(150)
PERDL_EVENT_ATTRIBUTE6	VARCHAR2	(150)
PERDL_EVENT_ATTRIBUTE7	VARCHAR2	(150)
PERDL_EVENT_ATTRIBUTE8	VARCHAR2	(150)
PERDL_EVENT_ATTRIBUTE9	VARCHAR2	(150)
PERDL_EVENT_ATTRIBUTE10	VARCHAR2	(150)
INVENTORY_ORG_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
PEV_REFERENCE1	VARCHAR2	(240)
PEV_REFERENCE2	VARCHAR2	(240)
PEV_REFERENCE3	VARCHAR2	(240)
PEV_REFERENCE4	VARCHAR2	(240)
PEV_REFERENCE5	VARCHAR2	(240)
PEV_REFERENCE6	VARCHAR2	(240)
PEV_REFERENCE7	VARCHAR2	(240)
PEV_REFERENCE8	VARCHAR2	(240)
PEV_REFERENCE9	VARCHAR2	(240)
PEV_REFERENCE10	VARCHAR2	(240)
ACCT_CURRENCY_CODE	VARCHAR2	(15)
EXCHANGE_RATE	NUMBER
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
EXCHANGE_RATE_DATE	DATE
ENTERED_AMOUNT	NUMBER
ENTERED_CURRENCY_CODE	VARCHAR2	(15)
USE_ACT_UPG_ATTRIB_FLAG	CHAR	(1)
ACTUAL_UPG_DR_CCID	NUMBER
ACTUAL_UPG_CR_CCID	NUMBER
ACTUAL_UPG_DR_ACCT_CLASS	VARCHAR2	(7)
ACTUAL_UPG_CR_ACCT_CLASS	VARCHAR2	(7)

Query Text

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


SELECT APPLICATION_ID
,      REVENUE_ENTITY_CODE
,      EVENT_ID
,      LINE_NUMBER
,      PDR_DRAFT_REV_NUM_CREDITED
,      LEDGER_ID
,      REVENUE_FIRST_DIST_ID
,      REVENUE_SECOND_DIST_ID
,      CR_REVENUE_FIRST_DIST_ID
,      CR_REVENUE_SECOND_DIST_ID
,      PROJECT_ID
,      PDR_DRAFT_REV_NUM
,      TASK_ID
,      EXPENDITURE_ITEM_ID
,      PRDL_LINE_NUM
,      PERDL_EVENT_ID
,      PERDL_LINE_NUM
,      ACCT_AMOUNT
,      PDR_UBR_CCID
,      PDR_UER_CCID
,      PDR_REALIZED_GAINS_CCID
,      PDR_REALIZED_LOSSES_CCID
,      PRDL_CODE_COMBINATION_ID
,      PERDL_CODE_COMBINATION_ID
,      PRDL_LINE_NUM_REVERSED
,      PERDL_LINE_NUM_REVERSED
,      REVENUE_DISTRIBUTION_TYPE
,      PERSON_ID
,      EMPLOYEE_NUMBER
,      EXPENDITURE_ORGANIZATION_ID
,      NL_RES_ORGANIZATION_ID
,      NON_LABOR_RESOURCE
,      SYSTEM_LINKAGE_FUNCTION
,      EXPENDITURE_TYPE
,      PEI_ATTRIBUTE_CATEGORY
,      PEI_ATTRIBUTE1
,      PEI_ATTRIBUTE2
,      PEI_ATTRIBUTE3
,      PEI_ATTRIBUTE4
,      PEI_ATTRIBUTE5
,      PEI_ATTRIBUTE6
,      PEI_ATTRIBUTE7
,      PEI_ATTRIBUTE8
,      PEI_ATTRIBUTE9
,      PEI_ATTRIBUTE10
,      REV_EVENT_TYPE
,      REV_EVENT_ORG_ID
,      PERDL_EVENT_ATTRIBUTE_CATEGORY
,      PERDL_EVENT_ATTRIBUTE1
,      PERDL_EVENT_ATTRIBUTE2
,      PERDL_EVENT_ATTRIBUTE3
,      PERDL_EVENT_ATTRIBUTE4
,      PERDL_EVENT_ATTRIBUTE5
,      PERDL_EVENT_ATTRIBUTE6
,      PERDL_EVENT_ATTRIBUTE7
,      PERDL_EVENT_ATTRIBUTE8
,      PERDL_EVENT_ATTRIBUTE9
,      PERDL_EVENT_ATTRIBUTE10
,      INVENTORY_ORG_ID
,      INVENTORY_ITEM_ID
,      PEV_REFERENCE1
,      PEV_REFERENCE2
,      PEV_REFERENCE3
,      PEV_REFERENCE4
,      PEV_REFERENCE5
,      PEV_REFERENCE6
,      PEV_REFERENCE7
,      PEV_REFERENCE8
,      PEV_REFERENCE9
,      PEV_REFERENCE10
,      ACCT_CURRENCY_CODE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      ENTERED_AMOUNT
,      ENTERED_CURRENCY_CODE
,      USE_ACT_UPG_ATTRIB_FLAG
,      ACTUAL_UPG_DR_CCID
,      ACTUAL_UPG_CR_CCID
,      ACTUAL_UPG_DR_ACCT_CLASS
,      ACTUAL_UPG_CR_ACCT_CLASS
FROM APPS.PA_XLA_REVENUE_LINES_V;