VIEW: APPS.MSD_OBJECTS_V

Source

View Text - Preformatted

SELECT to_char(level_id) object_id, level_name object_name, '5' object_type from msd_levels where plan_type is null union (select to_char(hierarchy_id) object_id, hierarchy_name object_name, '4' object_type from msd_hierarchies where plan_type is null) union (select lookup_code object_id, meaning object_name, '3' object_type from fnd_lookup_values_vl where lookup_type = 'MSD_DIMENSIONS') union (select to_char(demand_plan_id) object_id, demand_plan_name object_name, '2' object_type from msd_demand_plans where nvl(plan_type, '-1') <> 'LIABILITY')

View Text - HTML Formatted

SELECT TO_CHAR(LEVEL_ID) OBJECT_ID
, LEVEL_NAME OBJECT_NAME
, '5' OBJECT_TYPE
FROM MSD_LEVELS
WHERE PLAN_TYPE IS NULL UNION (SELECT TO_CHAR(HIERARCHY_ID) OBJECT_ID
, HIERARCHY_NAME OBJECT_NAME
, '4' OBJECT_TYPE
FROM MSD_HIERARCHIES
WHERE PLAN_TYPE IS NULL) UNION (SELECT LOOKUP_CODE OBJECT_ID
, MEANING OBJECT_NAME
, '3' OBJECT_TYPE
FROM FND_LOOKUP_VALUES_VL
WHERE LOOKUP_TYPE = 'MSD_DIMENSIONS') UNION (SELECT TO_CHAR(DEMAND_PLAN_ID) OBJECT_ID
, DEMAND_PLAN_NAME OBJECT_NAME
, '2' OBJECT_TYPE
FROM MSD_DEMAND_PLANS
WHERE NVL(PLAN_TYPE
, '-1') <> 'LIABILITY')