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.MTH_SRC_PRODUCTION_SCHEDULES_V

Source

View Text - Preformatted


SELECT WORKORDER_PK, SYSTEM_FK, WORKORDER_TYPE, STATUS, PLANNED_START_DATE, PLANNED_COMPLETION_DATE, ACTUAL_START_DATE, ACTUAL_COMPLETION_DATE, DATE_RELEASED, ERP_ACTUAL_START_DATE, ERP_ACTUAL_COMPLETION_DATE, EBS_ENTITY_ID, EBS_ORGANIZATION_ID, BOM_REVISION, ROUTING_REVISION, BOM_REVISION_DATE, ROUTING_REVISION_DATE, ALTERNATE_BOM_DESIGNATOR, ALTERNATE_ROUTING_DESIGNATOR, COMPLETION_SUBINVENTORY, COMPLETION_LOCATOR_ID, DEMAND_CLASS, SCHEDULE_GROUP_ID, BUILD_SEQUENCE, WORKORDER_NAME, DEMAND_SOURCE_HEADER_ID, DEMAND_SOURCE_LINE, DEMAND_SOURCE_DELIVERY, DEMAND_SOURCE_TYPE, KANBAN_CARD_ID, LINE_CODE, PARENT_WORKORDER_ID, PARENT_OPERATION_SEQ_NUM, SOURCE_ORG_CODE, USER_DIM1_FK, USER_DIM2_FK, USER_DIM3_FK, USER_DIM4_FK, USER_DIM5_FK, USER_ATTR1, USER_ATTR2, USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_ATTR6, USER_ATTR7, USER_ATTR8, USER_ATTR9, USER_ATTR10, USER_ATTR11, USER_ATTR12, USER_ATTR13, USER_ATTR14, USER_ATTR15, USER_ATTR16, USER_ATTR17, USER_ATTR18, USER_ATTR19, USER_ATTR20, USER_MEASURE1, USER_MEASURE2, USER_MEASURE3, USER_MEASURE4, USER_MEASURE5, RECIPE_NUM, RECIPE_VERSION, FORMULA_NUM, FORMULA_VERSION, BATCH_TYPE, REQ_COMPLETION_DATE, TERMINATED_IND, LAST_UPDATE_DATE FROM ( SELECT CAST(NULL AS VARCHAR2(150)) WORKORDER_PK, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, CASE WHEN WE.ENTITY_TYPE IN (1,3) THEN 1 WHEN WE.ENTITY_TYPE IN (5,8) THEN 3 ELSE 1 END WORKORDER_TYPE, MFG_LOOKUPS.MEANING STATUS, WDJ.SCHEDULED_START_DATE PLANNED_START_DATE, WDJ.SCHEDULED_COMPLETION_DATE PLANNED_COMPLETION_DATE, CAST(NULL AS DATE) ACTUAL_START_DATE, CAST(NULL AS DATE) ACTUAL_COMPLETION_DATE, WDJ.DATE_RELEASED DATE_RELEASED, CAST(NULL AS DATE) ERP_ACTUAL_START_DATE, NVL(WDJ.DATE_COMPLETED, WDJ.DATE_CLOSED ) ERP_ACTUAL_COMPLETION_DATE, WDJ.WIP_ENTITY_ID EBS_ENTITY_ID, WDJ.ORGANIZATION_ID EBS_ORGANIZATION_ID, WDJ.BOM_REVISION BOM_REVISION, WDJ.ROUTING_REVISION ROUTING_REVISION, WDJ.BOM_REVISION_DATE BOM_REVISION_DATE, WDJ.ROUTING_REVISION_DATE ROUTING_REVISION_DATE, WDJ.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, WDJ.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, WDJ.COMPLETION_SUBINVENTORY COMPLETION_SUBINVENTORY, WDJ.COMPLETION_LOCATOR_ID COMPLETION_LOCATOR_ID, WDJ.DEMAND_CLASS DEMAND_CLASS, WDJ.SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID, WDJ.BUILD_SEQUENCE BUILD_SEQUENCE, WE.WIP_ENTITY_NAME WORKORDER_NAME, CAST(NULL AS NUMBER)DEMAND_SOURCE_HEADER_ID, CAST(NULL AS VARCHAR2(150))DEMAND_SOURCE_LINE, CAST(NULL AS VARCHAR2(150))DEMAND_SOURCE_DELIVERY, CAST(NULL AS NUMBER)DEMAND_SOURCE_TYPE, WDJ.KANBAN_CARD_ID KANBAN_CARD_ID, CAST(NULL AS VARCHAR2(150))LINE_CODE, TO_CHAR( WDJ.PARENT_WIP_ENTITY_ID ) PARENT_WORKORDER_ID, CAST(NULL AS NUMBER) PARENT_OPERATION_SEQ_NUM, MP.ORGANIZATION_CODE SOURCE_ORG_CODE, CAST(NULL AS VARCHAR2(150)) USER_DIM1_FK, CAST(NULL AS VARCHAR2(150)) USER_DIM2_FK, CAST(NULL AS VARCHAR2(150)) USER_DIM3_FK, CAST(NULL AS VARCHAR2(150)) USER_DIM4_FK, CAST(NULL AS VARCHAR2(150)) USER_DIM5_FK, WDJ.ATTRIBUTE1 USER_ATTR1, WDJ.ATTRIBUTE2 USER_ATTR2, WDJ.ATTRIBUTE3 USER_ATTR3, WDJ.ATTRIBUTE4 USER_ATTR4, WDJ.ATTRIBUTE5 USER_ATTR5, WDJ.ATTRIBUTE6 USER_ATTR6, WDJ.ATTRIBUTE7 USER_ATTR7, WDJ.ATTRIBUTE8 USER_ATTR8, WDJ.ATTRIBUTE9 USER_ATTR9, WDJ.ATTRIBUTE10 USER_ATTR10, WDJ.ATTRIBUTE11 USER_ATTR11, WDJ.ATTRIBUTE12 USER_ATTR12, WDJ.ATTRIBUTE13 USER_ATTR13, WDJ.ATTRIBUTE14 USER_ATTR14, WDJ.ATTRIBUTE15 USER_ATTR15, CAST(NULL AS VARCHAR2(150)) USER_ATTR16, CAST(NULL AS VARCHAR2(150)) USER_ATTR17, CAST(NULL AS VARCHAR2(150)) USER_ATTR18, CAST(NULL AS VARCHAR2(150)) USER_ATTR19, CAST(NULL AS VARCHAR2(150)) USER_ATTR20, CAST(NULL AS NUMBER) USER_MEASURE1, CAST(NULL AS NUMBER) USER_MEASURE2, CAST(NULL AS NUMBER) USER_MEASURE3, CAST(NULL AS NUMBER) USER_MEASURE4, CAST(NULL AS NUMBER) USER_MEASURE5, CAST(NULL AS VARCHAR2(150)) RECIPE_NUM, CAST(NULL AS VARCHAR2(150)) RECIPE_VERSION, CAST(NULL AS VARCHAR2(150)) FORMULA_NUM, CAST(NULL AS VARCHAR2(150)) FORMULA_VERSION, CAST(NULL AS VARCHAR2(150)) BATCH_TYPE, CAST(NULL AS DATE) REQ_COMPLETION_DATE, CAST(NULL AS NUMBER) TERMINATED_IND, WDJ.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM WIP_DISCRETE_JOBS WDJ, WIP_ENTITIES WE, FND_LOOKUPS MFG_LOOKUPS, MTL_PARAMETERS MP WHERE WE.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID AND WE.ORGANIZATION_ID=WDJ.ORGANIZATION_ID AND WDJ.JOB_TYPE IN (1,3) AND WE.ENTITY_TYPE IN (1,3,5,8) AND MFG_LOOKUPS.LOOKUP_CODE = Decode(WDJ.STATUS_TYPE,16,17,17,1,WDJ.STATUS_TYPE) AND MFG_LOOKUPS.LOOKUP_TYPE='MTH_WORKORDER_STATUS_L' AND WDJ.ORGANIZATION_ID = MP.ORGANIZATION_ID UNION ALL SELECT CAST(NULL AS VARCHAR2(150)) WORKORDER_PK, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, 2 WORKORDER_TYPE, MFG_LOOKUPS.MEANING STATUS, WFS.SCHEDULED_START_DATE PLANNED_START_DATE, WFS.SCHEDULED_COMPLETION_DATE PLANNED_COMPLETION_DATE, CAST(NULL AS DATE) ACTUAL_START_DATE, CAST(NULL AS DATE) ACTUAL_COMPLETION_DATE, CAST(NULL AS DATE) DATE_RELEASED, CAST(NULL AS DATE) ERP_ACTUAL_START_DATE, WFS.DATE_CLOSED ERP_ACTUAL_COMPLETION_DATE, WFS.WIP_ENTITY_ID EBS_ENTITY_ID, WFS.ORGANIZATION_ID EBS_ORGANIZATION_ID, WFS.BOM_REVISION BOM_REVISION, WFS.ROUTING_REVISION ROUTING_REVISION, WFS.BOM_REVISION_DATE BOM_REVISION_DATE, WFS.ROUTING_REVISION_DATE ROUTING_REVISION_DATE, WFS.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, WFS.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, WFS.COMPLETION_SUBINVENTORY COMPLETION_SUBINVENTORY, WFS.COMPLETION_LOCATOR_ID COMPLETION_LOCATOR_ID, WFS.DEMAND_CLASS DEMAND_CLASS, WFS.SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID, WFS.BUILD_SEQUENCE BUILD_SEQUENCE, WE.WIP_ENTITY_NAME WORKORDER_NAME, WFS.DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID, WFS.DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE, WFS.DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY, WFS.DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE, WFS.KANBAN_CARD_ID KANBAN_CARD_ID, WL.LINE_CODE LINE_CODE, WFS.SYNCH_SCHEDULE_NUM PARENT_WORKORDER_ID, WFS.SYNCH_OPERATION_SEQ_NUM PARENT_OPERATION_SEQ_NUM, MP.ORGANIZATION_CODE SOURCE_ORG_CODE, CAST(NULL AS VARCHAR2(150)) USER_DIM1_FK, CAST(NULL AS VARCHAR2(150)) USER_DIM2_FK, CAST(NULL AS VARCHAR2(150)) USER_DIM3_FK, CAST(NULL AS VARCHAR2(150)) USER_DIM4_FK, CAST(NULL AS VARCHAR2(150)) USER_DIM5_FK, WFS.ATTRIBUTE1 USER_ATTR1, WFS.ATTRIBUTE2 USER_ATTR2, WFS.ATTRIBUTE3 USER_ATTR3, WFS.ATTRIBUTE4 USER_ATTR4, WFS.ATTRIBUTE5 USER_ATTR5, WFS.ATTRIBUTE6 USER_ATTR6, WFS.ATTRIBUTE7 USER_ATTR7, WFS.ATTRIBUTE8 USER_ATTR8, WFS.ATTRIBUTE9 USER_ATTR9, WFS.ATTRIBUTE10 USER_ATTR10, WFS.ATTRIBUTE11 USER_ATTR11, WFS.ATTRIBUTE12 USER_ATTR12, WFS.ATTRIBUTE13 USER_ATTR13, WFS.ATTRIBUTE14 USER_ATTR14, WFS.ATTRIBUTE15 USER_ATTR15, CAST(NULL AS VARCHAR2(150)) USER_ATTR16, CAST(NULL AS VARCHAR2(150)) USER_ATTR17, CAST(NULL AS VARCHAR2(150)) USER_ATTR18, CAST(NULL AS VARCHAR2(150)) USER_ATTR19, CAST(NULL AS VARCHAR2(150)) USER_ATTR20, CAST(NULL AS NUMBER) USER_MEASURE1, CAST(NULL AS NUMBER) USER_MEASURE2, CAST(NULL AS NUMBER) USER_MEASURE3, CAST(NULL AS NUMBER) USER_MEASURE4, CAST(NULL AS NUMBER) USER_MEASURE5, CAST(NULL AS VARCHAR2(150)) RECIPE_NUM, CAST(NULL AS VARCHAR2(150)) RECIPE_VERSION, CAST(NULL AS VARCHAR2(150)) FORMULA_NUM, CAST(NULL AS VARCHAR2(150)) FORMULA_VERSION, CAST(NULL AS VARCHAR2(150)) BATCH_TYPE, CAST(NULL AS DATE) REQ_COMPLETION_DATE, CAST(NULL AS NUMBER) TERMINATED_IND, WFS.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM WIP_FLOW_SCHEDULES WFS, WIP_ENTITIES WE, FND_LOOKUPS MFG_LOOKUPS, WIP_LINES WL, MTL_PARAMETERS MP WHERE MFG_LOOKUPS.LOOKUP_CODE = Decode(WFS.STATUS,1,2,12) AND MFG_LOOKUPS.LOOKUP_TYPE ='MTH_WORKORDER_STATUS_L' AND WE.WIP_ENTITY_ID=WFS.WIP_ENTITY_ID AND WE.ORGANIZATION_ID=WFS.ORGANIZATION_ID AND WE.ENTITY_TYPE =4 AND WFS.LINE_ID=WL.LINE_ID AND WFS.ORGANIZATION_ID = MP.ORGANIZATION_ID UNION ALL SELECT CAST(NULL AS VARCHAR2(150)) WORKORDER_PK, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, 4 WORKORDER_TYPE, GL.MEANING STATUS, GBH.PLAN_START_DATE PLANNED_START_DATE, GBH.PLAN_CMPLT_DATE PLANNED_COMPLETION_DATE, CAST(NULL AS DATE) ACTUAL_START_DATE, CAST(NULL AS DATE) ACTUAL_COMPLETION_DATE, GBH.ACTUAL_START_DATE DATE_RELEASED, GBH.ACTUAL_START_DATE ERP_ACTUAL_START_DATE, GBH.ACTUAL_CMPLT_DATE ERP_ACTUAL_COMPLETION_DATE, GBH.BATCH_ID EBS_ENTITY_ID, MP.ORGANIZATION_ID EBS_ORGANIZATION_ID, CAST(NULL AS VARCHAR2(150)) BOM_REVISION, CAST(NULL AS VARCHAR2(150)) ROUTING_REVISION, CAST(NULL AS DATE) BOM_REVISION_DATE, CAST(NULL AS DATE) ROUTING_REVISION_DATE, CAST(NULL AS VARCHAR2(150)) ALTERNATE_BOM_DESIGNATOR, CAST(NULL AS VARCHAR2(150)) ALTERNATE_ROUTING_DESIGNATOR, CAST(NULL AS VARCHAR2(150)) COMPLETION_SUBINVENTORY, CAST(NULL AS NUMBER) COMPLETION_LOCATOR_ID, CAST(NULL AS VARCHAR2(150)) DEMAND_CLASS, CAST(NULL AS NUMBER) SCHEDULE_GROUP_ID, CAST(NULL AS NUMBER) BUILD_SEQUENCE, GBH.BATCH_NO WORKORDER_NAME, CAST(NULL AS NUMBER) DEMAND_SOURCE_HEADER_ID, CAST(NULL AS VARCHAR2(150)) DEMAND_SOURCE_LINE, CAST(NULL AS VARCHAR2(150)) DEMAND_SOURCE_DELIVERY, CAST(NULL AS NUMBER) DEMAND_SOURCE_TYPE, CAST(NULL AS NUMBER) KANBAN_CARD_ID, CAST(NULL AS VARCHAR2(150)) LINE_CODE, CAST(NULL AS VARCHAR2(150)) PARENT_WORKORDER, CAST(NULL AS NUMBER) PARENT_OPERATION_SEQ_NUM, MP.ORGANIZATION_CODE SOURCE_ORG_CODE, CAST(NULL AS VARCHAR2(150)) USER_DIM1_FK, CAST(NULL AS VARCHAR2(150)) USER_DIM2_FK, CAST(NULL AS VARCHAR2(150)) USER_DIM3_FK, CAST(NULL AS VARCHAR2(150)) USER_DIM4_FK, CAST(NULL AS VARCHAR2(150)) USER_DIM5_FK, CAST(NULL AS VARCHAR2(150)) USER_ATTR1, CAST(NULL AS VARCHAR2(150)) USER_ATTR2, CAST(NULL AS VARCHAR2(150)) USER_ATTR3, CAST(NULL AS VARCHAR2(150)) USER_ATTR4, CAST(NULL AS VARCHAR2(150)) USER_ATTR5, CAST(NULL AS VARCHAR2(150)) USER_ATTR6, CAST(NULL AS VARCHAR2(150)) USER_ATTR7, CAST(NULL AS VARCHAR2(150)) USER_ATTR8, CAST(NULL AS VARCHAR2(150)) USER_ATTR9, CAST(NULL AS VARCHAR2(150)) USER_ATTR10, CAST(NULL AS VARCHAR2(150)) USER_ATTR11, CAST(NULL AS VARCHAR2(150)) USER_ATTR12, CAST(NULL AS VARCHAR2(150)) USER_ATTR13, CAST(NULL AS VARCHAR2(150)) USER_ATTR14, CAST(NULL AS VARCHAR2(150)) USER_ATTR15, CAST(NULL AS VARCHAR2(150)) USER_ATTR16, CAST(NULL AS VARCHAR2(150)) USER_ATTR17, CAST(NULL AS VARCHAR2(150)) USER_ATTR18, CAST(NULL AS VARCHAR2(150)) USER_ATTR19, CAST(NULL AS VARCHAR2(150)) USER_ATTR20, CAST(NULL AS NUMBER) USER_MEASURE1, CAST(NULL AS NUMBER) USER_MEASURE2, CAST(NULL AS NUMBER) USER_MEASURE3, CAST(NULL AS NUMBER) USER_MEASURE4, CAST(NULL AS NUMBER) USER_MEASURE5, GRL.RECIPE_NO RECIPE_NUM, TO_CHAR( GRL.RECIPE_VERSION ) RECIPE_VERSION, FML.FORMULA_NO FORMULA_NUM, TO_CHAR( FML.FORMULA_VERS ) FORMULA_VERSION, TO_CHAR( GBH.BATCH_TYPE ) BATCH_TYPE, GBH.DUE_DATE REQ_COMPLETION_DATE, GBH.TERMINATED_IND TERMINATED_IND, GBH.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM GME_BATCH_HEADER GBH, FND_LOOKUPS GL, GMD_RECIPES_VL GRL, FM_FORM_MST_VL FML, GMD_RECIPE_VALIDITY_RULES RVR, MTL_PARAMETERS MP WHERE GBH.BATCH_TYPE = 0 AND GL.LOOKUP_TYPE = 'MTH_WORKORDER_STATUS_L' AND GL.LOOKUP_CODE = Decode(GBH.BATCH_STATUS,-1,7,3,4,4,12,GBH.BATCH_STATUS) AND GBH.RECIPE_VALIDITY_RULE_ID = RVR.RECIPE_VALIDITY_RULE_ID AND GBH.LABORATORY_IND = 0 AND RVR.RECIPE_ID = GRL.RECIPE_ID AND GBH.FORMULA_ID = FML.FORMULA_ID AND GBH.ORGANIZATION_ID = MP.ORGANIZATION_ID)

View Text - HTML Formatted

SELECT WORKORDER_PK
, SYSTEM_FK
, WORKORDER_TYPE
, STATUS
, PLANNED_START_DATE
, PLANNED_COMPLETION_DATE
, ACTUAL_START_DATE
, ACTUAL_COMPLETION_DATE
, DATE_RELEASED
, ERP_ACTUAL_START_DATE
, ERP_ACTUAL_COMPLETION_DATE
, EBS_ENTITY_ID
, EBS_ORGANIZATION_ID
, BOM_REVISION
, ROUTING_REVISION
, BOM_REVISION_DATE
, ROUTING_REVISION_DATE
, ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR
, COMPLETION_SUBINVENTORY
, COMPLETION_LOCATOR_ID
, DEMAND_CLASS
, SCHEDULE_GROUP_ID
, BUILD_SEQUENCE
, WORKORDER_NAME
, DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY
, DEMAND_SOURCE_TYPE
, KANBAN_CARD_ID
, LINE_CODE
, PARENT_WORKORDER_ID
, PARENT_OPERATION_SEQ_NUM
, SOURCE_ORG_CODE
, USER_DIM1_FK
, USER_DIM2_FK
, USER_DIM3_FK
, USER_DIM4_FK
, USER_DIM5_FK
, USER_ATTR1
, USER_ATTR2
, USER_ATTR3
, USER_ATTR4
, USER_ATTR5
, USER_ATTR6
, USER_ATTR7
, USER_ATTR8
, USER_ATTR9
, USER_ATTR10
, USER_ATTR11
, USER_ATTR12
, USER_ATTR13
, USER_ATTR14
, USER_ATTR15
, USER_ATTR16
, USER_ATTR17
, USER_ATTR18
, USER_ATTR19
, USER_ATTR20
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, RECIPE_NUM
, RECIPE_VERSION
, FORMULA_NUM
, FORMULA_VERSION
, BATCH_TYPE
, REQ_COMPLETION_DATE
, TERMINATED_IND
, LAST_UPDATE_DATE
FROM ( SELECT CAST(NULL AS VARCHAR2(150)) WORKORDER_PK
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, CASE WHEN WE.ENTITY_TYPE IN (1
, 3) THEN 1 WHEN WE.ENTITY_TYPE IN (5
, 8) THEN 3 ELSE 1 END WORKORDER_TYPE
, MFG_LOOKUPS.MEANING STATUS
, WDJ.SCHEDULED_START_DATE PLANNED_START_DATE
, WDJ.SCHEDULED_COMPLETION_DATE PLANNED_COMPLETION_DATE
, CAST(NULL AS DATE) ACTUAL_START_DATE
, CAST(NULL AS DATE) ACTUAL_COMPLETION_DATE
, WDJ.DATE_RELEASED DATE_RELEASED
, CAST(NULL AS DATE) ERP_ACTUAL_START_DATE
, NVL(WDJ.DATE_COMPLETED
, WDJ.DATE_CLOSED ) ERP_ACTUAL_COMPLETION_DATE
, WDJ.WIP_ENTITY_ID EBS_ENTITY_ID
, WDJ.ORGANIZATION_ID EBS_ORGANIZATION_ID
, WDJ.BOM_REVISION BOM_REVISION
, WDJ.ROUTING_REVISION ROUTING_REVISION
, WDJ.BOM_REVISION_DATE BOM_REVISION_DATE
, WDJ.ROUTING_REVISION_DATE ROUTING_REVISION_DATE
, WDJ.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, WDJ.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, WDJ.COMPLETION_SUBINVENTORY COMPLETION_SUBINVENTORY
, WDJ.COMPLETION_LOCATOR_ID COMPLETION_LOCATOR_ID
, WDJ.DEMAND_CLASS DEMAND_CLASS
, WDJ.SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID
, WDJ.BUILD_SEQUENCE BUILD_SEQUENCE
, WE.WIP_ENTITY_NAME WORKORDER_NAME
, CAST(NULL AS NUMBER)DEMAND_SOURCE_HEADER_ID
, CAST(NULL AS VARCHAR2(150))DEMAND_SOURCE_LINE
, CAST(NULL AS VARCHAR2(150))DEMAND_SOURCE_DELIVERY
, CAST(NULL AS NUMBER)DEMAND_SOURCE_TYPE
, WDJ.KANBAN_CARD_ID KANBAN_CARD_ID
, CAST(NULL AS VARCHAR2(150))LINE_CODE
, TO_CHAR( WDJ.PARENT_WIP_ENTITY_ID ) PARENT_WORKORDER_ID
, CAST(NULL AS NUMBER) PARENT_OPERATION_SEQ_NUM
, MP.ORGANIZATION_CODE SOURCE_ORG_CODE
, CAST(NULL AS VARCHAR2(150)) USER_DIM1_FK
, CAST(NULL AS VARCHAR2(150)) USER_DIM2_FK
, CAST(NULL AS VARCHAR2(150)) USER_DIM3_FK
, CAST(NULL AS VARCHAR2(150)) USER_DIM4_FK
, CAST(NULL AS VARCHAR2(150)) USER_DIM5_FK
, WDJ.ATTRIBUTE1 USER_ATTR1
, WDJ.ATTRIBUTE2 USER_ATTR2
, WDJ.ATTRIBUTE3 USER_ATTR3
, WDJ.ATTRIBUTE4 USER_ATTR4
, WDJ.ATTRIBUTE5 USER_ATTR5
, WDJ.ATTRIBUTE6 USER_ATTR6
, WDJ.ATTRIBUTE7 USER_ATTR7
, WDJ.ATTRIBUTE8 USER_ATTR8
, WDJ.ATTRIBUTE9 USER_ATTR9
, WDJ.ATTRIBUTE10 USER_ATTR10
, WDJ.ATTRIBUTE11 USER_ATTR11
, WDJ.ATTRIBUTE12 USER_ATTR12
, WDJ.ATTRIBUTE13 USER_ATTR13
, WDJ.ATTRIBUTE14 USER_ATTR14
, WDJ.ATTRIBUTE15 USER_ATTR15
, CAST(NULL AS VARCHAR2(150)) USER_ATTR16
, CAST(NULL AS VARCHAR2(150)) USER_ATTR17
, CAST(NULL AS VARCHAR2(150)) USER_ATTR18
, CAST(NULL AS VARCHAR2(150)) USER_ATTR19
, CAST(NULL AS VARCHAR2(150)) USER_ATTR20
, CAST(NULL AS NUMBER) USER_MEASURE1
, CAST(NULL AS NUMBER) USER_MEASURE2
, CAST(NULL AS NUMBER) USER_MEASURE3
, CAST(NULL AS NUMBER) USER_MEASURE4
, CAST(NULL AS NUMBER) USER_MEASURE5
, CAST(NULL AS VARCHAR2(150)) RECIPE_NUM
, CAST(NULL AS VARCHAR2(150)) RECIPE_VERSION
, CAST(NULL AS VARCHAR2(150)) FORMULA_NUM
, CAST(NULL AS VARCHAR2(150)) FORMULA_VERSION
, CAST(NULL AS VARCHAR2(150)) BATCH_TYPE
, CAST(NULL AS DATE) REQ_COMPLETION_DATE
, CAST(NULL AS NUMBER) TERMINATED_IND
, WDJ.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE
, FND_LOOKUPS MFG_LOOKUPS
, MTL_PARAMETERS MP
WHERE WE.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
AND WDJ.JOB_TYPE IN (1
, 3)
AND WE.ENTITY_TYPE IN (1
, 3
, 5
, 8)
AND MFG_LOOKUPS.LOOKUP_CODE = DECODE(WDJ.STATUS_TYPE
, 16
, 17
, 17
, 1
, WDJ.STATUS_TYPE)
AND MFG_LOOKUPS.LOOKUP_TYPE='MTH_WORKORDER_STATUS_L'
AND WDJ.ORGANIZATION_ID = MP.ORGANIZATION_ID UNION ALL SELECT CAST(NULL AS VARCHAR2(150)) WORKORDER_PK
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, 2 WORKORDER_TYPE
, MFG_LOOKUPS.MEANING STATUS
, WFS.SCHEDULED_START_DATE PLANNED_START_DATE
, WFS.SCHEDULED_COMPLETION_DATE PLANNED_COMPLETION_DATE
, CAST(NULL AS DATE) ACTUAL_START_DATE
, CAST(NULL AS DATE) ACTUAL_COMPLETION_DATE
, CAST(NULL AS DATE) DATE_RELEASED
, CAST(NULL AS DATE) ERP_ACTUAL_START_DATE
, WFS.DATE_CLOSED ERP_ACTUAL_COMPLETION_DATE
, WFS.WIP_ENTITY_ID EBS_ENTITY_ID
, WFS.ORGANIZATION_ID EBS_ORGANIZATION_ID
, WFS.BOM_REVISION BOM_REVISION
, WFS.ROUTING_REVISION ROUTING_REVISION
, WFS.BOM_REVISION_DATE BOM_REVISION_DATE
, WFS.ROUTING_REVISION_DATE ROUTING_REVISION_DATE
, WFS.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, WFS.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, WFS.COMPLETION_SUBINVENTORY COMPLETION_SUBINVENTORY
, WFS.COMPLETION_LOCATOR_ID COMPLETION_LOCATOR_ID
, WFS.DEMAND_CLASS DEMAND_CLASS
, WFS.SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID
, WFS.BUILD_SEQUENCE BUILD_SEQUENCE
, WE.WIP_ENTITY_NAME WORKORDER_NAME
, WFS.DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID
, WFS.DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE
, WFS.DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY
, WFS.DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE
, WFS.KANBAN_CARD_ID KANBAN_CARD_ID
, WL.LINE_CODE LINE_CODE
, WFS.SYNCH_SCHEDULE_NUM PARENT_WORKORDER_ID
, WFS.SYNCH_OPERATION_SEQ_NUM PARENT_OPERATION_SEQ_NUM
, MP.ORGANIZATION_CODE SOURCE_ORG_CODE
, CAST(NULL AS VARCHAR2(150)) USER_DIM1_FK
, CAST(NULL AS VARCHAR2(150)) USER_DIM2_FK
, CAST(NULL AS VARCHAR2(150)) USER_DIM3_FK
, CAST(NULL AS VARCHAR2(150)) USER_DIM4_FK
, CAST(NULL AS VARCHAR2(150)) USER_DIM5_FK
, WFS.ATTRIBUTE1 USER_ATTR1
, WFS.ATTRIBUTE2 USER_ATTR2
, WFS.ATTRIBUTE3 USER_ATTR3
, WFS.ATTRIBUTE4 USER_ATTR4
, WFS.ATTRIBUTE5 USER_ATTR5
, WFS.ATTRIBUTE6 USER_ATTR6
, WFS.ATTRIBUTE7 USER_ATTR7
, WFS.ATTRIBUTE8 USER_ATTR8
, WFS.ATTRIBUTE9 USER_ATTR9
, WFS.ATTRIBUTE10 USER_ATTR10
, WFS.ATTRIBUTE11 USER_ATTR11
, WFS.ATTRIBUTE12 USER_ATTR12
, WFS.ATTRIBUTE13 USER_ATTR13
, WFS.ATTRIBUTE14 USER_ATTR14
, WFS.ATTRIBUTE15 USER_ATTR15
, CAST(NULL AS VARCHAR2(150)) USER_ATTR16
, CAST(NULL AS VARCHAR2(150)) USER_ATTR17
, CAST(NULL AS VARCHAR2(150)) USER_ATTR18
, CAST(NULL AS VARCHAR2(150)) USER_ATTR19
, CAST(NULL AS VARCHAR2(150)) USER_ATTR20
, CAST(NULL AS NUMBER) USER_MEASURE1
, CAST(NULL AS NUMBER) USER_MEASURE2
, CAST(NULL AS NUMBER) USER_MEASURE3
, CAST(NULL AS NUMBER) USER_MEASURE4
, CAST(NULL AS NUMBER) USER_MEASURE5
, CAST(NULL AS VARCHAR2(150)) RECIPE_NUM
, CAST(NULL AS VARCHAR2(150)) RECIPE_VERSION
, CAST(NULL AS VARCHAR2(150)) FORMULA_NUM
, CAST(NULL AS VARCHAR2(150)) FORMULA_VERSION
, CAST(NULL AS VARCHAR2(150)) BATCH_TYPE
, CAST(NULL AS DATE) REQ_COMPLETION_DATE
, CAST(NULL AS NUMBER) TERMINATED_IND
, WFS.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM WIP_FLOW_SCHEDULES WFS
, WIP_ENTITIES WE
, FND_LOOKUPS MFG_LOOKUPS
, WIP_LINES WL
, MTL_PARAMETERS MP
WHERE MFG_LOOKUPS.LOOKUP_CODE = DECODE(WFS.STATUS
, 1
, 2
, 12)
AND MFG_LOOKUPS.LOOKUP_TYPE ='MTH_WORKORDER_STATUS_L'
AND WE.WIP_ENTITY_ID=WFS.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID=WFS.ORGANIZATION_ID
AND WE.ENTITY_TYPE =4
AND WFS.LINE_ID=WL.LINE_ID
AND WFS.ORGANIZATION_ID = MP.ORGANIZATION_ID UNION ALL SELECT CAST(NULL AS VARCHAR2(150)) WORKORDER_PK
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, 4 WORKORDER_TYPE
, GL.MEANING STATUS
, GBH.PLAN_START_DATE PLANNED_START_DATE
, GBH.PLAN_CMPLT_DATE PLANNED_COMPLETION_DATE
, CAST(NULL AS DATE) ACTUAL_START_DATE
, CAST(NULL AS DATE) ACTUAL_COMPLETION_DATE
, GBH.ACTUAL_START_DATE DATE_RELEASED
, GBH.ACTUAL_START_DATE ERP_ACTUAL_START_DATE
, GBH.ACTUAL_CMPLT_DATE ERP_ACTUAL_COMPLETION_DATE
, GBH.BATCH_ID EBS_ENTITY_ID
, MP.ORGANIZATION_ID EBS_ORGANIZATION_ID
, CAST(NULL AS VARCHAR2(150)) BOM_REVISION
, CAST(NULL AS VARCHAR2(150)) ROUTING_REVISION
, CAST(NULL AS DATE) BOM_REVISION_DATE
, CAST(NULL AS DATE) ROUTING_REVISION_DATE
, CAST(NULL AS VARCHAR2(150)) ALTERNATE_BOM_DESIGNATOR
, CAST(NULL AS VARCHAR2(150)) ALTERNATE_ROUTING_DESIGNATOR
, CAST(NULL AS VARCHAR2(150)) COMPLETION_SUBINVENTORY
, CAST(NULL AS NUMBER) COMPLETION_LOCATOR_ID
, CAST(NULL AS VARCHAR2(150)) DEMAND_CLASS
, CAST(NULL AS NUMBER) SCHEDULE_GROUP_ID
, CAST(NULL AS NUMBER) BUILD_SEQUENCE
, GBH.BATCH_NO WORKORDER_NAME
, CAST(NULL AS NUMBER) DEMAND_SOURCE_HEADER_ID
, CAST(NULL AS VARCHAR2(150)) DEMAND_SOURCE_LINE
, CAST(NULL AS VARCHAR2(150)) DEMAND_SOURCE_DELIVERY
, CAST(NULL AS NUMBER) DEMAND_SOURCE_TYPE
, CAST(NULL AS NUMBER) KANBAN_CARD_ID
, CAST(NULL AS VARCHAR2(150)) LINE_CODE
, CAST(NULL AS VARCHAR2(150)) PARENT_WORKORDER
, CAST(NULL AS NUMBER) PARENT_OPERATION_SEQ_NUM
, MP.ORGANIZATION_CODE SOURCE_ORG_CODE
, CAST(NULL AS VARCHAR2(150)) USER_DIM1_FK
, CAST(NULL AS VARCHAR2(150)) USER_DIM2_FK
, CAST(NULL AS VARCHAR2(150)) USER_DIM3_FK
, CAST(NULL AS VARCHAR2(150)) USER_DIM4_FK
, CAST(NULL AS VARCHAR2(150)) USER_DIM5_FK
, CAST(NULL AS VARCHAR2(150)) USER_ATTR1
, CAST(NULL AS VARCHAR2(150)) USER_ATTR2
, CAST(NULL AS VARCHAR2(150)) USER_ATTR3
, CAST(NULL AS VARCHAR2(150)) USER_ATTR4
, CAST(NULL AS VARCHAR2(150)) USER_ATTR5
, CAST(NULL AS VARCHAR2(150)) USER_ATTR6
, CAST(NULL AS VARCHAR2(150)) USER_ATTR7
, CAST(NULL AS VARCHAR2(150)) USER_ATTR8
, CAST(NULL AS VARCHAR2(150)) USER_ATTR9
, CAST(NULL AS VARCHAR2(150)) USER_ATTR10
, CAST(NULL AS VARCHAR2(150)) USER_ATTR11
, CAST(NULL AS VARCHAR2(150)) USER_ATTR12
, CAST(NULL AS VARCHAR2(150)) USER_ATTR13
, CAST(NULL AS VARCHAR2(150)) USER_ATTR14
, CAST(NULL AS VARCHAR2(150)) USER_ATTR15
, CAST(NULL AS VARCHAR2(150)) USER_ATTR16
, CAST(NULL AS VARCHAR2(150)) USER_ATTR17
, CAST(NULL AS VARCHAR2(150)) USER_ATTR18
, CAST(NULL AS VARCHAR2(150)) USER_ATTR19
, CAST(NULL AS VARCHAR2(150)) USER_ATTR20
, CAST(NULL AS NUMBER) USER_MEASURE1
, CAST(NULL AS NUMBER) USER_MEASURE2
, CAST(NULL AS NUMBER) USER_MEASURE3
, CAST(NULL AS NUMBER) USER_MEASURE4
, CAST(NULL AS NUMBER) USER_MEASURE5
, GRL.RECIPE_NO RECIPE_NUM
, TO_CHAR( GRL.RECIPE_VERSION ) RECIPE_VERSION
, FML.FORMULA_NO FORMULA_NUM
, TO_CHAR( FML.FORMULA_VERS ) FORMULA_VERSION
, TO_CHAR( GBH.BATCH_TYPE ) BATCH_TYPE
, GBH.DUE_DATE REQ_COMPLETION_DATE
, GBH.TERMINATED_IND TERMINATED_IND
, GBH.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM GME_BATCH_HEADER GBH
, FND_LOOKUPS GL
, GMD_RECIPES_VL GRL
, FM_FORM_MST_VL FML
, GMD_RECIPE_VALIDITY_RULES RVR
, MTL_PARAMETERS MP
WHERE GBH.BATCH_TYPE = 0
AND GL.LOOKUP_TYPE = 'MTH_WORKORDER_STATUS_L'
AND GL.LOOKUP_CODE = DECODE(GBH.BATCH_STATUS
, -1
, 7
, 3
, 4
, 4
, 12
, GBH.BATCH_STATUS)
AND GBH.RECIPE_VALIDITY_RULE_ID = RVR.RECIPE_VALIDITY_RULE_ID
AND GBH.LABORATORY_IND = 0
AND RVR.RECIPE_ID = GRL.RECIPE_ID
AND GBH.FORMULA_ID = FML.FORMULA_ID
AND GBH.ORGANIZATION_ID = MP.ORGANIZATION_ID)