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