SQLDepot
1 query found for "Case Status"

Get all Case Status 

SELECT DISTINCT cs.case_type_cd, cs.case_status_cd, trim(csl.status_lbl) as description
FROM ci_case_status cs,
  ci_case_status_l csl
WHERE cs.case_type_cd=csl.case_type_cd
and cs.case_status_cd=csl.case_status_cd
AND csl.language_cd  = 'INSERT_LANGUAGE_CD_MOSTLY_ENG'
ORDER BY description
uploaded by Nuno Rodrigues

About & Contact

Why SQLDepot.com?
Because we've seen the same SQL code being written in different implementations - and that's a waste of time!

Who developed this?
Decrod Ltd - a consulting and application development company based in London, UK.

Is this an Oracle website?
This is not an Oracle website and we are not affiliated, associated, authorized, endorsed by, or in any way officially connected with Oracle Corporation.

Any questions?
Dont hesitate to get in touch. Our email is info@decrod.com