INV Item definition summary

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Item definition summary (XML)
Short Name: INVIRITS_XML
DB package: INV_INVIRITS_XMLP_PKG
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 NameSQL textValidation
CST_SRS_RATE_TYPE
 
Number
CST_SRS_INVERSE_RATE
 
Category Structure
 
Number
ICG Description Separator
 
Organization
 
Number
Exchange Rate
 
LOV Oracle
Currency
 
LOV Oracle
To
 
Items From
 
To
 
Categories From
 
Category Set Name
 
LOV Oracle
To
 
Item Catalog Groups From
 
Item Description Option
 
LOV Oracle
Sort By
 
LOV Oracle