VIEW: APPS.AP_SRS_REGION_NAMES_V

Source

View Text - Preformatted

SELECT AITR.region_short_name, AITR.region_short_name, AITR.region_long_name FROM AP_INCOME_TAX_REGIONS AITR UNION SELECT ALC.displayed_field, ALC.lookup_code, ALC.description FROM ap_lookup_codes ALC WHERE ALC.lookup_type = 'TAX UTILITY REGIONS' AND ALC.lookup_code = 'NO CHANGE' UNION SELECT ALC.displayed_field, ALC.lookup_code, ALC.description FROM ap_lookup_codes ALC WHERE ALC.lookup_type = 'TAX UTILITY REGIONS' AND ALC.lookup_code = 'VENDOR SITE' UNION SELECT ALC.displayed_field, ALC.lookup_code, ALC.description FROM ap_lookup_codes ALC WHERE ALC.lookup_type = 'TAX UTILITY REGIONS' AND ALC.lookup_code = 'INCOME TAX REPORTING SITE' UNION SELECT ALC.displayed_field, ALC.lookup_code, ALC.description FROM ap_lookup_codes ALC WHERE ALC.lookup_type = 'TAX UTILITY REGIONS' AND ALC.lookup_code = 'NO CHANGE' UNION SELECT ALC.displayed_field, ALC.lookup_code, ALC.description FROM ap_lookup_codes ALC WHERE ALC.lookup_type = 'TAX UTILITY REGIONS' AND ALC.lookup_code = 'VENDOR SITE' UNION SELECT ALC.displayed_field, ALC.lookup_code, ALC.description FROM ap_lookup_codes ALC WHERE ALC.lookup_type = 'TAX UTILITY REGIONS' AND ALC.lookup_code = 'INCOME TAX REPORTING SITE'

View Text - HTML Formatted

SELECT AITR.REGION_SHORT_NAME
, AITR.REGION_SHORT_NAME
, AITR.REGION_LONG_NAME
FROM AP_INCOME_TAX_REGIONS AITR UNION SELECT ALC.DISPLAYED_FIELD
, ALC.LOOKUP_CODE
, ALC.DESCRIPTION
FROM AP_LOOKUP_CODES ALC
WHERE ALC.LOOKUP_TYPE = 'TAX UTILITY REGIONS'
AND ALC.LOOKUP_CODE = 'NO CHANGE' UNION SELECT ALC.DISPLAYED_FIELD
, ALC.LOOKUP_CODE
, ALC.DESCRIPTION
FROM AP_LOOKUP_CODES ALC
WHERE ALC.LOOKUP_TYPE = 'TAX UTILITY REGIONS'
AND ALC.LOOKUP_CODE = 'VENDOR SITE' UNION SELECT ALC.DISPLAYED_FIELD
, ALC.LOOKUP_CODE
, ALC.DESCRIPTION
FROM AP_LOOKUP_CODES ALC
WHERE ALC.LOOKUP_TYPE = 'TAX UTILITY REGIONS'
AND ALC.LOOKUP_CODE = 'INCOME TAX REPORTING SITE' UNION SELECT ALC.DISPLAYED_FIELD
, ALC.LOOKUP_CODE
, ALC.DESCRIPTION
FROM AP_LOOKUP_CODES ALC
WHERE ALC.LOOKUP_TYPE = 'TAX UTILITY REGIONS'
AND ALC.LOOKUP_CODE = 'NO CHANGE' UNION SELECT ALC.DISPLAYED_FIELD
, ALC.LOOKUP_CODE
, ALC.DESCRIPTION
FROM AP_LOOKUP_CODES ALC
WHERE ALC.LOOKUP_TYPE = 'TAX UTILITY REGIONS'
AND ALC.LOOKUP_CODE = 'VENDOR SITE' UNION SELECT ALC.DISPLAYED_FIELD
, ALC.LOOKUP_CODE
, ALC.DESCRIPTION
FROM AP_LOOKUP_CODES ALC
WHERE ALC.LOOKUP_TYPE = 'TAX UTILITY REGIONS'
AND ALC.LOOKUP_CODE = 'INCOME TAX REPORTING SITE'