View: PABV_TASKS

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PABV_TASKS

View Text

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

Columns