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_SEARCH_CRITERIA_V

Object Details

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

Search Criteria (from IRC_SEARCH_CRITERIA table)

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_TYPE	VARCHAR2	(30)	Yes	Object type.
SEARCH_NAME	VARCHAR2	(240)		Search name.
SEARCH_TYPE	VARCHAR2	(30)		Search type.
LOCATION	VARCHAR2	(240)		Location.
DISTANCE_TO_LOCATION	VARCHAR2	(30)		Distance to location.
EMPLOYEE_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
CONTRACTOR_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
EMPLOYMENT_CATEGORY_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type IRC_EMP_CAT).
KEYWORDS	VARCHAR2	(240)		Keywords.
TRAVEL_PERCENTAGE_M	VARCHAR2	(4000)		Travel percentage.
TRAVEL_PERCENTAGE	NUMBER			Travel percentage.
MIN_SALARY	NUMBER			Min salary.
MAX_SALARY	NUMBER			Max salary.
SALARY_CURRENCY	VARCHAR2	(30)		Salary currency.
SALARY_PERIOD	VARCHAR2	(30)		Salary period.
MATCH_COMPETENCE_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
MATCH_QUALIFICATION_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
JOB_TITLE	VARCHAR2	(240)		Job title.
DEPARTMENT	VARCHAR2	(240)		Department.
PROFESSIONAL_AREA_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type IRC_PROFESSIONAL_AREA).
WORK_AT_HOME	VARCHAR2	(30)		Work at home.
MIN_QUAL_LEVEL	NUMBER	(9)		Minimum qualification level.
MAX_QUAL_LEVEL	NUMBER	(9)		Max qual level.
USE_FOR_MATCHING_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
DESCRIPTION	CLOB	(4000)		Description.
DATE_POSTED	VARCHAR2	(30)		Date posted.
GEOCODE_LOCATION	VARCHAR2	(240)		Geocode location.
GEOCODE_COUNTRY	VARCHAR2	(30)		Geocode country.
DERIVED_LOCATION	VARCHAR2	(240)		Derived location.
EMPLOYEE	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
CONTRACTOR	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
EMPLOYMENT_CATEGORY	VARCHAR2	(30)		(Lookup code based on lookup type IRC_EMP_CAT).
MATCH_COMPETENCE	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
MATCH_QUALIFICATION	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
PROFESSIONAL_AREA	VARCHAR2	(30)		(Lookup code based on lookup type IRC_PROFESSIONAL_AREA).
USE_FOR_MATCHING	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
ISC_INFORMATION_CATEGORY	VARCHAR2	(30)		Isc information category.
ISC_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION21	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION22	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION23	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION24	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION25	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION26	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION27	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION28	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION29	VARCHAR2	(150)		Developer descriptive flexfield column.
ISC_INFORMATION30	VARCHAR2	(150)		Developer descriptive flexfield column.
_DF:ISC	CHAR	(31)
OBJECT_ID	NUMBER	(15)	Yes	Object Id.
SEARCH_CRITERIA_ID	NUMBER	(15)	Yes	Primary key for IRC_SEARCH_CRITERIA.
LOCATION_ID	NUMBER	(15)		Foreign key to HR_LOCATIONS_ALL.
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 OBJECT_TYPE
,      SEARCH_NAME
,      SEARCH_TYPE
,      LOCATION
,      DISTANCE_TO_LOCATION
,      EMPLOYEE_M
,      CONTRACTOR_M
,      EMPLOYMENT_CATEGORY_M
,      KEYWORDS
,      TRAVEL_PERCENTAGE_M
,      TRAVEL_PERCENTAGE
,      MIN_SALARY
,      MAX_SALARY
,      SALARY_CURRENCY
,      SALARY_PERIOD
,      MATCH_COMPETENCE_M
,      MATCH_QUALIFICATION_M
,      JOB_TITLE
,      DEPARTMENT
,      PROFESSIONAL_AREA_M
,      WORK_AT_HOME
,      MIN_QUAL_LEVEL
,      MAX_QUAL_LEVEL
,      USE_FOR_MATCHING_M
,      DESCRIPTION
,      DATE_POSTED
,      GEOCODE_LOCATION
,      GEOCODE_COUNTRY
,      DERIVED_LOCATION
,      EMPLOYEE
,      CONTRACTOR
,      EMPLOYMENT_CATEGORY
,      MATCH_COMPETENCE
,      MATCH_QUALIFICATION
,      PROFESSIONAL_AREA
,      USE_FOR_MATCHING
,      ISC_INFORMATION_CATEGORY
,      ISC_INFORMATION1
,      ISC_INFORMATION2
,      ISC_INFORMATION3
,      ISC_INFORMATION4
,      ISC_INFORMATION5
,      ISC_INFORMATION6
,      ISC_INFORMATION7
,      ISC_INFORMATION8
,      ISC_INFORMATION9
,      ISC_INFORMATION10
,      ISC_INFORMATION11
,      ISC_INFORMATION12
,      ISC_INFORMATION13
,      ISC_INFORMATION14
,      ISC_INFORMATION15
,      ISC_INFORMATION16
,      ISC_INFORMATION17
,      ISC_INFORMATION18
,      ISC_INFORMATION19
,      ISC_INFORMATION20
,      ISC_INFORMATION21
,      ISC_INFORMATION22
,      ISC_INFORMATION23
,      ISC_INFORMATION24
,      ISC_INFORMATION25
,      ISC_INFORMATION26
,      ISC_INFORMATION27
,      ISC_INFORMATION28
,      ISC_INFORMATION29
,      ISC_INFORMATION30
,      _DF:ISC
,      OBJECT_ID
,      SEARCH_CRITERIA_ID
,      LOCATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.IRCBV_SEARCH_CRITERIA_V;

Dependencies

[top of page]

APPS.IRCBV_SEARCH_CRITERIA_V references the following:

APPS: HR_BIS - show dependent code; IRC_SEARCH_CRITERIA

APPS.IRCBV_SEARCH_CRITERIA_V is not referenced by any database object