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.PJM_PROJECT_PROJ_SUMMARY_V

Object Details

Object Name:	PJM_PROJECT_PROJ_SUMMARY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJM.PJM_PROJECT_PROJ_SUMMARY_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

PJM_PROJECT_PROJ_SUMMARY_V displays summary project level actual, budget, and commitment information for web inquiry. Project summary information is based on view PJM_PROJECT_PROJ_SUMM_BASE_V which is a scaled down version of PA_RPT_PRJ_SUMMARY from Oracle Projects. 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.
.
PJM_PROJECT_PROJ_SUMMARY_V corresponds to the Project Summary region in the AK metadata definition.
.
This view can be extended to include complex formulae based on raw summary information to suit your business needs. Placeholder columns FORMULA1-20 are included in the view definition as well as the AK meta data definition to hold those formulae. Once you have added your formulae, you can modify the display prompts in the Define Regions form available from the AK Developer responsibility.
.
The syntax of the view can be found under $PJM_TOP/admin/sql/pjmvw001.sql for easily customization.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	System-generated number that uniquely identifies a project
PROJECT_NUMBER	VARCHAR2	(25)	Yes	User-entered number that uniquely identifies a project or seiban
PROJECT_NAME	VARCHAR2	(30)	Yes	User-entered project / seiban name
PROJECT_DESCRIPTION	VARCHAR2	(250)		Project description
START_DATE	DATE			Project start date
COMPLETION_DATE	DATE			The date on which the project is completed
CLOSED_DATE	DATE			The date that the project was closed by changing the project status to Closed
MANAGER_PERSON_ID	NUMBER	(15)		Project manager employee unique identifier
MANAGER_NAME	VARCHAR2	(240)		Project manager name
PROJECT_STATUS	VARCHAR2	(80)	Yes	The user-defined project status name
PM_PRODUCT	VARCHAR2	(30)		The identifier of the external project management system from which the project was imported
PM_PROJECT_REFERENCE	VARCHAR2	(25)		The project identifier in the external project management system from which the project was imported
PROJECT_ORGANIZATION_ID	NUMBER	(15)	Yes	Unique identifier of organization owning the project
PROJECT_ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Name of organization owning the project
PROJECT_TYPE	VARCHAR2	(20)	Yes	The project type that classifies the project and defaults project information upon project entry
PROJECT_TYPE_CLASS_CODE	VARCHAR2	(30)		Indicates the class of project type
ORG_ID	NUMBER	(15)		Operating unit identifier for multi-organization installations
OPERATING_UNIT_NAME	VARCHAR2	(240)		Operating unit name
REVENUE_PTD	VARCHAR2	(24)		Period-to-date revenue for Project Accounting or General Ledger period
BURDENED_COST_PTD	VARCHAR2	(24)		Period-to-date burdened cost for Project Accounting or General Ledger period
MARGIN_PTD	VARCHAR2	(24)		Period-to-date margin for project
MARGIN_PTD_PERCENTAGE	NUMBER			Period-to-date margin percentage for project
REVENUE_YTD	VARCHAR2	(24)		Year-to-date revenue for project
BURDENED_COST_YTD	VARCHAR2	(24)		Year-to-date burdened cost for project
MARGIN_YTD	VARCHAR2	(24)		Year-to-date margin for project
MARGIN_YTD_PERCENTAGE	NUMBER			Year-to-date margin percentage for project
REVENUE_ITD	VARCHAR2	(24)		Inception-to-date revenue for project
BURDENED_COST_ITD	VARCHAR2	(24)		Inception-to-date burdened cost for project
MARGIN_ITD	VARCHAR2	(24)		Inception-to-date margin for project
MARGIN_ITD_PERCENTAGE	NUMBER			Inception-to-date margin percentage for project
BASE_REVENUE_TOT3	VARCHAR2	(24)		Total base revenue
BACKLOG	VARCHAR2	(24)		Backlog
BACKLOG_PERCENTAGE	NUMBER			Backlog percentage
CMT_BURDENED_COST	VARCHAR2	(24)		Burdened commitment cost
TOTAL_COST	VARCHAR2	(24)		Total cost
RAW_COST_ITD	NUMBER			Inception-to-date raw cost for project
RAW_COST_YTD	NUMBER			Year-to-date raw cost for project
RAW_COST_PTD	NUMBER			Period-to-date raw cost for Project Accounting or General Ledger 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_PTD	NUMBER			Period-to-date billable raw cost for Project Accounting or General Ledger 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_PTD	NUMBER			Period-to- date billable burdened cost for Project Accounting or General Ledger 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_PTD	NUMBER			Period-to- date labor hours for Project Accounting or General Ledger 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_PTD	NUMBER			Period-to- date billable labor hours for Project Accounting or General Ledger period
BUDGET_TYPE_CODE1	VARCHAR2	(30)		The identifier of budget type for which this line was created
BUDGET_TYPE1	VARCHAR2	(30)		The short, user-friendly name of the budget type
BASE_RAW_COST_ITD1	NUMBER			Inception-to-date base raw cost for project
BASE_RAW_COST_YTD1	NUMBER			Year-to-date base raw cost for project
BASE_RAW_COST_PTD1	NUMBER			Period-to-date base raw cost for Project Accounting or General Ledger period
BASE_RAW_COST_TOT1	NUMBER			Total base raw cost
ORIG_RAW_COST_ITD1	NUMBER			Inception-to-date original raw cost for project
ORIG_RAW_COST_YTD1	NUMBER			Year-to-date original raw cost for project
ORIG_RAW_COST_PTD1	NUMBER			Period-to-date original raw cost for Project Accounting or General Ledger period
ORIG_RAW_COST_TOT1	NUMBER			Total original raw cost
BASE_BURDENED_COST_ITD1	NUMBER			Inception-to-date base burdened cost for project
BASE_BURDENED_COST_YTD1	NUMBER			Year-to-date base burdened cost for project
BASE_BURDENED_COST_PTD1	NUMBER			Period-to-date base burdened cost for Project Accounting or General Ledger period
BASE_BURDENED_COST_TOT1	NUMBER			Total base burdened cost
ORIG_BURDENED_COST_ITD1	NUMBER			Inception-to-date original burdened cost for project
ORIG_BURDENED_COST_YTD1	NUMBER			Year-to-date original burdened cost for project
ORIG_BURDENED_COST_PTD1	NUMBER			Period-to-date original burdened cost for Project Accounting or General Ledger period
ORIG_BURDENED_COST_TOT1	NUMBER			Total original burdened cost
ORIG_LABOR_HOURS_ITD1	NUMBER			Inception-to-date original labor hours for project
ORIG_LABOR_HOURS_YTD1	NUMBER			Year-to-date original labor hours for project
ORIG_LABOR_HOURS_PTD1	NUMBER			Period-to-date original labor hours for Project Accounting or General Ledger period
ORIG_LABOR_HOURS_TOT1	NUMBER			Total original labor hours
BASE_LABOR_HOURS_ITD1	NUMBER			Inception-to-date base labor hours for project
BASE_LABOR_HOURS_YTD1	NUMBER			Year-to-date base labor hours for project
BASE_LABOR_HOURS_PTD1	NUMBER			Period-to-date base labor hours for Project Accounting or General Ledger period
BASE_LABOR_HOURS_TOT1	NUMBER			Total base labor hours
BUDGET_TYPE_CODE3	VARCHAR2	(0)		The identifier of budget type for which this line was created
BUDGET_TYPE3	VARCHAR2	(0)		The short, user-friendly name of the budget type
BASE_REVENUE_ITD3	NUMBER			Inception-to-date base revenue for project
BASE_REVENUE_YTD3	NUMBER			Year-to-date base revenue for project
BASE_REVENUE_PTD3	NUMBER			Period-to-date base revenue for Project Accounting or General Ledger period
ORIG_REVENUE_ITD3	NUMBER			Inception-to-date original revenue for project
ORIG_REVENUE_YTD3	NUMBER			Year-to-date original revenue for project
ORIG_REVENUE_PTD3	NUMBER			Period-to-date original revenue for Project Accounting or General Ledger period
ORIG_REVENUE_TOT3	NUMBER			Total original revenue
ORIG_LABOR_HOURS_ITD3	NUMBER			Inception-to-date original labor hours for project
ORIG_LABOR_HOURS_YTD3	NUMBER			Year-to-date original labor hours for project
ORIG_LABOR_HOURS_PTD3	NUMBER			Period-to-date original labor hours for Project Accounting or General Ledger period
ORIG_LABOR_HOURS_TOT3	NUMBER			Total original labor hours
BASE_LABOR_HOURS_ITD3	NUMBER			Inception-to-date base labor hours for project
BASE_LABOR_HOURS_YTD3	NUMBER			Year-to-date base labor hours for project
BASE_LABOR_HOURS_PTD3	NUMBER			Period-to-date base labor hours for Project Accounting or General Ledger period
BASE_LABOR_HOURS_TOT3	NUMBER			Total base labor hours
CMT_RAW_COST	NUMBER			Commitment raw cost
FORMULA1	NUMBER			Customizable formula column
FORMULA2	NUMBER			Customizable formula column
FORMULA3	NUMBER			Customizable formula column
FORMULA4	NUMBER			Customizable formula column
FORMULA5	NUMBER			Customizable formula column
FORMULA6	NUMBER			Customizable formula column
FORMULA7	NUMBER			Customizable formula column
FORMULA8	NUMBER			Customizable formula column
FORMULA9	NUMBER			Customizable formula column
FORMULA10	NUMBER			Customizable formula column
FORMULA11	NUMBER			Customizable formula column
FORMULA12	NUMBER			Customizable formula column
FORMULA13	NUMBER			Customizable formula column
FORMULA14	NUMBER			Customizable formula column
FORMULA15	NUMBER			Customizable formula column
FORMULA16	NUMBER			Customizable formula column
FORMULA17	NUMBER			Customizable formula column
FORMULA18	NUMBER			Customizable formula column
FORMULA19	NUMBER			Customizable formula column
FORMULA20	NUMBER			Customizable formula column

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_DESCRIPTION
,      START_DATE
,      COMPLETION_DATE
,      CLOSED_DATE
,      MANAGER_PERSON_ID
,      MANAGER_NAME
,      PROJECT_STATUS
,      PM_PRODUCT
,      PM_PROJECT_REFERENCE
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ORGANIZATION_NAME
,      PROJECT_TYPE
,      PROJECT_TYPE_CLASS_CODE
,      ORG_ID
,      OPERATING_UNIT_NAME
,      REVENUE_PTD
,      BURDENED_COST_PTD
,      MARGIN_PTD
,      MARGIN_PTD_PERCENTAGE
,      REVENUE_YTD
,      BURDENED_COST_YTD
,      MARGIN_YTD
,      MARGIN_YTD_PERCENTAGE
,      REVENUE_ITD
,      BURDENED_COST_ITD
,      MARGIN_ITD
,      MARGIN_ITD_PERCENTAGE
,      BASE_REVENUE_TOT3
,      BACKLOG
,      BACKLOG_PERCENTAGE
,      CMT_BURDENED_COST
,      TOTAL_COST
,      RAW_COST_ITD
,      RAW_COST_YTD
,      RAW_COST_PTD
,      BILLABLE_RAW_COST_ITD
,      BILLABLE_RAW_COST_YTD
,      BILLABLE_RAW_COST_PTD
,      BILLABLE_BURDENED_COST_ITD
,      BILLABLE_BURDENED_COST_YTD
,      BILLABLE_BURDENED_COST_PTD
,      LABOR_HOURS_ITD
,      LABOR_HOURS_YTD
,      LABOR_HOURS_PTD
,      BILLABLE_LABOR_HOURS_ITD
,      BILLABLE_LABOR_HOURS_YTD
,      BILLABLE_LABOR_HOURS_PTD
,      BUDGET_TYPE_CODE1
,      BUDGET_TYPE1
,      BASE_RAW_COST_ITD1
,      BASE_RAW_COST_YTD1
,      BASE_RAW_COST_PTD1
,      BASE_RAW_COST_TOT1
,      ORIG_RAW_COST_ITD1
,      ORIG_RAW_COST_YTD1
,      ORIG_RAW_COST_PTD1
,      ORIG_RAW_COST_TOT1
,      BASE_BURDENED_COST_ITD1
,      BASE_BURDENED_COST_YTD1
,      BASE_BURDENED_COST_PTD1
,      BASE_BURDENED_COST_TOT1
,      ORIG_BURDENED_COST_ITD1
,      ORIG_BURDENED_COST_YTD1
,      ORIG_BURDENED_COST_PTD1
,      ORIG_BURDENED_COST_TOT1
,      ORIG_LABOR_HOURS_ITD1
,      ORIG_LABOR_HOURS_YTD1
,      ORIG_LABOR_HOURS_PTD1
,      ORIG_LABOR_HOURS_TOT1
,      BASE_LABOR_HOURS_ITD1
,      BASE_LABOR_HOURS_YTD1
,      BASE_LABOR_HOURS_PTD1
,      BASE_LABOR_HOURS_TOT1
,      BUDGET_TYPE_CODE3
,      BUDGET_TYPE3
,      BASE_REVENUE_ITD3
,      BASE_REVENUE_YTD3
,      BASE_REVENUE_PTD3
,      ORIG_REVENUE_ITD3
,      ORIG_REVENUE_YTD3
,      ORIG_REVENUE_PTD3
,      ORIG_REVENUE_TOT3
,      ORIG_LABOR_HOURS_ITD3
,      ORIG_LABOR_HOURS_YTD3
,      ORIG_LABOR_HOURS_PTD3
,      ORIG_LABOR_HOURS_TOT3
,      BASE_LABOR_HOURS_ITD3
,      BASE_LABOR_HOURS_YTD3
,      BASE_LABOR_HOURS_PTD3
,      BASE_LABOR_HOURS_TOT3
,      CMT_RAW_COST
,      FORMULA1
,      FORMULA2
,      FORMULA3
,      FORMULA4
,      FORMULA5
,      FORMULA6
,      FORMULA7
,      FORMULA8
,      FORMULA9
,      FORMULA10
,      FORMULA11
,      FORMULA12
,      FORMULA13
,      FORMULA14
,      FORMULA15
,      FORMULA16
,      FORMULA17
,      FORMULA18
,      FORMULA19
,      FORMULA20
FROM APPS.PJM_PROJECT_PROJ_SUMMARY_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_PROJ_SUMMARY_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; PA_BUDGET_TYPES; PA_PROJECTS_ALL; PA_PROJECT_ACCUM_ACTUALS; PA_PROJECT_ACCUM_BUDGETS; PA_PROJECT_ACCUM_COMMITMENTS; PA_PROJECT_ACCUM_HEADERS; PA_PROJECT_PLAYERS; PA_PROJECT_STATUSES; PA_PROJECT_STATUS_CONTROLS; PA_PROJECT_TYPES_ALL; PA_RPT_UTILS - show dependent code; PA_SECURITY - show dependent code; PER_ALL_PEOPLE_F

APPS.PJM_PROJECT_PROJ_SUMMARY_V is not referenced by any database object