DBA Data[Home] [Help]

VIEW: APPS.MSD_SR_PRD_IT_V

Source

View Text - Preformatted

SELECT /*+ LEADING(imo) */ distinct    msiv.inventory_item_id inventory_item_id,     msiv.concatenated_segments,    msiv_tl.description,    decode( msiv.organization_id,             morg.parameter_value, decode(micv.category_set_id, dcs.category_set_id,                    decode(micv.category_id, null, to_char(msd_sr_util.get_null_pk),                           mcv.category_id),                   msd_sr_util.get_null_pk),            msd_sr_util.get_null_pk) category_id,     decode( msiv.organization_id, morg.parameter_value,            decode(micv.category_set_id, dcs.category_set_id,                   decode(micv.category_id, null, msd_sr_util.get_null_desc,                          mcv.CONCATENATED_SEGMENTS),                   msd_sr_util.get_null_desc),            msd_sr_util.get_null_desc),    decode( msiv.organization_id, morg.parameter_value,            decode(micv.category_set_id, dcs.category_set_id,                   decode(micv.category_id, null, msd_sr_util.get_null_desc,                          mcv.CONCATENATED_SEGMENTS),                   msd_sr_util.get_null_desc),            msd_sr_util.get_null_desc),     null,    null,    null,    null,    null,    null               FROM   msd_setup_parameters imo,    msd_app_instance_orgs vorg,    msd_setup_parameters morg,    mtl_item_categories_v micv,    mtl_system_items_kfv msiv,    mtl_system_items_tl msiv_tl,    mtl_categories_b_kfv mcv,    msd_setup_parameters morg2,    msd_setup_parameters msp1,    eni_denorm_hierarchies edh,     mtl_default_category_sets dcs  WHERE   /* Bug# 4157588 */  imo.parameter_name = 'MSD_ITEM_ORG' and   imo.parameter_value = 'MSD_ALL_ORG' and    morg2.parameter_name = 'MSD_PLANNING_PERCENTAGE' and    msp1.parameter_name = 'MSD_TWO_LEVEL_PLANNING' and    dcs.functional_area_id = 11 and    dcs.category_set_id = edh.object_id and    edh.object_type = 'CATEGORY_SET' and    edh.OLTP_flag = 'Y' and    edh.top_node_flag = 'Y' and     edh.child_id = micv.category_id and    dcs.category_set_id = micv.category_set_id and     msiv.inventory_item_id = msiv_tl.inventory_item_id and    msiv.organization_id = msiv_tl.organization_id and    msiv_tl.language = USERENV('LANG') and    decode(nvl(msp1.parameter_value,'2'), '1', decode(nvl(msiv.ato_forecast_control,3),                                                       3, decode(nvl(morg2.parameter_value, '1'),                                                                 '4', decode(msiv.bom_item_type,                                                                             2, 1,                                                                             msd_sr_util.is_product_family_forecastable(morg.parameter_value, msiv.inventory_item_id, 1)                                                                            ),                                                                 msd_sr_util.is_product_family_forecastable(morg.parameter_value, msiv.inventory_item_id, 2)                                                               ),           1),           decode(nvl(msiv.ato_forecast_control,3), 3, decode(nvl(morg2.parameter_value, '1'),                                                              '4', decode(msiv.bom_item_type,                                                                          2, 1,                                                                          MSD_SR_UTIL.IS_ITEM_OPTIONAL_FOR_LVL(msiv.inventory_item_id)                                                                         ),                                                              2),                  1) ) = 1 and    decode( nvl(morg2.parameter_value, '1') , '3', decode( msiv.bom_item_type, 2, 2, 1), 1) = 1 and    msiv.organization_id = vorg.organization_id and    micv.inventory_item_id = msiv.inventory_item_id and    micv.organization_id = msiv.organization_id and    mcv.category_id = edh.parent_id and    ( msiv.mrp_planning_code <> 6 or (msiv.mrp_planning_code = 6 and    msiv.pick_components_flag = 'Y')) and    msiv.bom_item_type <> 5 and    morg.parameter_name = 'MSD_MASTER_ORG' and    ( ( micv.category_set_id = dcs.category_set_id and    msiv.organization_id = morg.parameter_value ) or     not exists (select 1                 from mtl_system_items msiv2,                      mtl_item_categories_v cat1,                      mtl_categories_vl mcv1,                      msd_setup_parameters morg3,                      msd_setup_parameters msp2,                     eni_denorm_hierarchies edh1,                      mtl_default_category_sets dcs1                where morg3.parameter_name = 'MSD_PLANNING_PERCENTAGE' and                      msp2.parameter_name = 'MSD_TWO_LEVEL_PLANNING' and                      dcs1.functional_area_id = 11 and                      dcs1.category_set_id = edh1.object_id and                      edh1.object_type = 'CATEGORY_SET' and                      edh1.OLTP_flag = 'Y' and                      edh1.top_node_flag = 'Y' and                       edh1.child_id = cat1.category_id and                      cat1.category_set_id = dcs1.category_set_id and                      msiv2.inventory_item_id = cat1.inventory_item_id and                      msiv2.organization_id = cat1.organization_id and                      msiv2.inventory_item_id = msiv.inventory_item_id and                      msiv2.organization_id = morg.parameter_value and                      decode(nvl(msp2.parameter_value,'2'), '1', decode(nvl(msiv2.ato_forecast_control,3),                                                                         3, decode(nvl(morg3.parameter_value, '1'),                                                                         '4', decode(msiv2.bom_item_type,                                                                                     2, 1,                                                                                     msd_sr_util.is_product_family_forecastable(morg.parameter_value, msiv2.inventory_item_id, 1)                                                                                    ),                                                                         msd_sr_util.is_product_family_forecastable(morg.parameter_value, msiv.inventory_item_id, 2)                                                                       ),                              1),                              decode(nvl(msiv2.ato_forecast_control,3), 3, decode(nvl(morg3.parameter_value, '1'),                                                                           '4', decode(msiv2.bom_item_type,                                                                                       2, 1,                                                                                       MSD_SR_UTIL.IS_ITEM_OPTIONAL_FOR_LVL(msiv2.inventory_item_id)                                                                                      ),                                                                           2),                              1) ) = 1 and                      decode( nvl(morg3.parameter_value, '1'), '3', decode( msiv2.bom_item_type, 2, 2, 1), 1) = 1 and                      mcv.category_id = edh1.parent_id and                     (msiv2.mrp_planning_code <> 6 or (msiv2.mrp_planning_code = 6 and                      msiv2.pick_components_flag = 'Y')) and                      msiv2.bom_item_type <> 5 ) )  /* Bug# 4157588 */  UNION ALL  SELECT /*+ ORDERED */     msiv.inventory_item_id inventory_item_id,      msiv.concatenated_segments,     msiv_tl.description,     decode(msiv.organization_id,             morg.parameter_value,             decode(micv.category_set_id,                    dcs.category_set_id,                    decode(micv.category_id,                           null,                           to_char(msd_sr_util.get_null_pk),                           mcv.category_id),                   msd_sr_util.get_null_pk),            msd_sr_util.get_null_pk) category_id,      decode(msiv.organization_id,             morg.parameter_value,            decode(micv.category_set_id,                    dcs.category_set_id,                   decode(micv.category_id,                           null,                           msd_sr_util.get_null_desc,                          mcv.CONCATENATED_SEGMENTS),                   msd_sr_util.get_null_desc),            msd_sr_util.get_null_desc),     decode(msiv.organization_id,             morg.parameter_value,            decode(micv.category_set_id,                    dcs.category_set_id,                   decode(micv.category_id,                           null,                           msd_sr_util.get_null_desc,                          mcv.CONCATENATED_SEGMENTS),                   msd_sr_util.get_null_desc),            msd_sr_util.get_null_desc),      null,     null,     null,     null,     null,     null   FROM   msd_setup_parameters imo,  msd_setup_parameters morg,    msd_setup_parameters morg2,    msd_setup_parameters msp1,    mtl_system_items_kfv msiv,   mtl_system_items_tl msiv_tl,   mtl_default_category_sets dcs,  mtl_item_categories_v micv,   eni_denorm_hierarchies edh,  mtl_categories_b_kfv mcv   WHERE   imo.parameter_name = 'MSD_ITEM_ORG' and  imo.parameter_value = 'MSD_MASTER_ORG' and  morg.parameter_name = 'MSD_MASTER_ORG'  AND morg2.parameter_name = 'MSD_PLANNING_PERCENTAGE'  AND msp1.parameter_name = 'MSD_TWO_LEVEL_PLANNING' and  msiv.organization_id = morg.parameter_value and ( msiv.mrp_planning_code <> 6 or (msiv.mrp_planning_code = 6 and msiv.pick_components_flag = 'Y')) and  msiv.bom_item_type <> 5 AND decode(nvl(msp1.parameter_value,'2'),              '1',             decode(nvl(msiv.ato_forecast_control,3),                     3,                    decode(nvl(morg2.parameter_value, '1'),                           '4',                           decode(msiv.bom_item_type,                                  2,                                  1,                                 msd_sr_util.is_pf_forecastable(morg.parameter_value, 									  msiv.inventory_item_id, msiv.product_family_item_id,1)                                                                         ),                                                            msd_sr_util.is_pf_forecastable(morg.parameter_value, 							      msiv.inventory_item_id, msiv.product_family_item_id,2)                                                             ),         1),              decode(nvl(msiv.ato_forecast_control,3),                     3,                     decode(nvl(morg2.parameter_value, '1'),                            '4',                            decode(msiv.bom_item_type,                                   2,                                   1,                                    MSD_SR_UTIL.IS_ITEM_OPTIONAL_FOR_LVL(msiv.inventory_item_id, morg.parameter_value)),                           2),                     1) ) = 1   AND decode(nvl(morg2.parameter_value, '1') ,              '3',              decode(msiv.bom_item_type,                     2,                     2,                    1),              1) = 1 and msiv.organization_id = msiv_tl.organization_id and  msiv.inventory_item_id = msiv_tl.inventory_item_id and  msiv_tl.language = USERENV('LANG') and  dcs.functional_area_id = 11   AND micv.inventory_item_id = msiv.inventory_item_id  AND micv.organization_id = msiv.organization_id  and dcs.category_set_id = micv.category_set_id and   micv.category_set_id = edh.object_id and  edh.object_type = 'CATEGORY_SET' and  edh.OLTP_flag = 'Y' and  edh.top_node_flag = 'Y' and   edh.child_id = micv.category_id and    mcv.category_id = edh.parent_id   
View Text - HTML Formatted

SELECT /*+ LEADING(IMO) */ DISTINCT MSIV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSIV.CONCATENATED_SEGMENTS
, MSIV_TL.DESCRIPTION
, DECODE( MSIV.ORGANIZATION_ID
, MORG.PARAMETER_VALUE
, DECODE(MICV.CATEGORY_SET_ID
, DCS.CATEGORY_SET_ID
, DECODE(MICV.CATEGORY_ID
, NULL
, TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)
, MCV.CATEGORY_ID)
, MSD_SR_UTIL.GET_NULL_PK)
, MSD_SR_UTIL.GET_NULL_PK) CATEGORY_ID
, DECODE( MSIV.ORGANIZATION_ID
, MORG.PARAMETER_VALUE
, DECODE(MICV.CATEGORY_SET_ID
, DCS.CATEGORY_SET_ID
, DECODE(MICV.CATEGORY_ID
, NULL
, MSD_SR_UTIL.GET_NULL_DESC
, MCV.CONCATENATED_SEGMENTS)
, MSD_SR_UTIL.GET_NULL_DESC)
, MSD_SR_UTIL.GET_NULL_DESC)
, DECODE( MSIV.ORGANIZATION_ID
, MORG.PARAMETER_VALUE
, DECODE(MICV.CATEGORY_SET_ID
, DCS.CATEGORY_SET_ID
, DECODE(MICV.CATEGORY_ID
, NULL
, MSD_SR_UTIL.GET_NULL_DESC
, MCV.CONCATENATED_SEGMENTS)
, MSD_SR_UTIL.GET_NULL_DESC)
, MSD_SR_UTIL.GET_NULL_DESC)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MSD_SETUP_PARAMETERS IMO
, MSD_APP_INSTANCE_ORGS VORG
, MSD_SETUP_PARAMETERS MORG
, MTL_ITEM_CATEGORIES_V MICV
, MTL_SYSTEM_ITEMS_KFV MSIV
, MTL_SYSTEM_ITEMS_TL MSIV_TL
, MTL_CATEGORIES_B_KFV MCV
, MSD_SETUP_PARAMETERS MORG2
, MSD_SETUP_PARAMETERS MSP1
, ENI_DENORM_HIERARCHIES EDH
, MTL_DEFAULT_CATEGORY_SETS DCS
WHERE /* BUG# 4157588 */ IMO.PARAMETER_NAME = 'MSD_ITEM_ORG'
AND IMO.PARAMETER_VALUE = 'MSD_ALL_ORG'
AND MORG2.PARAMETER_NAME = 'MSD_PLANNING_PERCENTAGE'
AND MSP1.PARAMETER_NAME = 'MSD_TWO_LEVEL_PLANNING'
AND DCS.FUNCTIONAL_AREA_ID = 11
AND DCS.CATEGORY_SET_ID = EDH.OBJECT_ID
AND EDH.OBJECT_TYPE = 'CATEGORY_SET'
AND EDH.OLTP_FLAG = 'Y'
AND EDH.TOP_NODE_FLAG = 'Y'
AND EDH.CHILD_ID = MICV.CATEGORY_ID
AND DCS.CATEGORY_SET_ID = MICV.CATEGORY_SET_ID
AND MSIV.INVENTORY_ITEM_ID = MSIV_TL.INVENTORY_ITEM_ID
AND MSIV.ORGANIZATION_ID = MSIV_TL.ORGANIZATION_ID
AND MSIV_TL.LANGUAGE = USERENV('LANG')
AND DECODE(NVL(MSP1.PARAMETER_VALUE
, '2')
, '1'
, DECODE(NVL(MSIV.ATO_FORECAST_CONTROL
, 3)
, 3
, DECODE(NVL(MORG2.PARAMETER_VALUE
, '1')
, '4'
, DECODE(MSIV.BOM_ITEM_TYPE
, 2
, 1
, MSD_SR_UTIL.IS_PRODUCT_FAMILY_FORECASTABLE(MORG.PARAMETER_VALUE
, MSIV.INVENTORY_ITEM_ID
, 1) )
, MSD_SR_UTIL.IS_PRODUCT_FAMILY_FORECASTABLE(MORG.PARAMETER_VALUE
, MSIV.INVENTORY_ITEM_ID
, 2) )
, 1)
, DECODE(NVL(MSIV.ATO_FORECAST_CONTROL
, 3)
, 3
, DECODE(NVL(MORG2.PARAMETER_VALUE
, '1')
, '4'
, DECODE(MSIV.BOM_ITEM_TYPE
, 2
, 1
, MSD_SR_UTIL.IS_ITEM_OPTIONAL_FOR_LVL(MSIV.INVENTORY_ITEM_ID) )
, 2)
, 1) ) = 1
AND DECODE( NVL(MORG2.PARAMETER_VALUE
, '1')
, '3'
, DECODE( MSIV.BOM_ITEM_TYPE
, 2
, 2
, 1)
, 1) = 1
AND MSIV.ORGANIZATION_ID = VORG.ORGANIZATION_ID
AND MICV.INVENTORY_ITEM_ID = MSIV.INVENTORY_ITEM_ID
AND MICV.ORGANIZATION_ID = MSIV.ORGANIZATION_ID
AND MCV.CATEGORY_ID = EDH.PARENT_ID
AND ( MSIV.MRP_PLANNING_CODE <> 6 OR (MSIV.MRP_PLANNING_CODE = 6
AND MSIV.PICK_COMPONENTS_FLAG = 'Y'))
AND MSIV.BOM_ITEM_TYPE <> 5
AND MORG.PARAMETER_NAME = 'MSD_MASTER_ORG'
AND ( ( MICV.CATEGORY_SET_ID = DCS.CATEGORY_SET_ID
AND MSIV.ORGANIZATION_ID = MORG.PARAMETER_VALUE ) OR NOT EXISTS (SELECT 1
FROM MTL_SYSTEM_ITEMS MSIV2
, MTL_ITEM_CATEGORIES_V CAT1
, MTL_CATEGORIES_VL MCV1
, MSD_SETUP_PARAMETERS MORG3
, MSD_SETUP_PARAMETERS MSP2
, ENI_DENORM_HIERARCHIES EDH1
, MTL_DEFAULT_CATEGORY_SETS DCS1
WHERE MORG3.PARAMETER_NAME = 'MSD_PLANNING_PERCENTAGE'
AND MSP2.PARAMETER_NAME = 'MSD_TWO_LEVEL_PLANNING'
AND DCS1.FUNCTIONAL_AREA_ID = 11
AND DCS1.CATEGORY_SET_ID = EDH1.OBJECT_ID
AND EDH1.OBJECT_TYPE = 'CATEGORY_SET'
AND EDH1.OLTP_FLAG = 'Y'
AND EDH1.TOP_NODE_FLAG = 'Y'
AND EDH1.CHILD_ID = CAT1.CATEGORY_ID
AND CAT1.CATEGORY_SET_ID = DCS1.CATEGORY_SET_ID
AND MSIV2.INVENTORY_ITEM_ID = CAT1.INVENTORY_ITEM_ID
AND MSIV2.ORGANIZATION_ID = CAT1.ORGANIZATION_ID
AND MSIV2.INVENTORY_ITEM_ID = MSIV.INVENTORY_ITEM_ID
AND MSIV2.ORGANIZATION_ID = MORG.PARAMETER_VALUE
AND DECODE(NVL(MSP2.PARAMETER_VALUE
, '2')
, '1'
, DECODE(NVL(MSIV2.ATO_FORECAST_CONTROL
, 3)
, 3
, DECODE(NVL(MORG3.PARAMETER_VALUE
, '1')
, '4'
, DECODE(MSIV2.BOM_ITEM_TYPE
, 2
, 1
, MSD_SR_UTIL.IS_PRODUCT_FAMILY_FORECASTABLE(MORG.PARAMETER_VALUE
, MSIV2.INVENTORY_ITEM_ID
, 1) )
, MSD_SR_UTIL.IS_PRODUCT_FAMILY_FORECASTABLE(MORG.PARAMETER_VALUE
, MSIV.INVENTORY_ITEM_ID
, 2) )
, 1)
, DECODE(NVL(MSIV2.ATO_FORECAST_CONTROL
, 3)
, 3
, DECODE(NVL(MORG3.PARAMETER_VALUE
, '1')
, '4'
, DECODE(MSIV2.BOM_ITEM_TYPE
, 2
, 1
, MSD_SR_UTIL.IS_ITEM_OPTIONAL_FOR_LVL(MSIV2.INVENTORY_ITEM_ID) )
, 2)
, 1) ) = 1
AND DECODE( NVL(MORG3.PARAMETER_VALUE
, '1')
, '3'
, DECODE( MSIV2.BOM_ITEM_TYPE
, 2
, 2
, 1)
, 1) = 1
AND MCV.CATEGORY_ID = EDH1.PARENT_ID
AND (MSIV2.MRP_PLANNING_CODE <> 6 OR (MSIV2.MRP_PLANNING_CODE = 6
AND MSIV2.PICK_COMPONENTS_FLAG = 'Y'))
AND MSIV2.BOM_ITEM_TYPE <> 5 ) ) /* BUG# 4157588 */ UNION ALL SELECT /*+ ORDERED */ MSIV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSIV.CONCATENATED_SEGMENTS
, MSIV_TL.DESCRIPTION
, DECODE(MSIV.ORGANIZATION_ID
, MORG.PARAMETER_VALUE
, DECODE(MICV.CATEGORY_SET_ID
, DCS.CATEGORY_SET_ID
, DECODE(MICV.CATEGORY_ID
, NULL
, TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)
, MCV.CATEGORY_ID)
, MSD_SR_UTIL.GET_NULL_PK)
, MSD_SR_UTIL.GET_NULL_PK) CATEGORY_ID
, DECODE(MSIV.ORGANIZATION_ID
, MORG.PARAMETER_VALUE
, DECODE(MICV.CATEGORY_SET_ID
, DCS.CATEGORY_SET_ID
, DECODE(MICV.CATEGORY_ID
, NULL
, MSD_SR_UTIL.GET_NULL_DESC
, MCV.CONCATENATED_SEGMENTS)
, MSD_SR_UTIL.GET_NULL_DESC)
, MSD_SR_UTIL.GET_NULL_DESC)
, DECODE(MSIV.ORGANIZATION_ID
, MORG.PARAMETER_VALUE
, DECODE(MICV.CATEGORY_SET_ID
, DCS.CATEGORY_SET_ID
, DECODE(MICV.CATEGORY_ID
, NULL
, MSD_SR_UTIL.GET_NULL_DESC
, MCV.CONCATENATED_SEGMENTS)
, MSD_SR_UTIL.GET_NULL_DESC)
, MSD_SR_UTIL.GET_NULL_DESC)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MSD_SETUP_PARAMETERS IMO
, MSD_SETUP_PARAMETERS MORG
, MSD_SETUP_PARAMETERS MORG2
, MSD_SETUP_PARAMETERS MSP1
, MTL_SYSTEM_ITEMS_KFV MSIV
, MTL_SYSTEM_ITEMS_TL MSIV_TL
, MTL_DEFAULT_CATEGORY_SETS DCS
, MTL_ITEM_CATEGORIES_V MICV
, ENI_DENORM_HIERARCHIES EDH
, MTL_CATEGORIES_B_KFV MCV
WHERE IMO.PARAMETER_NAME = 'MSD_ITEM_ORG'
AND IMO.PARAMETER_VALUE = 'MSD_MASTER_ORG'
AND MORG.PARAMETER_NAME = 'MSD_MASTER_ORG'
AND MORG2.PARAMETER_NAME = 'MSD_PLANNING_PERCENTAGE'
AND MSP1.PARAMETER_NAME = 'MSD_TWO_LEVEL_PLANNING'
AND MSIV.ORGANIZATION_ID = MORG.PARAMETER_VALUE
AND ( MSIV.MRP_PLANNING_CODE <> 6 OR (MSIV.MRP_PLANNING_CODE = 6
AND MSIV.PICK_COMPONENTS_FLAG = 'Y'))
AND MSIV.BOM_ITEM_TYPE <> 5
AND DECODE(NVL(MSP1.PARAMETER_VALUE
, '2')
, '1'
, DECODE(NVL(MSIV.ATO_FORECAST_CONTROL
, 3)
, 3
, DECODE(NVL(MORG2.PARAMETER_VALUE
, '1')
, '4'
, DECODE(MSIV.BOM_ITEM_TYPE
, 2
, 1
, MSD_SR_UTIL.IS_PF_FORECASTABLE(MORG.PARAMETER_VALUE
, MSIV.INVENTORY_ITEM_ID
, MSIV.PRODUCT_FAMILY_ITEM_ID
, 1) )
, MSD_SR_UTIL.IS_PF_FORECASTABLE(MORG.PARAMETER_VALUE
, MSIV.INVENTORY_ITEM_ID
, MSIV.PRODUCT_FAMILY_ITEM_ID
, 2) )
, 1)
, DECODE(NVL(MSIV.ATO_FORECAST_CONTROL
, 3)
, 3
, DECODE(NVL(MORG2.PARAMETER_VALUE
, '1')
, '4'
, DECODE(MSIV.BOM_ITEM_TYPE
, 2
, 1
, MSD_SR_UTIL.IS_ITEM_OPTIONAL_FOR_LVL(MSIV.INVENTORY_ITEM_ID
, MORG.PARAMETER_VALUE))
, 2)
, 1) ) = 1
AND DECODE(NVL(MORG2.PARAMETER_VALUE
, '1')
, '3'
, DECODE(MSIV.BOM_ITEM_TYPE
, 2
, 2
, 1)
, 1) = 1
AND MSIV.ORGANIZATION_ID = MSIV_TL.ORGANIZATION_ID
AND MSIV.INVENTORY_ITEM_ID = MSIV_TL.INVENTORY_ITEM_ID
AND MSIV_TL.LANGUAGE = USERENV('LANG')
AND DCS.FUNCTIONAL_AREA_ID = 11
AND MICV.INVENTORY_ITEM_ID = MSIV.INVENTORY_ITEM_ID
AND MICV.ORGANIZATION_ID = MSIV.ORGANIZATION_ID
AND DCS.CATEGORY_SET_ID = MICV.CATEGORY_SET_ID
AND MICV.CATEGORY_SET_ID = EDH.OBJECT_ID
AND EDH.OBJECT_TYPE = 'CATEGORY_SET'
AND EDH.OLTP_FLAG = 'Y'
AND EDH.TOP_NODE_FLAG = 'Y'
AND EDH.CHILD_ID = MICV.CATEGORY_ID
AND MCV.CATEGORY_ID = EDH.PARENT_ID