FND Design Data [Home] [Help]

View: OKX_TAX_CODES_V

Product: OKX - Contracts Integration
Description: Tax codes
Implementation/DBA Data: ViewAPPS.OKX_TAX_CODES_V
View Text

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')

Columns

Name
ID1
ID2
NAME
TAX_RATE
TAX_TYPE
START_DATE_ACTIVE
END_DATE_ACTIVE
DESCRIPTION
ORG_ID
SET_OF_BOOKS_ID
PRINTED_TAX_NAME
VALIDATE_FLAG
B_STATUS
STATUS
AMOUNT_INCLUDES_TAX_FLAG
AMOUNT_INCLUDES_TAX_OVERRIDE