VIEW: APPS.MSD_CS_DEFN_COLUMN_DTLS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)