[Home] [Help]
View: PA_JOBS_RES_V
View Text
SELECT JOB_ID
, SUBSTR(NAME
, 1
, 60)
, 'Y'
, 'HOURS'
, 'N'
, JOB_GROUP_ID
FROM PA_JOBS_V
WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES
, 'Y'
, DATE_FROM
, TRUNC(SYSDATE) ) BETWEEN DATE_FROM
AND NVL(DATE_TO
, TRUNC(SYSDATE))
Columns
Name |
JOB_ID |
JOB_NAME |
TRACK_AS_LABOR_FLAG |
UNIT_OF_MEASURE |
ROLLUP_QUANTITY_FLAG |
JOB_GROUP_ID |