[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
cursor c_readings is SELECT TRR.REASON_TYPE REASON_TYPE,
TRR.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
FL.MEANING MEANING,
TRR.FROM_DATE FROM_DATE,
TRR.TO_DATE TO_DATE,
TRR.REASON_CODE REASON_CODE,
TRR.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM MTH_TAG_REASON_READINGS TRR ,FND_LOOKUPS FL
WHERE TRR.LAST_UPDATE_DATE >= v_log_from_date AND
TRR.REASON_TYPE = 1 AND
TRR.REASON_CODE = FL.LOOKUP_CODE And
FL.LOOKUP_TYPE = 'MTH_EQUIP_DOWNTIME_REASON' ;
cursor c_readings is SELECT EQP_IDLE_PER.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
EQP_IDLE_PER.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
EQP_IDLE_PER.FROM_DATE FROM_DATE,
EQP_IDLE_PER.TO_DATE TO_DATE,
EQP_IDLE_PER.STATUS STATUS,
EQP_IDLE_PER.DURATION_IN_MINUTES DURATION_IN_MINUTES,
EQP_IDLE_PER.LAG_STATUS LAG_STATUS,
EQP_IDLE_PER.LEAD_STATUS LEAD_STATUS
FROM MTH_EVENTS EVENTS1,
(SELECT IDLE_PER.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
IDLE_PER.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
IDLE_PER.FROM_DATE FROM_DATE,
CASE WHEN (Lead( IDLE_PER.STATUS, 1) OVER(PARTITION BY IDLE_PER.EQUIPMENT_FK_KEY , IDLE_PER.SHIFT_WORKDAY_FK_KEY ORDER BY IDLE_PER.FROM_DATE )) IS NULL
THEN IDLE_PER.TO_DATE
WHEN (Lead( IDLE_PER.STATUS, 1) OVER(PARTITION BY IDLE_PER.EQUIPMENT_FK_KEY , IDLE_PER.SHIFT_WORKDAY_FK_KEY ORDER BY IDLE_PER.FROM_DATE )) = IDLE_PER.STATUS
THEN (Lead( IDLE_PER.TO_DATE, 1)OVER(PARTITION BY IDLE_PER.EQUIPMENT_FK_KEY , IDLE_PER.SHIFT_WORKDAY_FK_KEY ORDER BY IDLE_PER.FROM_DATE ))
WHEN (Lead( IDLE_PER.STATUS, 1) OVER(PARTITION BY IDLE_PER.EQUIPMENT_FK_KEY , IDLE_PER.SHIFT_WORKDAY_FK_KEY ORDER BY IDLE_PER.FROM_DATE )) <> IDLE_PER.STATUS
THEN (Lead(IDLE_PER.FROM_DATE , 1) OVER(PARTITION BY IDLE_PER.EQUIPMENT_FK_KEY , IDLE_PER.SHIFT_WORKDAY_FK_KEY ORDER BY IDLE_PER.FROM_DATE )) - 1/86400
ELSE IDLE_PER.TO_DATE
END TO_DATE,
IDLE_PER.STATUS STATUS,
CASE WHEN (Lead( IDLE_PER.STATUS, 1) OVER(PARTITION BY IDLE_PER.EQUIPMENT_FK_KEY , IDLE_PER.SHIFT_WORKDAY_FK_KEY ORDER BY IDLE_PER.FROM_DATE )) IS NULL
THEN IDLE_PER.DURATION_IN_MINUTES
WHEN (Lead( IDLE_PER.STATUS, 1) OVER(PARTITION BY IDLE_PER.EQUIPMENT_FK_KEY , IDLE_PER.SHIFT_WORKDAY_FK_KEY ORDER BY IDLE_PER.FROM_DATE )) = IDLE_PER.STATUS
THEN (Lead( IDLE_PER.RUNNING_TOTAL_DURATION_IN_MIN , 1) OVER(PARTITION BY IDLE_PER.EQUIPMENT_FK_KEY , IDLE_PER.SHIFT_WORKDAY_FK_KEY ORDER BY IDLE_PER.FROM_DATE ))
- IDLE_PER.RUNNING_TOTAL_DURATION_IN_MIN + IDLE_PER.DURATION_IN_MINUTES
WHEN (Lead( IDLE_PER.STATUS, 1) OVER(PARTITION BY IDLE_PER.EQUIPMENT_FK_KEY , IDLE_PER.SHIFT_WORKDAY_FK_KEY ORDER BY IDLE_PER.FROM_DATE )) <> IDLE_PER.STATUS
THEN (Lead( IDLE_PER.RUNNING_TOTAL_DURATION_IN_MIN , 1) OVER(PARTITION BY IDLE_PER.EQUIPMENT_FK_KEY , IDLE_PER.SHIFT_WORKDAY_FK_KEY ORDER BY IDLE_PER.FROM_DATE ))
- IDLE_PER.RUNNING_TOTAL_DURATION_IN_MIN + IDLE_PER.DURATION_IN_MINUTES-
(Lead( IDLE_PER.DURATION_IN_MINUTES , 1) OVER(PARTITION BY IDLE_PER.EQUIPMENT_FK_KEY , IDLE_PER.SHIFT_WORKDAY_FK_KEY ORDER BY IDLE_PER.FROM_DATE ))
ELSE IDLE_PER.DURATION_IN_MINUTES
END DURATION_IN_MINUTES,
IDLE_PER.LAG_STATUS LAG_STATUS,
IDLE_PER.LEAD_STATUS LEAD_STATUS
FROM (SELECT SHIFTS.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
SHIFTS.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
ESD.AVAILABILITY_FLAG AVAILABILITY_FLAG,
greatest ( ESD.FROM_DATE , ES.FROM_DATE) FROM_DATE,
LEAST(NVL( ES.TO_DATE, SYSDATE ), ESD.TO_DATE ) TO_DATE,
(LEAST(NVL( ES.TO_DATE, SYSDATE ), ESD.TO_DATE ) - (greatest ( ESD.FROM_DATE , ES.FROM_DATE) )) * 1440 + 1 / 60 DURATION_IN_MINUTES,
ES.STATUS STATUS,
LAG( ES.STATUS , 1) OVER(PARTITION BY SHIFTS.EQUIPMENT_FK_KEY , SHIFTS.SHIFT_WORKDAY_FK_KEY ORDER BY (greatest (ESD.FROM_DATE , ES.FROM_DATE )))LAG_STATUS,
Lead( ES.STATUS , 1) OVER(PARTITION BY SHIFTS.EQUIPMENT_FK_KEY , SHIFTS.SHIFT_WORKDAY_FK_KEY ORDER BY (greatest (ESD.FROM_DATE , ES.FROM_DATE )) ) LEAD_STATUS,
SUM( ( (LEAST(NVL( ES.TO_DATE, SYSDATE ),ESD.TO_DATE ))
- (greatest ( ESD.FROM_DATE , ES.FROM_DATE )) ) * 1440 + 1 / 60 )
OVER(PARTITION BY SHIFTS.EQUIPMENT_FK_KEY , SHIFTS.SHIFT_WORKDAY_FK_KEY ORDER BY (greatest ( ESD.FROM_DATE , ES.FROM_DATE )) ROWS UNBOUNDED PRECEDING) RUNNING_TOTAL_DURATION_IN_MIN
FROM ( SELECT AGG_INPUT.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
AGG_INPUT.EQUIPMENT_FK_KEY
FROM (SELECT ES.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
ES.FROM_DATE FROM_DATE,
ES.TO_DATE TO_DATE,
ES.STATUS STATUS,
ES.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY
FROM MTH_EQUIP_STATUSES ES
WHERE ES.LAST_UPDATE_DATE >= v_log_from_date Or ES.TO_DATE IS NULL ) AGG_INPUT
GROUP BY AGG_INPUT.EQUIPMENT_FK_KEY , AGG_INPUT.SHIFT_WORKDAY_FK_KEY ) SHIFTS ,
MTH_EQUIP_STATUSES ES,
MTH_EQUIPMENT_SHIFTS_D ESD
WHERE SHIFTS.SHIFT_WORKDAY_FK_KEY = ES.SHIFT_WORKDAY_FK_KEY AND
SHIFTS.EQUIPMENT_FK_KEY = ES.EQUIPMENT_FK_KEY AND
SHIFTS.SHIFT_WORKDAY_FK_KEY = ESD.SHIFT_WORKDAY_FK_KEY AND
SHIFTS.EQUIPMENT_FK_KEY =ESD.EQUIPMENT_FK_KEY AND
( ES.FROM_DATE BETWEEN ESD.FROM_DATE AND ESD.TO_DATE Or ESD.FROM_DATE BETWEEN ES.FROM_DATE AND NVL (ES.TO_DATE , SYSDATE ))) IDLE_PER
WHERE IDLE_PER.LAG_STATUS <> IDLE_PER.STATUS or
IDLE_PER.LAG_STATUS IS NULL Or
IDLE_PER.LEAD_STATUS IS NULL ) EQP_IDLE_PER
WHERE EQP_IDLE_PER.STATUS = 2 AND
(EQP_IDLE_PER.LEAD_STATUS IS NOT NULL Or
EQP_IDLE_PER.LAG_STATUS IS NULL or
EQP_IDLE_PER.LEAD_STATUS IS NULL And
EQP_IDLE_PER.STATUS <> EQP_IDLE_PER.LAG_STATUS ) AND
EQP_IDLE_PER.DURATION_IN_MINUTES > v_dur_idle_limit_in_minutes and
EQP_IDLE_PER.EQUIPMENT_FK_KEY = EVENTS1.EQUIPMENT_FK_KEY (+) And
EQP_IDLE_PER.FROM_DATE = EVENTS1.TAG_READING_TIME (+) And
EQP_IDLE_PER.STATUS = EVENTS1.EQUIP_STATUS (+) And
EVENTS1.EVENT_ID IS NULL ;
cursor c_readings is SELECT equip_down_pd.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
equip_down_pd.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
equip_down_pd.FROM_DATE FROM_DATE,
equip_down_pd.TO_DATE TO_DATE,
equip_down_pd.STATUS STATUS,
equip_down_pd.LAG_STATUS LAG_STATUS,
equip_down_pd.LEAD_STATUS LEAD_STATUS,
equip_down_pd.DURATION_IN_MINUTES DURATION_IN_MINUTES
FROM MTH_EVENTS EVENTS1, (SELECT RNA.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
RNA.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
RNA.FROM_DATE FROM_DATE,
CASE WHEN (Lead( RNA.STATUS, 1) OVER(PARTITION BY RNA.EQUIPMENT_FK_KEY,RNA.SHIFT_WORKDAY_FK_KEY ORDER BY RNA.FROM_DATE )) IS NULL
THEN RNA.TO_DATE
WHEN (Lead( RNA.STATUS, 1) OVER(PARTITION BY RNA.EQUIPMENT_FK_KEY ,RNA.SHIFT_WORKDAY_FK_KEY ORDER BY RNA.FROM_DATE )) = RNA.STATUS
THEN (Lead( RNA.TO_DATE , 1) OVER(PARTITION BY RNA.EQUIPMENT_FK_KEY,RNA.SHIFT_WORKDAY_FK_KEY ORDER BY RNA.FROM_DATE))
WHEN (Lead( RNA.STATUS , 1) OVER(PARTITION BY RNA.EQUIPMENT_FK_KEY, RNA.SHIFT_WORKDAY_FK_KEY ORDER BY RNA.FROM_DATE )) <> RNA.STATUS
THEN (Lead(RNA.FROM_DATE , 1) OVER(PARTITION BY RNA.EQUIPMENT_FK_KEY ,RNA.SHIFT_WORKDAY_FK_KEY ORDER BY RNA.FROM_DATE )) - 1/86400
ELSE RNA.TO_DATE
END TO_DATE,
RNA.STATUS STATUS,
RNA.LAG_STATUS LAG_STATUS,
RNA.LEAD_STATUS LEAD_STATUS,
CASE WHEN (Lead(RNA.STATUS , 1) OVER(PARTITION BY RNA.EQUIPMENT_FK_KEY ,RNA.SHIFT_WORKDAY_FK_KEY ORDER BY RNA.FROM_DATE )) IS NULL
THEN RNA.DURATION_IN_MINUTES
WHEN (Lead( RNA.STATUS , 1) OVER(PARTITION BY RNA.EQUIPMENT_FK_KEY,RNA.SHIFT_WORKDAY_FK_KEY ORDER BY RNA.FROM_DATE )) =RNA.STATUS
THEN (Lead( RNA.DURATION_RUNNING_TOTAL , 1)
OVER(PARTITION BY RNA.EQUIPMENT_FK_KEY,RNA.SHIFT_WORKDAY_FK_KEY ORDER BY RNA.FROM_DATE ))
- RNA.DURATION_RUNNING_TOTAL + RNA.DURATION_IN_MINUTES
WHEN (Lead(RNA.STATUS , 1) OVER(PARTITION BY RNA.EQUIPMENT_FK_KEY ,RNA.SHIFT_WORKDAY_FK_KEY ORDER BY RNA.FROM_DATE )) <> RNA.STATUS
THEN (Lead( RNA.DURATION_RUNNING_TOTAL , 1)
OVER(PARTITION BY RNA.EQUIPMENT_FK_KEY, RNA.SHIFT_WORKDAY_FK_KEY
ORDER BY RNA.FROM_DATE )) - RNA.DURATION_RUNNING_TOTAL + RNA.DURATION_IN_MINUTES
- (Lead( RNA.DURATION_IN_MINUTES , 1) OVER(PARTITION BY RNA.EQUIPMENT_FK_KEY,RNA.SHIFT_WORKDAY_FK_KEY ORDER BY RNA.FROM_DATE ))
ELSE RNA.DURATION_IN_MINUTES
END DURATION_IN_MINUTES
FROM (SELECT ROWS_IN_SHIFTS.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
ROWS_IN_SHIFTS.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
ROWS_IN_SHIFTS.AVAILABILITY_FLAG AVAILABILITY_FLAG,
ROWS_IN_SHIFTS.FROM_DATE FROM_DATE,
ROWS_IN_SHIFTS.TO_DATE TO_DATE,
ROWS_IN_SHIFTS.DURATION_IN_MINUTES DURATION_IN_MINUTES,
ROWS_IN_SHIFTS.STATUS STATUS,
LAG( ROWS_IN_SHIFTS.STATUS , 1) OVER(PARTITION BY ROWS_IN_SHIFTS.EQUIPMENT_FK_KEY , ROWS_IN_SHIFTS.SHIFT_WORKDAY_FK_KEY ORDER BY ROWS_IN_SHIFTS.FROM_DATE ) LAG_STATUS,
LEAD( ROWS_IN_SHIFTS.STATUS , 1) OVER(PARTITION BY ROWS_IN_SHIFTS.EQUIPMENT_FK_KEY ,ROWS_IN_SHIFTS.SHIFT_WORKDAY_FK_KEY ORDER BY ROWS_IN_SHIFTS.FROM_DATE ) LEAD_STATUS,
SUM( (ROWS_IN_SHIFTS.TO_DATE - ROWS_IN_SHIFTS.FROM_DATE ) * 1440 + 1 / 60 )
OVER(PARTITION BY ROWS_IN_SHIFTS.EQUIPMENT_FK_KEY , ROWS_IN_SHIFTS.SHIFT_WORKDAY_FK_KEY
ORDER BY ROWS_IN_SHIFTS.FROM_DATE) DURATION_RUNNING_TOTAL
FROM (SELECT SHIFTS.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
SHIFTS.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
ESD.AVAILABILITY_FLAG AVAILABILITY_FLAG,
greatest ( ESD.FROM_DATE , ES.FROM_DATE) FROM_DATE,
LEAST(NVL( ES.TO_DATE, SYSDATE ), ESD.TO_DATE ) TO_DATE,
(LEAST(NVL( ES.TO_DATE, SYSDATE ), ESD.TO_DATE ) - (greatest ( ESD.FROM_DATE , ES.FROM_DATE) )) * 1440 + 1 / 60 DURATION_IN_MINUTES,
ES.STATUS STATUS
FROM ( SELECT AGG_INPUT.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
AGG_INPUT.EQUIPMENT_FK_KEY
FROM (SELECT ES.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
ES.FROM_DATE FROM_DATE,
ES.TO_DATE TO_DATE,
ES.STATUS STATUS,
ES.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY
FROM MTH_EQUIP_STATUSES ES
WHERE ES.LAST_UPDATE_DATE >= v_log_from_date Or ES.TO_DATE IS NULL ) AGG_INPUT
GROUP BY AGG_INPUT.EQUIPMENT_FK_KEY ,
AGG_INPUT.SHIFT_WORKDAY_FK_KEY ) SHIFTS ,
MTH_EQUIP_STATUSES ES ,
MTH_EQUIPMENT_SHIFTS_D ESD
WHERE SHIFTS.SHIFT_WORKDAY_FK_KEY = ES.SHIFT_WORKDAY_FK_KEY AND
SHIFTS.EQUIPMENT_FK_KEY = ES.EQUIPMENT_FK_KEY AND
SHIFTS.SHIFT_WORKDAY_FK_KEY = ESD.SHIFT_WORKDAY_FK_KEY AND
SHIFTS.EQUIPMENT_FK_KEY =ESD.EQUIPMENT_FK_KEY AND
( ES.FROM_DATE BETWEEN ESD.FROM_DATE AND ESD.TO_DATE Or ESD.FROM_DATE BETWEEN ES.FROM_DATE AND NVL (ES.TO_DATE , SYSDATE ) )) ROWS_IN_SHIFTS
WHERE ROWS_IN_SHIFTS.AVAILABILITY_FLAG IS NOT NULL AND
(ROWS_IN_SHIFTS.AVAILABILITY_FLAG = 'Y' Or
ROWS_IN_SHIFTS.STATUS <> 3) )RNA
WHERE RNA.LAG_STATUS <> RNA.STATUS Or
RNA.LAG_STATUS IS NULL Or
RNA.LEAD_STATUS IS NULL ) equip_down_pd
WHERE equip_down_pd.STATUS = 3 AND
(equip_down_pd.LEAD_STATUS IS NOT NULL Or
equip_down_pd.LAG_STATUS IS NULL or
equip_down_pd.LEAD_STATUS IS NULL And
equip_down_pd.STATUS <> equip_down_pd.LAG_STATUS ) AND
equip_down_pd.DURATION_IN_MINUTES >v_dur_down_limit_in_minutes and
equip_down_pd.EQUIPMENT_FK_KEY = events1.EQUIPMENT_FK_KEY (+) And
equip_down_pd.FROM_DATE = events1.TAG_READING_TIME (+) And
equip_down_pd.STATUS = events1.EQUIP_STATUS (+) AND
'DOW_PD' = events1.EVENT_TYPE (+) AND
events1.EVENT_ID IS NULL ;
cursor c_readings is SELECT OS.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
OS.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
OS.WORKORDER_FK_KEY WORKORDER_FK_KEY,
OS.TOTAL_SCRAP QTY_SCRAP,
OS.TOTAL_REWORK QTY_REWORK,
OS.TOTAL_OUTPUT QTY_OUTPUT
FROM MTH_EVENTS EVENTS1, (SELECT EOS.EQUIPMENT_FK_KEY ,
EOS.SHIFT_WORKDAY_FK_KEY,
EOS.WORKORDER_FK_KEY,
SUM(EOS.QTY_SCRAP) TOTAL_SCRAP,
SUM(EOS.QTY_REWORK) TOTAL_REWORK,
SUM(EOS.QTY_OUTPUT) TOTAL_OUTPUT
FROM ( SELECT MEOS.EQUIPMENT_FK_KEY ,
MEOS.SHIFT_WORKDAY_FK_KEY,
MEOS.WORKORDER_FK_KEY,
MEOS.QTY_SCRAP,
MEOS.QTY_REWORK ,
MEOS.QTY_OUTPUT
FROM MTH_EQUIP_OUTPUT_SUMMARY MEOS
WHERE MEOS.LAST_UPDATE_DATE >=v_log_from_date
)EOS
GROUP BY EOS.EQUIPMENT_FK_KEY ,
EOS.SHIFT_WORKDAY_FK_KEY,
EOS.WORKORDER_FK_KEY
)OS
WHERE OS.TOTAL_SCRAP IS NOT NULL And
OS.TOTAL_OUTPUT IS NOT NULL And
OS.TOTAL_SCRAP > 0 And
OS.TOTAL_OUTPUT > 0 And
OS.TOTAL_SCRAP / OS.TOTAL_OUTPUT * 100 > v_hi_scrap_threshold AND
OS.EQUIPMENT_FK_KEY = EVENTS1.EQUIPMENT_FK_KEY (+) And
OS.SHIFT_WORKDAY_FK_KEY = EVENTS1.SHIFT_WORKDAY_FK_KEY (+) And
OS.WORKORDER_FK_KEY = EVENTS1.WORKORDER_FK_KEY (+) And
EVENTS1.EVENT_ID IS NULL And 'HI_SCRP' = EVENTS1.EVENT_TYPE (+);
cursor c_readings is SELECT OS.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
OS.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
OS.WORKORDER_FK_KEY WORKORDER_FK_KEY,
OS.TOTAL_SCRAP QTY_SCRAP,
OS.TOTAL_REWORK QTY_REWORK,
OS.TOTAL_OUTPUT QTY_OUTPUT
FROM MTH_EVENTS EVENTS1, (SELECT EOS.EQUIPMENT_FK_KEY ,
EOS.SHIFT_WORKDAY_FK_KEY,
EOS.WORKORDER_FK_KEY,
SUM(EOS.QTY_SCRAP) TOTAL_SCRAP,
SUM(EOS.QTY_REWORK) TOTAL_REWORK,
SUM(EOS.QTY_OUTPUT) TOTAL_OUTPUT
FROM ( SELECT MEOS.EQUIPMENT_FK_KEY ,
MEOS.SHIFT_WORKDAY_FK_KEY,
MEOS.WORKORDER_FK_KEY,
MEOS.QTY_SCRAP,
MEOS.QTY_REWORK ,
MEOS.QTY_OUTPUT
FROM MTH_EQUIP_OUTPUT_SUMMARY MEOS
WHERE MEOS.LAST_UPDATE_DATE >=v_log_from_date
)EOS
GROUP BY EOS.EQUIPMENT_FK_KEY ,
EOS.SHIFT_WORKDAY_FK_KEY,
EOS.WORKORDER_FK_KEY
)OS
WHERE OS.TOTAL_REWORK IS NOT NULL And
OS.TOTAL_OUTPUT IS NOT NULL And
OS.TOTAL_REWORK > 0 And
OS.TOTAL_OUTPUT > 0 And
OS.TOTAL_REWORK / OS.TOTAL_OUTPUT * 100 > v_hi_rework_threshold AND
OS.EQUIPMENT_FK_KEY = EVENTS1.EQUIPMENT_FK_KEY (+) And
OS.SHIFT_WORKDAY_FK_KEY = EVENTS1.SHIFT_WORKDAY_FK_KEY (+) And
OS.WORKORDER_FK_KEY = EVENTS1.WORKORDER_FK_KEY (+) And
EVENTS1.EVENT_ID IS NULL And 'HI_RWRK' = EVENTS1.EVENT_TYPE (+);
SELECT Count(*) INTO v_count FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API');
SELECT B.DESCRIPTION INTO v_desc FROM FND_LOOKUPS B WHERE B.LOOKUP_TYPE IN ('MTH_EVENT_GEN_API');