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_LS_DETAIL_V

Object Details

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

View Type

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

PJM_PROJECT_PROJ_LS_DETAIL_V returns project-related line schedule detail information.
This view corresponds to the Project Line Item Detail 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_NUMBER	VARCHAR2	(4000)	User-entered number that uniquely identifies a project
PROJECT_NAME	VARCHAR2	(4000)	User-entered project/seiban name
PROJECT_ID	NUMBER		System-generated number that uniquely identifies a project or seiban
TASK_NUMBER	VARCHAR2	(4000)	User-entered string that uniquely identifies a task within a project
TASK_NAME	VARCHAR2	(4000)	User-entered task name
TASK_ID	NUMBER		System-generated number that uniquely identifies a task
SOURCE	VARCHAR2	(80)	WIP schedule type
SCHEDULE_NUMBER	VARCHAR2	(240)	WIP Job name or flow schedule number
ITEM_NUMBER	VARCHAR2	(40)	Item number
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)	End item model/unit number
PRIMARY_ITEM_ID	NUMBER		Inventory item unique identifier for the assembly
SCHEDULED_START_DATE	DATE		Date on which the job or flow schedule is scheduled to start
SCHEDULED_COMPLETION_DATE	DATE		Date on which the job or flow schedule is scheduled to complete
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_NUMBER
,      PROJECT_NAME
,      PROJECT_ID
,      TASK_NUMBER
,      TASK_NAME
,      TASK_ID
,      SOURCE
,      SCHEDULE_NUMBER
,      ITEM_NUMBER
,      END_ITEM_UNIT_NUMBER
,      PRIMARY_ITEM_ID
,      SCHEDULED_START_DATE
,      SCHEDULED_COMPLETION_DATE
,      PLANNED_QUANTITY
,      QUANTITY_COMPLETED
,      VARIANCE_QUANTITY
FROM APPS.PJM_PROJECT_PROJ_LS_DETAIL_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_PROJ_LS_DETAIL_V references the following:

APPS: PJM_LINE_SCHEDULES_V; PJM_PROJECT - show dependent code

APPS.PJM_PROJECT_PROJ_LS_DETAIL_V is not referenced by any database object