INV Transaction source type summary

select decode(:P_sort_id,1,nvl(SUBINV,' '),'X') Subinventory,
       decode(:P_sort_id,3,&P_cat_flex,'X') C_cat_flex,
       &P_item_flex                     C_item_flex,
       msi.description                  Description,
       msi.primary_uom_code             UOM, decode(:P_selection,3,round(sum(SOURCE_TYPE1),:C_std_prec),
	sum(SOURCE_TYPE1) )
			        SOURCE_TYPE1,
decode(:P_selection,3,round(sum(SOURCE_TYPE2),:C_std_prec),
	sum(SOURCE_TYPE2) )
			        SOURCE_TYPE2,
decode(:P_selection,3,round(sum(SOURCE_TYPE3),:C_std_prec),
	sum(SOURCE_TYPE3) )
			        SOURCE_TYPE3,
decode(:P_selection,3,round(sum(OTHER),:C_std_prec),
	sum(OTHER) )
			        OTHER,
	decode(:P_SORT_ID,3,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_pad', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE'),'X') C_cat_pad,
	decode(:P_SORT_ID,3,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_field', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE'),'X') C_cat_field,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_field,
	INV_INVTRSTS_XMLP_PKG.c_item_totalformula(decode ( :P_selection , 3 , round ( sum ( SOURCE_TYPE1 ) , :C_std_prec ) , sum ( SOURCE_TYPE1 ) ), decode ( :P_selection , 3 , round ( sum ( SOURCE_TYPE2 ) , :C_std_prec ) , sum ( SOURCE_TYPE2 ) ), decode ( :P_selection , 3 , round ( sum ( SOURCE_TYPE3 ) , :C_std_prec ) , sum ( SOURCE_TYPE3 ) ), decode ( :P_selection , 3 , round ( sum ( OTHER ) , :C_std_prec ) , sum ( OTHER ) )) C_item_total
from &P_view v,
     mtl_system_items_vl  msi
     &C_from_cat
where ITEM_ID = msi.inventory_item_id
and   &P_where_cat &C_where_cat
and   msi.organization_id = :P_org_id
and   &P_where_item
&C_where_subinv
&C_status_where
group by decode(:P_sort_id,1,nvl(SUBINV,' '),'X'),
         decode(:P_sort_id,3,&P_cat_flex,'X') ,
         &P_order_item,
         &P_item_flex, msi.description,
         msi.primary_uom_code,decode(:P_SORT_ID,3,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_pad', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE'),'X'),decode(:P_SORT_ID,3,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_field', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE'),'X'),fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')
		 order by 1