SQLDepot
1 query found for "CIS Division Language"

Get SA Type and CIS Div description given SA Id 

SELECT A.SA_TYPE_CD, B.DESCR SATYDESCR,A.CIS_DIVISION,  C.DESCR CISDIVDESCR FROM CI_SA A,  CI_SA_TYPE_L B,CI_CIS_DIVISION_L C
WHERE
A.SA_ID = 'INSERT_SA_ID'
AND A.SA_TYPE_CD = B.SA_TYPE_CD
AND B.LANGUAGE_CD = 'INSERT_LANGUAGE_CD_MOSTLY_ENG'
AND A.CIS_DIVISION = C.CIS_DIVISION
AND C.LANGUAGE_CD = 'INSERT_LANGUAGE_CD_MOSTLY_ENG'
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