eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
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 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
Name
PROJECT_ID
PROJECT_NUMBER
TASK_ID
TASK_NUMBER
TASK_NAME
START_DATE
COMPLETION_DATE
CHARGEABLE_FLAG
BILLABLE_FLAG
ORG_ID