INV Item definition summary

SELECT
decode(:P_sort_id,1,'X',2,&P_CATG_FLEXDATA,
                                               &P_CATG_FLEXDATA)
                                              BREAK_OPTION,
   &P_ITEM_FLEXDATA            ITEM_FLEXDATA,
   MSI.PRIMARY_UOM_CODE  UOM,
   INV_MEANING_SEL.C_ITEM_DESCRIPTION(msi.inventory_item_id,msi.organization_id) ITEM_DESC,
   MSI.INVENTORY_ITEM_STATUS_CODE
 		               STATUS,
   FCL.meaning                    TYPE,
   nvl(round(CST.ITEM_COST * :P_EXCHANGE_RATE, :ext_precision_saved), 0)	ITEM_COST,
   MSI.INVENTORY_ITEM_ID     ITEM_ID,
   MSI.ITEM_CATALOG_GROUP_ID  CAT_GROUP_ID,
--fnd_flex_xml_publisher_apis.process_kff_combination_1('c_break_option_pad', 'INV', 'MCAT', MCAT.STRUCTURE_ID, NULL, MCAT.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') C_break_option_pad,
--fnd_flex_xml_publisher_apis.process_kff_combination_1('c_break_option_value', 'INV', 'MCAT', MCAT.STRUCTURE_ID, NULL, MCAT.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_break_option_value,
&C_break_option_pad_av C_break_option_pad1,
&C_break_option_value_av C_break_option_value1,
fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_ITEM_VALUE,
	INV_INVIRITS_XMLP_PKG.c_icg_descformula(MSI.INVENTORY_ITEM_ID) C_ICG_DESC
FROM
   CST_ITEM_COSTS_FOR_GL_VIEW	CST,
   MTL_SYSTEM_ITEMS          		MSI,
   fnd_common_lookups 		FCL
   &C_from
 &C_catg_from
  &C_ICG_FROM
WHERE  msi.organization_id = :P_org
and 	cst.organization_id (+) = :P_org
and	cst.inventory_item_id (+) = msi.inventory_item_id
and	msi.item_type = fcl.lookup_code(+)
and	fcl.lookup_type(+) = 'ITEM_TYPE'
and        &P_CATG_WHERE
and        &P_ITEM_WHERE
and        &P_ICG_WHERE
&C_where
&C_catg_where
&C_icg_where
order by &P_item_order