Product: | PA - Projects |
---|---|
Description: | 10Sc Only - Retrofitted |
Implementation/DBA Data: | APPS.PA_PERCENT_COMPLETES_V |
SELECT PC.ROWID
, T.PROJECT_ID
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.DESCRIPTION
, LPAD(' '
, 2 * (T.WBS_LEVEL - 1))||T.TASK_NUMBER
, LPAD(' '
, 2 * (T.WBS_LEVEL - 1))||T.TASK_NAME
, T.WBS_LEVEL
, PC.DATE_COMPUTED
, PC.COMPLETED_PERCENTAGE
, PC.DESCRIPTION
, PC.PM_PRODUCT_CODE
, PC.CURRENT_FLAG
, PA_TASK_UTILS.SORT_ORDER_TREE_WALK(T.PARENT_TASK_ID
, T.TASK_NUMBER)
, PC.LAST_UPDATE_DATE
, PC.LAST_UPDATED_BY
, PC.CREATION_DATE
, PC.CREATED_BY
, PC.LAST_UPDATE_LOGIN
FROM PA_PERCENT_COMPLETES PC
, PA_TASKS T
WHERE T.TASK_ID = PC.TASK_ID (+)