1. Tables and Views for Sales and Fusion Service
  2. OKC_RESOURCE_ORGANIZATIONS_V

OKC_RESOURCE_ORGANIZATIONS_V

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: VIEW

Columns

Name

ORGANIZATION_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

ACTION_OCCURRENCE_ID

BUSINESS_GROUP_ID

LEGAL_ENTITY_ID

ESTABLISHMENT_ID

NAME

INTERNAL_EXTERNAL_FLAG

TYPE

INTERNAL_ADDRESS_LINE

COST_ALLOCATION_KEYFLEX_ID

LOCATION_ID

ORGANIZATION_CODE

Query

SQL_Statement

SELECT

hao.ORGANIZATION_ID,

hao.EFFECTIVE_START_DATE,

hao.EFFECTIVE_END_DATE,

hao.ACTION_OCCURRENCE_ID,

hao.BUSINESS_GROUP_ID,

hao.LEGAL_ENTITY_ID,

hao.ESTABLISHMENT_ID,

haotl.NAME,

hao.INTERNAL_EXTERNAL_FLAG,

hao.TYPE,

hao.INTERNAL_ADDRESS_LINE,

hao.COST_ALLOCATION_KEYFLEX_ID,

hao.LOCATION_ID,

hao.ORGANIZATION_CODE

FROM

HR_ALL_ORGANIZATION_UNITS_F hao,

HR_ORGANIZATION_UNITS_F_TL haotl

WHERE hao.ORGANIZATION_ID = haotl.ORGANIZATION_ID

AND haotl.LANGUAGE = USERENV('LANG')

AND trunc(haotl.EFFECTIVE_START_DATE) = trunc(hao.EFFECTIVE_START_DATE)

AND trunc(haotl.EFFECTIVE_END_DATE) = trunc(hao.EFFECTIVE_END_DATE)

AND ( EXISTS (

SELECT 1 FROM HR_ORG_UNIT_CLASSIFICATIONS_F OrgUnitClassificationDPEO,

HR_ORG_CLASSIFICATIONS_VL OrgClassificationPEO

WHERE OrgClassificationPEO.CLASSIFICATION_CODE = OrgUnitClassificationDPEO.CLASSIFICATION_CODE

and OrgClassificationPEO.INFORMATION1 = 'RESOURCE_ORG'

and OrgUnitClassificationDPEO.status = 'A'

and hao.ORGANIZATION_ID = OrgUnitClassificationDPEO.ORGANIZATION_ID

)

)