Product: | MSD - Demand Planning |
---|---|
Description: | This view is provides Data Stream's Dimension-Column specific details. |
Implementation/DBA Data: | APPS.MSD_CS_CLMN_DIM_DTLS_V |
SELECT CLDIM.CS_CLMN_DIM_DTLS_ID
, CLDIM.CS_DEFN_DIM_DTLS_ID
, CLDIM.CS_COLUMN_DTLS_ID
, DFCLM.CS_DEFINITION_ID
, DFCLM.IDENTIFIER_TYPE
, DFCLM.COLUMN_IDENTIFIER
, DFCLM.COLUMN_IDENTIFIER_DESC
, DFCLM.TABLE_COLUMN
, CLDIM.AGGREGATION_TYPE
, CLDIM.ALLOCATION_TYPE
, DFDIM.DIMENSION_CODE
, DFDIM.DIMENSION_DESC
, AGG.MEANING AGGREGATION_TYPE_DESC
, ALLO.MEANING ALLOCATION_TYPE_DESC
, CLDIM.CREATION_DATE
, CLDIM.CREATED_BY
, CLDIM.LAST_UPDATE_DATE
, CLDIM.LAST_UPDATED_BY
, CLDIM.LAST_UPDATE_LOGIN
, CLDIM.REQUEST_ID
, CLDIM.PROGRAM_APPLICATION_ID
, CLDIM.PROGRAM_ID
, CLDIM.PROGRAM_UPDATE_DATE
FROM MSD_CS_CLMN_DIM_DTLS CLDIM
, MSD_CS_DEFN_COLUMN_DTLS_V DFCLM
, MSD_CS_DEFN_DIM_DTLS_V DFDIM
, FND_LOOKUP_VALUES_VL AGG
, FND_LOOKUP_VALUES_VL ALLO
WHERE CLDIM.AGGREGATION_TYPE = AGG.LOOKUP_CODE (+)
AND AGG.LOOKUP_TYPE (+) = 'MSD_CS_AGGREGATION_TYPE'
AND CLDIM.ALLOCATION_TYPE = ALLO.LOOKUP_CODE (+)
AND ALLO.LOOKUP_TYPE (+) = 'MSD_CS_ALLOCATION_TYPE'
AND DFCLM.CS_COLUMN_DTLS_ID = CLDIM.CS_COLUMN_DTLS_ID
AND DFDIM.CS_DEFN_DIM_DTLS_ID = CLDIM.CS_DEFN_DIM_DTLS_ID