INV Transaction source type summary

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Transaction source type summary
Application: Inventory
Source: Transaction source type summary (XML)
Short Name: INVTRSTS_XML
DB package: INV_INVTRSTS_XMLP_PKG
Run INV Transaction source type summary and other Oracle EBS reports with Blitz Report™ on our demo environment
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 Name SQL text Validation
Sort By 
 
 LOV Oracle
Selection Option 
 
 LOV Oracle
Transaction Dates From 
 
 Date
To 
 
 Date
Category Set 
 
 LOV Oracle
Categories From 
 
 Char
To 2 
 
 Char
Items From 
 
 Char
To 3 
 
 Char
Subinventories From 
 
 LOV Oracle
To 4 
 
 LOV Oracle
Source Type for Column One 
 
 LOV Oracle
Source Type for Column Two 
 
 LOV Oracle
Source Type for Column Three 
 
 LOV Oracle
Download
 
Related Blitz Reports
GL Account Analysis CAC Missing Receiving Accounting Transactions CAC Missing Material Accounting Transactions CAC Missing WIP Accounting Transactions CAC Receiving Account Detail CAC User-Defined and Rolled Up Costs CAC Cost vs. Planning Item Controls BOM Item Where Used Report GUI INV Cycle count entries and adjustments CAC Item Cost Summary
Blitz Report™

Blitz Report™ provides multiple benefits: