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

VIEW: APPS.PA_CMT_BY_GL_PERIOD_V

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

View Type

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


This view displays current commitment totals for lowest level tasks and resources by GL periods


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes Refer to the base table
TASK_ID NUMBER (15) Yes Refer to the base table
RESOURCE_LIST_MEMBER_ID NUMBER (15) Yes Refer to the base table
RESOURCE_LIST_ID NUMBER (15) Yes Refer to the base table
GL_PERIOD_NAME VARCHAR2 (15) Yes Refer to the base table
PERIOD_START_DATE DATE
Yes Refer to the base table
PERIOD_END_DATE DATE
Yes Refer to the base table
CMT_QUANTITY NUMBER

Total commitment quantity by period
CMT_RAW_COST NUMBER

Total commitment raw cost by period
CMT_BURDENED_COST NUMBER

Total commitment burdened cost by period
ORG_ID NUMBER (15)
Operating Unit Identifier
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_LIST_ID
,      GL_PERIOD_NAME
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      CMT_QUANTITY
,      CMT_RAW_COST
,      CMT_BURDENED_COST
,      ORG_ID
FROM APPS.PA_CMT_BY_GL_PERIOD_V;

Dependencies

[top of page]

APPS.PA_CMT_BY_GL_PERIOD_V references the following:

SchemaAPPS
SynonymGL_PERIOD_STATUSES
SynonymPA_IMPLEMENTATIONS
PL/SQL PackagePA_PERIOD_PROCESS_PKG - show dependent code
SynonymPA_RESOURCE_ACCUM_DETAILS
SynonymPA_TXN_ACCUM

APPS.PA_CMT_BY_GL_PERIOD_V is not referenced by any database object