[Home] [Help] [Dependency Information]
Object Name: | PA_CMT_BY_PA_PERIOD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_CMT_BY_PA_PERIOD_V |
Subobject Name: | |
Status: | VALID |
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 PA periods
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | Refer to base table |
TASK_ID | NUMBER | (15) | Yes | Refer to base table |
RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | Yes | Refer to base table |
RESOURCE_LIST_ID | NUMBER | (15) | Yes | Refer to base table |
PA_PERIOD_NAME | VARCHAR2 | (20) | Yes | Refer to base table |
PERIOD_START_DATE | DATE | Yes | Refer to base table | |
PERIOD_END_DATE | DATE | Yes | Refer to base table | |
CMT_QUANTITY | NUMBER | Total commitment quantity for the period. | ||
CMT_RAW_COST | NUMBER | Total commitment raw cost for the period. | ||
CMT_BURDENED_COST | NUMBER | Total commitment burdened cost for the period. | ||
ORG_ID | NUMBER | (15) | Operating Unit Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, TASK_ID
, RESOURCE_LIST_MEMBER_ID
, RESOURCE_LIST_ID
, PA_PERIOD_NAME
, PERIOD_START_DATE
, PERIOD_END_DATE
, CMT_QUANTITY
, CMT_RAW_COST
, CMT_BURDENED_COST
, ORG_ID
FROM APPS.PA_CMT_BY_PA_PERIOD_V;
APPS.PA_CMT_BY_PA_PERIOD_V is not referenced by any database object
|
|
|