[Home] [Help]
View: PA_PROJECT_ROLES_RES_V
View Text
SELECT PROJECT_ROLE_ID
, PROJECT_ROLE_TYPE
, SUBSTR(MEANING
, 1
, 60)
, 'Y'
, 'HOURS'
, 'N'
FROM PA_PROJECT_ROLE_TYPES
WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES
, 'Y'
, START_DATE_ACTIVE
, TRUNC(SYSDATE) ) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))
Columns
Name |
PROJECT_ROLE_ID |
PROJECT_ROLE_TYPE |
MEANING |
TRACK_AS_LABOR_FLAG |
UNIT_OF_MEASURE |
ROLLUP_QUANTITY_FLAG |