View: IRC_ALL_RECRUITING_SITES_VL

Product:	PER - Human Resources
Description:	This is the translated view for recruiting sites
Implementation/DBA Data:	APPS.IRC_ALL_RECRUITING_SITES_VL

View Text

SELECT RSE.ROWID
, RSE.RECRUITING_SITE_ID
, IRT.SITE_NAME
, RSE.INTERNAL
, RSE.EXTERNAL
, RSE.THIRD_PARTY
, IRT.REDIRECTION_URL
, IRT.POSTING_URL
, RSE.POSTING_COST
, RSE.POSTING_COST_PERIOD
, RSE.POSTING_COST_CURRENCY
, RSE.STYLESHEET
, RSE.ATTRIBUTE_CATEGORY
, RSE.ATTRIBUTE1
, RSE.ATTRIBUTE2
, RSE.ATTRIBUTE3
, RSE.ATTRIBUTE4
, RSE.ATTRIBUTE5
, RSE.ATTRIBUTE6
, RSE.ATTRIBUTE7
, RSE.ATTRIBUTE8
, RSE.ATTRIBUTE9
, RSE.ATTRIBUTE10
, RSE.ATTRIBUTE11
, RSE.ATTRIBUTE12
, RSE.ATTRIBUTE13
, RSE.ATTRIBUTE14
, RSE.ATTRIBUTE15
, RSE.ATTRIBUTE16
, RSE.ATTRIBUTE17
, RSE.ATTRIBUTE18
, RSE.ATTRIBUTE19
, RSE.ATTRIBUTE20
, RSE.ATTRIBUTE21
, RSE.ATTRIBUTE22
, RSE.ATTRIBUTE23
, RSE.ATTRIBUTE24
, RSE.ATTRIBUTE25
, RSE.ATTRIBUTE26
, RSE.ATTRIBUTE27
, RSE.ATTRIBUTE28
, RSE.ATTRIBUTE29
, RSE.ATTRIBUTE30
, RSE.LAST_UPDATE_DATE
, RSE.LAST_UPDATED_BY
, RSE.LAST_UPDATE_LOGIN
, RSE.CREATED_BY
, RSE.CREATION_DATE
, RSE.OBJECT_VERSION_NUMBER
, RSE.DATE_FROM
, RSE.DATE_TO
, RSE.POSTING_USERNAME
, RSE.POSTING_PASSWORD
, RSE.INTERNAL_NAME
FROM IRC_ALL_RECRUITING_SITES RSE
, IRC_ALL_RECRUITING_SITES_TL IRT
WHERE RSE.RECRUITING_SITE_ID = IRT.RECRUITING_SITE_ID
AND IRT.LANGUAGE = USERENV('LANG')

Columns