IGI Standing Charges: Item Price History Report- Not Supported: Reserved For Future Use
Description
- Categories
- BI Publisher
- 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
Imported from BI Publisher
Standing Charges: Item Price History Report
Standing Charges: Item Price History Report
SQL 28 lines
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 |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV | |
| From Item Code | LOV Oracle | |
| To Item Code | LOV Oracle |