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_TASK_V

Object Details

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

View Type

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

PJM_PROJECT_TASK_V returns chargeable tasks for each project.
This view corresponds to the Task Summary (multi-row) and Task Information (single-row) web inquiry regions. It also serves as the base object for the Task Drilldowns region that contains drilldown buttons.

[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
PROJECT_NAME	VARCHAR2	(30)	Yes	User-entered project name
PROJECT_DESCRIPTION	VARCHAR2	(250)		Project description
TASK_ID	NUMBER	(15)	Yes	System-generated number that uniquely identifies a task
TASK_NUMBER	VARCHAR2	(25)	Yes	User-entered string that uniquely identifies a task within a project
TASK_NAME	VARCHAR2	(20)	Yes	User-entered task name
DESCRIPTION	VARCHAR2	(250)		Task description
WBS_SORT_ORDER	VARCHAR2	(4000)		Sort order of task in work breakdown structure
MANAGER	VARCHAR2	(240)		Task manager
START_DATE	DATE			Task start date
END_DATE	DATE			Task end date

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_DESCRIPTION
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      DESCRIPTION
,      WBS_SORT_ORDER
,      MANAGER
,      START_DATE
,      END_DATE
FROM APPS.PJM_PROJECT_TASK_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_TASK_V references the following:

APPS: FND_PROFILE - show dependent code; PA_PROJECTS_ALL; PA_TASKS; PA_TASK_UTILS - show dependent code; PER_ALL_PEOPLE_F

APPS.PJM_PROJECT_TASK_V is not referenced by any database object