VIEW: APPS.PAY_US_TAX_UNIT_STATES_V

Source

View Text - Preformatted

SELECT DISTINCT SUBSTR(JURISDICTION_CODE,1,2)||'-000-0000' STATE_CODE , TAX_UNIT_ID FROM PAY_US_ASG_REPORTING

View Text - HTML Formatted

SELECT DISTINCT SUBSTR(JURISDICTION_CODE
, 1
, 2)||'-000-0000' STATE_CODE
, TAX_UNIT_ID
FROM PAY_US_ASG_REPORTING