View: BIS_JOBS_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_JOBS_V

View Text

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)

Columns