View: HR_H2PI_ORGANIZATION_INFO_V

Product:	PER - Human Resources
Description:	Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for organization info
Implementation/DBA Data:	APPS.HR_H2PI_ORGANIZATION_INFO_V

View Text

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')
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 DAY INFORMATION'
, 'LEGAL ENTITY ACCOUNTING'
, 'MULTIPLE WORKSITE REPORTING'
, 'TIAA-CREF SETUP CODES'
, 'VETS-100 FILING'
, 'W2 REPORTING 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')

Columns