eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PA_RPT_CUST_ACT_SUMMARY

Object Details

Object Name:	PA_RPT_CUST_ACT_SUMMARY
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_RPT_CUST_ACT_SUMMARY
Subobject Name:
Status:	VALID

View Type

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

PA_RPT_CUST_ACT_SUMMARY displays summary project level actual information by customer for Oracle Discoverer Workbooks. All project amounts are divided among each of the customers of the project based on the customer bill split percentage. All Reporting Profiles must be set up at the site level of the application in order to use this view correctly.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ACCUM_ID	NUMBER	(15)	Yes	The identifier which uniquely identifies this line for the actuals and budgets
ACCUM_PERIOD	VARCHAR2	(20)		Last accumulation GL or PA period, depending on the imp. option
CUSTOMER_ID	NUMBER	(15)	Yes	The identifier of the customer that is involved with the project
CUSTOMER_BILL_SPLIT	NUMBER	(7)		The bill split percenatge for the customer.
RAW_COST_ITD	NUMBER			Inception to date raw cost for project
RAW_COST_YTD	NUMBER			Year to date raw cost for project
RAW_COST_PP	NUMBER			Prior period to date raw cost for project
RAW_COST_PTD	NUMBER			Period to date raw cost for PA or GL period
BILLABLE_RAW_COST_ITD	NUMBER			Inception to date billable raw cost for project
BILLABLE_RAW_COST_YTD	NUMBER			Year to date billable raw cost for project
BILLABLE_RAW_COST_PP	NUMBER			Prior period to date billable raw cost for project
BILLABLE_RAW_COST_PTD	NUMBER			Period to date billable raw cost for PA or GL period
BURDENED_COST_ITD	NUMBER			Inception to date burdened cost for project
BURDENED_COST_YTD	NUMBER			Year to date burdened cost for project
BURDENED_COST_PP	NUMBER			Prior period to date burdened cost for project
BURDENED_COST_PTD	NUMBER			Period to date burdened cost for PA or GL period
BILLABLE_BURDENED_COST_ITD	NUMBER			Inception to date billable burdened cost for project
BILLABLE_BURDENED_COST_YTD	NUMBER			Year to date billable burdened cost for project
BILLABLE_BURDENED_COST_PP	NUMBER			Prior period to date billable burdened cost for project
BILLABLE_BURDENED_COST_PTD	NUMBER			Period to date billable burdened cost for PA or GL period
LABOR_HOURS_ITD	NUMBER			Inception to date labor hours for project
LABOR_HOURS_YTD	NUMBER			Year to date labor hours for project
LABOR_HOURS_PP	NUMBER			Prior period to date labor hours for project
LABOR_HOURS_PTD	NUMBER			Period to date labor hours for PA or GL period
BILLABLE_LABOR_HOURS_ITD	NUMBER			Inception to date billable labor hours for project
BILLABLE_LABOR_HOURS_YTD	NUMBER			Year to date billable labor hours for project
BILLABLE_LABOR_HOURS_PP	NUMBER			Prior period to date billable labor hours for project
BILLABLE_LABOR_HOURS_PTD	NUMBER			Period to date billable labor hours for PA or GL period
REVENUE_ITD	NUMBER			Inception to date revenue for project
REVENUE_YTD	NUMBER			Year to date revenue for project
REVENUE_PP	NUMBER			Prior period to date revenue for PA or GL period
REVENUE_PTD	NUMBER			Period to date revenue for PA or GL period
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project for which the amounts apply

Query Text

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


SELECT PROJECT_ACCUM_ID
,      ACCUM_PERIOD
,      CUSTOMER_ID
,      CUSTOMER_BILL_SPLIT
,      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
,      LABOR_HOURS_ITD
,      LABOR_HOURS_YTD
,      LABOR_HOURS_PP
,      LABOR_HOURS_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
,      PROJECT_ID
FROM APPS.PA_RPT_CUST_ACT_SUMMARY;

Dependencies

[top of page]

APPS.PA_RPT_CUST_ACT_SUMMARY references the following:

APPS: PA_PROJECTS; PA_PROJECT_ACCUM_ACTUALS; PA_PROJECT_ACCUM_HEADERS; PA_PROJECT_CUSTOMERS; PA_PROJECT_TYPES

APPS.PA_RPT_CUST_ACT_SUMMARY is referenced by following:

APPS: PA_RPT_CUST_SUMMARY_BASE_V