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_BGT_SUMMARY

Object Details

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

View Type

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

PA_RPT_CUST_BGT_SUMMARY displays summary project level budget 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. Specifically, all four Reporting Budget Type profiles need to be set up in order to return all the values from this view.

[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
BUDGET_TYPE_CODE	VARCHAR2	(30)	Yes	The identifier of budget type for which this line was created
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 percentage bill split for the customer.
BASE_RAW_COST_ITD	NUMBER			Inception to date base raw cost for project
BASE_RAW_COST_YTD	NUMBER			Year to date base raw cost for project
BASE_RAW_COST_PP	NUMBER			Prior period to date base raw cost for PA or GL period
BASE_RAW_COST_PTD	NUMBER			Period to date base raw cost for PA or GL period
BASE_BURDENED_COST_ITD	NUMBER			Inception to date base burdened cost for project
BASE_BURDENED_COST_YTD	NUMBER			Year to date base burdened cost for project
BASE_BURDENED_COST_PP	NUMBER			Prior period to date base burdened cost for PA or GL period
BASE_BURDENED_COST_PTD	NUMBER			Period to date base burdened cost for PA or GL period
ORIG_RAW_COST_ITD	NUMBER			Inception to date original raw cost for project
ORIG_RAW_COST_YTD	NUMBER			Year to date original raw cost for project
ORIG_RAW_COST_PP	NUMBER			Prior period to date original raw cost for PA or GL period
ORIG_RAW_COST_PTD	NUMBER			Period to date original raw cost for PA or GL period
ORIG_BURDENED_COST_ITD	NUMBER			Inception to date original burdened cost for project
ORIG_BURDENED_COST_YTD	NUMBER			Year to date original burdened cost for project
ORIG_BURDENED_COST_PP	NUMBER			Prior period to date original burdened cost for PA or GL period
ORIG_BURDENED_COST_PTD	NUMBER			Period to date original burdened cost for PA or GL period
BASE_REVENUE_ITD	NUMBER			Inception to date base revenue for project
BASE_REVENUE_YTD	NUMBER			Year to date base revenue for project
BASE_REVENUE_PP	NUMBER			Prior period to date base revenue for PA or GL period
BASE_REVENUE_PTD	NUMBER			Period to date base revenue for PA or GL period
ORIG_REVENUE_ITD	NUMBER			Inception to date original revenue for project
ORIG_REVENUE_YTD	NUMBER			Year to date original revenue for project
ORIG_REVENUE_PP	NUMBER			Prior period to date original revenue for PA or GL period
ORIG_REVENUE_PTD	NUMBER			Period to date original revenue for PA or GL period
ORIG_LABOR_HOURS_ITD	NUMBER			Inception to date original labor hours for project
ORIG_LABOR_HOURS_YTD	NUMBER			Year to date original labor hours for project
ORIG_LABOR_HOURS_PP	NUMBER			Prior period to date original labor hours for PA or GL period
ORIG_LABOR_HOURS_PTD	NUMBER			Period to date original labor hours for PA or GL period
BASE_LABOR_HOURS_ITD	NUMBER			Inception to date base labor hours for project
BASE_LABOR_HOURS_YTD	NUMBER			Year to date base labor hours for project
BASE_LABOR_HOURS_PP	NUMBER			Prior period to date base labor hours for PA or GL period
BASE_LABOR_HOURS_PTD	NUMBER			Period to date base labor hours for PA or GL period
ORIG_LABOR_HOURS_TOT	NUMBER			Total original labor hours
BASE_LABOR_HOURS_TOT	NUMBER			Total base labor hours
BASE_RAW_COST_TOT	NUMBER			Total base raw cost
BASE_BURDENED_COST_TOT	NUMBER			Total base burdened cost
ORIG_RAW_COST_TOT	NUMBER			Total original raw cost
ORIG_BURDENED_COST_TOT	NUMBER			Total original burdened cost
BASE_REVENUE_TOT	NUMBER			Total base revenue
ORIG_REVENUE_TOT	NUMBER			Total original revenue
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project for which the amounts apply
BUDGET_AMOUNT_CODE	VARCHAR2	(30)	Yes	The amount type indocator for the budget
BUDGET_TYPE	VARCHAR2	(30)	Yes	The short, user-friendly name of the budget type
ORG_ID	NUMBER	(15)		Operating Unit Identifier

Query Text

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


SELECT PROJECT_ACCUM_ID
,      BUDGET_TYPE_CODE
,      ACCUM_PERIOD
,      CUSTOMER_ID
,      CUSTOMER_BILL_SPLIT
,      BASE_RAW_COST_ITD
,      BASE_RAW_COST_YTD
,      BASE_RAW_COST_PP
,      BASE_RAW_COST_PTD
,      BASE_BURDENED_COST_ITD
,      BASE_BURDENED_COST_YTD
,      BASE_BURDENED_COST_PP
,      BASE_BURDENED_COST_PTD
,      ORIG_RAW_COST_ITD
,      ORIG_RAW_COST_YTD
,      ORIG_RAW_COST_PP
,      ORIG_RAW_COST_PTD
,      ORIG_BURDENED_COST_ITD
,      ORIG_BURDENED_COST_YTD
,      ORIG_BURDENED_COST_PP
,      ORIG_BURDENED_COST_PTD
,      BASE_REVENUE_ITD
,      BASE_REVENUE_YTD
,      BASE_REVENUE_PP
,      BASE_REVENUE_PTD
,      ORIG_REVENUE_ITD
,      ORIG_REVENUE_YTD
,      ORIG_REVENUE_PP
,      ORIG_REVENUE_PTD
,      ORIG_LABOR_HOURS_ITD
,      ORIG_LABOR_HOURS_YTD
,      ORIG_LABOR_HOURS_PP
,      ORIG_LABOR_HOURS_PTD
,      BASE_LABOR_HOURS_ITD
,      BASE_LABOR_HOURS_YTD
,      BASE_LABOR_HOURS_PP
,      BASE_LABOR_HOURS_PTD
,      ORIG_LABOR_HOURS_TOT
,      BASE_LABOR_HOURS_TOT
,      BASE_RAW_COST_TOT
,      BASE_BURDENED_COST_TOT
,      ORIG_RAW_COST_TOT
,      ORIG_BURDENED_COST_TOT
,      BASE_REVENUE_TOT
,      ORIG_REVENUE_TOT
,      PROJECT_ID
,      BUDGET_AMOUNT_CODE
,      BUDGET_TYPE
,      ORG_ID
FROM APPS.PA_RPT_CUST_BGT_SUMMARY;

Dependencies

[top of page]

APPS.PA_RPT_CUST_BGT_SUMMARY references the following:

APPS: PA_BUDGET_TYPES; PA_PROJECTS_ALL; PA_PROJECT_ACCUM_BUDGETS; PA_PROJECT_ACCUM_HEADERS; PA_PROJECT_CUSTOMERS; PA_PROJECT_TYPES

APPS.PA_RPT_CUST_BGT_SUMMARY is referenced by following:

APPS: PA_RPT_CUST_SUMMARY_BASE_V