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

VIEW: APPS.PA_STRUCT_TASK_WBS_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes The Project Id
TASK_ID NUMBER (15) Yes The Task Id
TASK_NUMBER VARCHAR2 (100)
The Task Number
TASK_NAME VARCHAR2 (240) Yes The Task Name
TOP_TASK_ID NUMBER

The Top Task Id
TOP_TASK_VER_ID NUMBER

The Top Task Version Id
TASK_LEVEL VARCHAR2 (4000)
The WBS Level of the financial task, T-> Top Task, M -> Middle Task,L -> Lowest Task and X -> Not Financial Task
PARENT_TASK_ID NUMBER

The Parent Task Id
PARENT_TASK_VERSION_ID NUMBER

The Parent Task Version Id
PARENT_STRUCTURE_ID NUMBER (15)
The Parent Structure Id
PARENT_STRUCTURE_VERSION_ID NUMBER (15)
The Parent Structure Version Id
ELEMENT_VERSION_ID NUMBER (15) Yes The Element Version Id
START_DATE DATE

The Start Date
COMPLETION_DATE DATE

The Completion Date
TRANSACTION_START_DATE DATE

TRANSACTION_COMPLETION_DATE DATE

ACTUAL_START_DATE DATE

ACTUAL_FINISH_DATE DATE

ESTIMATED_START_DATE DATE

ESTIMATED_FINISH_DATE DATE

FINANCIAL_TASK_FLAG VARCHAR2 (1)
The financial task flag
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      TOP_TASK_ID
,      TOP_TASK_VER_ID
,      TASK_LEVEL
,      PARENT_TASK_ID
,      PARENT_TASK_VERSION_ID
,      PARENT_STRUCTURE_ID
,      PARENT_STRUCTURE_VERSION_ID
,      ELEMENT_VERSION_ID
,      START_DATE
,      COMPLETION_DATE
,      TRANSACTION_START_DATE
,      TRANSACTION_COMPLETION_DATE
,      ACTUAL_START_DATE
,      ACTUAL_FINISH_DATE
,      ESTIMATED_START_DATE
,      ESTIMATED_FINISH_DATE
,      FINANCIAL_TASK_FLAG
FROM APPS.PA_STRUCT_TASK_WBS_V;

Dependencies

[top of page]

APPS.PA_STRUCT_TASK_WBS_V references the following:

SchemaAPPS
SynonymPA_PROJECTS_ALL
SynonymPA_PROJ_ELEMENTS
PL/SQL PackagePA_PROJ_ELEMENTS_UTILS - show dependent code
SynonymPA_PROJ_ELEMENT_VERSIONS
SynonymPA_PROJ_ELEM_VER_SCHEDULE
SynonymPA_TASKS
APPS.PA_STRUCT_TASK_WBS_V is referenced by following:

SchemaAPPS
Package BodyPA_BUDGET_PUB - show dependent code
Package BodyPA_FIN_PLAN_UTILS - show dependent code
PL/SQL PackagePA_FIN_PLAN_UTILS - show dependent code
Package BodyPA_FP_PLANNING_TRANSACTION_PUB - show dependent code
Package BodyPA_PLANNING_TRANSACTION_UTILS - show dependent code