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_SUMMARY_AMOUNTS_V

Object Details

Object Name:	PA_PROJ_SUMMARY_AMOUNTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJ_SUMMARY_AMOUNTS_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	Comments
ORGANIZATION_ID	NUMBER	(15)	Identifier of the organization managing the project work
ORGANIZATION_NAME	VARCHAR2	(240)	Name of the organization managing the project work
MEMBER_PERSON_ID	NUMBER	(15)	Identifier of project member
MEMBER_NAME	VARCHAR2	(240)	Full name of project member
PROJECT_ROLE_TYPE	VARCHAR2	(20)	Code that identifies the project role type. This column displays PROJECT MANAGER for the project manager role type
PROJECT_ROLE	VARCHAR2	(80)	Role that project member has on project
PROJECT_ID	NUMBER	(15)	Project identifier
PROJECT_NUMBER	VARCHAR2	(25)	Project number
PROJECT_NAME	VARCHAR2	(30)	Project name
DESCRIPTION	VARCHAR2	(250)	Description of project
BUDGET_REVENUE_AMOUNT	NUMBER		Baselined budgeted revenue amount for the project
TOTAL_REVENUE_AMOUNT	NUMBER		Total revenue amount for the project
WRITE_OFF_REVENUE_AMOUNT	NUMBER		Total Write-Off event revenue amount accrued for revenue events that are classified as Revenue Write-Offs
WRITE_ON_REVENUE_AMOUNT	NUMBER		Total event revenue amount accrued for revenue events that are not classified as Revenue Write-Offs. This includes Write-On and Manual revenue event type classifications
INVOICED_AMOUNT	NUMBER		Net invoice amount, which includes retentions, for released invoices. Invoice Amount = Total Invoice Amount - Retentions
TOTAL_RETENTION_AMOUNT	NUMBER		Invoice retention amount on released invoices. The retention amount is reported as a positive amount
RETENTION_BILLED_AMOUNT	NUMBER
TOTAL_INVOICE_AMOUNT	NUMBER		Total amount of released invoices, excluding retentions
PROJFUNC_INVOICE_AMOUNT	NUMBER
PROJFUNC_TOT_RETN_AMOUNT	NUMBER
PROJFUNC_RETN_BILLED_AMOUNT	NUMBER
PROJFUNC_TOT_INV_AMOUNT	NUMBER
ON_HOLD_AMOUNT	NUMBER		Total bill amount of expenditure items on hold (includes both permanent and one-time holds)
ON_HOLD_QUANTITY	NUMBER		Number of expenditure items on hold (includes both permanent and one-time holds)
INVOICE_LESS_WRITEOFF	NUMBER		Total Invoice amount excluding retentions and write off invoices
INVOICE_WRITEOFF	NUMBER		Total Invoice amount of write off invoices

Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_NAME
,      MEMBER_PERSON_ID
,      MEMBER_NAME
,      PROJECT_ROLE_TYPE
,      PROJECT_ROLE
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      DESCRIPTION
,      BUDGET_REVENUE_AMOUNT
,      TOTAL_REVENUE_AMOUNT
,      WRITE_OFF_REVENUE_AMOUNT
,      WRITE_ON_REVENUE_AMOUNT
,      INVOICED_AMOUNT
,      TOTAL_RETENTION_AMOUNT
,      RETENTION_BILLED_AMOUNT
,      TOTAL_INVOICE_AMOUNT
,      PROJFUNC_INVOICE_AMOUNT
,      PROJFUNC_TOT_RETN_AMOUNT
,      PROJFUNC_RETN_BILLED_AMOUNT
,      PROJFUNC_TOT_INV_AMOUNT
,      ON_HOLD_AMOUNT
,      ON_HOLD_QUANTITY
,      INVOICE_LESS_WRITEOFF
,      INVOICE_WRITEOFF
FROM APPS.PA_PROJ_SUMMARY_AMOUNTS_V;

Dependencies

[top of page]

APPS.PA_PROJ_SUMMARY_AMOUNTS_V references the following:

APPS: FND_GLOBAL - show dependent code; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PA_CUST_EVENT_REV_DIST_LINES; PA_CUST_REV_DIST_LINES; PA_DRAFT_INVOICES; PA_DRAFT_INVOICE_ITEMS; PA_DRAFT_REVENUES; PA_DRAFT_REVENUE_ITEMS; PA_EVENTS; PA_EVENT_TYPES; PA_EXPENDITURE_ITEMS_ALL; PA_PROJ_MEMBERS_VIEW; PA_ROLE_JOB_BG_UTILS - show dependent code; PA_SUMMARY_PROJECT_FUNDINGS

APPS.PA_PROJ_SUMMARY_AMOUNTS_V is not referenced by any database object