VIEW: APPS.EDW_HR_JOB_JOBS_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvjb.odf 115.7 2001/11/01 01:21:22 pkm ship       $ */ job_pk ,instance ,name ,job_dp ,all_fk ,business_group ,job_id ,business_group_id ,job_definition_id ,job_cat_set1 ,job_cat_set2 ,job_cat_set3 ,job_cat_set4 ,job_cat_set5 ,job_cat_set6 ,job_cat_set7 ,job_cat_set8 ,job_cat_set9 ,job_cat_set10 ,job_cat_set11 ,job_cat_set12 ,job_cat_set13 ,job_cat_set14 ,job_cat_set15 ,benchmark_job_name ,benchmark_job_id ,emp_rights_flag ,benchmark_job_flag ,creation_date ,last_update_date ,null ,null ,null ,null ,null FROM edwbv_hr_job_jobs_lcv

View Text - HTML Formatted

SELECT /* $HEADER: HRISVJB.ODF 115.7 2001/11/01 01:21:22 PKM SHIP $ */ JOB_PK
, INSTANCE
, NAME
, JOB_DP
, ALL_FK
, BUSINESS_GROUP
, JOB_ID
, BUSINESS_GROUP_ID
, JOB_DEFINITION_ID
, JOB_CAT_SET1
, JOB_CAT_SET2
, JOB_CAT_SET3
, JOB_CAT_SET4
, JOB_CAT_SET5
, JOB_CAT_SET6
, JOB_CAT_SET7
, JOB_CAT_SET8
, JOB_CAT_SET9
, JOB_CAT_SET10
, JOB_CAT_SET11
, JOB_CAT_SET12
, JOB_CAT_SET13
, JOB_CAT_SET14
, JOB_CAT_SET15
, BENCHMARK_JOB_NAME
, BENCHMARK_JOB_ID
, EMP_RIGHTS_FLAG
, BENCHMARK_JOB_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_HR_JOB_JOBS_LCV