Product: | MSD - Demand Planning |
---|---|
Description: | This view provides Data Stream's Dimension Details. |
Implementation/DBA Data: | APPS.MSD_CS_DEFN_DIM_DTLS_V |
SELECT DFDIM.CS_DEFN_DIM_DTLS_ID
, DFDIM.CS_DEFINITION_ID
, DFDIM.DIMENSION_CODE
, DFDIM.COLLECT_LEVEL_ID
, DIM.MEANING
, DFDIM.COLLECT_FLAG
, MSD_CS_DFN_UTL.GET_LEVEL_DESC(DFDIM.DIMENSION_CODE
, DFDIM.COLLECT_LEVEL_ID) LEVEL_DESC
, DFDIM.ALLOCATION_TYPE
, ALLO.MEANING
, DFDIM.AGGREGATION_TYPE
, AGG.MEANING
, DFDIM.CREATION_DATE
, DFDIM.CREATED_BY
, DFDIM.LAST_UPDATE_DATE
, DFDIM.LAST_UPDATED_BY
, DFDIM.LAST_UPDATE_LOGIN
, DFDIM.REQUEST_ID
, DFDIM.PROGRAM_APPLICATION_ID
, DFDIM.PROGRAM_ID
, DFDIM.PROGRAM_UPDATE_DATE
FROM MSD_CS_DEFN_DIM_DTLS DFDIM
, FND_LOOKUP_VALUES_VL DIM
, FND_LOOKUP_VALUES_VL AGG
, FND_LOOKUP_VALUES_VL ALLO
WHERE DFDIM.DIMENSION_CODE = DIM.LOOKUP_CODE
AND DIM.LOOKUP_TYPE = 'MSD_DIMENSIONS'
AND DFDIM.AGGREGATION_TYPE = AGG.LOOKUP_CODE (+)
AND AGG.LOOKUP_TYPE (+) = 'MSD_CS_AGGREGATION_TYPE'
AND DFDIM.ALLOCATION_TYPE = ALLO.LOOKUP_CODE (+)
AND ALLO.LOOKUP_TYPE (+) = 'MSD_CS_ALLOCATION_TYPE'