IGI Standing Charges: Item Price History - draft

Description
Categories: BI Publisher, Financials
Application: Public Sector Financials International
Source: Standing Charges: Item Price History Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGIRRCIH_XML
DB package: IGI_IGIRRCIH_XMLP_PKG
SELECT 	SUBSTR(ITM.ITEM_CODE,1,25) 	ITEM_CODE
,	SUBSTR(ITM.DESCRIPTION,1,50)	ITEM_DESC
,	AI.PRICE 				IT_CURPRICE
,	AI.EFFECTIVE_DATE			IT_CURDATE
,	AI.REVISED_PRICE			IT_REVPRICE
,	AI.REVISED_EFFECTIVE_DATE		IT_REVDATE
,	AI.LAST_UPDATE_DATE            	IT_UPDATE
,	SC.CHARGE_REFERENCE		CHRG_REF
,	LN.PRICE				LN_CURPRICE
,	LN.EFFECTIVE_DATE			LN_CURDATE
,	LN.REVISED_PRICE			LN_REVPRICE
,	LN.REVISED_EFFECTIVE_DATE		LN_REVDATE
FROM	IGI_RPI_LINE_AUDIT_DET		LN
,	IGI_RPI_STANDING_CHARGES	SC
,	IGI_RPI_AUDIT_ITEMS		AI
,	IGI_RPI_ITEMS			ITM
WHERE	ITM.SET_OF_BOOKS_ID = :P_SET_OF_BOOKS_ID 
AND	ITM.ITEM_CODE >=
	NVL(:P_FROM_ITEM_CODE,ITM.ITEM_CODE) 
AND 	ITM.ITEM_CODE <= NVL(:P_TO_ITEM_CODE,ITM.ITEM_CODE)
AND	ITM.ITEM_ID = AI.ITEM_ID 
AND	AI.ITEM_ID  = LN.ITEM_ID (+)
AND	AI.RUN_ID = LN.RUN_ID(+)
AND	LN.STANDING_CHARGE_ID = 
			 SC.STANDING_CHARGE_ID(+)
ORDER BY ITM.ITEM_CODE, AI.LAST_UPDATE_DATE DESC,   
	 SC.CHARGE_REFERENCE, LN.LAST_UPDATE_DATE DESC
Parameter NameSQL textValidation
Ledger ID
 
LOV Oracle
To Item Code
 
LOV Oracle
From Item Code
 
LOV Oracle