IGI Standing Charges: Item Price History Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Standing Charges: Item Price History Report
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
Run IGI Standing Charges: Item Price History Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 Name SQL text Validation
Operating Unit 
 
 LOV
From Item Code 
 
 LOV Oracle
To Item Code 
 
 LOV Oracle
Download
Related Blitz Reports
IGI Standing Charges: Charge Item Price History- Not Supported: Reserved For Future Use IGI Standing Charges: Preliminary Invoice Register- Not Supported: Reserved For Future Use IGI Standing Charges: Listing- Not Supported: Reserved For Future Use IGI Standing Charges: Transaction History Report- Not Supported: Reserved For Future Use IGI Standing Charges: Transaction Report- Not Supported: Reserved For Future Use IGI Installment Terms: Installment Audit Report- Not Supported: Reserved For Future Use IGI CIS2007 Subcontractor Statement of Payment and Deductions IGI Unbalanced Budget Journal Report- Not Supported: Reserved For Future Use IGI Internal Trading: Internal Charge Status - draft
Blitz Report™

Blitz Report™ provides multiple benefits: