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_COMMITMENT_BASE_VIEW

Object Details

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

View Type

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

Base view of the project commitment reporting view PA_PROJ_COMMITMENT_STATUS.

[View Source]

Columns

Name	Datatype	Length	Comments
PROJECT_NUMBER	VARCHAR2	(25)	Number of the project charged
PROJECT_NAME	VARCHAR2	(30)	Name of the project charged
PROJECT_ID	NUMBER	(15)	Identifier of the project charged
TASK_NUMBER	VARCHAR2	(25)	Number of the lowest level task charged
TASK_NAME	VARCHAR2	(20)	Name of the lowest level task charged
REQ_AMOUNT_OPEN	NUMBER		Open requisition amount, defined as approved, unpurchased requisitions
PO_AMOUNT_ORDERED	NUMBER		PO amount ordered, defined as the amount originally ordered - amount cancelled
PO_AMOUNT_DELIVERED	NUMBER		PO amount delivered
PO_AMOUNT_OPEN	NUMBER		PO amount open defined as the approved, uninvoiced PO amount
AP_AMOUNT_PENDING	NUMBER		Pending invoice amount

Query Text

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


SELECT PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_ID
,      TASK_NUMBER
,      TASK_NAME
,      REQ_AMOUNT_OPEN
,      PO_AMOUNT_ORDERED
,      PO_AMOUNT_DELIVERED
,      PO_AMOUNT_OPEN
,      AP_AMOUNT_PENDING
FROM APPS.PA_PROJ_COMMITMENT_BASE_VIEW;

Dependencies

[top of page]

APPS.PA_PROJ_COMMITMENT_BASE_VIEW references the following:

APPS: AP_INVOICES_PKG - show dependent code; FND_PROFILE - show dependent code; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; PA_CMT_UTILS - show dependent code; PA_CURRENCY - show dependent code; PA_FUNDS_CONTROL_UTILS - show dependent code; PA_MULTI_CURRENCY - show dependent code; PA_PJC_CWK_UTILS - show dependent code; PA_PROJECTS; PA_PROJ_APPR_PO_DISTRIBUTIONS; PA_PROJ_APPR_REQ_DISTRIBUTIONS; PA_PROJ_AP_INV_DISTRIBUTIONS; PA_TASK_UTILS - show dependent code; PA_UTILS4 - show dependent code

APPS.PA_PROJ_COMMITMENT_BASE_VIEW is referenced by following:

APPS: PA_PROJ_COMMITMENT_STATUS