VIEW: APPS.PA_TASKS_EXPEND_V

Source

View Text - Preformatted

SELECT T.PROJECT_ID , P.SEGMENT1 PROJECT_NUMBER , T.TASK_ID , T.TASK_NUMBER , T.TASK_NAME , DECODE(LU.LOOKUP_CODE,'ALL', LPAD(' ',(NVL(WBS_LEVEL,1)-1)*2,' ')||T.TASK_NAME, T.TASK_NAME) , T.START_DATE , T.LABOR_COST_MULTIPLIER_NAME , T.COMPLETION_DATE , T.CHARGEABLE_FLAG , substr( DECODE(LU.LOOKUP_CODE,'ALL', pa_task_utils.sort_order_tree_walk(T.parent_task_id, T.TASK_NUMBER), TASK_NUMBER),1,2000) wbs_sort_order ,T.allow_cross_charge_flag ,T.project_rate_date ,T.project_rate_type ,T.billable_flag ,T.carrying_out_organization_id ,T.TASKFUNC_COST_RATE_TYPE ,T.TASKFUNC_COST_RATE_DATE ,T.work_type_id ,Substr(pa_utils4.get_work_type_name(T.work_type_id),1,200) Work_type_name ,Substr(pa_utils4.get_tp_amt_type_code(T.work_type_id),1,200) Tp_amt_type_code ,t.description ,P.ORG_ID FROM PA_TASKS T, PA_PROJECTS_ALL P, 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 ( T.allow_cross_charge_flag = 'Y' or EXISTS ( select '1' from pa_implementations imp where imp.org_id = p.org_id ) ))

View Text - HTML Formatted

SELECT T.PROJECT_ID
, P.SEGMENT1 PROJECT_NUMBER
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, DECODE(LU.LOOKUP_CODE
, 'ALL'
, LPAD(' '
, (NVL(WBS_LEVEL
, 1)-1)*2
, ' ')||T.TASK_NAME
, T.TASK_NAME)
, T.START_DATE
, T.LABOR_COST_MULTIPLIER_NAME
, T.COMPLETION_DATE
, T.CHARGEABLE_FLAG
, SUBSTR( DECODE(LU.LOOKUP_CODE
, 'ALL'
, PA_TASK_UTILS.SORT_ORDER_TREE_WALK(T.PARENT_TASK_ID
, T.TASK_NUMBER)
, TASK_NUMBER)
, 1
, 2000) WBS_SORT_ORDER
, T.ALLOW_CROSS_CHARGE_FLAG
, T.PROJECT_RATE_DATE
, T.PROJECT_RATE_TYPE
, T.BILLABLE_FLAG
, T.CARRYING_OUT_ORGANIZATION_ID
, T.TASKFUNC_COST_RATE_TYPE
, T.TASKFUNC_COST_RATE_DATE
, T.WORK_TYPE_ID
, SUBSTR(PA_UTILS4.GET_WORK_TYPE_NAME(T.WORK_TYPE_ID)
, 1
, 200) WORK_TYPE_NAME
, SUBSTR(PA_UTILS4.GET_TP_AMT_TYPE_CODE(T.WORK_TYPE_ID)
, 1
, 200) TP_AMT_TYPE_CODE
, T.DESCRIPTION
, P.ORG_ID
FROM PA_TASKS T
, PA_PROJECTS_ALL P
, 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 ( T.ALLOW_CROSS_CHARGE_FLAG = 'Y' OR EXISTS ( SELECT '1'
FROM PA_IMPLEMENTATIONS IMP
WHERE IMP.ORG_ID = P.ORG_ID ) ))