DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_RPT_PRJ_CMT_SUMMARY

Object Details
Object Name: PA_RPT_PRJ_CMT_SUMMARY
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_RPT_PRJ_CMT_SUMMARY
Subobject Name:
Status: VALID

View Type

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


PA_RPT_PRJ_CMT_SUMMARY displays summary project level commitments information for Oracle Discoverer Workbooks. All Reporting Profiles must be set up at the site level of the application in order to use this view correctly.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ACCUM_ID NUMBER (15) Yes The identifier which uniquely identifies this line for the actuals and budgets
ACCUM_PERIOD VARCHAR2 (20)
Last accumulation GL or PA period, depending on the imp. option
CMT_RAW_COST NUMBER

Commitment raw cost for the project
CMT_BURDENED_COST NUMBER

Commitment burdened cost for the project
PROJECT_ID NUMBER (15) Yes The identifier of the project for which the amounts apply
Query Text

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


SELECT PROJECT_ACCUM_ID
,      ACCUM_PERIOD
,      CMT_RAW_COST
,      CMT_BURDENED_COST
,      PROJECT_ID
FROM APPS.PA_RPT_PRJ_CMT_SUMMARY;

Dependencies

[top of page]

APPS.PA_RPT_PRJ_CMT_SUMMARY references the following:

SchemaAPPS
SynonymPA_PROJECTS
SynonymPA_PROJECT_ACCUM_COMMITMENTS
SynonymPA_PROJECT_ACCUM_HEADERS
APPS.PA_RPT_PRJ_CMT_SUMMARY is referenced by following:

SchemaAPPS
ViewPA_RPT_PRJ_SUMMARY_BASE_V