[Home] [Help]
View: OKE_TAX_CODES_V
Product: | OKE - Project Contracts |
Description: | Tax code listing |
Implementation/DBA Data: |
APPS.OKE_TAX_CODES_V
|
View Text
SELECT ORG_ID
, 'B'
, TAX_ID
, NAME
, DESCRIPTION
, START_DATE
, TO_DATE(NULL)
, NVL(ENABLED_FLAG
, 'Y')
FROM AP_TAX_CODES_ALL UNION ALL SELECT ORG_ID
, 'S'
, VAT_TAX_ID
, TAX_CODE
, DESCRIPTION
, START_DATE
, END_DATE
, NVL(ENABLED_FLAG
, 'Y')
FROM AR_VAT_TAX_ALL
Columns
Name |
ORG_ID |
BUY_OR_SELL |
ID |
TAX_CODE |
DESCRIPTION |
START_DATE |
END_DATE |
ENABLED_FLAG |