DBA Data[Home] [Help]

VIEW: APPS.PAY_US_ASG_SCHOOLS_V

Source

View Text - Preformatted

SELECT DISTINCT PUR.ASSIGNMENT_ID , PUR.JURISDICTION_CODE , PUR.TAX_UNIT_ID FROM PAY_US_ASG_REPORTING PUR WHERE LENGTH(PUR.JURISDICTION_CODE) = 8
View Text - HTML Formatted

SELECT DISTINCT PUR.ASSIGNMENT_ID
, PUR.JURISDICTION_CODE
, PUR.TAX_UNIT_ID
FROM PAY_US_ASG_REPORTING PUR
WHERE LENGTH(PUR.JURISDICTION_CODE) = 8