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

VIEW: APPS.PA_ACCUM_RSRC_CMT_BASE_V

Object Details
Object Name: PA_ACCUM_RSRC_CMT_BASE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_ACCUM_RSRC_CMT_BASE_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
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
RESOURCE_LIST_MEMBER_ID NUMBER

PARENT_MEMBER_ID NUMBER

RESOURCE_LIST_ASSIGNMENT_ID NUMBER (15)
CMT_RAW_COST_ITD NUMBER

CMT_RAW_COST_YTD NUMBER

CMT_RAW_COST_PP NUMBER

CMT_RAW_COST_PTD NUMBER

CMT_BURDENED_COST_ITD NUMBER

CMT_BURDENED_COST_YTD NUMBER

CMT_BURDENED_COST_PP NUMBER

CMT_BURDENED_COST_PTD NUMBER

CMT_QUANTITY_ITD NUMBER

CMT_QUANTITY_YTD NUMBER

CMT_QUANTITY_PP NUMBER

CMT_QUANTITY_PTD NUMBER

Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      RESOURCE_LIST_MEMBER_ID
,      PARENT_MEMBER_ID
,      RESOURCE_LIST_ASSIGNMENT_ID
,      CMT_RAW_COST_ITD
,      CMT_RAW_COST_YTD
,      CMT_RAW_COST_PP
,      CMT_RAW_COST_PTD
,      CMT_BURDENED_COST_ITD
,      CMT_BURDENED_COST_YTD
,      CMT_BURDENED_COST_PP
,      CMT_BURDENED_COST_PTD
,      CMT_QUANTITY_ITD
,      CMT_QUANTITY_YTD
,      CMT_QUANTITY_PP
,      CMT_QUANTITY_PTD
FROM APPS.PA_ACCUM_RSRC_CMT_BASE_V;

Dependencies

[top of page]

APPS.PA_ACCUM_RSRC_CMT_BASE_V references the following:

SchemaAPPS
SynonymPA_PROJECT_ACCUM_COMMITMENTS
SynonymPA_PROJECT_ACCUM_HEADERS
SynonymPA_RESOURCE_LIST_MEMBERS
APPS.PA_ACCUM_RSRC_CMT_BASE_V is referenced by following:

SchemaAPPS
ViewPA_ACCUM_RSRC_CMT_V