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_LINE_SCHEDULES_V

Object Details

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

View Type

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

PJM_LINE_SCHEDULES_V is a lower level view that returns line scheduling detail information. While not directly used in the Web Inquiry, this view provides different levels of summarization by item, day or week for a project or task.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	ROWID, or row identifier, from the base table
PROJECT_ID	NUMBER		System-generated number that uniquely identifies a project or seiban
TASK_ID	NUMBER		System-generated number that uniquely identifies a task
LINE_ID	NUMBER		Production line unique identifier
LINE_CODE	VARCHAR2	(10)	Production line code
SCHEDULE_TYPE	NUMBER		WIP schedule type code
SCHEDULE_TYPE_TEXT	VARCHAR2	(80)	WIP schedule type
SCHEDULE_NUMBER	VARCHAR2	(240)	WIP Job name or flow schedule number
ORGANIZATION_ID	NUMBER		Inventory organization unique identifier
PRIMARY_ITEM_ID	NUMBER		Inventory item unique identifier for the assembly
ITEM_NUMBER	VARCHAR2	(40)	Item number
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)	End item model/unit number
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
DATE_CLOSED	DATE		Last unit actual completion date
PLANNED_QUANTITY	NUMBER		Initial planned quantity
QUANTITY_COMPLETED	NUMBER		Quantity completed

Query Text

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


SELECT ROW_ID
,      PROJECT_ID
,      TASK_ID
,      LINE_ID
,      LINE_CODE
,      SCHEDULE_TYPE
,      SCHEDULE_TYPE_TEXT
,      SCHEDULE_NUMBER
,      ORGANIZATION_ID
,      PRIMARY_ITEM_ID
,      ITEM_NUMBER
,      END_ITEM_UNIT_NUMBER
,      SCHEDULED_START_DATE
,      SCHEDULED_COMPLETION_DATE
,      DATE_CLOSED
,      PLANNED_QUANTITY
,      QUANTITY_COMPLETED
FROM APPS.PJM_LINE_SCHEDULES_V;

Dependencies

[top of page]

APPS.PJM_LINE_SCHEDULES_V references the following:

APPS: MFG_LOOKUPS; MTL_SYSTEM_ITEMS_KFV; WIP_DISCRETE_JOBS; WIP_ENTITIES; WIP_FLOW_SCHEDULES; WIP_LINES

APPS.PJM_LINE_SCHEDULES_V is referenced by following:

APPS: PJM_PROJECT_PROJ_LS_DAILY_V; PJM_PROJECT_PROJ_LS_DETAIL_V; PJM_PROJECT_PROJ_LS_ITEM_SUM_V; PJM_PROJECT_PROJ_LS_LINE_SUM_V; PJM_PROJECT_PROJ_LS_WEEKLY_V; PJM_PROJECT_TASK_LS_DAILY_V; PJM_PROJECT_TASK_LS_ITEM_SUM_V; PJM_PROJECT_TASK_LS_LINE_SUM_V; PJM_PROJECT_TASK_LS_WEEKLY_V