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.HR_DE_SOC_INS_ORG_INFO_V

Source

View Text - Preformatted


SELECT inf.org_information_id ,inf.org_information1 WEST_BETRIEBSNUMMER ,inf.organization_id ,inf.org_information2 EAST_BETRIEBSNUMMER ,inf.org_information3 HEALTH_PROVIDER_TYPE ,inf.org_information4 PENSION_PROVIDER_TYPE ,hr_general.decode_lookup ('DE_PENSION_PROV_TYPE',inf.org_information4) D_PENSION_PROVIDER_TYPE ,hr_general.decode_lookup ('DE_HEALTH_PROV_TYPE' ,inf.org_information3) D_HEALTH_PROVIDER_TYPE ,inf.object_version_number FROM hr_organization_information inf WHERE inf.org_information_context = 'DE_SOCIAL_INSURANCE_INFO'

View Text - HTML Formatted

SELECT INF.ORG_INFORMATION_ID
, INF.ORG_INFORMATION1 WEST_BETRIEBSNUMMER
, INF.ORGANIZATION_ID
, INF.ORG_INFORMATION2 EAST_BETRIEBSNUMMER
, INF.ORG_INFORMATION3 HEALTH_PROVIDER_TYPE
, INF.ORG_INFORMATION4 PENSION_PROVIDER_TYPE
, HR_GENERAL.DECODE_LOOKUP ('DE_PENSION_PROV_TYPE'
, INF.ORG_INFORMATION4) D_PENSION_PROVIDER_TYPE
, HR_GENERAL.DECODE_LOOKUP ('DE_HEALTH_PROV_TYPE'
, INF.ORG_INFORMATION3) D_HEALTH_PROVIDER_TYPE
, INF.OBJECT_VERSION_NUMBER
FROM HR_ORGANIZATION_INFORMATION INF
WHERE INF.ORG_INFORMATION_CONTEXT = 'DE_SOCIAL_INSURANCE_INFO'