INV Transaction source type summary

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Transaction source type summary (XML)
Short Name: INVTRSTS_XML
DB package: INV_INVTRSTS_XMLP_PKG
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
Parameter NameSQL textValidation
Category Structure
 
Number
Dynamic Precision Option
 
LOV Oracle
Organization
 
Number
Source Type for Column Three
 
LOV Oracle
Source Type for Column Two
 
LOV Oracle
Source Type for Column One
 
LOV Oracle
To
 
LOV Oracle
Subinventories From
 
LOV Oracle
To
 
Items From
 
To
 
Categories From
 
Category Set
 
LOV Oracle
To
 
Date
Transaction Dates From
 
Date
Selection Option
 
LOV Oracle
Sort By
 
LOV Oracle