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: ViewPJM.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 Mandatory 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:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymWIP_DISCRETE_JOBS
SynonymWIP_ENTITIES
SynonymWIP_FLOW_SCHEDULES
SynonymWIP_LINES
APPS.PJM_LINE_SCHEDULES_V is referenced by following:

SchemaAPPS
ViewPJM_PROJECT_PROJ_LS_DAILY_V
ViewPJM_PROJECT_PROJ_LS_DETAIL_V
ViewPJM_PROJECT_PROJ_LS_ITEM_SUM_V
ViewPJM_PROJECT_PROJ_LS_LINE_SUM_V
ViewPJM_PROJECT_PROJ_LS_WEEKLY_V
ViewPJM_PROJECT_TASK_LS_DAILY_V
ViewPJM_PROJECT_TASK_LS_ITEM_SUM_V
ViewPJM_PROJECT_TASK_LS_LINE_SUM_V
ViewPJM_PROJECT_TASK_LS_WEEKLY_V