IGI Standing Charges: Charge Item Price History- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Standing Charges: Charge Item Price History
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
Description: Standing Charges: Charge Item Price History
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
Run
IGI Standing Charges: Charge Item Price History- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 | |
---|---|---|---|
Operating Unit |
|
LOV | |
From Standing Charge reference |
|
LOV Oracle | |
To Standing charge reference |
|
LOV Oracle |