APC&INV different about items

SELECT * ? FROM (SELECT msib.segment1 item_num,?????????????? fl_col.descriptive_flex_context_code attr_group_name,?????????????? fl_col.end_user_column_name attr_internal_name_apc,?????????????? tl.form_left_prompt attr_name_apc,?????????????? fl_col.application_column_name database_column_apc,?????????????? DECODE (fl_col.application_column_name,?????????????????????? 'C_EXT_ATTR1',emib.c_ext_attr1,?????????????????????? 'C_EXT_ATTR2',emib.c_ext_attr2,?????????????????????? 'C_EXT_ATTR3',emib.c_ext_attr3,?????????????????????? 'C_EXT_ATTR4',emib.c_ext_attr4,?????????????????????? 'C_EXT_ATTR5',emib.c_ext_attr5,?????????????????????? 'C_EXT_ATTR6',emib.c_ext_attr6,?????????????????????? 'C_EXT_ATTR7',emib.c_ext_attr7,?????????????????????? 'C_EXT_ATTR8',emib.c_ext_attr8,?????????????????????? 'C_EXT_ATTR9',emib.c_ext_attr9,?????????????????????? 'C_EXT_ATTR10',emib.c_ext_attr10,?????????????????????? 'C_EXT_ATTR11',emib.c_ext_attr11,?????????????????????? 'C_EXT_ATTR12',emib.c_ext_attr12,?????????????????????? 'C_EXT_ATTR13',emib.c_ext_attr13,?????????????????????? 'C_EXT_ATTR14',emib.c_ext_attr14,?????????????????????? 'C_EXT_ATTR15',emib.c_ext_attr15,?????????????????????? 'C_EXT_ATTR16',emib.c_ext_attr16,?????????????????????? 'C_EXT_ATTR17',emib.c_ext_attr17,?????????????????????? 'C_EXT_ATTR18',emib.c_ext_attr18,?????????????????????? 'C_EXT_ATTR19',emib.c_ext_attr19,?????????????????????? 'C_EXT_ATTR20',emib.c_ext_attr20,?????????????????????? 'C_EXT_ATTR21',emib.c_ext_attr21,?????????????????????? 'C_EXT_ATTR22',emib.c_ext_attr22,?????????????????????? 'C_EXT_ATTR23',emib.c_ext_attr23,?????????????????????? 'C_EXT_ATTR24',emib.c_ext_attr24,?????????????????????? 'C_EXT_ATTR25',emib.c_ext_attr25,?????????????????????? 'C_EXT_ATTR26',emib.c_ext_attr26,?????????????????????? 'C_EXT_ATTR27',emib.c_ext_attr27,?????????????????????? 'C_EXT_ATTR28',emib.c_ext_attr28,?????????????????????? 'C_EXT_ATTR29',emib.c_ext_attr29,?????????????????????? 'C_EXT_ATTR30',emib.c_ext_attr30,?????????????????????? 'C_EXT_ATTR31',emib.c_ext_attr31,?????????????????????? 'C_EXT_ATTR32',emib.c_ext_attr32,?????????????????????? 'C_EXT_ATTR33',emib.c_ext_attr33,?????????????????????? 'C_EXT_ATTR34',emib.c_ext_attr34,?????????????????????? 'C_EXT_ATTR35',emib.c_ext_attr35,?????????????????????? 'C_EXT_ATTR36',emib.c_ext_attr36,?????????????????????? 'C_EXT_ATTR37',emib.c_ext_attr37,?????????????????????? 'C_EXT_ATTR38',emib.c_ext_attr38,?????????????????????? 'C_EXT_ATTR39',emib.c_ext_attr39,?????????????????????? 'C_EXT_ATTR40',emib.c_ext_attr40 ????????????????????? ) attr_name_value_apc,?????????????? (SELECT MAX (mdev.element_value) ????????????????? FROM mtl_descr_element_values mdev ???????????????? WHERE msib.inventory_item_id = ??????????????????????????????????????? mdev.inventory_item_id ?????????????????? AND mdev.element_name = tl.form_left_prompt) ?????????????????????????????????????????????????????????????? attr_value_inv ????????? FROM fnd_descr_flex_column_usages fl_col,?????????????? ego_fnd_dsc_flx_ctx_ext fl_ctx_ext,?????????????? fnd_descr_flex_col_usage_tl tl,?????????????? ego_mtl_sy_items_ext_b emib,?????????????? mtl_system_items_b msib,?????????????? hr_organization_units hou,?????????????? mtl_item_catalog_groups_tl mcg,?????????????? fnd_descr_flex_contexts_tl fdfct ???????? WHERE msib.organization_id = hou.organization_id ?????????? AND hou.NAME = 'Item Master Org - IO' ?????????? AND (msib.item_type = 'EMM' OR msib.item_type = 'OEMOD') ?????????? AND msib.item_catalog_group_id = mcg.item_catalog_group_id ?????????? AND fdfct.application_id = fl_col.application_id ?????????? AND fl_col.application_id = fl_ctx_ext.application_id ?????????? AND fl_col.descriptive_flex_context_code = ????????????????????????????????????? fl_ctx_ext.descriptive_flex_context_code ?????????? AND fl_col.descriptive_flexfield_name = ???????????????????????????????????????? fl_ctx_ext.descriptive_flexfield_name ?????????? AND tl.application_id = fl_col.application_id ?????????? AND tl.descriptive_flexfield_name = ???????????????????????????????????????????? fl_col.descriptive_flexfield_name ?????????? AND tl.descriptive_flex_context_code = ????????????????????????????????????????? fl_col.descriptive_flex_context_code ?????????? AND tl.application_column_name = fl_col.application_column_name ?????????? AND fl_col.enabled_flag = 'Y' ?????????? AND tl.LANGUAGE = USERENV ('LANG') ?????????? AND tl.LANGUAGE = mcg.LANGUAGE ?????????? AND tl.LANGUAGE = fdfct.LANGUAGE ?????????? AND emib.organization_id = hou.organization_id ?????????? AND emib.attr_group_id = fl_ctx_ext.attr_group_id ?????????? AND fdfct.descriptive_flex_context_code = ????????????????????????????????????? fl_ctx_ext.descriptive_flex_context_code ?????????? AND fdfct.descriptive_flex_context_name = mcg.description ?????????? AND fl_ctx_ext.application_id > 0 ?????????? AND emib.inventory_item_id = msib.inventory_item_id ?????????? AND emib.organization_id = msib.organization_id ?????????? AND fl_col.descriptive_flex_context_code <> 'EMR_PIC_ATTRIBS' --??????? AND?? msib.SEGMENT1='EZX2-A20' ?????? ) ?WHERE NVL (attr_name_value_apc,CHR (0)) <> NVL (attr_value_inv,CHR (0))