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_PROJECT_FUNDING_AUDITS

Object Details

Object Name:	PA_PROJECT_FUNDING_AUDITS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJECT_FUNDING_AUDITS
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
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project to which funds are allocated
PROJECT_NUMBER	VARCHAR2	(25)	Yes
PROJECT_TYPE	VARCHAR2	(20)	Yes
TASK_NUMBER	VARCHAR2	(25)
AGREEMENT_NUMBER	VARCHAR2	(50)	Yes
CUSTOMER_NUMBER	VARCHAR2	(30)	Yes
CUSTOMER_NAME	VARCHAR2	(360)	Yes
REVALUATION_DATE	DATE
FUNDING_CURRENCY	VARCHAR2	(15)
FUNDING_BASELINED_FUNDING	NUMBER
FUNDING_AMOUNT_APPLIED	NUMBER
FUNDING_AMOUNT_DUE	NUMBER
FUNDING_BACKLOG	NUMBER
FUNDING_REVALUATION_FACTOR	NUMBER
FUNDING_BACKLOG_SUBJ_REVAL	NUMBER
REVPROC_CURRENCY	VARCHAR2	(15)
REVPROC_RATE_TYPE	VARCHAR2	(30)
REVPROC_RATE_DATE	DATE
REVPROC_RATE	NUMBER
REVPROC_BACKLOG_REVALUED	NUMBER
REVPROC_AMOUNT_APPLIED	NUMBER
REVPROC_AMOUNT_DUE_REVALED	NUMBER
REVPROC_REALIZED_GAINS	NUMBER
REVPROC_REALIZED_LOSSES	NUMBER
REVPROC_BASELINED_REVALUED	NUMBER
REVPROC_BASELINED_BFR_REVAL	NUMBER
REVPROC_REVALUATION_ADJ	NUMBER	(22)
INVPROC_CURRENCY	VARCHAR2	(15)
INVPROC_RATE_TYPE	VARCHAR2	(30)
INVPROC_RATE_DATE	DATE
INVPROC_RATE	NUMBER
INVPROC_BACKLOG_RAVALED	NUMBER
INVPROC_BASELINED_REVALED	NUMBER
INVPROC_BASELINED_BFR_REVAL	NUMBER
INVPROC_REVALUATION_ADJ	NUMBER	(22)
EVENT_NUMBER	NUMBER	(15)
EVENT_TYPE	VARCHAR2	(30)
EVENT_CLASSIFICATION	VARCHAR2	(80)
EVENT_CURRENCY	VARCHAR2	(15)
EVENT_AMOUNT	NUMBER

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_TYPE
,      TASK_NUMBER
,      AGREEMENT_NUMBER
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
,      REVALUATION_DATE
,      FUNDING_CURRENCY
,      FUNDING_BASELINED_FUNDING
,      FUNDING_AMOUNT_APPLIED
,      FUNDING_AMOUNT_DUE
,      FUNDING_BACKLOG
,      FUNDING_REVALUATION_FACTOR
,      FUNDING_BACKLOG_SUBJ_REVAL
,      REVPROC_CURRENCY
,      REVPROC_RATE_TYPE
,      REVPROC_RATE_DATE
,      REVPROC_RATE
,      REVPROC_BACKLOG_REVALUED
,      REVPROC_AMOUNT_APPLIED
,      REVPROC_AMOUNT_DUE_REVALED
,      REVPROC_REALIZED_GAINS
,      REVPROC_REALIZED_LOSSES
,      REVPROC_BASELINED_REVALUED
,      REVPROC_BASELINED_BFR_REVAL
,      REVPROC_REVALUATION_ADJ
,      INVPROC_CURRENCY
,      INVPROC_RATE_TYPE
,      INVPROC_RATE_DATE
,      INVPROC_RATE
,      INVPROC_BACKLOG_RAVALED
,      INVPROC_BASELINED_REVALED
,      INVPROC_BASELINED_BFR_REVAL
,      INVPROC_REVALUATION_ADJ
,      EVENT_NUMBER
,      EVENT_TYPE
,      EVENT_CLASSIFICATION
,      EVENT_CURRENCY
,      EVENT_AMOUNT
FROM APPS.PA_PROJECT_FUNDING_AUDITS;