DBA Data[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