IGI Standing Charges: Charge Item Price History - draft

Description
Categories: BI Publisher, Financials
Application: Public Sector Financials International
Source: Standing Charges: Charge Item Price History (XML) - Not Supported: Reserved For Future Use
Short Name: IGIRRSCH_XML
DB package: IGI_IGIRRSCH_XMLP_PKG
SELECT 	SC.CHARGE_REFERENCE 		CHRG_REF
,	SUBSTR(ITM.ITEM_CODE,1,15)	ITEM_CODE
,	SUBSTR(ITM.DESCRIPTION,1,30)	ITEM_DESC
,	LN.PRICE				LN_CURPRICE
,	LN.EFFECTIVE_DATE			LN_CURDATE
,	LN.LAST_UPDATE_DATE           	                   LN_UPDATE
,                  LN.PREVIOUS_PRICE 		LN_PREVPRICE
,	LN.PREVIOUS_EFFECTIVE_DATE         	LN_PREVDATE
,	FND_DATE.DATE_TO_DISPLAYDATE(LN.PREVIOUS_EFFECTIVE_DATE) LN_PREVIOUS_EFFECTIVE_DATE
,	FND_DATE.DATE_TO_DISPLAYDATE(LN.EFFECTIVE_DATE) LN_EFFECTIVE_DATE
,	FND_DATE.DATE_TO_DISPLAYDATE(LN.LAST_UPDATE_DATE) LN_LAST_UPDATE_DATE
FROM	IGI_RPI_LINE_AUDIT_DET		LN
,	IGI_RPI_STANDING_CHARGES	SC
,	IGI_RPI_ITEMS			ITM
WHERE	ITM.SET_OF_BOOKS_ID = :P_SET_OF_BOOKS_ID
AND	SC.CHARGE_REFERENCE  BETWEEN  
	NVL(:P_FROM_SC_REF,SC.CHARGE_REFERENCE) 
AND   	NVL(:P_TO_SC_REF,SC.CHARGE_REFERENCE) 
AND	ITM.ITEM_ID = LN.ITEM_ID
AND	SC.STANDING_CHARGE_ID = LN.STANDING_CHARGE_ID
ORDER BY  SC.CHARGE_REFERENCE, ITM.ITEM_CODE, 
	LN.LAST_UPDATE_DATE DESC
Parameter Name SQL text Validation
Ledger Id
 
LOV Oracle
To Standing charge reference
 
LOV Oracle
From Standing Charge reference
 
LOV Oracle