View: HR_DE_TAX_OFFICES_LOV

Product:	PER - Human Resources
Description:	View for german Tax offices stored as Organizations
Implementation/DBA Data:	APPS.HR_DE_TAX_OFFICES_LOV

View Text

SELECT SUBSTR(ORI.ORG_INFORMATION1
, 1
, 10)
, ORG.NAME
, ORG.ORGANIZATION_ID
, ORI.ORG_INFORMATION2
, ORG.BUSINESS_GROUP_ID
FROM HR_ORGANIZATION_UNITS ORG
, HR_ORGANIZATION_INFORMATION ORI
, FND_SESSIONS SES
WHERE ORG.ORGANIZATION_ID = ORI.ORGANIZATION_ID
AND ORI.ORG_INFORMATION_CONTEXT = 'DE_TAX_OFFICE_INFO'
AND ORG.ORGANIZATION_ID IN (SELECT ORGANIZATION_ID
FROM HR_ORGANIZATION_INFORMATION ORI
WHERE ORI.ORG_INFORMATION_CONTEXT = 'CLASS'
AND ORI.ORG_INFORMATION1 = 'DE_TAX_OFFICE'
AND ORI.ORG_INFORMATION2 = 'Y')
AND SES.SESSION_ID = USERENV('SESSIONID')
AND ORG.DATE_FROM < = SES.EFFECTIVE_DATE
AND ((ORG.DATE_TO IS NULL) OR (ORG.DATE_TO >= SES.EFFECTIVE_DATE))

Columns