eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: POR_TAX_CODE_LOV_V

Product:	ICX - Oracle iProcurement
Description:	View to get tax codes
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TAX_ID
, NAME
, TAX_RATE
, DESCRIPTION
FROM AP_TAX_CODES
WHERE SYSDATE BETWEEN CREATION_DATE
AND NVL(INACTIVE_DATE
, SYSDATE)
AND ENABLED_FLAG='Y' ORDER BY NAME

Columns

Name
TAX_CODE_ID
TAX_CODE
TAX_RATE
TAX_DESCRIPTION