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

VIEW: APPS.PA_TASK_DET_SCH_OPT_V

Object Details
Object Name: PA_TASK_DET_SCH_OPT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_TASK_DET_SCH_OPT_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
PROJ_ELEMENT_ID NUMBER (15) Yes
ELEMENT_VERSION_ID NUMBER (15) Yes
DEF_SCH_TOOL_TSK_TYPE_CODE VARCHAR2 (30)
DEF_SCH_TOOL_TSK_TYPE_M VARCHAR2 (4000)
CONSTRAINT_TYPE_CODE VARCHAR2 (30)
CONSTRAINT_TYPE_M VARCHAR2 (4000)
CONSTRAINT_DATE DATE

FREE_SLACK NUMBER (15)
TOTAL_SLACK NUMBER (15)
EFFORT_DRIVEN_FLAG VARCHAR2 (1)
LEVEL_ASSIGNMENTS_FLAG VARCHAR2 (1)
PEVS_RECORD_VERSION_NUMBER NUMBER (15)
ACTUAL_DURATION NUMBER

REMAINING_DURATION NUMBER

SCHEDULED_DURATION NUMBER

Query Text

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


SELECT PROJECT_ID
,      PROJ_ELEMENT_ID
,      ELEMENT_VERSION_ID
,      DEF_SCH_TOOL_TSK_TYPE_CODE
,      DEF_SCH_TOOL_TSK_TYPE_M
,      CONSTRAINT_TYPE_CODE
,      CONSTRAINT_TYPE_M
,      CONSTRAINT_DATE
,      FREE_SLACK
,      TOTAL_SLACK
,      EFFORT_DRIVEN_FLAG
,      LEVEL_ASSIGNMENTS_FLAG
,      PEVS_RECORD_VERSION_NUMBER
,      ACTUAL_DURATION
,      REMAINING_DURATION
,      SCHEDULED_DURATION
FROM APPS.PA_TASK_DET_SCH_OPT_V;

Dependencies

[top of page]

APPS.PA_TASK_DET_SCH_OPT_V references the following:

SchemaAPPS
PL/SQL PackagePA_PROJ_ELEMENTS_UTILS - show dependent code
SynonymPA_PROJ_ELEM_VER_SCHEDULE

APPS.PA_TASK_DET_SCH_OPT_V is not referenced by any database object