VIEW: APPS.PAY_US_PSD_TAX_COLL_DSTS_V

Source

View Text - Preformatted

SELECT DISTINCT (substr (sdtif.sch_information_category, 1, 2)), sdtif.sch_information2 FROM pay_us_school_dsts_tax_info_f sdtif, pay_us_city_names ctn, pay_us_school_dsts sd, pay_us_counties cn WHERE ctn.state_code = substr (sdtif.jurisdiction_code, 1, 2) AND ctn.county_code = substr (sdtif.jurisdiction_code, 4, 3) AND ctn.city_code = substr (sdtif.jurisdiction_code, 8, 4) AND sd.state_code = substr (sdtif.jurisdiction_code, 1, 2) AND sd.county_code = substr (sdtif.jurisdiction_code, 4, 3) AND sd.city_code = substr (sdtif.jurisdiction_code, 8, 4) AND sd.school_dst_code = sdtif.school_dsts_code AND ctn.county_code = cn.county_code AND cn.state_code = substr (sdtif.jurisdiction_code, 1, 2) AND sdtif.sch_information1 = 'PSDCODES' AND ctn.state_code = '39' ORDER BY 1,2

View Text - HTML Formatted

SELECT DISTINCT (SUBSTR (SDTIF.SCH_INFORMATION_CATEGORY
, 1
, 2))
, SDTIF.SCH_INFORMATION2
FROM PAY_US_SCHOOL_DSTS_TAX_INFO_F SDTIF
, PAY_US_CITY_NAMES CTN
, PAY_US_SCHOOL_DSTS SD
, PAY_US_COUNTIES CN
WHERE CTN.STATE_CODE = SUBSTR (SDTIF.JURISDICTION_CODE
, 1
, 2)
AND CTN.COUNTY_CODE = SUBSTR (SDTIF.JURISDICTION_CODE
, 4
, 3)
AND CTN.CITY_CODE = SUBSTR (SDTIF.JURISDICTION_CODE
, 8
, 4)
AND SD.STATE_CODE = SUBSTR (SDTIF.JURISDICTION_CODE
, 1
, 2)
AND SD.COUNTY_CODE = SUBSTR (SDTIF.JURISDICTION_CODE
, 4
, 3)
AND SD.CITY_CODE = SUBSTR (SDTIF.JURISDICTION_CODE
, 8
, 4)
AND SD.SCHOOL_DST_CODE = SDTIF.SCHOOL_DSTS_CODE
AND CTN.COUNTY_CODE = CN.COUNTY_CODE
AND CN.STATE_CODE = SUBSTR (SDTIF.JURISDICTION_CODE
, 1
, 2)
AND SDTIF.SCH_INFORMATION1 = 'PSDCODES'
AND CTN.STATE_CODE = '39' ORDER BY 1
, 2