INV Shortages Summary

Description
Categories: BI Publisher
Application: Inventory
Source: Shortages Summary report (XML)
Short Name: INVTRSHS_XML
DB package: INV_INVTRSHS_XMLP_PKG
SELECT
	 DECODE(:P_GROUP_BY, 1, &P_CAT_FLEX, 3, MSSV.item_planner_code, 'X') C_GROUP_FLEX
	,MSSV.object_type
	,MSSV.object_type_meaning
	,DECODE(:P_GROUP_BY, 2, 'X', &P_ITEM_FLEX) C_ITEM_FLEX
	,DECODE(:P_GROUP_BY, 2, 'X', MSSV.item_description) C_ITEM_DESCRIPTION_POS
	,DECODE(:P_GROUP_BY, 2, MSSV.item_description, 'X') C_ITEM_DESCRIPTION_HDR
	,DECODE(:P_GROUP_BY, 1, MSSV.item_planner_code, 'X')</