[Home] [Help]
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
Name |
OBJECT_ID |
OBJECT_NAME |
OBJECT_TYPE |