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


VIEW: APPS.PABV_TASK_RESOURCE_ACT_SUMMARY

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

View Type

A Business Intelligence System view


This shows information about actuals at the project/task/resource level.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ACCUM_ID NUMBER (15) Yes
ACCUM_PERIOD VARCHAR2 (20)
RAW_COST_ITD NUMBER


RAW_COST_YTD NUMBER


RAW_COST_PP NUMBER


RAW_COST_PTD NUMBER


BILLABLE_RAW_COST_ITD NUMBER


BILLABLE_RAW_COST_YTD NUMBER


BILLABLE_RAW_COST_PP NUMBER


BILLABLE_RAW_COST_PTD NUMBER


BURDENED_COST_ITD NUMBER


BURDENED_COST_YTD NUMBER


BURDENED_COST_PP NUMBER


BURDENED_COST_PTD NUMBER


BILLABLE_BURDENED_COST_ITD NUMBER


BILLABLE_BURDENED_COST_YTD NUMBER


BILLABLE_BURDENED_COST_PP NUMBER


BILLABLE_BURDENED_COST_PTD NUMBER


QUANTITY_ITD NUMBER


QUANTITY_YTD NUMBER


QUANTITY_PP NUMBER


QUANTITY_PTD NUMBER


LABOR_HOURS_ITD NUMBER


LABOR_HOURS_YTD NUMBER


LABOR_HOURS_PP NUMBER


LABOR_HOURS_PTD NUMBER


BILLABLE_QUANTITY_ITD NUMBER


BILLABLE_QUANTITY_YTD NUMBER


BILLABLE_QUANTITY_PP NUMBER


BILLABLE_QUANTITY_PTD NUMBER


BILLABLE_LABOR_HOURS_ITD NUMBER


BILLABLE_LABOR_HOURS_YTD NUMBER


BILLABLE_LABOR_HOURS_PP NUMBER


BILLABLE_LABOR_HOURS_PTD NUMBER


REVENUE_ITD NUMBER


REVENUE_YTD NUMBER


REVENUE_PP NUMBER


REVENUE_PTD NUMBER


_LA:TXN_UNIT_OF_MEASURE CHAR (51)

PROJECT_ID NUMBER (15) Yes
TASK_ID NUMBER (15) Yes
RESOURCE_LIST_ID NUMBER (15) Yes
RESOURCE_LIST_ASSIGNMENT_ID NUMBER (15) Yes
RESOURCE_LIST_MEMBER_ID NUMBER (15) Yes
RESOURCE_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
Query Text

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


SELECT PROJECT_ACCUM_ID
,      ACCUM_PERIOD
,      RAW_COST_ITD
,      RAW_COST_YTD
,      RAW_COST_PP
,      RAW_COST_PTD
,      BILLABLE_RAW_COST_ITD
,      BILLABLE_RAW_COST_YTD
,      BILLABLE_RAW_COST_PP
,      BILLABLE_RAW_COST_PTD
,      BURDENED_COST_ITD
,      BURDENED_COST_YTD
,      BURDENED_COST_PP
,      BURDENED_COST_PTD
,      BILLABLE_BURDENED_COST_ITD
,      BILLABLE_BURDENED_COST_YTD
,      BILLABLE_BURDENED_COST_PP
,      BILLABLE_BURDENED_COST_PTD
,      QUANTITY_ITD
,      QUANTITY_YTD
,      QUANTITY_PP
,      QUANTITY_PTD
,      LABOR_HOURS_ITD
,      LABOR_HOURS_YTD
,      LABOR_HOURS_PP
,      LABOR_HOURS_PTD
,      BILLABLE_QUANTITY_ITD
,      BILLABLE_QUANTITY_YTD
,      BILLABLE_QUANTITY_PP
,      BILLABLE_QUANTITY_PTD
,      BILLABLE_LABOR_HOURS_ITD
,      BILLABLE_LABOR_HOURS_YTD
,      BILLABLE_LABOR_HOURS_PP
,      BILLABLE_LABOR_HOURS_PTD
,      REVENUE_ITD
,      REVENUE_YTD
,      REVENUE_PP
,      REVENUE_PTD
,      _LA:TXN_UNIT_OF_MEASURE
,      PROJECT_ID
,      TASK_ID
,      RESOURCE_LIST_ID
,      RESOURCE_LIST_ASSIGNMENT_ID
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.PABV_TASK_RESOURCE_ACT_SUMMARY;

Dependencies

[top of page]

APPS.PABV_TASK_RESOURCE_ACT_SUMMARY references the following:

SchemaAPPS
ViewPA_PRJ_ACCUM_PERIODS_V
SynonymPA_PROJECTS_ALL
SynonymPA_PROJECT_ACCUM_ACTUALS
SynonymPA_PROJECT_ACCUM_HEADERS

APPS.PABV_TASK_RESOURCE_ACT_SUMMARY is not referenced by any database object