VIEW: APPS.IRCBV_ALL_RECRUITING_SITES_V

Source

View Text - Preformatted

SELECT STE.INTERNAL_NAME , STET.SITE_NAME , STE.DATE_FROM , STE.DATE_TO , HR_BIS.BIS_DECODE_LOOKUP('YES_NO', STE.INTERNAL) , HR_BIS.BIS_DECODE_LOOKUP('YES_NO', STE.EXTERNAL) , HR_BIS.BIS_DECODE_LOOKUP('YES_NO', STE.THIRD_PARTY) , STET.REDIRECTION_URL , STET.POSTING_URL , STE.POSTING_USERNAME , STE.POSTING_PASSWORD , STE.POSTING_COST , STE.POSTING_COST_PERIOD , STE.POSTING_COST_CURRENCY , STE.STYLESHEET , STE.INTERNAL , STE.EXTERNAL , STE.THIRD_PARTY ,'_DF:PER:IRC_ALL_RECRUITING_SITES:STE' , STE.RECRUITING_SITE_ID , STE.LAST_UPDATE_DATE , STE.LAST_UPDATED_BY , STE.LAST_UPDATE_LOGIN , STE.CREATED_BY , STE.CREATION_DATE FROM IRC_ALL_RECRUITING_SITES STE ,IRC_ALL_RECRUITING_SITES_TL STET WHERE STE.RECRUITING_SITE_ID = STET.RECRUITING_SITE_ID AND STET.LANGUAGE = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT STE.INTERNAL_NAME
, STET.SITE_NAME
, STE.DATE_FROM
, STE.DATE_TO
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, STE.INTERNAL)
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, STE.EXTERNAL)
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, STE.THIRD_PARTY)
, STET.REDIRECTION_URL
, STET.POSTING_URL
, STE.POSTING_USERNAME
, STE.POSTING_PASSWORD
, STE.POSTING_COST
, STE.POSTING_COST_PERIOD
, STE.POSTING_COST_CURRENCY
, STE.STYLESHEET
, STE.INTERNAL
, STE.EXTERNAL
, STE.THIRD_PARTY
, '_DF:PER:IRC_ALL_RECRUITING_SITES:STE'
, STE.RECRUITING_SITE_ID
, STE.LAST_UPDATE_DATE
, STE.LAST_UPDATED_BY
, STE.LAST_UPDATE_LOGIN
, STE.CREATED_BY
, STE.CREATION_DATE
FROM IRC_ALL_RECRUITING_SITES STE
, IRC_ALL_RECRUITING_SITES_TL STET
WHERE STE.RECRUITING_SITE_ID = STET.RECRUITING_SITE_ID
AND STET.LANGUAGE = USERENV('LANG') WITH READ ONLY