[Home] [Help]
202: FROM
203:
204: MTH_TAG_READINGS_RAW_PROCESSED RP
205: GROUP BY
206: RP.READING_TIME , RP.TAG_CODE ) RAW_DATA ,MTH_TAG_MASTER TM ,MTH_TAG_DESTINATION_MAP TDM ,MTH_EQUIPMENTS_D EQP
207: WHERE
208: RAW_DATA.TAG_CODE = TM.TAG_CODE
209: AND TM.TAG_CODE = TDM.TAG_CODE (+)
210: AND TDM.EQUIPMENT_FK_KEY = EQP.EQUIPMENT_PK_KEY(+)
297: FROM
298: MTH_TAG_READINGS_RAW_PROCESSED RP
299: --WHERE (r.CREATION_DATE >= v_log_from_date and r.CREATION_DATE < v_log_to_date )
300: GROUP BY
301: RP.READING_TIME , RP.TAG_CODE ) RAW_DATA ,MTH_TAG_MASTER TM ,MTH_TAG_DESTINATION_MAP TDM ,MTH_EQUIPMENTS_D EQP
302: WHERE
303: RAW_DATA.TAG_CODE = TM.TAG_CODE
304: AND TM.TAG_CODE = TDM.TAG_CODE (+)
305: AND TDM.EQUIPMENT_FK_KEY = EQP.EQUIPMENT_PK_KEY(+)
874: MCM.CONTEXTUALIZE_METHOD = 1 AND
875: STG.MTH_ENTITY IS NOT NULL AND
876: STG.MTH_ENTITY IN ( 2 , 3 , 4 , 14 , 15 ) ) BUS
877: GROUP BY
878: BUS.GROUP_ID, BUS.EQUIPMENT_FK_KEY ) BUS_CONTEXT ,MTH_PLANTS_D PLANTS , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS , MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS
879: WHERE
880: TAG_DATA.GROUP_ID = BUS_CONTEXT.GROUP_ID (+) And
881: TAG_DATA.EQUIPMENT_FK_KEY = BUS_CONTEXT.EQUIPMENT_FK_KEY (+) And
882: TAG_DATA.PLANT_FK_KEY = PLANTS.PLANT_PK_KEY (+) And
1104: MCM.CONTEXTUALIZE_METHOD = 1 AND
1105: STG.MTH_ENTITY IS NOT NULL AND
1106: STG.MTH_ENTITY IN ( 2 , 3 , 4 , 14 , 15 ) ) BUS
1107: GROUP BY
1108: BUS.GROUP_ID, BUS.EQUIPMENT_FK_KEY ) BUS_CONTEXT ,MTH_PLANTS_D PLANTS , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS , MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS
1109: WHERE
1110: TAG_DATA.GROUP_ID = BUS_CONTEXT.GROUP_ID (+) And
1111: TAG_DATA.EQUIPMENT_FK_KEY = BUS_CONTEXT.EQUIPMENT_FK_KEY (+) And
1112: TAG_DATA.PLANT_FK_KEY = PLANTS.PLANT_PK_KEY (+) And
1228: STG.QUALITY_FLAG,
1229: NVL(STG.PROCESSED_FLAG , 0),
1230: EQUIPMENTS.STATUS
1231: FROM MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_EQUIP_PROD_SCHEDULE_F EQUIP_PROD_SCHEDULE,
1232: MTH_EQUIPMENTS_D EQUIPMENTS, MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS,MTH_HOUR_D HOURS ,MTH_PRODUCTION_SCHEDULES_F PROD_SCHD ,
1233: MTH_CONTEXTUALIZATION_REQ MCR
1234: WHERE MCM.CONTEXTUALIZE_METHOD = 2
1235: AND STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
1236: -- AND EQP_SHIFTS.FROM_DATE IS NOT NULL
1339: PROD_SCHD.RECIPE_NUM,
1340: PROD_SCHD.RECIPE_VERSION
1341: FROM
1342: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_EQUIP_PROD_SCHEDULE_F EQUIP_PROD_SCHEDULE,
1343: MTH_EQUIPMENTS_D EQUIPMENTS, MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS,MTH_HOUR_D HOURS ,MTH_PRODUCTION_SCHEDULES_F PROD_SCHD ,
1344: MTH_CONTEXTUALIZATION_REQ MCR
1345: WHERE MCM.CONTEXTUALIZE_METHOD = 2
1346: AND STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
1347: AND EQP_SHIFTS.FROM_DATE IS NOT NULL
1459: STG.USER_MEASURE5,
1460: STG.QUALITY_FLAG
1461: FROM
1462: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS ,MTH_CONTEXTUALIZATION_REQ CONTEXT_REQ,
1463: MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS
1464: WHERE
1465: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
1466: AND MCM.CONTEXTUALIZE_METHOD = 3
1467: AND EQP_SHIFTS.FROM_DATE IS NOT NULL
1539: NVL(STG.PROCESSED_FLAG , 0),
1540: EQUIPMENTS.STATUS
1541: FROM
1542: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS ,MTH_CONTEXTUALIZATION_REQ CONTEXT_REQ,
1543: MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS
1544: WHERE
1545: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
1546: AND MCM.CONTEXTUALIZE_METHOD = 3
1547: -- AND EQP_SHIFTS.FROM_DATE IS NOT NULL