MSC_EXCEPTION

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
EXCEPTION_ID SEEDED_FLAG PLAN_TYPE BASIS BASIS_VALUE EXCEPTION_OPERATION THRESHOLD_TYPE THRESHOLD THRESHOLD_DATE CUSTOMER_DIM_ENABLED CUSTOMER_HIERARCHY CUSTOMER_LEVEL DEMAND_CLASS_DIM_ENABLED DEMAND_CLASS_HIERARCHY DEMAND_CLASS_LEVEL EXCEPTION_DIM_ENABLED EXCEPTION_HIERARCHY EXCEPTION_LEVEL ORDER_TYPE_DIM_ENABLED ORDER_TYPE_HIERARCHY ORDER_TYPE_LEVEL ORGANIZATION_DIM_ENABLED ORGANIZATION_HIERARCHY ORGANIZATION_LEVEL PLAN_DIM_ENABLED PLAN_HIERARCHY PLAN_LEVEL PRODUCT_DIM_ENABLED PRODUCT_HIERARCHY PRODUCT_LEVEL RESOURCE_DIM_ENABLED RESOURCE_HIERARCHY RESOURCE_LEVEL SALES_ORGANIZATION_DIM_ENABLED SALES_ORGANIZATION_HIERARCHY SALES_ORGANIZATION_LEVEL SCENARIO_DIM_ENABLED SCENARIO_HIERARCHY SCENARIO_LEVEL SOURCE_DIM_ENABLED SOURCE_HIERARCHY SOURCE_LEVEL SUPPLIER_DIM_ENABLED SUPPLIER_HIERARCHY SUPPLIER_LEVEL TIME_DIM_ENABLED TIME_HIERARCHY TIME_LEVEL CLUSTER_DIM_ENABLED CLUSTER_HIERARCHY CLUSTER_LEVEL INCLUDE_DEPENDENT_MEASURES SEND_NOTIFICATION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER NAME DISPLAY_NAME END_DEM_PRODUCT_DIM_ENABLED END_DEM_PRODUCT_HIERARCHY END_DEM_PRODUCT_LEVEL END_DEM_ORG_DIM_ENABLED END_DEM_ORG_HIERARCHY END_DEM_ORG_LEVEL END_DEM_ORDER_TYPE_DIM_ENABLED END_DEM_ORDER_TYPE_HIERARCHY END_DEM_ORDER_TYPE_LEVEL

Name

EXCEPTION_ID

SEEDED_FLAG

PLAN_TYPE

BASIS

BASIS_VALUE

EXCEPTION_OPERATION

THRESHOLD_TYPE

THRESHOLD

THRESHOLD_DATE

CUSTOMER_DIM_ENABLED

CUSTOMER_HIERARCHY

CUSTOMER_LEVEL

DEMAND_CLASS_DIM_ENABLED

DEMAND_CLASS_HIERARCHY

DEMAND_CLASS_LEVEL

EXCEPTION_DIM_ENABLED

EXCEPTION_HIERARCHY

EXCEPTION_LEVEL

ORDER_TYPE_DIM_ENABLED

ORDER_TYPE_HIERARCHY

ORDER_TYPE_LEVEL

ORGANIZATION_DIM_ENABLED

ORGANIZATION_HIERARCHY

ORGANIZATION_LEVEL

PLAN_DIM_ENABLED

PLAN_HIERARCHY

PLAN_LEVEL

PRODUCT_DIM_ENABLED

PRODUCT_HIERARCHY

PRODUCT_LEVEL

RESOURCE_DIM_ENABLED

RESOURCE_HIERARCHY

RESOURCE_LEVEL

SALES_ORGANIZATION_DIM_ENABLED

SALES_ORGANIZATION_HIERARCHY

SALES_ORGANIZATION_LEVEL

SCENARIO_DIM_ENABLED

SCENARIO_HIERARCHY

SCENARIO_LEVEL

SOURCE_DIM_ENABLED

SOURCE_HIERARCHY

SOURCE_LEVEL

SUPPLIER_DIM_ENABLED

SUPPLIER_HIERARCHY

SUPPLIER_LEVEL

TIME_DIM_ENABLED

TIME_HIERARCHY

TIME_LEVEL

CLUSTER_DIM_ENABLED

CLUSTER_HIERARCHY

CLUSTER_LEVEL

INCLUDE_DEPENDENT_MEASURES

SEND_NOTIFICATION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

NAME

DISPLAY_NAME

END_DEM_PRODUCT_DIM_ENABLED

END_DEM_PRODUCT_HIERARCHY

END_DEM_PRODUCT_LEVEL

END_DEM_ORG_DIM_ENABLED

END_DEM_ORG_HIERARCHY

END_DEM_ORG_LEVEL

END_DEM_ORDER_TYPE_DIM_ENABLED

END_DEM_ORDER_TYPE_HIERARCHY

END_DEM_ORDER_TYPE_LEVEL

Query

SQL_Statement
SELECT B.EXCEPTION_ID, B.SEEDED_FLAG, B.PLAN_TYPE, B.BASIS, B.BASIS_VALUE, B.EXCEPTION_OPERATION, B.THRESHOLD_TYPE, B.THRESHOLD, B.THRESHOLD_DATE, B.CUSTOMER_DIM_ENABLED, B.CUSTOMER_HIERARCHY, B.CUSTOMER_LEVEL, B.DEMAND_CLASS_DIM_ENABLED, B.DEMAND_CLASS_HIERARCHY, B.DEMAND_CLASS_LEVEL, B.EXCEPTION_DIM_ENABLED, B.EXCEPTION_HIERARCHY, B.EXCEPTION_LEVEL, B.ORDER_TYPE_DIM_ENABLED, B.ORDER_TYPE_HIERARCHY, B.ORDER_TYPE_LEVEL, B.ORGANIZATION_DIM_ENABLED, B.ORGANIZATION_HIERARCHY, B.ORGANIZATION_LEVEL, B.PLAN_DIM_ENABLED, B.PLAN_HIERARCHY, B.PLAN_LEVEL, B.PRODUCT_DIM_ENABLED, B.PRODUCT_HIERARCHY, B.PRODUCT_LEVEL, B.RESOURCE_DIM_ENABLED, B.RESOURCE_HIERARCHY, B.RESOURCE_LEVEL, B.SALES_ORGANIZATION_DIM_ENABLED, B.SALES_ORGANIZATION_HIERARCHY, B.SALES_ORGANIZATION_LEVEL, B.SCENARIO_DIM_ENABLED, B.SCENARIO_HIERARCHY, B.SCENARIO_LEVEL, B.SOURCE_DIM_ENABLED, B.SOURCE_HIERARCHY, B.SOURCE_LEVEL, B.SUPPLIER_DIM_ENABLED, B.SUPPLIER_HIERARCHY, B.SUPPLIER_LEVEL, B.TIME_DIM_ENABLED, B.TIME_HIERARCHY, B.TIME_LEVEL, B.CLUSTER_DIM_ENABLED, B.CLUSTER_HIERARCHY, B.CLUSTER_LEVEL, B.INCLUDE_DEPENDENT_MEASURES, B.SEND_NOTIFICATION, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, T.NAME, T.DISPLAY_NAME, B.END_DEM_PRODUCT_DIM_ENABLED, B.END_DEM_PRODUCT_HIERARCHY, B.END_DEM_PRODUCT_LEVEL, B.END_DEM_ORG_DIM_ENABLED, B.END_DEM_ORG_HIERARCHY, B.END_DEM_ORG_LEVEL, B.END_DEM_ORDER_TYPE_DIM_ENABLED, B.END_DEM_ORDER_TYPE_HIERARCHY, B.END_DEM_ORDER_TYPE_LEVEL FROM MSC_EXCEPTION_TL T, MSC_EXCEPTION_B B WHERE B.EXCEPTION_ID = T.EXCEPTION_ID AND T.LANGUAGE = userenv('LANG')

SQL_Statement

SELECT

B.EXCEPTION_ID,

B.SEEDED_FLAG,

B.PLAN_TYPE,

B.BASIS,

B.BASIS_VALUE,

B.EXCEPTION_OPERATION,

B.THRESHOLD_TYPE,

B.THRESHOLD,

B.THRESHOLD_DATE,

B.CUSTOMER_DIM_ENABLED,

B.CUSTOMER_HIERARCHY,

B.CUSTOMER_LEVEL,

B.DEMAND_CLASS_DIM_ENABLED,

B.DEMAND_CLASS_HIERARCHY,

B.DEMAND_CLASS_LEVEL,

B.EXCEPTION_DIM_ENABLED,

B.EXCEPTION_HIERARCHY,

B.EXCEPTION_LEVEL,

B.ORDER_TYPE_DIM_ENABLED,

B.ORDER_TYPE_HIERARCHY,

B.ORDER_TYPE_LEVEL,

B.ORGANIZATION_DIM_ENABLED,

B.ORGANIZATION_HIERARCHY,

B.ORGANIZATION_LEVEL,

B.PLAN_DIM_ENABLED,

B.PLAN_HIERARCHY,

B.PLAN_LEVEL,

B.PRODUCT_DIM_ENABLED,

B.PRODUCT_HIERARCHY,

B.PRODUCT_LEVEL,

B.RESOURCE_DIM_ENABLED,

B.RESOURCE_HIERARCHY,

B.RESOURCE_LEVEL,

B.SALES_ORGANIZATION_DIM_ENABLED,

B.SALES_ORGANIZATION_HIERARCHY,

B.SALES_ORGANIZATION_LEVEL,

B.SCENARIO_DIM_ENABLED,

B.SCENARIO_HIERARCHY,

B.SCENARIO_LEVEL,

B.SOURCE_DIM_ENABLED,

B.SOURCE_HIERARCHY,

B.SOURCE_LEVEL,

B.SUPPLIER_DIM_ENABLED,

B.SUPPLIER_HIERARCHY,

B.SUPPLIER_LEVEL,

B.TIME_DIM_ENABLED,

B.TIME_HIERARCHY,

B.TIME_LEVEL,

B.CLUSTER_DIM_ENABLED,

B.CLUSTER_HIERARCHY,

B.CLUSTER_LEVEL,

B.INCLUDE_DEPENDENT_MEASURES,

B.SEND_NOTIFICATION,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

T.NAME,

T.DISPLAY_NAME,

B.END_DEM_PRODUCT_DIM_ENABLED,

B.END_DEM_PRODUCT_HIERARCHY,

B.END_DEM_PRODUCT_LEVEL,

B.END_DEM_ORG_DIM_ENABLED,

B.END_DEM_ORG_HIERARCHY,

B.END_DEM_ORG_LEVEL,

B.END_DEM_ORDER_TYPE_DIM_ENABLED,

B.END_DEM_ORDER_TYPE_HIERARCHY,

B.END_DEM_ORDER_TYPE_LEVEL

FROM MSC_EXCEPTION_TL T,

MSC_EXCEPTION_B B

WHERE B.EXCEPTION_ID = T.EXCEPTION_ID

AND T.LANGUAGE = userenv('LANG')