View: PER_JP_SCHOOL_LOOKUPS_V

Product:	PER - Human Resources
Description:	This view is used to display Japanese school information.
Implementation/DBA Data:	APPS.PER_JP_SCHOOL_LOOKUPS_V

View Text

SELECT ROWIDTOCHAR(ROWID)
, SCHOOL_ID
, SUBSTRB(SCHOOL_ID
, 1
, 2)
, SUBSTRB(SCHOOL_ID
, 3
, 6)
, SCHOOL_NAME
, SCHOOL_NAME_KANA
, SUBSTRB(SCHOOL_ID
, 9
, 3)
, MAJOR
, MAJOR_KANA
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM PER_JP_SCHOOL_LOOKUPS

Columns