[Home] [Help] [Dependency Information]

VIEW: APPS.PA_XLA_REV_V

Object Details

Object Name:	PA_XLA_REV_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_XLA_REV_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

Query Text

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

SELECT PROJECT_NAME_NUM_CONCAT
,      PROJECT_STATUS
,      DRAFT_REVENUE_NUM
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
,      AGREEMENT
,      REVENUE_CURRENCY_CODE
,      REVENUE_AMOUNT
,      REVENUE_STATUS
,      DRAFT_REVENUE_NUM_CREDITED
,      ACCRUE_THROUGH_DATE
,      PA_DATE
,      RELEASED_DATE
,      TRANSFERRED_DATE
,      GL_DATE
,      CUSTOMER_BILL_SPLIT
,      UNBILLED_RECEIVABLE_DR
,      UNEARNED_REVENUE_CR
,      UNBILLED_CODE_COMBINATION_ID
,      UNEARNED_CODE_COMBINATION_ID
,      PROJECT_ID
,      CUSTOMER_ID
,      AGREEMENT_ID
,      TRANSFER_STATUS_CODE
,      PROJECT_TYPE
,      PROJECT_STATUS_CODE
,      PROJECT_ORGANIZATION_NAME
,      REVENUE_STATUS_CODE
,      PROJECT_ORGANIZATION_ID
,      TRANSFER_STATUS
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_REVENUE_AMOUNT
,      PROJECT_CURRENCY_CODE
,      PROJECT_REVENUE_AMOUNT
,      FUNDING_CURRENCY_CODE
,      FUNDING_REVENUE_AMOUNT
,      REVPROC_CURRENCY_CODE
,      ADJUSTING_REVENUE_FLAG
,      REALIZED_GAINS_AMOUNT
,      REALIZED_LOSSES_AMOUNT
,      REALIZED_GAINS_CCID
,      REALIZED_LOSSES_CCID
,      REVTRANS_UBR_DR
,      REVTRANS_UER_CR
,      REVTRANS_CURRENCY_CODE
,      REVTRANS_AMOUNT
FROM APPS.PA_XLA_REV_V;

Dependencies

[top of page]

APPS

HR_GENERAL - show dependent code

HR_ORGANIZATION_UNITS

HR_SECURITY - show dependent code

PA_AGREEMENTS_ALL

PA_CUSTOMERS_V

PA_DRAFT_REVENUES_ALL

PA_DRAFT_REVENUE_ITEMS

PA_LOOKUPS

PA_PROJECTS_ALL

PA_PROJECT_STATUSES

PA_PROJECT_TYPES_ALL

PA_SECURITY - show dependent code

SYS

DUAL

APPS.PA_XLA_REV_V is not referenced by any database object