Product: | IGI - Public Sector Financials International |
---|---|
Description: | View for the standing charges item form based on IGI_RPI_ITEMS view |
Implementation/DBA Data: | APPS.IGI_RPI_ITEMS_V |
SELECT JURI.ITEM_ID
, JURI.SET_OF_BOOKS_ID
, JURI.ITEM_CODE
, JURI.PRICE
, JURI.PRICE_EFFECTIVE_DATE
, JURI.UNIT_OF_MEASURE
, JURI.START_EFFECTIVE_DATE
, JURI.CREATION_DATE
, JURI.CREATED_BY
, JURI.LAST_UPDATE_DATE
, JURI.LAST_UPDATED_BY
, JURI.LAST_UPDATE_LOGIN
, JURI.REVISED_PRICE_EFF_DATE
, JURI.REVISED_PRICE
, JURI.DESCRIPTION
, JURI.VAT_TAX_ID
, JURI.REVENUE_CODE_COMBINATION_ID
, JURI.INACTIVE_DATE
, JURI.ENABLED_FLAG "ENABLED_FLAG"
, AVT.TAX_CODE
FROM AR_VAT_TAX AVT
, IGI_RPI_ITEMS JURI
WHERE AVT.VAT_TAX_ID(+) = JURI.VAT_TAX_ID