[Home] [Help]
VIEW: APPS.PAY_US_TAX_UNIT_COUNTIES_V
Source
View Text - Preformatted
SELECT DISTINCT SUBSTR(JURISDICTION_CODE,1,6)||'-0000' JURISDICTION_CODE , TAX_UNIT_ID FROM PAY_US_ASG_REPORTING WHERE LENGTH(JURISDICTION_CODE) = 11
View Text - HTML Formatted
SELECT DISTINCT SUBSTR(JURISDICTION_CODE
, 1
, 6)||'-0000' JURISDICTION_CODE
, TAX_UNIT_ID
FROM PAY_US_ASG_REPORTING
WHERE LENGTH(JURISDICTION_CODE) = 11