VIEW: APPS.IGI_RPI_ITEMS_V

Source

View Text - Preformatted

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 , zsv.tax_rate_code, juri.org_id FROM ZX_RATES_B ZSV, IGI_RPI_ITEMS JURI WHERE ZSV.tax_rate_id(+) = juri.vat_tax_id

View Text - HTML Formatted

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
, ZSV.TAX_RATE_CODE
, JURI.ORG_ID
FROM ZX_RATES_B ZSV
, IGI_RPI_ITEMS JURI
WHERE ZSV.TAX_RATE_ID(+) = JURI.VAT_TAX_ID