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


VIEW: APPS.PA_WORKPLAN_OPTIONS_V

Object Details
Object Name: PA_WORKPLAN_OPTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_WORKPLAN_OPTIONS_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
STRUCTURE_NAME VARCHAR2 (240) Yes
WP_DEFAULT_DISPLAY_LVL NUMBER (15) Yes
WP_APPROVAL_REQD_FLAG VARCHAR2 (1) Yes
WP_AUTO_PUBLISH_FLAG VARCHAR2 (1) Yes
WP_APPROVER_SOURCE_ID NUMBER (15)
WP_APPROVER_SOURCE_TYPE NUMBER (15)
WP_APPROVER_NAME VARCHAR2 (4000)
ENABLE_WP_VERSION_FLAG VARCHAR2 (1) Yes
AUTO_PUB_UPON_CREATION_FLAG VARCHAR2 (1) Yes
AUTO_SYNC_TXN_DATE_FLAG VARCHAR2 (1) Yes
TXN_DATE_SYNC_BUF_DAYS NUMBER (15)
LIFE_CYCLE_NAME VARCHAR2 (240)
SHORT_LIFE_CYCLE_NAME VARCHAR2 (100)
LIFE_CYCLE_VERSION_ID NUMBER (15)
PHASE_CODE VARCHAR2 (150)
PHASE_NAME VARCHAR2 (240)
SHORT_PHASE_NAME VARCHAR2 (100)
PHASE_VERSION_ID NUMBER (15)
WQ_ENABLE_FLAG VARCHAR2 (1)
PROJ_PROGRESS_ATTR_ID NUMBER (15) Yes
PROG_RECORD_VERSION_NUMBER NUMBER (15)
PPWA_RECORD_VERSION_NUMBER NUMBER (15)
PPE_RECORD_VERSION_NUMBER NUMBER (15)
SCHEDULE_THIRD_PARTY_FLAG VARCHAR2 (1)
ALLOW_LOWEST_TSK_DEP_FLAG VARCHAR2 (1)
AUTO_ROLLUP_SUBPROJ_FLAG VARCHAR2 (1)
THIRD_PARTY_SCHEDULE_CODE VARCHAR2 (30)
ENABLE_WF_FLAG VARCHAR2 (1)
USE_TASK_SCHEDULE_FLAG VARCHAR2 (1)
Query Text

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


SELECT PROJECT_ID
,      PROJ_ELEMENT_ID
,      STRUCTURE_NAME
,      WP_DEFAULT_DISPLAY_LVL
,      WP_APPROVAL_REQD_FLAG
,      WP_AUTO_PUBLISH_FLAG
,      WP_APPROVER_SOURCE_ID
,      WP_APPROVER_SOURCE_TYPE
,      WP_APPROVER_NAME
,      ENABLE_WP_VERSION_FLAG
,      AUTO_PUB_UPON_CREATION_FLAG
,      AUTO_SYNC_TXN_DATE_FLAG
,      TXN_DATE_SYNC_BUF_DAYS
,      LIFE_CYCLE_NAME
,      SHORT_LIFE_CYCLE_NAME
,      LIFE_CYCLE_VERSION_ID
,      PHASE_CODE
,      PHASE_NAME
,      SHORT_PHASE_NAME
,      PHASE_VERSION_ID
,      WQ_ENABLE_FLAG
,      PROJ_PROGRESS_ATTR_ID
,      PROG_RECORD_VERSION_NUMBER
,      PPWA_RECORD_VERSION_NUMBER
,      PPE_RECORD_VERSION_NUMBER
,      SCHEDULE_THIRD_PARTY_FLAG
,      ALLOW_LOWEST_TSK_DEP_FLAG
,      AUTO_ROLLUP_SUBPROJ_FLAG
,      THIRD_PARTY_SCHEDULE_CODE
,      ENABLE_WF_FLAG
,      USE_TASK_SCHEDULE_FLAG
FROM APPS.PA_WORKPLAN_OPTIONS_V;

Dependencies

[top of page]

APPS.PA_WORKPLAN_OPTIONS_V references the following:

SchemaAPPS
SynonymPA_PROJ_ELEMENTS
SynonymPA_PROJ_ELEMENT_VERSIONS
SynonymPA_PROJ_PROGRESS_ATTR
SynonymPA_PROJ_WORKPLAN_ATTR
PL/SQL PackagePA_RESOURCE_UTILS - show dependent code
APPS.PA_WORKPLAN_OPTIONS_V is referenced by following:

SchemaAPPS
Package BodyPA_FP_PLANNING_TRANSACTION_PUB - show dependent code
Package BodyPA_TASK_ASSIGNMENT_UTILS - show dependent code
Package BodyPJI_REP_UTIL - show dependent code