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.HRI_OBI_CL_RVAC_VACNCY_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length
VAC_VACNCY_PK	NUMBER
VAC_VACANCY_NAME	VARCHAR2	(4000)
VAC_VACANCY_NAME_UNQ	VARCHAR2	(4000)
VAC_VACANCY_DESC	VARCHAR2	(4000)
VAC_VALID_FROM	DATE
VAC_VALID_TO	DATE
VAC_REQSTN_FK	NUMBER
VAC_ORDER_BY	VARCHAR2	(4000)
VAC_STATUS_CODE	VARCHAR2	(4000)
VAC_CATEGORY_CODE	VARCHAR2	(4000)
VAC_STATUS_NAME	VARCHAR2	(4000)
VAC_CATEGORY_NAME	VARCHAR2	(4000)

Query Text

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


SELECT VAC_VACNCY_PK
,      VAC_VACANCY_NAME
,      VAC_VACANCY_NAME_UNQ
,      VAC_VACANCY_DESC
,      VAC_VALID_FROM
,      VAC_VALID_TO
,      VAC_REQSTN_FK
,      VAC_ORDER_BY
,      VAC_STATUS_CODE
,      VAC_CATEGORY_CODE
,      VAC_STATUS_NAME
,      VAC_CATEGORY_NAME
FROM APPS.HRI_OBI_CL_RVAC_VACNCY_V;

Dependencies

[top of page]

APPS.HRI_OBI_CL_RVAC_VACNCY_V references the following:

APPS: HRI_OLTP_VIEW_MESSAGE - show dependent code; HRI_UNASSIGNED; HR_BIS - show dependent code; HR_GENERAL - show dependent code; PER_ALL_VACANCIES

APPS.HRI_OBI_CL_RVAC_VACNCY_V is not referenced by any database object