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.

[Home] [Help]

View: HR_DE_SOC_INS_ORG_INFO_V

Product:	PER - Human Resources
Description:	Holds information relating to German Insurance Providers.
Implementation/DBA Data:	APPS.HR_DE_SOC_INS_ORG_INFO_V

View Text

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'

Columns

Name
ORG_INFORMATION_ID
WEST_BETRIEBSNUMMER
ORGANIZATION_ID
EAST_BETRIEBSNUMMER
HEALTH_PROVIDER_TYPE
PENSION_PROVIDER_TYPE
D_PENSION_PROVIDER_TYPE
D_HEALTH_PROVIDER_TYPE
OBJECT_VERSION_NUMBER