Product: | IGI - Public Sector Financials International |
---|---|
Description: | View for the standing charges line details form based on IGI_RPI_LINE_DETAILS view |
Implementation/DBA Data: | APPS.IGI_RPI_LINE_DETAILS_V |
SELECT JURLD.CHARGE_ITEM_NUMBER
, JURLD.QUANTITY
, JURLD.PERIOD_NAME
, JURLD.DESCRIPTION
, JURLD.PRICE
, JURLD.PREVIOUS_EFFECTIVE_DATE
, JURLD.CURRENT_EFFECTIVE_DATE
, JURLD.REVISED_PRICE
, JURLD.REVISED_EFFECTIVE_DATE
, JURLD.PREVIOUS_PRICE
, JURLD.ADDITIONAL_REFERENCE
, JURLD.ITEM_ID
, JURLD.VAT_TAX_ID
, JURLD.LINE_ITEM_ID
, JURLD.STANDING_CHARGE_ID
, JURLD.ACCOUNTING_RULE_ID
, RR.NAME ACCOUNTING_RULE_NAME
, JURLD.START_DATE
, JURLD.DURATION
, JURLD.REVENUE_CODE_COMBINATION_ID
, JURLD.RECEIVABLE_CODE_COMBINATION_ID
, JURLD.LAST_UPDATE_DATE
, JURLD.CREATION_DATE
, JURLD.LAST_UPDATED_BY
, JURLD.CREATED_BY
, JURLD.LAST_UPDATE_LOGIN
, JURLD.ROWID ROW_ID
FROM IGI_RPI_LINE_DETAILS JURLD
, RA_RULES RR
WHERE JURLD.ACCOUNTING_RULE_ID = RR.RULE_ID(+)