VIEW: APPS.OKX_TAX_CODES_V

Source

View Text - Preformatted

SELECT B.VAT_TAX_ID ID1, '#' ID2, B.TAX_CODE NAME, B.TAX_RATE TAX_RATE, B.TAX_TYPE TAX_TYPE, B.START_DATE START_DATE_ACTIVE, B.END_DATE END_DATE_ACTIVE, B.DESCRIPTION DESCRIPTION, B.ORG_ID ORG_ID, B.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, T.PRINTED_TAX_NAME PRINTED_TAX_NAME, B.VALIDATE_FLAG VALIDATE_FLAG, B.ENABLED_FLAG B_STATUS, decode(b.enabled_flag,'Y','A','I') STATUS, B.AMOUNT_INCLUDES_TAX_FLAG AMOUNT_INCLUDES_TAX_FLAG, B.AMOUNT_INCLUDES_TAX_OVERRIDE AMOUNT_INCLUDES_TAX_OVERRIDE FROM AR_VAT_TAX_ALL_B B,AR_VAT_TAX_ALL_TL T WHERE B.VAT_TAX_ID = T.VAT_TAX_ID AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.VAT_TAX_ID ID1
, '#' ID2
, B.TAX_CODE NAME
, B.TAX_RATE TAX_RATE
, B.TAX_TYPE TAX_TYPE
, B.START_DATE START_DATE_ACTIVE
, B.END_DATE END_DATE_ACTIVE
, B.DESCRIPTION DESCRIPTION
, B.ORG_ID ORG_ID
, B.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, T.PRINTED_TAX_NAME PRINTED_TAX_NAME
, B.VALIDATE_FLAG VALIDATE_FLAG
, B.ENABLED_FLAG B_STATUS
, DECODE(B.ENABLED_FLAG
, 'Y'
, 'A'
, 'I') STATUS
, B.AMOUNT_INCLUDES_TAX_FLAG AMOUNT_INCLUDES_TAX_FLAG
, B.AMOUNT_INCLUDES_TAX_OVERRIDE AMOUNT_INCLUDES_TAX_OVERRIDE
FROM AR_VAT_TAX_ALL_B B
, AR_VAT_TAX_ALL_TL T
WHERE B.VAT_TAX_ID = T.VAT_TAX_ID
AND T.LANGUAGE = USERENV('LANG')