VIEW: AP.AP_INCOME_TAX_REGIONS#

Source

View Text - Preformatted

select REGION_SHORT_NAME REGION_SHORT_NAME, REGION_LONG_NAME REGION_LONG_NAME, REGION_CODE REGION_CODE, REPORTING_LIMIT REPORTING_LIMIT, NUM_OF_PAYEES NUM_OF_PAYEES, CONTROL_TOTAL1 CONTROL_TOTAL1, CONTROL_TOTAL2 CONTROL_TOTAL2, CONTROL_TOTAL3 CONTROL_TOTAL3, CONTROL_TOTAL4 CONTROL_TOTAL4, CONTROL_TOTAL5 CONTROL_TOTAL5, CONTROL_TOTAL6 CONTROL_TOTAL6, CONTROL_TOTAL7 CONTROL_TOTAL7, CONTROL_TOTAL8 CONTROL_TOTAL8, CONTROL_TOTAL9 CONTROL_TOTAL9, CONTROL_TOTAL10 CONTROL_TOTAL10, ACTIVE_DATE ACTIVE_DATE, INACTIVE_DATE INACTIVE_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REPORTING_LIMIT_METHOD_CODE REPORTING_LIMIT_METHOD_CODE, CONTROL_TOTAL13 CONTROL_TOTAL13, CONTROL_TOTAL13E CONTROL_TOTAL13E, CONTROL_TOTAL14 CONTROL_TOTAL14, CONTROL_TOTAL15A CONTROL_TOTAL15A, CONTROL_TOTAL15B CONTROL_TOTAL15B from "AP"."AP_INCOME_TAX_REGIONS"

View Text - HTML Formatted

SELECT REGION_SHORT_NAME REGION_SHORT_NAME
, REGION_LONG_NAME REGION_LONG_NAME
, REGION_CODE REGION_CODE
, REPORTING_LIMIT REPORTING_LIMIT
, NUM_OF_PAYEES NUM_OF_PAYEES
, CONTROL_TOTAL1 CONTROL_TOTAL1
, CONTROL_TOTAL2 CONTROL_TOTAL2
, CONTROL_TOTAL3 CONTROL_TOTAL3
, CONTROL_TOTAL4 CONTROL_TOTAL4
, CONTROL_TOTAL5 CONTROL_TOTAL5
, CONTROL_TOTAL6 CONTROL_TOTAL6
, CONTROL_TOTAL7 CONTROL_TOTAL7
, CONTROL_TOTAL8 CONTROL_TOTAL8
, CONTROL_TOTAL9 CONTROL_TOTAL9
, CONTROL_TOTAL10 CONTROL_TOTAL10
, ACTIVE_DATE ACTIVE_DATE
, INACTIVE_DATE INACTIVE_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REPORTING_LIMIT_METHOD_CODE REPORTING_LIMIT_METHOD_CODE
, CONTROL_TOTAL13 CONTROL_TOTAL13
, CONTROL_TOTAL13E CONTROL_TOTAL13E
, CONTROL_TOTAL14 CONTROL_TOTAL14
, CONTROL_TOTAL15A CONTROL_TOTAL15A
, CONTROL_TOTAL15B CONTROL_TOTAL15B
FROM "AP"."AP_INCOME_TAX_REGIONS"