SELECT 'NA' ID, 'Other' VALUE FROM dual UNION ALL SELECT to_char(tp.partner_id) ID, tp.partner_name VALUE FROM msc_trading_partners TP WHERE tp.partner_type = 2
View Text - HTML Formatted
SELECT 'NA' ID , 'OTHER' VALUE FROM DUAL UNION ALL SELECT TO_CHAR(TP.PARTNER_ID) ID , TP.PARTNER_NAME VALUE FROM MSC_TRADING_PARTNERS TP WHERE TP.PARTNER_TYPE = 2