DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PABV_TASKS

Object Details
Object Name: PABV_TASKS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PABV_TASKS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows information about user-defined subdivisions of project work (tasks). Tasks can have multiple levels of subtasks.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER (15) Yes
TASK_NUMBER VARCHAR2 (25) Yes
TASK_NAME VARCHAR2 (20) Yes
DESCRIPTION VARCHAR2 (250)

WORK_BREAKDOWN_STRUCTURE_LEVEL NUMBER (3) Yes
_LA:SERVICE_TYPE CHAR (56)
_DF CHAR (28)
START_DATE DATE


COMPLETION_DATE DATE


_LA:PM_PRODUCT CHAR (57)
PM_TASK_REFERENCE VARCHAR2 (25)
PARENT_TASK_ID NUMBER (15)

TOP_TASK_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
CARRYING_OUT_ORGANIZATION_ID NUMBER (15) Yes
TASK_MANAGER_PERSON_ID NUMBER (9)

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      DESCRIPTION
,      WORK_BREAKDOWN_STRUCTURE_LEVEL
,      _LA:SERVICE_TYPE
,      _DF
,      START_DATE
,      COMPLETION_DATE
,      _LA:PM_PRODUCT
,      PM_TASK_REFERENCE
,      PARENT_TASK_ID
,      TOP_TASK_ID
,      PROJECT_ID
,      CARRYING_OUT_ORGANIZATION_ID
,      TASK_MANAGER_PERSON_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.PABV_TASKS;

Dependencies

[top of page]

APPS.PABV_TASKS references the following:

SchemaAPPS
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS

APPS.PABV_TASKS is not referenced by any database object