VIEW: APPS.MSC_X_PLANNERS_V

Source

View Text - Preformatted

SELECT distinct planner_code, plan_id from msc_system_items where planner_code is not null order by planner_code

View Text - HTML Formatted

SELECT DISTINCT PLANNER_CODE
, PLAN_ID
FROM MSC_SYSTEM_ITEMS
WHERE PLANNER_CODE IS NOT NULL ORDER BY PLANNER_CODE