Forum Stats

  • 3,760,418 Users
  • 2,251,703 Discussions
  • 7,871,111 Comments

Discussions

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

MD DIDARUL ISLAM
MD DIDARUL ISLAM Member Posts: 3 Green Ribbon

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