SELECT c.PARTY_ID, c.CLASS_CATEGORY, c.CLASS_CODE FROM FII_PARTY_MKT_CLASS c UNION ALL SELECT -2 PARTY_ID, bis_common_parameters.GET_BIS_CUST_CLASS_TYPE CLASS_CATEGORY, '-1' FROM dual
View Text - HTML Formatted
SELECT C.PARTY_ID , C.CLASS_CATEGORY , C.CLASS_CODE FROM FII_PARTY_MKT_CLASS C UNION ALL SELECT -2 PARTY_ID , BIS_COMMON_PARAMETERS.GET_BIS_CUST_CLASS_TYPE CLASS_CATEGORY , '-1' FROM DUAL