VIEW: APPS.IRC_ALL_RECRUITING_SITES_VL

Source

View Text - Preformatted

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, RSE.POSTING_IMPL_CLASS 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')

View Text - HTML Formatted

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
, RSE.POSTING_IMPL_CLASS
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')