[Home] [Help]
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
Name |
ID |
VALUE |
JOB_ID |
JOB_NAME |
BUSINESS_GROUP_NAME |
BUSINESS_GROUP_ID |