eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: MSD.MSD_CS_DEFINITIONS#

Source

View Text - Preformatted


select CS_DEFINITION_ID CS_DEFINITION_ID, NAME NAME, DESCRIPTION DESCRIPTION, CS_CLASSIFICATION CS_CLASSIFICATION, CS_TYPE CS_TYPE, LOWEST_LEVEL_FLAG LOWEST_LEVEL_FLAG, STRICT_FLAG STRICT_FLAG, SYSTEM_FLAG SYSTEM_FLAG, LOCAL_STREAM_FLAG LOCAL_STREAM_FLAG, MULTIPLE_STREAM_FLAG MULTIPLE_STREAM_FLAG, AGGREGATION_ALLOWED_FLAG AGGREGATION_ALLOWED_FLAG, ALLOCATION_ALLOWED_FLAG ALLOCATION_ALLOWED_FLAG, MEASUREMENT_TYPE MEASUREMENT_TYPE, STREAM_EDITABLE_FLAG STREAM_EDITABLE_FLAG, PRD_LEVEL_ID PRD_LEVEL_ID, GEO_LEVEL_ID GEO_LEVEL_ID, CUS_LEVEL_ID CUS_LEVEL_ID, ORG_LEVEL_ID ORG_LEVEL_ID, CHN_LEVEL_ID CHN_LEVEL_ID, REP_LEVEL_ID REP_LEVEL_ID, UD1_LEVEL_ID UD1_LEVEL_ID, UD2_LEVEL_ID UD2_LEVEL_ID, PLANNING_SERVER_VIEW_NAME PLANNING_SERVER_VIEW_NAME, SOURCE_VIEW_NAME SOURCE_VIEW_NAME, COLLECTION_PROGRAM_NAME COLLECTION_PROGRAM_NAME, COLLECT_ADDTL_WHERE_CLAUSE COLLECT_ADDTL_WHERE_CLAUSE, PULL_ADDTL_WHERE_CLAUSE PULL_ADDTL_WHERE_CLAUSE, VALID_FLAG VALID_FLAG, ENABLE_FLAG ENABLE_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, CS_LOV_VIEW_NAME CS_LOV_VIEW_NAME, DEPENDENT_DATA_FLAG DEPENDENT_DATA_FLAG, COMPOSITE_GROUP_CODE COMPOSITE_GROUP_CODE, DEPENDENT_DEMAND_CODE DEPENDENT_DEMAND_CODE, STRIPE_FLAG STRIPE_FLAG, PLANNING_SERVER_VIEW_NAME_DS PLANNING_SERVER_VIEW_NAME_DS, PLAN_TYPE PLAN_TYPE, LIABILITY_USER_FLAG LIABILITY_USER_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "MSD"."MSD_CS_DEFINITIONS"

View Text - HTML Formatted

SELECT CS_DEFINITION_ID CS_DEFINITION_ID
, NAME NAME
, DESCRIPTION DESCRIPTION
, CS_CLASSIFICATION CS_CLASSIFICATION
, CS_TYPE CS_TYPE
, LOWEST_LEVEL_FLAG LOWEST_LEVEL_FLAG
, STRICT_FLAG STRICT_FLAG
, SYSTEM_FLAG SYSTEM_FLAG
, LOCAL_STREAM_FLAG LOCAL_STREAM_FLAG
, MULTIPLE_STREAM_FLAG MULTIPLE_STREAM_FLAG
, AGGREGATION_ALLOWED_FLAG AGGREGATION_ALLOWED_FLAG
, ALLOCATION_ALLOWED_FLAG ALLOCATION_ALLOWED_FLAG
, MEASUREMENT_TYPE MEASUREMENT_TYPE
, STREAM_EDITABLE_FLAG STREAM_EDITABLE_FLAG
, PRD_LEVEL_ID PRD_LEVEL_ID
, GEO_LEVEL_ID GEO_LEVEL_ID
, CUS_LEVEL_ID CUS_LEVEL_ID
, ORG_LEVEL_ID ORG_LEVEL_ID
, CHN_LEVEL_ID CHN_LEVEL_ID
, REP_LEVEL_ID REP_LEVEL_ID
, UD1_LEVEL_ID UD1_LEVEL_ID
, UD2_LEVEL_ID UD2_LEVEL_ID
, PLANNING_SERVER_VIEW_NAME PLANNING_SERVER_VIEW_NAME
, SOURCE_VIEW_NAME SOURCE_VIEW_NAME
, COLLECTION_PROGRAM_NAME COLLECTION_PROGRAM_NAME
, COLLECT_ADDTL_WHERE_CLAUSE COLLECT_ADDTL_WHERE_CLAUSE
, PULL_ADDTL_WHERE_CLAUSE PULL_ADDTL_WHERE_CLAUSE
, VALID_FLAG VALID_FLAG
, ENABLE_FLAG ENABLE_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, CS_LOV_VIEW_NAME CS_LOV_VIEW_NAME
, DEPENDENT_DATA_FLAG DEPENDENT_DATA_FLAG
, COMPOSITE_GROUP_CODE COMPOSITE_GROUP_CODE
, DEPENDENT_DEMAND_CODE DEPENDENT_DEMAND_CODE
, STRIPE_FLAG STRIPE_FLAG
, PLANNING_SERVER_VIEW_NAME_DS PLANNING_SERVER_VIEW_NAME_DS
, PLAN_TYPE PLAN_TYPE
, LIABILITY_USER_FLAG LIABILITY_USER_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "MSD"."MSD_CS_DEFINITIONS"