[Home] [Help]
VIEW: APPS.ISC_MSC_BIS_SUPPLIERS_V
Source
View Text - Preformatted
SELECT 'NA' ID, 'Other' VALUE FROM DUAL UNION ALL SELECT to_char(partner_id) ID, partner_name VALUE FROM msc_trading_partners WHERE partner_type = 1
View Text - HTML Formatted
SELECT 'NA' ID
, 'OTHER' VALUE
FROM DUAL UNION ALL SELECT TO_CHAR(PARTNER_ID) ID
, PARTNER_NAME VALUE
FROM MSC_TRADING_PARTNERS
WHERE PARTNER_TYPE = 1