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))
)