VIEW: APPS.ISC_MSC_BIS_INV_ORGS_V

Source

View Text - Preformatted

SELECT distinct sr_instance_id||'-'||sr_tp_id ID, partner_name VALUE FROM msc_trading_partners WHERE partner_type = 3

View Text - HTML Formatted

SELECT DISTINCT SR_INSTANCE_ID||'-'||SR_TP_ID ID
, PARTNER_NAME VALUE
FROM MSC_TRADING_PARTNERS
WHERE PARTNER_TYPE = 3