INV Item definition summary

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Item definition summary
Application: Inventory
Source: Item definition summary (XML)
Short Name: INVIRITS_XML
DB package: INV_INVIRITS_XMLP_PKG
Run INV Item definition summary and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Sort By 
 
 LOV Oracle
Item Description Option 
 
 LOV Oracle
Item Catalog Groups From 
 
 Char
To 
 
 Char
Category Set Name 
 
 LOV Oracle
Categories From 
 
 Char
To 2 
 
 Char
Items From 
 
 Char
To 3 
 
 Char
Currency 
 
 LOV Oracle
Exchange Rate 
 
 LOV Oracle
Download
 
Related Blitz Reports
CAC Item Cost Summary CAC ICP PII WIP Material Usage Variance CAC Open Internal ISO-IRO CAC Material Account Summary CAC Inventory and Intransit Value (Period-End) CAC ICP PII Inventory and Intransit Value (Period-End) CAC New Standard Item Costs CAC Missing Material Accounting Transactions CAC User-Defined and Rolled Up Costs CAC Cost vs. Planning Item Controls
Blitz Report™

Blitz Report™ provides multiple benefits: