VIEW: APPS.HR_TAX_UNITS_V

Source

View Text - Preformatted

SELECT O.ORGANIZATION_ID , O.BUSINESS_GROUP_ID + 0 , OTL.NAME , O.DATE_FROM , O.DATE_TO , O.TYPE , O.INTERNAL_ADDRESS_LINE , O.COMMENTS , O.LOCATION_ID , O2.ORG_INFORMATION1 , O4.ORG_INFORMATION1 , O5.ORG_INFORMATION1 , O4.ORG_INFORMATION2 , O4.ORG_INFORMATION3 , O5.ORG_INFORMATION2 , O4.ORG_INFORMATION4 , O4.ORG_INFORMATION5 , O6.ORG_INFORMATION1 , O7.ORG_INFORMATION1 , O8.ORG_INFORMATION1 , O8.ORG_INFORMATION2 , O8.ORG_INFORMATION3 , O8.ORG_INFORMATION4 , L.ADDRESS_LINE_1 , L.ADDRESS_LINE_2 , L.ADDRESS_LINE_3 , L.TOWN_OR_CITY , DECODE(L.STYLE, 'US', L.REGION_2, 'CA', L.REGION_1, '  ') , L.POSTAL_CODE , L.COUNTRY , O9.ORG_INFORMATION1 , O9.ORG_INFORMATION2 , O9.ORG_INFORMATION3 , O9.ORG_INFORMATION4 , O9.ORG_INFORMATION5 , O9.ORG_INFORMATION6 , O9.ORG_INFORMATION7 , O10.ORG_INFORMATION1 , O10.ORG_INFORMATION2 , O2.ORG_INFORMATION3 FROM HR_ALL_ORGANIZATION_UNITS O, HR_ALL_ORGANIZATION_UNITS_TL OTL, HR_ORGANIZATION_INFORMATION O2, HR_ORGANIZATION_INFORMATION O4, HR_ORGANIZATION_INFORMATION O5, HR_ORGANIZATION_INFORMATION O6, HR_ORGANIZATION_INFORMATION O7, HR_ORGANIZATION_INFORMATION O8, HR_ORGANIZATION_INFORMATION O9, HR_ORGANIZATION_INFORMATION O10, HR_ORGANIZATION_INFORMATION O3, HR_LOCATIONS L WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = O4.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = O5.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = O6.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = O7.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = O8.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = O9.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = O10.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID AND O2.ORG_INFORMATION_CONTEXT (+) || '' = 'Employer Identification' AND O4.ORG_INFORMATION_CONTEXT (+) || '' = 'EEO-1 Filing' AND O5.ORG_INFORMATION_CONTEXT (+) || '' = 'VETS-100 Filing' AND O6.ORG_INFORMATION_CONTEXT (+) || '' = 'W2 Reporting Rules' AND O7.ORG_INFORMATION_CONTEXT (+) || '' = 'SQWL GN Transmitter Rules' AND O8.ORG_INFORMATION_CONTEXT (+) || '' = '1099R Magnetic Report Rules' AND O9.ORG_INFORMATION_CONTEXT (+) || '' = 'Multiple Worksite Reporting' AND O10.ORG_INFORMATION_CONTEXT (+) || '' = 'State_Tax_Rules' AND O3.ORG_INFORMATION_CONTEXT || '' = 'CLASS' AND O3.ORG_INFORMATION1 = 'HR_LEGAL' AND O3.ORG_INFORMATION2 = 'Y' AND L.LOCATION_ID (+) = O.LOCATION_ID AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID AND OTL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT O.ORGANIZATION_ID
, O.BUSINESS_GROUP_ID + 0
, OTL.NAME
, O.DATE_FROM
, O.DATE_TO
, O.TYPE
, O.INTERNAL_ADDRESS_LINE
, O.COMMENTS
, O.LOCATION_ID
, O2.ORG_INFORMATION1
, O4.ORG_INFORMATION1
, O5.ORG_INFORMATION1
, O4.ORG_INFORMATION2
, O4.ORG_INFORMATION3
, O5.ORG_INFORMATION2
, O4.ORG_INFORMATION4
, O4.ORG_INFORMATION5
, O6.ORG_INFORMATION1
, O7.ORG_INFORMATION1
, O8.ORG_INFORMATION1
, O8.ORG_INFORMATION2
, O8.ORG_INFORMATION3
, O8.ORG_INFORMATION4
, L.ADDRESS_LINE_1
, L.ADDRESS_LINE_2
, L.ADDRESS_LINE_3
, L.TOWN_OR_CITY
, DECODE(L.STYLE
, 'US'
, L.REGION_2
, 'CA'
, L.REGION_1
, ' ')
, L.POSTAL_CODE
, L.COUNTRY
, O9.ORG_INFORMATION1
, O9.ORG_INFORMATION2
, O9.ORG_INFORMATION3
, O9.ORG_INFORMATION4
, O9.ORG_INFORMATION5
, O9.ORG_INFORMATION6
, O9.ORG_INFORMATION7
, O10.ORG_INFORMATION1
, O10.ORG_INFORMATION2
, O2.ORG_INFORMATION3
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OTL
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O4
, HR_ORGANIZATION_INFORMATION O5
, HR_ORGANIZATION_INFORMATION O6
, HR_ORGANIZATION_INFORMATION O7
, HR_ORGANIZATION_INFORMATION O8
, HR_ORGANIZATION_INFORMATION O9
, HR_ORGANIZATION_INFORMATION O10
, HR_ORGANIZATION_INFORMATION O3
, HR_LOCATIONS L
WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O4.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O5.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O6.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O7.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O8.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O9.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O10.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O2.ORG_INFORMATION_CONTEXT (+) || '' = 'EMPLOYER IDENTIFICATION'
AND O4.ORG_INFORMATION_CONTEXT (+) || '' = 'EEO-1 FILING'
AND O5.ORG_INFORMATION_CONTEXT (+) || '' = 'VETS-100 FILING'
AND O6.ORG_INFORMATION_CONTEXT (+) || '' = 'W2 REPORTING RULES'
AND O7.ORG_INFORMATION_CONTEXT (+) || '' = 'SQWL GN TRANSMITTER RULES'
AND O8.ORG_INFORMATION_CONTEXT (+) || '' = '1099R MAGNETIC REPORT RULES'
AND O9.ORG_INFORMATION_CONTEXT (+) || '' = 'MULTIPLE WORKSITE REPORTING'
AND O10.ORG_INFORMATION_CONTEXT (+) || '' = 'STATE_TAX_RULES'
AND O3.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND O3.ORG_INFORMATION1 = 'HR_LEGAL'
AND O3.ORG_INFORMATION2 = 'Y'
AND L.LOCATION_ID (+) = O.LOCATION_ID
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')