[Home] [Help]
View: AP_TAX_CODES_NAMES_V
Product: | AP - Payables |
Description: | (Release 10SC Only) |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TC.NAME TAX_NAME
, LC.DISPLAYED_FIELD TYPE
, TC.TAX_TYPE
, TC.DESCRIPTION
, TC.TAX_CODE_COMBINATION_ID
, TC.TAX_ID
, TC.START_DATE
, TC.INACTIVE_DATE FROM AP_TAX_CODES TC
, AP_LOOKUP_CODES LC
, AP_SYSTEM_PARAMETERS SP
WHERE NVL(TC.ENABLED_FLAG
, 'Y') = 'Y'
AND TC.TAX_TYPE = LC.LOOKUP_CODE
AND TC.SET_OF_BOOKS_ID = SP.SET_OF_BOOKS_ID
AND LC.LOOKUP_TYPE = 'TAX TYPE'
Columns
Name |
TAX_NAME |
TYPE |
TAX_TYPE |
DESCRIPTION |
TAX_CODE_COMBINATION_ID |
TAX_ID |
START_DATE |
INACTIVE_DATE |