eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_US_PSD_TAX_BAL_GRE_V

Source

View Text - Preformatted


SELECT PSD.BAL_SET_NAME BALANCE_SET_NAME ,PSD.LEGISLATION_CODE LEGISLATION_CODE ,PSD.BALANCE_NAME BALANCE_NAME ,PSD.TAX_CLASSIFICATION TAX_CLASSIFICATION ,PSD.WAGES_CLASSIFICATION WAGES_CLASSIFICATION ,PSD.DIMENSION DIMENSION ,PSD.REPORTING_NAME REPORTING_NAME ,PSD.STATE_ABBREV STATE_ABBREV ,PSD.STATE_CODE STATE_CODE ,'RS: ' || PSD.RS_TAX_AGENCY||DECODE(NVL(PSD.RS_CITY_NAME,'X'),'X','',', '||PSD.RS_CITY_NAME||', '||PSD.RS_SCH_DST_NAME)||'('||PSD.RS_PSD_CODE||')' ||DECODE(PSD.CTD_RS_TAX_VALUE,0,DECODE(PSD.OTD_RS_TAX_VALUE,0,'','*'),'*')|| CHR(13)||CHR(10) ||'WK: '|| PSD.WK_TAX_AGENCY||DECODE(NVL(PSD.WK_CITY_NAME,'X'),'X','',', '||PSD.WK_CITY_NAME)||'('||PSD.WK_PSD_CODE||')' ||DECODE(PSD.CTD_WK_TAX_VALUE,0,DECODE(PSD.OTD_WK_TAX_VALUE,0,'','*'),'*') PSD_NAME ,PSD.PSD_JD PSD_JD ,PSD.GRE_ID GRE_ID ,(PSD.CTD_RS_TAX_VALUE + PSD.CTD_WK_TAX_VALUE) CTD_TAX_VALUE ,PSD.CTD_WAGE_VALUE CTD_WAGE_VALUE ,(PSD.OTD_RS_TAX_VALUE + PSD.OTD_WK_TAX_VALUE) OTD_TAX_VALUE ,PSD.OTD_WAGE_VALUE OTD_WAGE_VALUE FROM (SELECT DISTINCT BAL.BALANCE_SET_NAME BAL_SET_NAME ,BAL.LEGISLATION_CODE LEGISLATION_CODE ,BAL.ATTRIBUTE_1 BALANCE_NAME ,BAL.ATTRIBUTE_2 TAX_CLASSIFICATION ,BAL.ATTRIBUTE_3 WAGES_CLASSIFICATION ,BAL.ATTRIBUTE_4 DIMENSION ,BAL.ATTRIBUTE_5 REPORTING_NAME ,ST.STATE_ABBREV STATE_ABBREV ,ST.STATE_CODE STATE_CODE ,SDTIF1.SCH_INFORMATION2 RS_TAX_AGENCY ,RS_CITY.CITY_NAME RS_CITY_NAME ,RS_SD.SCHOOL_DST_NAME RS_SCH_DST_NAME ,SDTIF1.SCH_INFORMATION_CATEGORY RS_PSD_CODE ,SDTIF2.SCH_INFORMATION2 WK_TAX_AGENCY ,WK_CITY.CITY_NAME WK_CITY_NAME ,SDTIF2.SCH_INFORMATION_CATEGORY WK_PSD_CODE ,TAX.JURISDICTION_CODE PSD_JD ,TAX.TAX_UNIT_ID GRE_ID ,DECODE (SUBSTR (TAX.JURISDICTION_CODE,4,6) ,'880000',0 ,PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_2 ,'CITY_RS_'|| BAL.ATTRIBUTE_1 ,'EE' ,'PYDATE' ,'GRE' ,TAX.TAX_UNIT_ID ,TAX.JURISDICTION_CODE ,- 1 ,NULL ,NULL ,NULL) + PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_2 ,'SCHOOL_RS_'|| BAL.ATTRIBUTE_1 ,'EE' ,'PYDATE' ,'GRE' ,TAX.TAX_UNIT_ID ,TAX.JURISDICTION_CODE ,- 1 ,NULL ,NULL ,NULL)) CTD_RS_TAX_VALUE ,DECODE (SUBSTR (TAX.JURISDICTION_CODE,11,6) ,'880000',0 ,PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_2 ,'CITY_WK_'|| BAL.ATTRIBUTE_1 ,'EE' ,'PYDATE' ,'GRE' ,TAX.TAX_UNIT_ID ,TAX.JURISDICTION_CODE ,- 1 ,NULL ,NULL ,NULL)) CTD_WK_TAX_VALUE ,PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_3 ,'CITY_'|| BAL.ATTRIBUTE_1 ,'EE' ,'PYDATE' ,'GRE' ,TAX.TAX_UNIT_ID ,TAX.JURISDICTION_CODE ,- 1 ,NULL ,NULL ,NULL) CTD_WAGE_VALUE ,DECODE (BAL.ATTRIBUTE_4 ,NULL,0 ,DECODE (SUBSTR (TAX.JURISDICTION_CODE,4,6) ,'880000',0 ,PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_2 ,'CITY_RS_'|| BAL.ATTRIBUTE_1 ,'EE' ,BAL.ATTRIBUTE_4 ,'GRE' ,TAX.TAX_UNIT_ID ,TAX.JURISDICTION_CODE ,- 1 ,NULL ,NULL ,NULL) + PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_2 ,'SCHOOL_RS_'|| BAL.ATTRIBUTE_1 ,'EE' ,BAL.ATTRIBUTE_4 ,'GRE' ,TAX.TAX_UNIT_ID ,TAX.JURISDICTION_CODE ,- 1 ,NULL ,NULL ,NULL))) OTD_RS_TAX_VALUE ,DECODE(BAL.ATTRIBUTE_4 ,NULL,0 ,DECODE (SUBSTR (TAX.JURISDICTION_CODE,11,6) ,'880000',0 ,PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_2 ,'CITY_WK_'|| BAL.ATTRIBUTE_1 ,'EE' ,BAL.ATTRIBUTE_4 ,'GRE' ,TAX.TAX_UNIT_ID ,TAX.JURISDICTION_CODE ,- 1 ,NULL ,NULL ,NULL))) OTD_WK_TAX_VALUE ,DECODE (BAL.ATTRIBUTE_4 ,NULL,0 ,PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_3 ,'CITY_'|| BAL.ATTRIBUTE_1 ,'EE' ,BAL.ATTRIBUTE_4 ,'GRE' ,TAX.TAX_UNIT_ID ,TAX.JURISDICTION_CODE ,- 1 ,NULL ,NULL ,NULL)) OTD_WAGE_VALUE FROM PAY_US_SCHOOL_DSTS_TAX_INFO_F SDTIF1 ,PAY_US_SCHOOL_DSTS_TAX_INFO_F SDTIF2 ,PAY_US_STATES ST ,PAY_BALANCE_SETS BAL ,PAY_US_TAX_UNIT_PSD_V TAX ,PAY_US_CITY_NAMES WK_CITY ,PAY_US_CITY_NAMES RS_CITY ,PAY_US_SCHOOL_DSTS RS_SD WHERE SUBSTR (TAX.JURISDICTION_CODE,1,2) = ST.STATE_CODE AND BAL.BALANCE_SET_NAME LIKE 'PSD_TRR%' AND SUBSTR (TAX.JURISDICTION_CODE,4,6) = SDTIF1.SCH_INFORMATION_CATEGORY AND SUBSTR (TAX.JURISDICTION_CODE,11,6) = SDTIF2.SCH_INFORMATION_CATEGORY AND SDTIF1.SCH_INFORMATION1 = 'PSDCODES' AND SDTIF2.SCH_INFORMATION1 = 'PSDCODES' AND WK_CITY.PRIMARY_FLAG(+) = 'Y' AND RS_CITY.PRIMARY_FLAG(+) = 'Y' AND RS_CITY.STATE_CODE(+) = SDTIF1.STATE_CODE AND WK_CITY.STATE_CODE(+) = SDTIF2.STATE_CODE AND RS_CITY.CITY_CODE(+) = SUBSTR(SDTIF1.JURISDICTION_CODE,8,4) AND WK_CITY.CITY_CODE(+) = SUBSTR(SDTIF2.JURISDICTION_CODE,8,4) AND RS_SD.SCHOOL_DST_CODE(+) = SDTIF1.SCHOOL_DSTS_CODE AND RS_SD.STATE_CODE(+) = SDTIF1.STATE_CODE AND RS_SD.CITY_CODE(+) = SUBSTR(SDTIF1.JURISDICTION_CODE,8,4) AND RS_CITY.COUNTY_CODE (+) = SUBSTR(SDTIF1.JURISDICTION_CODE,4,3) AND WK_CITY.COUNTY_CODE (+) = SUBSTR(SDTIF2.JURISDICTION_CODE,4,3) AND RS_SD.COUNTY_CODE (+) = SUBSTR(SDTIF1.JURISDICTION_CODE,4,3) ) PSD

View Text - HTML Formatted

SELECT PSD.BAL_SET_NAME BALANCE_SET_NAME
, PSD.LEGISLATION_CODE LEGISLATION_CODE
, PSD.BALANCE_NAME BALANCE_NAME
, PSD.TAX_CLASSIFICATION TAX_CLASSIFICATION
, PSD.WAGES_CLASSIFICATION WAGES_CLASSIFICATION
, PSD.DIMENSION DIMENSION
, PSD.REPORTING_NAME REPORTING_NAME
, PSD.STATE_ABBREV STATE_ABBREV
, PSD.STATE_CODE STATE_CODE
, 'RS: ' || PSD.RS_TAX_AGENCY||DECODE(NVL(PSD.RS_CITY_NAME
, 'X')
, 'X'
, ''
, '
, '||PSD.RS_CITY_NAME||'
, '||PSD.RS_SCH_DST_NAME)||'('||PSD.RS_PSD_CODE||')' ||DECODE(PSD.CTD_RS_TAX_VALUE
, 0
, DECODE(PSD.OTD_RS_TAX_VALUE
, 0
, ''
, '*')
, '*')|| CHR(13)||CHR(10) ||'WK: '|| PSD.WK_TAX_AGENCY||DECODE(NVL(PSD.WK_CITY_NAME
, 'X')
, 'X'
, ''
, '
, '||PSD.WK_CITY_NAME)||'('||PSD.WK_PSD_CODE||')' ||DECODE(PSD.CTD_WK_TAX_VALUE
, 0
, DECODE(PSD.OTD_WK_TAX_VALUE
, 0
, ''
, '*')
, '*') PSD_NAME
, PSD.PSD_JD PSD_JD
, PSD.GRE_ID GRE_ID
, (PSD.CTD_RS_TAX_VALUE + PSD.CTD_WK_TAX_VALUE) CTD_TAX_VALUE
, PSD.CTD_WAGE_VALUE CTD_WAGE_VALUE
, (PSD.OTD_RS_TAX_VALUE + PSD.OTD_WK_TAX_VALUE) OTD_TAX_VALUE
, PSD.OTD_WAGE_VALUE OTD_WAGE_VALUE
FROM (SELECT DISTINCT BAL.BALANCE_SET_NAME BAL_SET_NAME
, BAL.LEGISLATION_CODE LEGISLATION_CODE
, BAL.ATTRIBUTE_1 BALANCE_NAME
, BAL.ATTRIBUTE_2 TAX_CLASSIFICATION
, BAL.ATTRIBUTE_3 WAGES_CLASSIFICATION
, BAL.ATTRIBUTE_4 DIMENSION
, BAL.ATTRIBUTE_5 REPORTING_NAME
, ST.STATE_ABBREV STATE_ABBREV
, ST.STATE_CODE STATE_CODE
, SDTIF1.SCH_INFORMATION2 RS_TAX_AGENCY
, RS_CITY.CITY_NAME RS_CITY_NAME
, RS_SD.SCHOOL_DST_NAME RS_SCH_DST_NAME
, SDTIF1.SCH_INFORMATION_CATEGORY RS_PSD_CODE
, SDTIF2.SCH_INFORMATION2 WK_TAX_AGENCY
, WK_CITY.CITY_NAME WK_CITY_NAME
, SDTIF2.SCH_INFORMATION_CATEGORY WK_PSD_CODE
, TAX.JURISDICTION_CODE PSD_JD
, TAX.TAX_UNIT_ID GRE_ID
, DECODE (SUBSTR (TAX.JURISDICTION_CODE
, 4
, 6)
, '880000'
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_2
, 'CITY_RS_'|| BAL.ATTRIBUTE_1
, 'EE'
, 'PYDATE'
, 'GRE'
, TAX.TAX_UNIT_ID
, TAX.JURISDICTION_CODE
, - 1
, NULL
, NULL
, NULL) + PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_2
, 'SCHOOL_RS_'|| BAL.ATTRIBUTE_1
, 'EE'
, 'PYDATE'
, 'GRE'
, TAX.TAX_UNIT_ID
, TAX.JURISDICTION_CODE
, - 1
, NULL
, NULL
, NULL)) CTD_RS_TAX_VALUE
, DECODE (SUBSTR (TAX.JURISDICTION_CODE
, 11
, 6)
, '880000'
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_2
, 'CITY_WK_'|| BAL.ATTRIBUTE_1
, 'EE'
, 'PYDATE'
, 'GRE'
, TAX.TAX_UNIT_ID
, TAX.JURISDICTION_CODE
, - 1
, NULL
, NULL
, NULL)) CTD_WK_TAX_VALUE
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_3
, 'CITY_'|| BAL.ATTRIBUTE_1
, 'EE'
, 'PYDATE'
, 'GRE'
, TAX.TAX_UNIT_ID
, TAX.JURISDICTION_CODE
, - 1
, NULL
, NULL
, NULL) CTD_WAGE_VALUE
, DECODE (BAL.ATTRIBUTE_4
, NULL
, 0
, DECODE (SUBSTR (TAX.JURISDICTION_CODE
, 4
, 6)
, '880000'
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_2
, 'CITY_RS_'|| BAL.ATTRIBUTE_1
, 'EE'
, BAL.ATTRIBUTE_4
, 'GRE'
, TAX.TAX_UNIT_ID
, TAX.JURISDICTION_CODE
, - 1
, NULL
, NULL
, NULL) + PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_2
, 'SCHOOL_RS_'|| BAL.ATTRIBUTE_1
, 'EE'
, BAL.ATTRIBUTE_4
, 'GRE'
, TAX.TAX_UNIT_ID
, TAX.JURISDICTION_CODE
, - 1
, NULL
, NULL
, NULL))) OTD_RS_TAX_VALUE
, DECODE(BAL.ATTRIBUTE_4
, NULL
, 0
, DECODE (SUBSTR (TAX.JURISDICTION_CODE
, 11
, 6)
, '880000'
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_2
, 'CITY_WK_'|| BAL.ATTRIBUTE_1
, 'EE'
, BAL.ATTRIBUTE_4
, 'GRE'
, TAX.TAX_UNIT_ID
, TAX.JURISDICTION_CODE
, - 1
, NULL
, NULL
, NULL))) OTD_WK_TAX_VALUE
, DECODE (BAL.ATTRIBUTE_4
, NULL
, 0
, PAY_US_TAX_BALS_PKG.US_TAX_BALANCE (BAL.ATTRIBUTE_3
, 'CITY_'|| BAL.ATTRIBUTE_1
, 'EE'
, BAL.ATTRIBUTE_4
, 'GRE'
, TAX.TAX_UNIT_ID
, TAX.JURISDICTION_CODE
, - 1
, NULL
, NULL
, NULL)) OTD_WAGE_VALUE
FROM PAY_US_SCHOOL_DSTS_TAX_INFO_F SDTIF1
, PAY_US_SCHOOL_DSTS_TAX_INFO_F SDTIF2
, PAY_US_STATES ST
, PAY_BALANCE_SETS BAL
, PAY_US_TAX_UNIT_PSD_V TAX
, PAY_US_CITY_NAMES WK_CITY
, PAY_US_CITY_NAMES RS_CITY
, PAY_US_SCHOOL_DSTS RS_SD
WHERE SUBSTR (TAX.JURISDICTION_CODE
, 1
, 2) = ST.STATE_CODE
AND BAL.BALANCE_SET_NAME LIKE 'PSD_TRR%'
AND SUBSTR (TAX.JURISDICTION_CODE
, 4
, 6) = SDTIF1.SCH_INFORMATION_CATEGORY
AND SUBSTR (TAX.JURISDICTION_CODE
, 11
, 6) = SDTIF2.SCH_INFORMATION_CATEGORY
AND SDTIF1.SCH_INFORMATION1 = 'PSDCODES'
AND SDTIF2.SCH_INFORMATION1 = 'PSDCODES'
AND WK_CITY.PRIMARY_FLAG(+) = 'Y'
AND RS_CITY.PRIMARY_FLAG(+) = 'Y'
AND RS_CITY.STATE_CODE(+) = SDTIF1.STATE_CODE
AND WK_CITY.STATE_CODE(+) = SDTIF2.STATE_CODE
AND RS_CITY.CITY_CODE(+) = SUBSTR(SDTIF1.JURISDICTION_CODE
, 8
, 4)
AND WK_CITY.CITY_CODE(+) = SUBSTR(SDTIF2.JURISDICTION_CODE
, 8
, 4)
AND RS_SD.SCHOOL_DST_CODE(+) = SDTIF1.SCHOOL_DSTS_CODE
AND RS_SD.STATE_CODE(+) = SDTIF1.STATE_CODE
AND RS_SD.CITY_CODE(+) = SUBSTR(SDTIF1.JURISDICTION_CODE
, 8
, 4)
AND RS_CITY.COUNTY_CODE (+) = SUBSTR(SDTIF1.JURISDICTION_CODE
, 4
, 3)
AND WK_CITY.COUNTY_CODE (+) = SUBSTR(SDTIF2.JURISDICTION_CODE
, 4
, 3)
AND RS_SD.COUNTY_CODE (+) = SUBSTR(SDTIF1.JURISDICTION_CODE
, 4
, 3) ) PSD