1. Tables and Views for HCM
  2. IRC_PROFILE_ESTABLISHMENTS_V

IRC_PROFILE_ESTABLISHMENTS_V

Details

  • Schema: FUSION

  • Object owner: IRC

  • Object type: VIEW

Columns

Name

ESTABLISHMENT_ID

BUSINESS_GROUP_ID

LANGUAGE

NAME

SCHOOL_CODE

LOCATION

DESCRIPTION

PARTY_ID

COUNTRY_ID

STATE_PROVINCE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

SOURCE_TABLE

Query

SQL_Statement

SELECT CIB.CONTENT_ITEM_ID AS ESTABLISHMENT_ID,

CIB.BUSINESS_GROUP_ID,

CITL.LANGUAGE,

CITL.NAME,

CIB.ITEM_TEXT_1 AS SCHOOL_CODE,

CITL.ITEM_TEXT_TL_1 AS LOCATION,

CITL.ITEM_DESCRIPTION AS DESCRIPTION,

CIB.ITEM_NUMBER_1 AS PARTY_ID,

CIB.COUNTRY_ID,

CIB.STATE_PROVINCE_ID,

CIB.OBJECT_VERSION_NUMBER,

CIB.CREATED_BY,

CIB.CREATION_DATE,

CIB.LAST_UPDATE_DATE,

CIB.LAST_UPDATED_BY,

CIB.LAST_UPDATE_LOGIN,

'HRT_CONTENT_ITEMS' AS SOURCE_TABLE

FROM HRT_CONTENT_ITEMS_B CIB, HRT_CONTENT_ITEMS_TL CITL

WHERE CIB.CONTENT_TYPE_ID = 135

AND CIB.CONTENT_ITEM_ID = CITL.CONTENT_ITEM_ID

AND CIB.BUSINESS_GROUP_ID = CITL.BUSINESS_GROUP_ID