View: WIP_JOB_SCHEDULE_INTERFACE_V

Product:	WIP - Work in Process
Description:	Foreign-key data for WIP_JOB_SCHEDULE_INTERFACE
Implementation/DBA Data:	APPS.WIP_JOB_SCHEDULE_INTERFACE_V

View Text

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

Columns