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