[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 |