VIEW: APPS.OKE_TAX_CODES_V

Source

View Text - Preformatted

SELECT zxv.ORG_ID ORG_ID, decode(zxv.lookup_type,'ZX_OUTPUT_CLASSIFICATIONS','S','B') BUY_OR_SELL, NULL ID, zxv.lookup_Code TAX_CODE, zxv.description DESCRIPTION, zxv.start_date_active START_DATE, zxv.END_DATE_active end_date, zxv.enabled_flag ENABLED_FLAG from ZX_TAX_CLASSIFICATIONS_V ZXV UNION SELECT APT.ORG_ID ORG_ID, 'B' BUY_OR_SELL, NULL ID, APT.name TAX_CODE, APT.description DESCRIPTION, APT.start_date START_DATE, APT.inactive_date END_DATE, APT.enabled_flag ENABLED_FLAG from AP_TAX_CODES_ALL APT where APT.tax_type = 'AWT'

View Text - HTML Formatted

SELECT ZXV.ORG_ID ORG_ID
, DECODE(ZXV.LOOKUP_TYPE
, 'ZX_OUTPUT_CLASSIFICATIONS'
, 'S'
, 'B') BUY_OR_SELL
, NULL ID
, ZXV.LOOKUP_CODE TAX_CODE
, ZXV.DESCRIPTION DESCRIPTION
, ZXV.START_DATE_ACTIVE START_DATE
, ZXV.END_DATE_ACTIVE END_DATE
, ZXV.ENABLED_FLAG ENABLED_FLAG
FROM ZX_TAX_CLASSIFICATIONS_V ZXV UNION SELECT APT.ORG_ID ORG_ID
, 'B' BUY_OR_SELL
, NULL ID
, APT.NAME TAX_CODE
, APT.DESCRIPTION DESCRIPTION
, APT.START_DATE START_DATE
, APT.INACTIVE_DATE END_DATE
, APT.ENABLED_FLAG ENABLED_FLAG
FROM AP_TAX_CODES_ALL APT
WHERE APT.TAX_TYPE = 'AWT'