VIEW: APPS.PA_OUTPUT_TAX_CODE_SETUP_ALL_V

Source

View Text - Preformatted

SELECT DISTINCT L.TAX_CODE , L.PRINTED_TAX_NAME , L.TAX_RATE FROM AR_VAT_TAX_ALL_VL L WHERE SYSDATE BETWEEN L.START_DATE AND NVL(L.END_DATE,SYSDATE) AND nvl(L.ENABLED_FLAG,'Y') = 'Y' AND nvl(L.TAX_CLASS,'O') = 'O' AND nvl(L.DISPLAYED_FLAG,'Y') = 'Y'

View Text - HTML Formatted

SELECT DISTINCT L.TAX_CODE
, L.PRINTED_TAX_NAME
, L.TAX_RATE
FROM AR_VAT_TAX_ALL_VL L
WHERE SYSDATE BETWEEN L.START_DATE
AND NVL(L.END_DATE
, SYSDATE)
AND NVL(L.ENABLED_FLAG
, 'Y') = 'Y'
AND NVL(L.TAX_CLASS
, 'O') = 'O'
AND NVL(L.DISPLAYED_FLAG
, 'Y') = 'Y'