Process Manufacturing - EBS (MOSC)

MOSC Banner

Eliminate Text Formula: from query

Hi All,

Working in OPM 12.1.3

The below query is not working, the first line should not appear and the second should appear.

in my qqery both are not appeatring

Please i need some help

Formula: TVI 2100:60--NC/PU

 3034NB0900DU:NC. ALC. ORANGE

select * 

from fm_ibom_dtl a

where top_formula_id IN( 64540) --84255,

   and not exists(select 'X' from apps.fm_form_mst

                where formula_status = 700

                 and owner_organization_id = 108

                   and formula_no =trim (substr (trim (replace (a.line_desc,'Formula:','')), 1,instr (trim (replace (a.line_desc,'Formula:','')),':', 1, 1)- 1))

                   )

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