VIEW: APPS.MSC_PLAN_LIST_LB_V

Source

View Text - Preformatted

SELECT PLAN_ID , PLAN_NAME FROM (select PLAN_id PLAN_ID, COMPILE_DESIGNATOR PLAN_NAME FROM MSC_PLANS WHERE PLAN_ID > 0 UNION SELECT -1 PLAN_ID, FND_MESSAGE.get_string('MSC', 'MSC_COLLAB_LIAB') PLAN_NAME FROM DUAL ) ORDER BY PLAN_ID

View Text - HTML Formatted

SELECT PLAN_ID
, PLAN_NAME
FROM (SELECT PLAN_ID PLAN_ID
, COMPILE_DESIGNATOR PLAN_NAME
FROM MSC_PLANS
WHERE PLAN_ID > 0 UNION SELECT -1 PLAN_ID
, FND_MESSAGE.GET_STRING('MSC'
, 'MSC_COLLAB_LIAB') PLAN_NAME
FROM DUAL ) ORDER BY PLAN_ID