View: AP_TAX_CODES_ACTIVE_V

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