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_PROJ_REVENUE_VIEW

Object Details

Object Name:	PA_PROJ_REVENUE_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJ_REVENUE_VIEW
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

PA_PROJ_REVENUE_VIEW is a view of the draft revenue information
for a project that can be used for management reporting and online
queries. The view displays one record per project revenue.
For optimum performance in your reports and online
queries, always include PROJECT_ID in your selection
criteria.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	Identifier of the project
PROJECT_NUMBER	VARCHAR2	(25)	Yes	Project number
DRAFT_REVENUE_NUM	NUMBER	(15)	Yes	Sequential number that identifies the draft revenue within a project
RELEASED_DATE	DATE			Date on which the draft revenue was released
CREATION_DATE	DATE		Yes	Standard Who Column
GL_DATE	DATE			Date within the GL period in which the revenue is posted. This value is blank if the revenue is not yet transferred to Oracle General Ledger
GL_PERIOD	VARCHAR2	(15)		GL period in which the revenue is posted. This value is blank if the revenue is not yet transferred to Oracle General Ledger
PA_DATE	DATE		Yes	Date within the PA period in which the revenue is accounted for.
TRANSFER_REJECTION_REASON	VARCHAR2	(250)		Reason why the draft revenue was rejected by the Transfer Revenue program or rejected by Oracle General Ledger"s Journal Import program
PA_PERIOD	VARCHAR2	(20)	Yes	PA period in which the revenue is accounted for
AMOUNT	NUMBER			Total revenue amount of the draft revenue
DRAFT_REVENUE_NUM_CREDITED	NUMBER	(15)		Draft revenue number that is credited by this draft revenue
TRANSFER_STATUS_CODE	VARCHAR2	(1)	Yes	Status of the revenue as it is transferred to Oracle General Ledger
REVENUE_STATUS	VARCHAR2	(80)	Yes	Status of the revenue as it is reviewed and released in Oracle Projects and then transferred to Oracle General Ledger

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUMBER
,      DRAFT_REVENUE_NUM
,      RELEASED_DATE
,      CREATION_DATE
,      GL_DATE
,      GL_PERIOD
,      PA_DATE
,      TRANSFER_REJECTION_REASON
,      PA_PERIOD
,      AMOUNT
,      DRAFT_REVENUE_NUM_CREDITED
,      TRANSFER_STATUS_CODE
,      REVENUE_STATUS
FROM APPS.PA_PROJ_REVENUE_VIEW;

Dependencies

[top of page]

APPS.PA_PROJ_REVENUE_VIEW references the following:

APPS: GL_PERIOD_STATUSES; PA_DRAFT_REVENUES_ALL; PA_DRAFT_REVENUE_ITEMS; PA_IMPLEMENTATIONS; PA_LOOKUPS; PA_PERIODS; PA_PERIOD_PROCESS_PKG - show dependent code; PA_PROJECTS_ALL

APPS.PA_PROJ_REVENUE_VIEW is not referenced by any database object