eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IRCBV_ALL_RECRUITING_SITES_V

Object Details

Object Name:	IRCBV_ALL_RECRUITING_SITES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

Recruiting site (from IRC_ALL_RECRUITING_SITES/TL table).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INTERNAL_NAME	VARCHAR2	(240)	Yes	Internal name.
SITE_NAME	VARCHAR2	(240)	Yes	Site name.
DATE_FROM	DATE			Date from.
DATE_TO	DATE			Date to.
INTERNAL_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
EXTERNAL_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
THIRD_PARTY_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
REDIRECTION_URL	CLOB	(4000)		Redirection url.
POSTING_URL	CLOB	(4000)		Posting url.
POSTING_USERNAME	VARCHAR2	(240)		Posting username.
POSTING_PASSWORD	VARCHAR2	(240)		Posting password.
POSTING_COST	NUMBER			Posting cost.
POSTING_COST_PERIOD	VARCHAR2	(30)		Posting cost period.
POSTING_COST_CURRENCY	VARCHAR2	(30)		Posting cost currency.
STYLESHEET	VARCHAR2	(4000)		Stylesheet.
INTERNAL	VARCHAR2	(30)	Yes	(Lookup code based on lookup type YES_NO).
EXTERNAL	VARCHAR2	(30)	Yes	(Lookup code based on lookup type YES_NO).
THIRD_PARTY	VARCHAR2	(30)	Yes	(Lookup code based on lookup type YES_NO).
_DF:STE	CHAR	(36)
RECRUITING_SITE_ID	NUMBER	(15)	Yes	Primary Key for IRC_ALL_RECRUITING_SITES.
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERNAL_NAME
,      SITE_NAME
,      DATE_FROM
,      DATE_TO
,      INTERNAL_M
,      EXTERNAL_M
,      THIRD_PARTY_M
,      REDIRECTION_URL
,      POSTING_URL
,      POSTING_USERNAME
,      POSTING_PASSWORD
,      POSTING_COST
,      POSTING_COST_PERIOD
,      POSTING_COST_CURRENCY
,      STYLESHEET
,      INTERNAL
,      EXTERNAL
,      THIRD_PARTY
,      _DF:STE
,      RECRUITING_SITE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.IRCBV_ALL_RECRUITING_SITES_V;

Dependencies

[top of page]

APPS.IRCBV_ALL_RECRUITING_SITES_V references the following:

APPS: HR_BIS - show dependent code; IRC_ALL_RECRUITING_SITES; IRC_ALL_RECRUITING_SITES_TL

APPS.IRCBV_ALL_RECRUITING_SITES_V is not referenced by any database object