View: PJM_LINE_SCHEDULES_V

Product:	PJM - Project Manufacturing
Description:	Project related line scheduling details view for web inquiry
Implementation/DBA Data:	APPS.PJM_LINE_SCHEDULES_V

View Text

SELECT JOB.ROWID
, JOB.PROJECT_ID
, JOB.TASK_ID
, JOB.LINE_ID
, LINE.LINE_CODE
, WST.LOOKUP_CODE
, WST.MEANING
, ENTITIES.WIP_ENTITY_NAME
, JOB.ORGANIZATION_ID
, JOB.PRIMARY_ITEM_ID
, KFV.CONCATENATED_SEGMENTS
, JOB.END_ITEM_UNIT_NUMBER
, JOB.SCHEDULED_START_DATE
, JOB.SCHEDULED_COMPLETION_DATE
, JOB.DATE_CLOSED
, JOB.START_QUANTITY
, JOB.QUANTITY_COMPLETED
FROM MFG_LOOKUPS WST
, MFG_LOOKUPS WJS
, WIP_ENTITIES ENTITIES
, MTL_SYSTEM_ITEMS_KFV KFV
, WIP_DISCRETE_JOBS JOB
, WIP_LINES LINE
WHERE JOB.PROJECT_ID IS NOT NULL
AND WST.LOOKUP_CODE = 1
AND WST.LOOKUP_TYPE = 'MRP_WIP_SCHEDULE_TYPE'
AND WJS.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND WJS.LOOKUP_CODE = JOB.STATUS_TYPE
AND ENTITIES.ORGANIZATION_ID = JOB.ORGANIZATION_ID
AND ENTITIES.WIP_ENTITY_ID = JOB.WIP_ENTITY_ID
AND KFV.INVENTORY_ITEM_ID = JOB.PRIMARY_ITEM_ID
AND KFV.ORGANIZATION_ID = JOB.ORGANIZATION_ID
AND JOB.LINE_ID = LINE.LINE_ID
AND JOB.ORGANIZATION_ID = LINE.ORGANIZATION_ID UNION ALL SELECT FLOW.ROWID
, FLOW.PROJECT_ID
, FLOW.TASK_ID
, FLOW.LINE_ID
, LINE.LINE_CODE
, WST.LOOKUP_CODE
, WST.MEANING
, FLOW.SCHEDULE_NUMBER
, FLOW.ORGANIZATION_ID
, FLOW.PRIMARY_ITEM_ID
, KFV.CONCATENATED_SEGMENTS
, FLOW.END_ITEM_UNIT_NUMBER
, FLOW.SCHEDULED_START_DATE
, FLOW.SCHEDULED_COMPLETION_DATE
, FLOW.DATE_CLOSED
, FLOW.PLANNED_QUANTITY
, FLOW.QUANTITY_COMPLETED
FROM MFG_LOOKUPS WST
, MTL_SYSTEM_ITEMS_KFV KFV
, WIP_FLOW_SCHEDULES FLOW
, WIP_LINES LINE
WHERE FLOW.PROJECT_ID IS NOT NULL
AND WST.LOOKUP_CODE = 2
AND WST.LOOKUP_TYPE = 'MRP_WIP_SCHEDULE_TYPE'
AND KFV.INVENTORY_ITEM_ID = FLOW.PRIMARY_ITEM_ID
AND KFV.ORGANIZATION_ID = FLOW.ORGANIZATION_ID
AND FLOW.LINE_ID = LINE.LINE_ID
AND FLOW.ORGANIZATION_ID = LINE.ORGANIZATION_ID

Columns