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_STATUS

Object Details

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

View Type

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

View of project commitment costs including requisitions, purchase orders, and pending vendor invoices.

[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
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
,      REQ_AMOUNT_OPEN
,      PO_AMOUNT_ORDERED
,      PO_AMOUNT_DELIVERED
,      PO_AMOUNT_OPEN
,      AP_AMOUNT_PENDING
FROM APPS.PA_PROJ_COMMITMENT_STATUS;

Dependencies

[top of page]

APPS.PA_PROJ_COMMITMENT_STATUS 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_PROJ_COMMITMENT_BASE_VIEW; PA_TASK_UTILS - show dependent code; PA_UTILS4 - show dependent code

APPS.PA_PROJ_COMMITMENT_STATUS is not referenced by any database object