how to disappear line based on condition
Hi All,
Oracle EBS
Version 12.2.10
Actually i want remove line based on condition like
if itemcategory = 'SOLVENTS' and ing_count <> 1 then this should not display else rest all data should appear please see the below example
this is my query
SELECT a.batch_no, a.batch_id btch_id,
NVL (a.actual_cmplt_date, a.plan_start_date) batch_date,
TO_CHAR( NVL (a.actual_cmplt_date, a.plan_start_date), 'MON-YYYY') MONTH,
TO_CHAR( NVL (a.actual_cmplt_date, a.plan_start_date), 'MM') MNTH,
e.attribute13 itemcategory,
,decode(org.operating_unit, 82,'RIYADH', 83,'JEDDAH', 84, 'DAMMAM', 85, 'DUBAI') BRANCH
, ( CASE WHEN a.attribute27 = 'PACKAGING' THEN