VIEW: APPS.HR_H2PI_ORGANIZATION_INFO_V

Source

View Text - Preformatted

SELECT ogi.last_update_date, org.business_group_Id, ogi.org_information_id, ogi.organization_id, ogi.org_information_context, ogi.org_information1, ogi.org_information2, ogi.org_information3, ogi.org_information4, ogi.org_information5, ogi.org_information6, ogi.org_information7, ogi.org_information8, ogi.org_information9, ogi.org_information10, ogi.org_information11, ogi.org_information12, ogi.org_information13, ogi.org_information14, ogi.org_information15, ogi.org_information16, ogi.org_information17, ogi.org_information18, ogi.org_information19, ogi.org_information20 from hr_organization_units org, hr_organization_information ogi, hr_organization_information ogi2, hr_org_info_types_by_class oitbc, hr_org_information_types oit WHERE org.organization_id = ogi.organization_id and ogi.organization_id = ogi2.organization_id and ogi2.org_information_context = 'CLASS' and ogi2.org_information1 IN ('HR_ORG', 'HR_LEGAL', 'HR_BG', 'HR_PAYEE', 'US_CARRIER', 'US_WC_CARRIER') and ogi.org_information_context = oit.org_information_type and ogi.org_information_context IN ('Work Day Information', '1099R Magnetic Report Rules', 'EEO-1 Filing', 'Employer Identification', 'Federal Tax Rules', 'NACHA Rules', 'SQWL Employer Rules 1', 'SQWL Employer Rules 2', 'SQWL GN Transmitter Rules', 'SQWL SS Transmitter Rules', 'PAY_US_STATE_WAGE_PLAN_INFO', 'Costing Information', 'Organization Name Alias', 'Work Schedule', 'Legal Entity Accounting', 'Multiple Worksite Reporting', 'TIAA-CREF Setup Codes', 'VETS-100 Filing', 'W2 Reporting Rules','State Tax Rules','Local Tax Rules') and oitbc.org_classification = ogi2.org_information1 and oitbc.org_information_type = oit.org_information_type and (oit.legislation_code is NULL or oit.legislation_code = 'US')

View Text - HTML Formatted

SELECT OGI.LAST_UPDATE_DATE
, ORG.BUSINESS_GROUP_ID
, OGI.ORG_INFORMATION_ID
, OGI.ORGANIZATION_ID
, OGI.ORG_INFORMATION_CONTEXT
, OGI.ORG_INFORMATION1
, OGI.ORG_INFORMATION2
, OGI.ORG_INFORMATION3
, OGI.ORG_INFORMATION4
, OGI.ORG_INFORMATION5
, OGI.ORG_INFORMATION6
, OGI.ORG_INFORMATION7
, OGI.ORG_INFORMATION8
, OGI.ORG_INFORMATION9
, OGI.ORG_INFORMATION10
, OGI.ORG_INFORMATION11
, OGI.ORG_INFORMATION12
, OGI.ORG_INFORMATION13
, OGI.ORG_INFORMATION14
, OGI.ORG_INFORMATION15
, OGI.ORG_INFORMATION16
, OGI.ORG_INFORMATION17
, OGI.ORG_INFORMATION18
, OGI.ORG_INFORMATION19
, OGI.ORG_INFORMATION20
FROM HR_ORGANIZATION_UNITS ORG
, HR_ORGANIZATION_INFORMATION OGI
, HR_ORGANIZATION_INFORMATION OGI2
, HR_ORG_INFO_TYPES_BY_CLASS OITBC
, HR_ORG_INFORMATION_TYPES OIT
WHERE ORG.ORGANIZATION_ID = OGI.ORGANIZATION_ID
AND OGI.ORGANIZATION_ID = OGI2.ORGANIZATION_ID
AND OGI2.ORG_INFORMATION_CONTEXT = 'CLASS'
AND OGI2.ORG_INFORMATION1 IN ('HR_ORG'
, 'HR_LEGAL'
, 'HR_BG'
, 'HR_PAYEE'
, 'US_CARRIER'
, 'US_WC_CARRIER')
AND OGI.ORG_INFORMATION_CONTEXT = OIT.ORG_INFORMATION_TYPE
AND OGI.ORG_INFORMATION_CONTEXT IN ('WORK DAY INFORMATION'
, '1099R MAGNETIC REPORT RULES'
, 'EEO-1 FILING'
, 'EMPLOYER IDENTIFICATION'
, 'FEDERAL TAX RULES'
, 'NACHA RULES'
, 'SQWL EMPLOYER RULES 1'
, 'SQWL EMPLOYER RULES 2'
, 'SQWL GN TRANSMITTER RULES'
, 'SQWL SS TRANSMITTER RULES'
, 'PAY_US_STATE_WAGE_PLAN_INFO'
, 'COSTING INFORMATION'
, 'ORGANIZATION NAME ALIAS'
, 'WORK SCHEDULE'
, 'LEGAL ENTITY ACCOUNTING'
, 'MULTIPLE WORKSITE REPORTING'
, 'TIAA-CREF SETUP CODES'
, 'VETS-100 FILING'
, 'W2 REPORTING RULES'
, 'STATE TAX RULES'
, 'LOCAL TAX RULES')
AND OITBC.ORG_CLASSIFICATION = OGI2.ORG_INFORMATION1
AND OITBC.ORG_INFORMATION_TYPE = OIT.ORG_INFORMATION_TYPE
AND (OIT.LEGISLATION_CODE IS NULL OR OIT.LEGISLATION_CODE = 'US')