VIEW: APPS.PAFV_TASKS

Source

View Text - Preformatted

SELECT pt.task_id , pt.task_number , pt.task_name , pt.description , pt.WBS_level , pt.start_date , pt.completion_date , pt.pm_task_reference , pt.parent_task_id , pt.top_task_id , pt.project_id , ppa.name,ppa.segment1 , ppa.org_id , pt.carrying_out_organization_id , hou.name , pt.task_manager_person_id , pap.full_name , pt.LAST_UPDATE_DATE , pt.LAST_UPDATED_BY , pt.CREATION_DATE , pt.CREATED_BY , '_DF:PA:PA_TASKS_DESC_FLEX:pt' , '_LA:pt.service_type_code:PA_LOOKUPS:SERVICE TYPE:MEANING' , '_LA:pt.pm_product_code:PA_LOOKUPS:PM_PRODUCT_CODE:MEANING' FROM pa_tasks pt , pa_projects_all ppa , hr_organization_units hou , per_all_people_f pap WHERE pt.project_id = ppa.project_id and pt.carrying_out_organization_id = hou.organization_id and pt.task_manager_person_id = pap.person_id(+) and trunc(sysdate) between pap.effective_start_date (+) and pap.effective_end_date (+) and '_SEC:ppa.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PT.TASK_ID
, PT.TASK_NUMBER
, PT.TASK_NAME
, PT.DESCRIPTION
, PT.WBS_LEVEL
, PT.START_DATE
, PT.COMPLETION_DATE
, PT.PM_TASK_REFERENCE
, PT.PARENT_TASK_ID
, PT.TOP_TASK_ID
, PT.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPA.ORG_ID
, PT.CARRYING_OUT_ORGANIZATION_ID
, HOU.NAME
, PT.TASK_MANAGER_PERSON_ID
, PAP.FULL_NAME
, PT.LAST_UPDATE_DATE
, PT.LAST_UPDATED_BY
, PT.CREATION_DATE
, PT.CREATED_BY
, '_DF:PA:PA_TASKS_DESC_FLEX:PT'
, '_LA:PT.SERVICE_TYPE_CODE:PA_LOOKUPS:SERVICE TYPE:MEANING'
, '_LA:PT.PM_PRODUCT_CODE:PA_LOOKUPS:PM_PRODUCT_CODE:MEANING'
FROM PA_TASKS PT
, PA_PROJECTS_ALL PPA
, HR_ORGANIZATION_UNITS HOU
, PER_ALL_PEOPLE_F PAP
WHERE PT.PROJECT_ID = PPA.PROJECT_ID
AND PT.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND PT.TASK_MANAGER_PERSON_ID = PAP.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN PAP.EFFECTIVE_START_DATE (+)
AND PAP.EFFECTIVE_END_DATE (+)
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY