[Home] [Help] [Dependency Information]

VIEW: APPS.GMS_STATUS_COMMITMENTS_V

Object Details

Object Name:	GMS_STATUS_COMMITMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMS.GMS_STATUS_COMMITMENTS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT AWARD_ID
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      DOCUMENT_TYPE
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION
,      COMMITMENT_NUMBER
,      DESCRIPTION
,      QUANTITY
,      UNIT_OF_MEASURE
,      SUPPLIER_NAME
,      TRANSACTION_SOURCE
,      RAW_COST
,      BURDENED_COST
,      PA_PERIOD
,      ORG_ID
,      GL_DATE
FROM APPS.GMS_STATUS_COMMITMENTS_V;

Dependencies

[top of page]

APPS

GMS_BUDGET_BALANCE - show dependent code

GMS_COMMITMENT_BURDEN_V

HR_GENERAL - show dependent code

HR_ORGANIZATION_UNITS

HR_SECURITY - show dependent code

PA_CMT_UTILS - show dependent code

PA_CURRENCY - show dependent code

PA_PERIODS

PA_PROJECTS_ALL

PA_TASKS

PO_INTG_DOCUMENT_FUNDS_GRP - show dependent code

APPS.GMS_STATUS_COMMITMENTS_V is not referenced by any database object