VIEW: APPS.PJM_TASKS_MTLL_V

Source

View Text - Preformatted

SELECT T.PROJECT_ID , T.TASK_ID , T.TASK_NUMBER , T.TASK_NAME , DECODE( LU.LOOKUP_CODE , 'ALL' , '*' , 'CHARGEABLE' , DECODE( T.CHARGEABLE_FLAG , 'Y' , '*' , NULL ) , 'LOWEST' , DECODE( PA_TASK_UTILS.CHECK_CHILD_EXISTS(T.TASK_ID) , 0 , '*' , NULL ) ) FROM PA_TASKS T , PA_LOOKUPS LU WHERE LU.LOOKUP_TYPE = 'PA_TASKS_TO_DISPLAY' AND LU.LOOKUP_CODE = NVL( FND_PROFILE.VALUE('PA_TASK_DISPLAYED') , 'ALL' )

View Text - HTML Formatted

SELECT T.PROJECT_ID
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, DECODE( LU.LOOKUP_CODE
, 'ALL'
, '*'
, 'CHARGEABLE'
, DECODE( T.CHARGEABLE_FLAG
, 'Y'
, '*'
, NULL )
, 'LOWEST'
, DECODE( PA_TASK_UTILS.CHECK_CHILD_EXISTS(T.TASK_ID)
, 0
, '*'
, NULL ) )
FROM PA_TASKS T
, PA_LOOKUPS LU
WHERE LU.LOOKUP_TYPE = 'PA_TASKS_TO_DISPLAY'
AND LU.LOOKUP_CODE = NVL( FND_PROFILE.VALUE('PA_TASK_DISPLAYED')
, 'ALL' )