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.

VIEW: APPS.MSD_SR_PRD_IT_V

Source

View Text - Preformatted


SELECT 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_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 */
   NOT EXISTS (SELECT 1
               FROM msd_setup_parameters
               WHERE  parameter_name = 'MSD_ITEM_ORG'
                  AND parameter_value = 'MSD_MASTER_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 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 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
   EXISTS (SELECT 1
           FROM msd_setup_parameters
           WHERE  parameter_name = 'MSD_ITEM_ORG'
              AND parameter_value = 'MSD_MASTER_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, 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 = morg.parameter_value */
   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

View Text - HTML Formatted

SELECT 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_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 */ NOT EXISTS (SELECT 1
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_ITEM_ORG'
AND PARAMETER_VALUE = 'MSD_MASTER_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 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 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 EXISTS (SELECT 1
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_ITEM_ORG'
AND PARAMETER_VALUE = 'MSD_MASTER_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
, 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 = MORG.PARAMETER_VALUE */
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