Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
SELECT CUST_CODE, OP_CODE, JOB_TP_DES, DOC_NUM, DOC_LINE_NUM, LAB_UNIT, INVT_ACCESS, (select INVT_QTY_BKD_FACT as IQBP FROM C_INVT WHERE C_INVT.Comp_Code = 'A1' AND C_INVT.Invt_access = INVT_ACCESS) IQBP2, CASE WHEN MINS < 0 THEN 1 ELSE MINS END as MINS FROM ( SELECT LAB.CUST_CODE,LAB.OP_CODE,JOB.JOB_TP_DES,LAB.DOC_NUM, LAB.DOC_LINE_NUM, LAB.LAB_UNIT, CASE WHEN LAB.JOB_TP_Code IN('PI','LO') THEN (SELECT INVT_ACCESS from E_ORD_D5 Where comp_code = Lab.Comp_code and ord_num = Lab.doc_num and ord_line_num = Lab.DOC_LINE_NUM) WHEN LAB.JOB_TP_Code IN('PU','UN') THEN (SELECT INVT_ACCESS from E_RCPT_D5 Where comp_code = Lab.Comp_code and rcpt_num = Lab.doc_num and rcpt_line_num = Lab.DOC_LINE_NUM) END as INVT_ACCESS, LAB_START_DATE, ROUND(((LEAD(LAB_START_DATE) OVER(order by OP_CODE,LAB_START_DATE)-LAB_START_DATE) *1440),2) MINS FROM M_JOB_TP_H JOB,C_LAB LAB where lab.comp_code='A1' and lab.comp_code=job.comp_code and lab.job_tp_code=job.job_tp_code AND LAB.OP_CODE in ('KHANA','DEXTER') AND (TRUNC(LAB_START_DATE)>trunc(SYSDATE -5)) AND (TRUNC(LAB_START_DATE)<trunc(SYSDATE-3)) order by LAB.OP_CODE,LAB_START_DATE )
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.