V_RISK_ASSESSMENT - LEFT OUTER JOIN

less than 1 minute read


<P><FONT SIZE=2 FACE=”Arial”>CREATE OR REPLACE VIEW CCOP1DBO.V_RISK_ASSESSMENT AS</FONT>
<FONT SIZE=2 FACE=”Arial”>SELECT DISTINCT</FONT>
        <FONT SIZE=2 FACE=”Arial”>RA.RA_OID, </FONT>
        <FONT SIZE=2 FACE=”Arial”>RA.RA_NAME,</FONT>
        <FONT SIZE=2 FACE=”Arial”>BH.BH_LEVEL_SHORT_NAME,</FONT>
        <FONT SIZE=2 FACE=”Arial”>NVL(CDL.CSR_DOCUMENT_ID,’N’) xx,</FONT>
        <FONT SIZE=2 FACE=”Arial”>CDL.RA_OID AS CSR_RA_OID</FONT>
<FONT SIZE=2 FACE=”Arial”>FROM </FONT>
        <FONT SIZE=2 FACE=”Arial”>T_RISK_ASSESSMENT RA </FONT>
        <FONT SIZE=2 FACE=”Arial”>LEFT OUTER JOIN T_BUSINESS_HIERARCHY BH</FONT>
<FONT SIZE=2 FACE=”Arial”>        ON RA.BH_OID = BH.BH_OID</FONT>
        <FONT SIZE=2 FACE=”Arial”>LEFT OUTER JOIN T_CSR_DOCUMENT_LINK CDL </FONT>
<FONT SIZE=2 FACE=”Arial”>        ON CDL.RA_OID = RA.RA_OID</FONT>
<FONT SIZE=2 FACE=”Arial”>ORDER BY RA.RA_OID;</FONT>
<FONT SIZE=2 FACE=”Arial”>commit;</FONT> </P>

Categories:

Updated:

Leave a Comment