Product: | MSD - Demand Planning |
---|---|
Description: | This view provides Data Stream's Column Details. |
Implementation/DBA Data: | APPS.MSD_CS_DEFN_COLUMN_DTLS_V |
SELECT DFND.CS_COLUMN_DTLS_ID
, DFND.CS_DEFINITION_ID
, DEFN.NAME
, DFND.SOURCE_VIEW_COLUMN_NAME
, DFND.PLANNING_VIEW_COLUMN_NAME
, DFND.COLUMN_IDENTIFIER
, DFND.TABLE_COLUMN
, IDEN.DESCRIPTION COLUMN_IDENTIFIER_DESC
, IDEN.IDENTIFIER_TYPE
, DFND.AGGREGATION_TYPE
, DFND.ALLOCATION_TYPE
, LOOK1.MEANING
, LOOK2.MEANING
, IDEN.USER_PROMPT
, UOM_CONVERSION_FLAG
, DFND.CREATION_DATE
, DFND.CREATED_BY
, DFND.LAST_UPDATE_DATE
, DFND.LAST_UPDATED_BY
, DFND.LAST_UPDATE_LOGIN
, DFND.REQUEST_ID
, DFND.PROGRAM_APPLICATION_ID
, DFND.PROGRAM_ID
, DFND.PROGRAM_UPDATE_DATE
FROM MSD_CS_DEFN_COLUMN_DTLS DFND
, MSD_CS_CLMN_IDENTIFIERS_VL IDEN
, MSD_CS_DEFINITIONS DEFN
, FND_LOOKUP_VALUES_VL LOOK1
, FND_LOOKUP_VALUES_VL LOOK2
WHERE DFND.CS_DEFINITION_ID = DEFN.CS_DEFINITION_ID
AND DFND.COLUMN_IDENTIFIER = IDEN.COLUMN_IDENTIFIER
AND DFND.AGGREGATION_TYPE = LOOK1.LOOKUP_CODE (+)
AND 'MSD_CS_AGGREGATION_TYPE' = LOOK1.LOOKUP_TYPE (+)
AND DFND.ALLOCATION_TYPE = LOOK2.LOOKUP_CODE (+)
AND 'MSD_CS_ALLOCATION_TYPE' = LOOK2.LOOKUP_TYPE (+)