View: PA_ONLINE_TASKS_V

Product:	PA - Projects
Description:	Customizable view for tasks used in Self Service Time, Oracle Time Capture, and Sel f Service Expense applications. PA_ONLINE_TASKS_V is a customizable view for Self Service Time application , Oracle Time Capture, and Self Service Expense.
Implementation/DBA Data:	APPS.PA_ONLINE_TASKS_V

View Text

SELECT T.PROJECT_ID
, P.SEGMENT1 PROJECT_NUMBER
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.START_DATE
, T.COMPLETION_DATE
, T.CHARGEABLE_FLAG
, T.BILLABLE_FLAG
, IMP.ORG_ID
, T.TASK_NUMBER || '-' || T.TASK_NAME TASK_DETAILS
FROM PA_TASKS T
, PA_PROJECTS_ALL P
, PA_IMPLEMENTATIONS IMP
, PA_LOOKUPS LU
WHERE LU.LOOKUP_TYPE = 'PA_TASKS_TO_DISPLAY'
AND LU.LOOKUP_CODE = NVL(FND_PROFILE.VALUE('PA_TASKS_DISPLAYED')
, 'ALL')
AND (( LU.LOOKUP_CODE = 'CHARGEABLE'
AND T.CHARGEABLE_FLAG = 'Y') OR ( LU.LOOKUP_CODE = 'ALL') OR (LU.LOOKUP_CODE = 'LOWEST'
AND PA_TASK_UTILS.CHECK_CHILD_EXISTS(T.TASK_ID) = 0) )
AND (P.PROJECT_ID = T.PROJECT_ID AND( IMP.ORG_ID = P.ORG_ID OR T.ALLOW_CROSS_CHARGE_FLAG = 'Y'))

Columns