SQL Language (MOSC)

MOSC Banner

how to disappear line based on condition

in SQL Language (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center