VIEW: APPS.EDW_HR_RQVC_VACANCY_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvvc.odf 115.5 2001/11/01 01:21:25 pkm ship       $ */ vacancy_pk ,requisition_fk ,instance ,vacancy_status_code ,vacancy_status ,number_of_openings ,budget_msrmnt_type_code ,budget_msrmnt_type ,budget_msrmnt_value ,name ,vacancy_dp ,business_group_id ,requisition_id ,vacancy_id ,vacancy_start_date ,vacancy_end_date ,creation_date ,last_update_date ,null ,null ,null ,null ,null FROM edwbv_hr_rqvc_vacancy_lcv

View Text - HTML Formatted

SELECT /* $HEADER: HRISVVC.ODF 115.5 2001/11/01 01:21:25 PKM SHIP $ */ VACANCY_PK
, REQUISITION_FK
, INSTANCE
, VACANCY_STATUS_CODE
, VACANCY_STATUS
, NUMBER_OF_OPENINGS
, BUDGET_MSRMNT_TYPE_CODE
, BUDGET_MSRMNT_TYPE
, BUDGET_MSRMNT_VALUE
, NAME
, VACANCY_DP
, BUSINESS_GROUP_ID
, REQUISITION_ID
, VACANCY_ID
, VACANCY_START_DATE
, VACANCY_END_DATE
, CREATION_DATE
, LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_HR_RQVC_VACANCY_LCV