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_LS_LINE_SUM_V

Object Details

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

View Type

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

PJM_PROJECT_TASK_LS_LINE_SUM_V returns task-related line schedule summary information.
This view corresponds to the Task Line web inquiry region.

[View Source]

Columns

Name	Datatype	Length	Comments
LINE_CODE	VARCHAR2	(10)	Production line code
LINE_ID	NUMBER		Production line unique identifier
PROJECT_ID	NUMBER		System-generated number that uniquely identifies a project
TASK_ID	NUMBER		System-generated number that uniquely identifies a task
PLANNED_QUANTITY	NUMBER		Initial planned quantity
QUANTITY_COMPLETED	NUMBER		Quantity completed
VARIANCE_QUANTITY	NUMBER		Variance quantity

Query Text

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


SELECT LINE_CODE
,      LINE_ID
,      PROJECT_ID
,      TASK_ID
,      PLANNED_QUANTITY
,      QUANTITY_COMPLETED
,      VARIANCE_QUANTITY
FROM APPS.PJM_PROJECT_TASK_LS_LINE_SUM_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_TASK_LS_LINE_SUM_V references the following:

APPS: PJM_LINE_SCHEDULES_V

APPS.PJM_PROJECT_TASK_LS_LINE_SUM_V is not referenced by any database object