VIEW: APPS.BIS_JOBS_V

Source

View Text - Preformatted

SELECT DISTINCT TO_CHAR(job.job_id) ID , job.name VALUE , job.job_id job_id , job.name job_name , bgr.name business_group_name , bgr.business_group_id business_group_id from per_business_groups bgr , per_jobs job WHERE job.business_group_id = bgr.business_group_id and trunc(sysdate) between job.date_from and nvl(job.date_to,sysdate)

View Text - HTML Formatted

SELECT DISTINCT TO_CHAR(JOB.JOB_ID) ID
, JOB.NAME VALUE
, JOB.JOB_ID JOB_ID
, JOB.NAME JOB_NAME
, BGR.NAME BUSINESS_GROUP_NAME
, BGR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_BUSINESS_GROUPS BGR
, PER_JOBS JOB
WHERE JOB.BUSINESS_GROUP_ID = BGR.BUSINESS_GROUP_ID
AND TRUNC(SYSDATE) BETWEEN JOB.DATE_FROM
AND NVL(JOB.DATE_TO
, SYSDATE)