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]

TABLE: PA.PA_PROJECT_ACCUM_BUDGETS

Object Details

Object Name:	PA_PROJECT_ACCUM_BUDGETS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PROJECT_ACCUM_BUDGETS
Subobject Name:
Status:	VALID

PA_PROJECT_ACCUM_BUDGETS stores the summary records for original
budgets and baseline budgets by budget type for each combination of
project_id, task_id, resource_list_member_id and budget type.
Budget information is denormalized and stored at each level of
Work Breakdown Structure (equal and higher than WBS level of
budgets). For resources, amounts are stored only at the lowest
level.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJECT_ACCUM_BUDGETS_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	PROJECT_ACCUM_ID BUDGET_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ACCUM_ID	NUMBER	(15)	Yes	The identifier of accumulation header for which this line was created
BUDGET_TYPE_CODE	VARCHAR2	(30)	Yes	The identifier of budget type for which this line was created
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			Base raw cost for prior GL or PA 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			Base burdened cost for prior GL or PA 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			Original raw cost for prior GL or PA 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 project
ORIG_BURDENED_COST_PP	NUMBER			Original burdened cost for prior GL or PA 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 project
BASE_REVENUE_PP	NUMBER			Base revenue for prior GL or PA 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			Original revenue for prior GL or PA 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			Original labor hours for prior GL or PA 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			Base labor hours for prior GL or PA period
BASE_LABOR_HOURS_PTD	NUMBER			Period to date base labor hours for PA or GL period
ORIG_QUANTITY_YTD	NUMBER			Year to date original quantity for project
ORIG_QUANTITY_ITD	NUMBER			Inception to date original quantity for project
ORIG_QUANTITY_PP	NUMBER			Original quantity for prior GL or PA period
ORIG_QUANTITY_PTD	NUMBER			Period to date original quantity for PA or GL period
BASE_QUANTITY_YTD	NUMBER			Year to date base quantity for project
BASE_QUANTITY_ITD	NUMBER			Inception to date base quantity for project
BASE_QUANTITY_PP	NUMBER			Base quantity for prior GL or PA period
BASE_QUANTITY_PTD	NUMBER			Period to date base quantity for PA or GL period
ORIG_LABOR_HOURS_TOT	NUMBER			Total original labor hours
BASE_LABOR_HOURS_TOT	NUMBER			Total base labor hours
ORIG_QUANTITY_TOT	NUMBER			Total original quantity
BASE_QUANTITY_TOT	NUMBER			Total base quantity
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
BASE_UNIT_OF_MEASURE	VARCHAR2	(30)		Base unit of measurement
ORIG_UNIT_OF_MEASURE	VARCHAR2	(30)		Original unit of measurement
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column
REQUEST_ID	NUMBER			Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
FIN_PLAN_TYPE_ID	NUMBER	(15)		The identifier of the financial plan type.

Query Text

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


SELECT PROJECT_ACCUM_ID
,      BUDGET_TYPE_CODE
,      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_QUANTITY_YTD
,      ORIG_QUANTITY_ITD
,      ORIG_QUANTITY_PP
,      ORIG_QUANTITY_PTD
,      BASE_QUANTITY_YTD
,      BASE_QUANTITY_ITD
,      BASE_QUANTITY_PP
,      BASE_QUANTITY_PTD
,      ORIG_LABOR_HOURS_TOT
,      BASE_LABOR_HOURS_TOT
,      ORIG_QUANTITY_TOT
,      BASE_QUANTITY_TOT
,      BASE_RAW_COST_TOT
,      BASE_BURDENED_COST_TOT
,      ORIG_RAW_COST_TOT
,      ORIG_BURDENED_COST_TOT
,      BASE_REVENUE_TOT
,      ORIG_REVENUE_TOT
,      BASE_UNIT_OF_MEASURE
,      ORIG_UNIT_OF_MEASURE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      FIN_PLAN_TYPE_ID
FROM PA.PA_PROJECT_ACCUM_BUDGETS;

Dependencies

[top of page]

PA.PA_PROJECT_ACCUM_BUDGETS does not reference any database object

PA.PA_PROJECT_ACCUM_BUDGETS is referenced by following:

PA: PA_PROJECT_ACCUM_BUDGETS#