View: AP_SRS_REGION_NAMES_V

Product:	AP - Payables
Description:	This view provides a list of available tax regions for the 1099 Payments report.
Implementation/DBA Data:	APPS.AP_SRS_REGION_NAMES_V

View Text

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'

Columns