[Home] [Help] [Dependency Information]
Object Name: | PA_ACT_BY_PA_PERIOD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_ACT_BY_PA_PERIOD_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PA_ACT_BY_PA_PERIOD_V is a view that displays actual cost and revenue
totals for lowest level tasks and resources by PA periods. The view
is mainly used by external project management systems that import
actuals from Oracle Projects .
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. |
PA_PERIOD_NAME | VARCHAR2 | (20) | 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. | |
REVENUE | NUMBER | Total revenue for the period. | ||
RAW_COST | NUMBER | Total raw cost for the period. | ||
CAPITAL_RAW_COST | NUMBER | Total capitalized raw cost for the period. | ||
BURDENED_COST | NUMBER | Total burdened cost for the period. | ||
CAPITAL_BURDENED_COST | NUMBER | Total capitalized burdened cost for the period. | ||
QUANTITY | NUMBER | Total quantity for the period. | ||
LABOR_HOURS | NUMBER | Total labor hours for the period. | ||
BILLABLE_RAW_COST | NUMBER | Total billable raw cost for the period. | ||
BILLABLE_BURDENED_COST | NUMBER | Total billable burdened cost for the period. | ||
BILLABLE_QUANTITY | NUMBER | Total billable quantity for the period. | ||
BILLABLE_LABOR_HOURS | NUMBER | Total billable labor hours for the period. |
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
, REVENUE
, RAW_COST
, CAPITAL_RAW_COST
, BURDENED_COST
, CAPITAL_BURDENED_COST
, QUANTITY
, LABOR_HOURS
, BILLABLE_RAW_COST
, BILLABLE_BURDENED_COST
, BILLABLE_QUANTITY
, BILLABLE_LABOR_HOURS
FROM APPS.PA_ACT_BY_PA_PERIOD_V;
APPS.PA_ACT_BY_PA_PERIOD_V is not referenced by any database object
|
|
|