Skip to Main Content

I want to create Oracle apex Summery report by using this query--Help PLZ

MD DIDARUL ISLAMMay 27 2021

Select SERIALNO,DECODE (PLANT,'1','Plant 01','2','Plant 02') PLANT, KLIN_IMPUT, KLIN_REJECTION,KLIN_GAP,KLIN_OUTPUT, SIZE_CODE, SIZE_SPECIFICATION, MODEL_CODE, FAST_CLASS, SECOND_CLASS, WC_CLASS, TOTAL_PACKING, SAMPLE, REJECTION, TOTAL_PACKING_OUTPUT, CUM_KLINPRODUCTION
from X
where to_date(MDATE,'dd-mm-rrrr') between to_date(:P33_FDATE,'dd-mm-rrrr') and to_date(:P33_TODATE,'dd-mm-rrrr')
and (:P33_PLANT is null or PLANT=:P33_PLANT)
and (:P33_SIZE is null or SIZE_CODE=:P33_SIZE)
and (:P33_TTYPE is null or SIZE_SPECIFICATION=:P33_TTYPE)
--and ( to_date(:P15_FROM_DATE,'dd-mm-rrrr') is null or to_date(MDATE,'dd-mm-rrrr') >= to_date(:P15_FROM_DATE,'dd-mm-rrrr') )
--and ( to_date(:P15_TO_DATE,'dd-mm-rrrr') is null or to_date(MDATE,'dd-mm-rrrr') <= to_date(:P15_TO_DATE,'dd-mm-rrrr') )
order by mdate desc,serialno

This post has been answered by Jose Alejandro on Dec 28 2021
Jump to Answer
Comments
Post Details
Added on May 27 2021
1 comment
34 views