VIEW: APPS.PABV_TASKS

Source

View Text - Preformatted

SELECT pt.task_id , pt.task_number , pt.task_name , pt.description , pt.WBS_level , '_LA:pt.service_type_code:PA_LOOKUPS:SERVICE TYPE:MEANING' , '_DF:PA:PA_TASKS_DESC_FLEX:pt' , pt.start_date , pt.completion_date , '_LA:pt.pm_product_code:PA_LOOKUPS:PM_PRODUCT_CODE:MEANING' , pt.pm_task_reference , pt.parent_task_id , pt.top_task_id , pt.project_id , pt.carrying_out_organization_id , pt.task_manager_person_id , pt.LAST_UPDATE_DATE , pt.LAST_UPDATED_BY , pt.CREATION_DATE , pt.CREATED_BY FROM pa_tasks pt , pa_projects_all ppa WHERE pt.project_id = ppa.project_id 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
, '_LA:PT.SERVICE_TYPE_CODE:PA_LOOKUPS:SERVICE TYPE:MEANING'
, '_DF:PA:PA_TASKS_DESC_FLEX:PT'
, PT.START_DATE
, PT.COMPLETION_DATE
, '_LA:PT.PM_PRODUCT_CODE:PA_LOOKUPS:PM_PRODUCT_CODE:MEANING'
, PT.PM_TASK_REFERENCE
, PT.PARENT_TASK_ID
, PT.TOP_TASK_ID
, PT.PROJECT_ID
, PT.CARRYING_OUT_ORGANIZATION_ID
, PT.TASK_MANAGER_PERSON_ID
, PT.LAST_UPDATE_DATE
, PT.LAST_UPDATED_BY
, PT.CREATION_DATE
, PT.CREATED_BY
FROM PA_TASKS PT
, PA_PROJECTS_ALL PPA
WHERE PT.PROJECT_ID = PPA.PROJECT_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY