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.

VIEW: APPS.WIP_JOB_SCHEDULE_INTERFACE_V

Source

View Text - Preformatted


SELECT WJSI.ROWID ROW_ID , WJSI.INTERFACE_ID , WJSI.REQUEST_ID , WJSI.GROUP_ID , ML3.MEANING LOAD_TYPE_MEANING , ML4.MEANING PROCESS_PHASE_MEANING , ML5.MEANING PROCESS_STATUS_MEANING , ML6.MEANING FIRM_PLANNED_MEANING , WJSI.LOAD_TYPE , WJSI.PROCESS_PHASE , WJSI.PROCESS_STATUS , DECODE(WJSI.ORGANIZATION_ID,NULL,WJSI.ORGANIZATION_CODE, OOD.ORGANIZATION_CODE) ORGANIZATION_CODE , NVL(WE.WIP_ENTITY_NAME, WJSI.JOB_NAME) , ML1.MEANING STATUS_TYPE_MEANING , WJSI.CLASS_CODE , WJSI.START_QUANTITY , WJSI.ALTERNATE_BOM_DESIGNATOR , WJSI.BOM_REVISION , WJSI.BOM_REVISION_DATE , ML2.MEANING WIP_SUPPLY_TYPE_MEANING , WJSI.WIP_SUPPLY_TYPE , WJSI.ALTERNATE_ROUTING_DESIGNATOR , WJSI.ROUTING_REVISION , WJSI.ROUTING_REVISION_DATE , WJSI.COMPLETION_SUBINVENTORY , WJSI.COMPLETION_LOCATOR_SEGMENTS LOCATOR , WJSI.FIRST_UNIT_START_DATE , WJSI.FIRST_UNIT_COMPLETION_DATE , WJSI.LAST_UNIT_START_DATE , WJSI.LAST_UNIT_COMPLETION_DATE , WJSI.PROCESSING_WORK_DAYS , WJSI.DAILY_PRODUCTION_RATE , WJSI.PROCESSING_WORK_DAYS * WJSI.DAILY_PRODUCTION_RATE TOTAL_QUANTITY , WJSI.SOURCE_CODE , WJSI.SOURCE_LINE_ID , WJSI.LOT_NUMBER , WJSI.FIRM_PLANNED_FLAG , WJSI.DEMAND_CLASS , WJSI.DESCRIPTION , DECODE(WJSI.LAST_UPDATED_BY,NULL,WJSI.LAST_UPDATED_BY_NAME, FU1.USER_NAME) LAST_UPDATED_BY_NAME , DECODE(WJSI.CREATED_BY,NULL,WJSI.CREATED_BY_NAME,FU2.USER_NAME) CREATED_BY_NAME , DECODE(WJSI.SCHEDULE_GROUP_ID,NULL,WJSI.SCHEDULE_GROUP_NAME, WSG.SCHEDULE_GROUP_NAME) SCHEDULE_GROUP_NAME , WJSI.BUILD_SEQUENCE , DECODE(WJSI.PROJECT_ID,NULL,WJSI.PROJECT_NUMBER,PROJ.SEGMENT1) PROJECT_NUMBER , DECODE(WJSI.TASK_ID,NULL,WJSI.TASK_NUMBER,TASK.TASK_NUMBER) TASK_NUMBER , DECODE(WJSI.LINE_ID,NULL,WJSI.LINE_CODE,WL.LINE_CODE) LINE_CODE , WJSI.NET_QUANTITY , WJSI.SCHEDULING_METHOD , ML7.MEANING SCHEDULING_METHOD_MEANING , WJSI.STATUS_TYPE , WJSI.LAST_UPDATED_BY , WJSI.CREATED_BY , WJSI.ORGANIZATION_ID , WJSI.LINE_ID , WJSI.PRIMARY_ITEM_ID , WJSI.WIP_ENTITY_ID , WJSI.REPETITIVE_SCHEDULE_ID , WJSI.BOM_REFERENCE_ID , WJSI.ROUTING_REFERENCE_ID , WJSI.COMPLETION_LOCATOR_ID , WJSI.SCHEDULE_GROUP_ID , WJSI.PROJECT_ID , WJSI.TASK_ID , WJSI.END_ITEM_UNIT_NUMBER , WJSI.LAST_UPDATE_DATE , WJSI.CREATION_DATE , WJSI.LAST_UPDATE_LOGIN , WJSI.PROGRAM_ID , WJSI.PROGRAM_APPLICATION_ID , WJSI.PROGRAM_UPDATE_DATE , WJSI.ATTRIBUTE_CATEGORY , WJSI.ATTRIBUTE1 , WJSI.ATTRIBUTE2 , WJSI.ATTRIBUTE3 , WJSI.ATTRIBUTE4 , WJSI.ATTRIBUTE5 , WJSI.ATTRIBUTE6 , WJSI.ATTRIBUTE7 , WJSI.ATTRIBUTE8 , WJSI.ATTRIBUTE9 , WJSI.ATTRIBUTE10 , WJSI.ATTRIBUTE11 , WJSI.ATTRIBUTE12 , WJSI.ATTRIBUTE13 , WJSI.ATTRIBUTE14 , WJSI.ATTRIBUTE15 , WDJ.ASSET_NUMBER , WDJ.ASSET_GROUP_ID , WDJ.REBUILD_ITEM_ID , WDJ.REBUILD_SERIAL_NUMBER , WE2.ENTITY_TYPE FROM MFG_LOOKUPS ML1, MFG_LOOKUPS ML2, MFG_LOOKUPS ML3, MFG_LOOKUPS ML4, MFG_LOOKUPS ML5, MFG_LOOKUPS ML6, MFG_LOOKUPS ML7, ORG_ORGANIZATION_DEFINITIONS OOD, FND_USER FU1, FND_USER FU2, PA_PROJECTS_ALL PROJ, PA_TASKS TASK, WIP_LINES WL, WIP_SCHEDULE_GROUPS WSG, WIP_ENTITIES WE, WIP_JOB_SCHEDULE_INTERFACE WJSI, WIP_DISCRETE_JOBS WDJ, WIP_ENTITIES WE2 WHERE WJSI.PROCESS_PHASE IS NOT NULL AND WJSI.PROCESS_STATUS IS NOT NULL AND WE.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID AND WE.WIP_ENTITY_ID (+) = DECODE(WJSI.LOAD_TYPE, 3, WJSI.WIP_ENTITY_ID, -1) AND OOD.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID AND WSG.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID AND WSG.SCHEDULE_GROUP_ID (+) = WJSI.SCHEDULE_GROUP_ID AND ML1.LOOKUP_TYPE(+) = 'WIP_JOB_STATUS' AND ML1.LOOKUP_CODE(+) = WJSI.STATUS_TYPE AND ML2.LOOKUP_TYPE(+) = 'WIP_SUPPLY' AND ML2.LOOKUP_CODE(+) = WJSI.WIP_SUPPLY_TYPE AND ML3.LOOKUP_TYPE(+) = 'WIP_LOAD_TYPE' AND ML3.LOOKUP_CODE(+) = WJSI.LOAD_TYPE AND ML4.LOOKUP_TYPE(+) = 'WIP_ML_PROCESS_PHASE' AND ML4.LOOKUP_CODE(+) = WJSI.PROCESS_PHASE AND ML5.LOOKUP_TYPE(+) = 'WIP_PROCESS_STATUS' AND ML5.LOOKUP_CODE(+) = DECODE(WJSI.PROCESS_STATUS,5,3,WJSI.PROCESS_STATUS) AND ML6.LOOKUP_TYPE(+) = 'SYS_YES_NO' AND ML6.LOOKUP_CODE(+) = WJSI.FIRM_PLANNED_FLAG AND ML7.LOOKUP_TYPE(+) = 'WIP_SCHEDULING_METHOD' AND ML7.LOOKUP_CODE(+) = WJSI.SCHEDULING_METHOD AND FU1.USER_ID(+) = WJSI.LAST_UPDATED_BY AND FU2.USER_ID(+) = WJSI.CREATED_BY AND PROJ.PROJECT_ID(+) = WJSI.PROJECT_ID AND TASK.PROJECT_ID(+) = WJSI.PROJECT_ID AND TASK.TASK_ID(+) = WJSI.TASK_ID AND WL.LINE_ID (+) = WJSI.LINE_ID AND WL.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID AND WDJ.WIP_ENTITY_ID(+) = WJSI.WIP_ENTITY_ID AND WDJ.ORGANIZATION_ID(+) = WJSI.ORGANIZATION_ID AND WE2.WIP_ENTITY_ID(+) = WJSI.WIP_ENTITY_ID UNION SELECT WJSI.ROWID ROW_ID , WJSI.INTERFACE_ID , WJSI.REQUEST_ID , WJSI.GROUP_ID , ML3.MEANING LOAD_TYPE_MEANING , ML4.MEANING PROCESS_PHASE_MEANING , ML5.MEANING PROCESS_STATUS_MEANING , ML6.MEANING FIRM_PLANNED_MEANING , WJSI.LOAD_TYPE , WJSI.PROCESS_PHASE , WJSI.PROCESS_STATUS , DECODE(WJSI.ORGANIZATION_ID,NULL,WJSI.ORGANIZATION_CODE, OOD.ORGANIZATION_CODE) ORGANIZATION_CODE , NVL(WE.WIP_ENTITY_NAME, WJSI.JOB_NAME) , ML1.MEANING STATUS_TYPE_MEANING , WJSI.CLASS_CODE , WJSI.START_QUANTITY , WJSI.ALTERNATE_BOM_DESIGNATOR , WJSI.BOM_REVISION , WJSI.BOM_REVISION_DATE , ML2.MEANING WIP_SUPPLY_TYPE_MEANING , WJSI.WIP_SUPPLY_TYPE , WJSI.ALTERNATE_ROUTING_DESIGNATOR , WJSI.ROUTING_REVISION , WJSI.ROUTING_REVISION_DATE , WJSI.COMPLETION_SUBINVENTORY , WJSI.COMPLETION_LOCATOR_SEGMENTS LOCATOR , WJSI.FIRST_UNIT_START_DATE , WJSI.FIRST_UNIT_COMPLETION_DATE , WJSI.LAST_UNIT_START_DATE , WJSI.LAST_UNIT_COMPLETION_DATE , WJSI.PROCESSING_WORK_DAYS , WJSI.DAILY_PRODUCTION_RATE , WJSI.PROCESSING_WORK_DAYS * WJSI.DAILY_PRODUCTION_RATE TOTAL_QUANTITY , WJSI.SOURCE_CODE , WJSI.SOURCE_LINE_ID , WJSI.LOT_NUMBER , WJSI.FIRM_PLANNED_FLAG , WJSI.DEMAND_CLASS , WJSI.DESCRIPTION , DECODE(WJSI.LAST_UPDATED_BY,NULL, WJSI.LAST_UPDATED_BY_NAME, FU1.USER_NAME) LAST_UPDATED_BY_NAME , DECODE(WJSI.CREATED_BY,NULL,WJSI.CREATED_BY_NAME ,FU2.USER_NAME) CREATED_BY_NAME , DECODE(WJSI.SCHEDULE_GROUP_ID,NULL, WJSI.SCHEDULE_GROUP_NAME,WSG.SCHEDULE_GROUP_NAME) SCHEDULE_GROUP_NAME , WJSI.BUILD_SEQUENCE , DECODE(WJSI.PROJECT_ID,NULL,WJSI.PROJECT_NUMBER, PROJ.PROJECT_NUMBER) PROJECT_NUMBER, NULL, DECODE(WJSI.LINE_ID,NULL,WJSI.LINE_CODE,WL.LINE_CODE) LINE_CODE , WJSI.NET_QUANTITY , WJSI.SCHEDULING_METHOD , ML7.MEANING SCHEDULING_METHOD_MEANING , WJSI.STATUS_TYPE , WJSI.LAST_UPDATED_BY , WJSI.CREATED_BY , WJSI.ORGANIZATION_ID , WJSI.LINE_ID , WJSI.PRIMARY_ITEM_ID , WJSI.WIP_ENTITY_ID , WJSI.REPETITIVE_SCHEDULE_ID , WJSI.BOM_REFERENCE_ID , WJSI.ROUTING_REFERENCE_ID , WJSI.COMPLETION_LOCATOR_ID , WJSI.SCHEDULE_GROUP_ID , WJSI.PROJECT_ID , WJSI.TASK_ID , WJSI.END_ITEM_UNIT_NUMBER, WJSI.LAST_UPDATE_DATE , WJSI.CREATION_DATE , WJSI.LAST_UPDATE_LOGIN , WJSI.PROGRAM_ID , WJSI.PROGRAM_APPLICATION_ID , WJSI.PROGRAM_UPDATE_DATE , WJSI.ATTRIBUTE_CATEGORY , WJSI.ATTRIBUTE1 , WJSI.ATTRIBUTE2 , WJSI.ATTRIBUTE3 , WJSI.ATTRIBUTE4 , WJSI.ATTRIBUTE5 , WJSI.ATTRIBUTE6 , WJSI.ATTRIBUTE7 , WJSI.ATTRIBUTE8 , WJSI.ATTRIBUTE9 , WJSI.ATTRIBUTE10 , WJSI.ATTRIBUTE11 , WJSI.ATTRIBUTE12 , WJSI.ATTRIBUTE13 , WJSI.ATTRIBUTE14 , WJSI.ATTRIBUTE15, WDJ.ASSET_NUMBER, WDJ.ASSET_GROUP_ID, WDJ.REBUILD_ITEM_ID, WDJ.REBUILD_SERIAL_NUMBER, WE2.ENTITY_TYPE FROM MFG_LOOKUPS ML1, MFG_LOOKUPS ML2, MFG_LOOKUPS ML3, MFG_LOOKUPS ML4, MFG_LOOKUPS ML5, MFG_LOOKUPS ML6, MFG_LOOKUPS ML7, ORG_ORGANIZATION_DEFINITIONS OOD, FND_USER FU1, FND_USER FU2, PJM_SEIBAN_NUMBERS PROJ, WIP_LINES WL, WIP_SCHEDULE_GROUPS WSG, WIP_ENTITIES WE, WIP_JOB_SCHEDULE_INTERFACE WJSI, WIP_DISCRETE_JOBS WDJ, WIP_ENTITIES WE2 WHERE WJSI.PROCESS_PHASE IS NOT NULL AND WJSI.PROCESS_STATUS IS NOT NULL AND WE.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID AND WE.WIP_ENTITY_ID (+) = DECODE(WJSI.LOAD_TYPE, 3, WJSI.WIP_ENTITY_ID, -1) AND OOD.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID AND WSG.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID AND WSG.SCHEDULE_GROUP_ID (+) = WJSI.SCHEDULE_GROUP_ID AND ML1.LOOKUP_TYPE(+) = 'WIP_JOB_STATUS_10SC' AND ML1.LOOKUP_CODE(+) = WJSI.STATUS_TYPE AND ML2.LOOKUP_TYPE(+) = 'WIP_SUPPLY_10SC' AND ML2.LOOKUP_CODE(+) = WJSI.WIP_SUPPLY_TYPE AND ML3.LOOKUP_TYPE(+) = 'WIP_LOAD_TYPE_10SC' AND ML3.LOOKUP_CODE(+) = WJSI.LOAD_TYPE AND ML4.LOOKUP_TYPE(+) = 'WIP_ML_PROCESS_PHASE' AND ML4.LOOKUP_CODE(+) = WJSI.PROCESS_PHASE AND ML5.LOOKUP_TYPE(+) = 'WIP_PROCESS_STATUS' AND ML5.LOOKUP_CODE(+) = DECODE(WJSI.PROCESS_STATUS,5 ,3,WJSI.PROCESS_STATUS) AND ML6.LOOKUP_TYPE(+) = 'SYS_YES_NO' AND ML6.LOOKUP_CODE(+) = WJSI.FIRM_PLANNED_FLAG AND ML7.LOOKUP_TYPE(+) = 'WIP_SCHEDULING_METHOD' AND ML7.LOOKUP_CODE(+) = WJSI.SCHEDULING_METHOD AND FU1.USER_ID(+) = WJSI.LAST_UPDATED_BY AND FU2.USER_ID(+) = WJSI.CREATED_BY AND PROJ.PROJECT_ID = WJSI.PROJECT_ID AND WL.LINE_ID (+) = WJSI.LINE_ID AND WL.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID AND WDJ.WIP_ENTITY_ID(+) = WJSI.WIP_ENTITY_ID AND WDJ.ORGANIZATION_ID(+) = WJSI.ORGANIZATION_ID AND WE2.WIP_ENTITY_ID(+) = WJSI.WIP_ENTITY_ID

View Text - HTML Formatted

SELECT WJSI.ROWID ROW_ID
, WJSI.INTERFACE_ID
, WJSI.REQUEST_ID
, WJSI.GROUP_ID
, ML3.MEANING LOAD_TYPE_MEANING
, ML4.MEANING PROCESS_PHASE_MEANING
, ML5.MEANING PROCESS_STATUS_MEANING
, ML6.MEANING FIRM_PLANNED_MEANING
, WJSI.LOAD_TYPE
, WJSI.PROCESS_PHASE
, WJSI.PROCESS_STATUS
, DECODE(WJSI.ORGANIZATION_ID
, NULL
, WJSI.ORGANIZATION_CODE
, OOD.ORGANIZATION_CODE) ORGANIZATION_CODE
, NVL(WE.WIP_ENTITY_NAME
, WJSI.JOB_NAME)
, ML1.MEANING STATUS_TYPE_MEANING
, WJSI.CLASS_CODE
, WJSI.START_QUANTITY
, WJSI.ALTERNATE_BOM_DESIGNATOR
, WJSI.BOM_REVISION
, WJSI.BOM_REVISION_DATE
, ML2.MEANING WIP_SUPPLY_TYPE_MEANING
, WJSI.WIP_SUPPLY_TYPE
, WJSI.ALTERNATE_ROUTING_DESIGNATOR
, WJSI.ROUTING_REVISION
, WJSI.ROUTING_REVISION_DATE
, WJSI.COMPLETION_SUBINVENTORY
, WJSI.COMPLETION_LOCATOR_SEGMENTS LOCATOR
, WJSI.FIRST_UNIT_START_DATE
, WJSI.FIRST_UNIT_COMPLETION_DATE
, WJSI.LAST_UNIT_START_DATE
, WJSI.LAST_UNIT_COMPLETION_DATE
, WJSI.PROCESSING_WORK_DAYS
, WJSI.DAILY_PRODUCTION_RATE
, WJSI.PROCESSING_WORK_DAYS * WJSI.DAILY_PRODUCTION_RATE TOTAL_QUANTITY
, WJSI.SOURCE_CODE
, WJSI.SOURCE_LINE_ID
, WJSI.LOT_NUMBER
, WJSI.FIRM_PLANNED_FLAG
, WJSI.DEMAND_CLASS
, WJSI.DESCRIPTION
, DECODE(WJSI.LAST_UPDATED_BY
, NULL
, WJSI.LAST_UPDATED_BY_NAME
, FU1.USER_NAME) LAST_UPDATED_BY_NAME
, DECODE(WJSI.CREATED_BY
, NULL
, WJSI.CREATED_BY_NAME
, FU2.USER_NAME) CREATED_BY_NAME
, DECODE(WJSI.SCHEDULE_GROUP_ID
, NULL
, WJSI.SCHEDULE_GROUP_NAME
, WSG.SCHEDULE_GROUP_NAME) SCHEDULE_GROUP_NAME
, WJSI.BUILD_SEQUENCE
, DECODE(WJSI.PROJECT_ID
, NULL
, WJSI.PROJECT_NUMBER
, PROJ.SEGMENT1) PROJECT_NUMBER
, DECODE(WJSI.TASK_ID
, NULL
, WJSI.TASK_NUMBER
, TASK.TASK_NUMBER) TASK_NUMBER
, DECODE(WJSI.LINE_ID
, NULL
, WJSI.LINE_CODE
, WL.LINE_CODE) LINE_CODE
, WJSI.NET_QUANTITY
, WJSI.SCHEDULING_METHOD
, ML7.MEANING SCHEDULING_METHOD_MEANING
, WJSI.STATUS_TYPE
, WJSI.LAST_UPDATED_BY
, WJSI.CREATED_BY
, WJSI.ORGANIZATION_ID
, WJSI.LINE_ID
, WJSI.PRIMARY_ITEM_ID
, WJSI.WIP_ENTITY_ID
, WJSI.REPETITIVE_SCHEDULE_ID
, WJSI.BOM_REFERENCE_ID
, WJSI.ROUTING_REFERENCE_ID
, WJSI.COMPLETION_LOCATOR_ID
, WJSI.SCHEDULE_GROUP_ID
, WJSI.PROJECT_ID
, WJSI.TASK_ID
, WJSI.END_ITEM_UNIT_NUMBER
, WJSI.LAST_UPDATE_DATE
, WJSI.CREATION_DATE
, WJSI.LAST_UPDATE_LOGIN
, WJSI.PROGRAM_ID
, WJSI.PROGRAM_APPLICATION_ID
, WJSI.PROGRAM_UPDATE_DATE
, WJSI.ATTRIBUTE_CATEGORY
, WJSI.ATTRIBUTE1
, WJSI.ATTRIBUTE2
, WJSI.ATTRIBUTE3
, WJSI.ATTRIBUTE4
, WJSI.ATTRIBUTE5
, WJSI.ATTRIBUTE6
, WJSI.ATTRIBUTE7
, WJSI.ATTRIBUTE8
, WJSI.ATTRIBUTE9
, WJSI.ATTRIBUTE10
, WJSI.ATTRIBUTE11
, WJSI.ATTRIBUTE12
, WJSI.ATTRIBUTE13
, WJSI.ATTRIBUTE14
, WJSI.ATTRIBUTE15
, WDJ.ASSET_NUMBER
, WDJ.ASSET_GROUP_ID
, WDJ.REBUILD_ITEM_ID
, WDJ.REBUILD_SERIAL_NUMBER
, WE2.ENTITY_TYPE
FROM MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
, MFG_LOOKUPS ML5
, MFG_LOOKUPS ML6
, MFG_LOOKUPS ML7
, ORG_ORGANIZATION_DEFINITIONS OOD
, FND_USER FU1
, FND_USER FU2
, PA_PROJECTS_ALL PROJ
, PA_TASKS TASK
, WIP_LINES WL
, WIP_SCHEDULE_GROUPS WSG
, WIP_ENTITIES WE
, WIP_JOB_SCHEDULE_INTERFACE WJSI
, WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE2
WHERE WJSI.PROCESS_PHASE IS NOT NULL
AND WJSI.PROCESS_STATUS IS NOT NULL
AND WE.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID
AND WE.WIP_ENTITY_ID (+) = DECODE(WJSI.LOAD_TYPE
, 3
, WJSI.WIP_ENTITY_ID
, -1)
AND OOD.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID
AND WSG.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID
AND WSG.SCHEDULE_GROUP_ID (+) = WJSI.SCHEDULE_GROUP_ID
AND ML1.LOOKUP_TYPE(+) = 'WIP_JOB_STATUS'
AND ML1.LOOKUP_CODE(+) = WJSI.STATUS_TYPE
AND ML2.LOOKUP_TYPE(+) = 'WIP_SUPPLY'
AND ML2.LOOKUP_CODE(+) = WJSI.WIP_SUPPLY_TYPE
AND ML3.LOOKUP_TYPE(+) = 'WIP_LOAD_TYPE'
AND ML3.LOOKUP_CODE(+) = WJSI.LOAD_TYPE
AND ML4.LOOKUP_TYPE(+) = 'WIP_ML_PROCESS_PHASE'
AND ML4.LOOKUP_CODE(+) = WJSI.PROCESS_PHASE
AND ML5.LOOKUP_TYPE(+) = 'WIP_PROCESS_STATUS'
AND ML5.LOOKUP_CODE(+) = DECODE(WJSI.PROCESS_STATUS
, 5
, 3
, WJSI.PROCESS_STATUS)
AND ML6.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND ML6.LOOKUP_CODE(+) = WJSI.FIRM_PLANNED_FLAG
AND ML7.LOOKUP_TYPE(+) = 'WIP_SCHEDULING_METHOD'
AND ML7.LOOKUP_CODE(+) = WJSI.SCHEDULING_METHOD
AND FU1.USER_ID(+) = WJSI.LAST_UPDATED_BY
AND FU2.USER_ID(+) = WJSI.CREATED_BY
AND PROJ.PROJECT_ID(+) = WJSI.PROJECT_ID
AND TASK.PROJECT_ID(+) = WJSI.PROJECT_ID
AND TASK.TASK_ID(+) = WJSI.TASK_ID
AND WL.LINE_ID (+) = WJSI.LINE_ID
AND WL.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID
AND WDJ.WIP_ENTITY_ID(+) = WJSI.WIP_ENTITY_ID
AND WDJ.ORGANIZATION_ID(+) = WJSI.ORGANIZATION_ID
AND WE2.WIP_ENTITY_ID(+) = WJSI.WIP_ENTITY_ID UNION SELECT WJSI.ROWID ROW_ID
, WJSI.INTERFACE_ID
, WJSI.REQUEST_ID
, WJSI.GROUP_ID
, ML3.MEANING LOAD_TYPE_MEANING
, ML4.MEANING PROCESS_PHASE_MEANING
, ML5.MEANING PROCESS_STATUS_MEANING
, ML6.MEANING FIRM_PLANNED_MEANING
, WJSI.LOAD_TYPE
, WJSI.PROCESS_PHASE
, WJSI.PROCESS_STATUS
, DECODE(WJSI.ORGANIZATION_ID
, NULL
, WJSI.ORGANIZATION_CODE
, OOD.ORGANIZATION_CODE) ORGANIZATION_CODE
, NVL(WE.WIP_ENTITY_NAME
, WJSI.JOB_NAME)
, ML1.MEANING STATUS_TYPE_MEANING
, WJSI.CLASS_CODE
, WJSI.START_QUANTITY
, WJSI.ALTERNATE_BOM_DESIGNATOR
, WJSI.BOM_REVISION
, WJSI.BOM_REVISION_DATE
, ML2.MEANING WIP_SUPPLY_TYPE_MEANING
, WJSI.WIP_SUPPLY_TYPE
, WJSI.ALTERNATE_ROUTING_DESIGNATOR
, WJSI.ROUTING_REVISION
, WJSI.ROUTING_REVISION_DATE
, WJSI.COMPLETION_SUBINVENTORY
, WJSI.COMPLETION_LOCATOR_SEGMENTS LOCATOR
, WJSI.FIRST_UNIT_START_DATE
, WJSI.FIRST_UNIT_COMPLETION_DATE
, WJSI.LAST_UNIT_START_DATE
, WJSI.LAST_UNIT_COMPLETION_DATE
, WJSI.PROCESSING_WORK_DAYS
, WJSI.DAILY_PRODUCTION_RATE
, WJSI.PROCESSING_WORK_DAYS * WJSI.DAILY_PRODUCTION_RATE TOTAL_QUANTITY
, WJSI.SOURCE_CODE
, WJSI.SOURCE_LINE_ID
, WJSI.LOT_NUMBER
, WJSI.FIRM_PLANNED_FLAG
, WJSI.DEMAND_CLASS
, WJSI.DESCRIPTION
, DECODE(WJSI.LAST_UPDATED_BY
, NULL
, WJSI.LAST_UPDATED_BY_NAME
, FU1.USER_NAME) LAST_UPDATED_BY_NAME
, DECODE(WJSI.CREATED_BY
, NULL
, WJSI.CREATED_BY_NAME
, FU2.USER_NAME) CREATED_BY_NAME
, DECODE(WJSI.SCHEDULE_GROUP_ID
, NULL
, WJSI.SCHEDULE_GROUP_NAME
, WSG.SCHEDULE_GROUP_NAME) SCHEDULE_GROUP_NAME
, WJSI.BUILD_SEQUENCE
, DECODE(WJSI.PROJECT_ID
, NULL
, WJSI.PROJECT_NUMBER
, PROJ.PROJECT_NUMBER) PROJECT_NUMBER
, NULL
, DECODE(WJSI.LINE_ID
, NULL
, WJSI.LINE_CODE
, WL.LINE_CODE) LINE_CODE
, WJSI.NET_QUANTITY
, WJSI.SCHEDULING_METHOD
, ML7.MEANING SCHEDULING_METHOD_MEANING
, WJSI.STATUS_TYPE
, WJSI.LAST_UPDATED_BY
, WJSI.CREATED_BY
, WJSI.ORGANIZATION_ID
, WJSI.LINE_ID
, WJSI.PRIMARY_ITEM_ID
, WJSI.WIP_ENTITY_ID
, WJSI.REPETITIVE_SCHEDULE_ID
, WJSI.BOM_REFERENCE_ID
, WJSI.ROUTING_REFERENCE_ID
, WJSI.COMPLETION_LOCATOR_ID
, WJSI.SCHEDULE_GROUP_ID
, WJSI.PROJECT_ID
, WJSI.TASK_ID
, WJSI.END_ITEM_UNIT_NUMBER
, WJSI.LAST_UPDATE_DATE
, WJSI.CREATION_DATE
, WJSI.LAST_UPDATE_LOGIN
, WJSI.PROGRAM_ID
, WJSI.PROGRAM_APPLICATION_ID
, WJSI.PROGRAM_UPDATE_DATE
, WJSI.ATTRIBUTE_CATEGORY
, WJSI.ATTRIBUTE1
, WJSI.ATTRIBUTE2
, WJSI.ATTRIBUTE3
, WJSI.ATTRIBUTE4
, WJSI.ATTRIBUTE5
, WJSI.ATTRIBUTE6
, WJSI.ATTRIBUTE7
, WJSI.ATTRIBUTE8
, WJSI.ATTRIBUTE9
, WJSI.ATTRIBUTE10
, WJSI.ATTRIBUTE11
, WJSI.ATTRIBUTE12
, WJSI.ATTRIBUTE13
, WJSI.ATTRIBUTE14
, WJSI.ATTRIBUTE15
, WDJ.ASSET_NUMBER
, WDJ.ASSET_GROUP_ID
, WDJ.REBUILD_ITEM_ID
, WDJ.REBUILD_SERIAL_NUMBER
, WE2.ENTITY_TYPE
FROM MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
, MFG_LOOKUPS ML5
, MFG_LOOKUPS ML6
, MFG_LOOKUPS ML7
, ORG_ORGANIZATION_DEFINITIONS OOD
, FND_USER FU1
, FND_USER FU2
, PJM_SEIBAN_NUMBERS PROJ
, WIP_LINES WL
, WIP_SCHEDULE_GROUPS WSG
, WIP_ENTITIES WE
, WIP_JOB_SCHEDULE_INTERFACE WJSI
, WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE2
WHERE WJSI.PROCESS_PHASE IS NOT NULL
AND WJSI.PROCESS_STATUS IS NOT NULL
AND WE.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID
AND WE.WIP_ENTITY_ID (+) = DECODE(WJSI.LOAD_TYPE
, 3
, WJSI.WIP_ENTITY_ID
, -1)
AND OOD.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID
AND WSG.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID
AND WSG.SCHEDULE_GROUP_ID (+) = WJSI.SCHEDULE_GROUP_ID
AND ML1.LOOKUP_TYPE(+) = 'WIP_JOB_STATUS_10SC'
AND ML1.LOOKUP_CODE(+) = WJSI.STATUS_TYPE
AND ML2.LOOKUP_TYPE(+) = 'WIP_SUPPLY_10SC'
AND ML2.LOOKUP_CODE(+) = WJSI.WIP_SUPPLY_TYPE
AND ML3.LOOKUP_TYPE(+) = 'WIP_LOAD_TYPE_10SC'
AND ML3.LOOKUP_CODE(+) = WJSI.LOAD_TYPE
AND ML4.LOOKUP_TYPE(+) = 'WIP_ML_PROCESS_PHASE'
AND ML4.LOOKUP_CODE(+) = WJSI.PROCESS_PHASE
AND ML5.LOOKUP_TYPE(+) = 'WIP_PROCESS_STATUS'
AND ML5.LOOKUP_CODE(+) = DECODE(WJSI.PROCESS_STATUS
, 5
, 3
, WJSI.PROCESS_STATUS)
AND ML6.LOOKUP_TYPE(+) = 'SYS_YES_NO'
AND ML6.LOOKUP_CODE(+) = WJSI.FIRM_PLANNED_FLAG
AND ML7.LOOKUP_TYPE(+) = 'WIP_SCHEDULING_METHOD'
AND ML7.LOOKUP_CODE(+) = WJSI.SCHEDULING_METHOD
AND FU1.USER_ID(+) = WJSI.LAST_UPDATED_BY
AND FU2.USER_ID(+) = WJSI.CREATED_BY
AND PROJ.PROJECT_ID = WJSI.PROJECT_ID
AND WL.LINE_ID (+) = WJSI.LINE_ID
AND WL.ORGANIZATION_ID (+) = WJSI.ORGANIZATION_ID
AND WDJ.WIP_ENTITY_ID(+) = WJSI.WIP_ENTITY_ID
AND WDJ.ORGANIZATION_ID(+) = WJSI.ORGANIZATION_ID
AND WE2.WIP_ENTITY_ID(+) = WJSI.WIP_ENTITY_ID