[Home] [Help]
View: AP_TAX_CODES_ACTIVE_V
Product: | AP - Payables |
Description: | (Release 10SC Only) |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TC.NAME VAT_CODE
, LC.DISPLAYED_FIELD TAX_TYPE_DISPLAY
, TC.DESCRIPTION DESCRIPTION
, TC.TAX_TYPE TAX_TYPE
, TC.TAX_RATE TAX_RATE
, VS.OFFSET_TAX_FLAG
, VS.VENDOR_SITE_ID VENDOR_SITE_ID
, TC.TAX_ID
, TC.START_DATE
, TC.INACTIVE_DATE
FROM AP_TAX_CODES TC
, AP_LOOKUP_CODES LC
, AP_SYSTEM_PARAMETERS SP
, PO_VENDOR_SITES VS
WHERE NVL(TC.ENABLED_FLAG
, 'Y') = 'Y'
AND TC.TAX_TYPE = LC.LOOKUP_CODE
AND LC.LOOKUP_TYPE = 'TAX TYPE'
AND TC.TAX_TYPE NOT IN ('OFFSET'
, 'AWT')
AND TC.SET_OF_BOOKS_ID = SP.SET_OF_BOOKS_ID
AND (NVL(SP.REQUIRE_TAX_ENTRY_FLAG
, 'N') = 'N' OR (SP.REQUIRE_TAX_ENTRY_FLAG = 'Y'
AND TC.TAX_TYPE != 'USE'))
Columns
Name |
VAT_CODE |
TAX_TYPE_DISPLAY |
DESCRIPTION |
TAX_TYPE |
TAX_RATE |
OFFSET_TAX_FLAG |
VENDOR_SITE_ID |
TAX_ID |
START_DATE |
INACTIVE_DATE |