VIEW: APPS.MSD_CS_DEFINITIONS_VL

Source

View Text - Preformatted

SELECT csd.CS_DEFINITION_ID, csd.NAME, csd_tl.DESCRIPTION, csd.CS_CLASSIFICATION, csd.CS_TYPE, LOK1.MEANING, csd.STRICT_FLAG, csd.SYSTEM_FLAG, csd.aggregation_allowed_flag, csd.allocation_allowed_flag, csd.stream_editable_flag, csd.enable_flag, csd.cs_lov_view_name, csd.measurement_type, LOK2.MEANING, csd.PLANNING_SERVER_VIEW_NAME, csd.PLANNING_SERVER_VIEW_NAME_DS, csd.SOURCE_VIEW_NAME, csd.stripe_flag, csd.COLLECTION_PROGRAM_NAME, csd.COLLECT_ADDTL_WHERE_CLAUSE, csd.PULL_ADDTL_WHERE_CLAUSE, csd.multiple_stream_flag, csd.VALID_FLAG, csd.CREATION_DATE,csd.CREATED_BY,csd.LAST_UPDATE_DATE, csd.LAST_UPDATED_BY, csd.LAST_UPDATE_LOGIN, csd.REQUEST_ID,csd.PROGRAM_APPLICATION_ID, csd.PROGRAM_ID, csd.PROGRAM_UPDATE_DATE, csd.lowest_level_flag, csd.COMPOSITE_GROUP_CODE, csd.dependent_data_flag, csd.dependent_demand_code , csd.plan_type,csd.liability_user_flag from msd_cs_definitions csd, msd_cs_definitions_tl csd_tl, fnd_lookup_values_vl lok1, fnd_lookup_values_vl lok2 WHERE csd.cs_definition_id = csd_tl.cs_definition_id and csd_tl.language = userenv('LANG') and csd.cs_type = lok1.lookup_code (+) and lok1.lookup_type (+) = 'MSD_CS_STREAM_SOURCE_TYPE' and csd.measurement_type = lok2.lookup_code (+) and lok2.lookup_type (+) = 'MSD_CS_MEASUREMENT_TYPE'

View Text - HTML Formatted

SELECT CSD.CS_DEFINITION_ID
, CSD.NAME
, CSD_TL.DESCRIPTION
, CSD.CS_CLASSIFICATION
, CSD.CS_TYPE
, LOK1.MEANING
, CSD.STRICT_FLAG
, CSD.SYSTEM_FLAG
, CSD.AGGREGATION_ALLOWED_FLAG
, CSD.ALLOCATION_ALLOWED_FLAG
, CSD.STREAM_EDITABLE_FLAG
, CSD.ENABLE_FLAG
, CSD.CS_LOV_VIEW_NAME
, CSD.MEASUREMENT_TYPE
, LOK2.MEANING
, CSD.PLANNING_SERVER_VIEW_NAME
, CSD.PLANNING_SERVER_VIEW_NAME_DS
, CSD.SOURCE_VIEW_NAME
, CSD.STRIPE_FLAG
, CSD.COLLECTION_PROGRAM_NAME
, CSD.COLLECT_ADDTL_WHERE_CLAUSE
, CSD.PULL_ADDTL_WHERE_CLAUSE
, CSD.MULTIPLE_STREAM_FLAG
, CSD.VALID_FLAG
, CSD.CREATION_DATE
, CSD.CREATED_BY
, CSD.LAST_UPDATE_DATE
, CSD.LAST_UPDATED_BY
, CSD.LAST_UPDATE_LOGIN
, CSD.REQUEST_ID
, CSD.PROGRAM_APPLICATION_ID
, CSD.PROGRAM_ID
, CSD.PROGRAM_UPDATE_DATE
, CSD.LOWEST_LEVEL_FLAG
, CSD.COMPOSITE_GROUP_CODE
, CSD.DEPENDENT_DATA_FLAG
, CSD.DEPENDENT_DEMAND_CODE
, CSD.PLAN_TYPE
, CSD.LIABILITY_USER_FLAG
FROM MSD_CS_DEFINITIONS CSD
, MSD_CS_DEFINITIONS_TL CSD_TL
, FND_LOOKUP_VALUES_VL LOK1
, FND_LOOKUP_VALUES_VL LOK2
WHERE CSD.CS_DEFINITION_ID = CSD_TL.CS_DEFINITION_ID
AND CSD_TL.LANGUAGE = USERENV('LANG')
AND CSD.CS_TYPE = LOK1.LOOKUP_CODE (+)
AND LOK1.LOOKUP_TYPE (+) = 'MSD_CS_STREAM_SOURCE_TYPE'
AND CSD.MEASUREMENT_TYPE = LOK2.LOOKUP_CODE (+)
AND LOK2.LOOKUP_TYPE (+) = 'MSD_CS_MEASUREMENT_TYPE'