VIEW: APPS.PJM_LINE_SCHEDULES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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