View: MSD_OBJECTS_V

Product:	MSD - Demand Planning
Description:	This view to show all MSD Objects
Implementation/DBA Data:	APPS.MSD_OBJECTS_V

View Text

SELECT TO_CHAR(LEVEL_ID) OBJECT_ID
, LEVEL_NAME OBJECT_NAME
, '5' OBJECT_TYPE
FROM MSD_LEVELS UNION (SELECT TO_CHAR(HIERARCHY_ID) OBJECT_ID
, HIERARCHY_NAME OBJECT_NAME
, '4' OBJECT_TYPE
FROM MSD_HIERARCHIES) 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)

Columns