[Home] [Help] [Dependency Information]
Object Name: | PA_TASKS_PUBLISHING_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_TASKS_PUBLISHING_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ELEMENT_NUMBER | VARCHAR2 | (100) | ||
ELEMENT_NAME | VARCHAR2 | (240) | Yes | |
ELEMENT_VERSION_ID | NUMBER | (15) | Yes | |
PROJ_ELEMENT_ID | NUMBER | (15) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
PARENT_STRUCTURE_VERSION_ID | NUMBER | (15) | ||
DISPLAY_SEQUENCE | NUMBER | (15) | ||
MILESTONE_FLAG | VARCHAR2 | (1) | ||
MILESTONE_FLAG_MEANING | VARCHAR2 | (0) | ||
CRITICAL_FLAG | VARCHAR2 | (1) | ||
CRITICAL_FLAG_MEANING | VARCHAR2 | (0) | ||
PROGRESS_STATUS_CODE | VARCHAR2 | (0) | ||
PROGRESS_STATUS_MEANING | VARCHAR2 | (0) | ||
NEW_SCHEDULED_START_DATE | DATE | |||
NEW_SCHEDULED_FINISH_DATE | DATE | |||
PREVIOUS_SCH_START_DATE | DATE | |||
PREVIOUS_SCH_FINISH_DATE | DATE | |||
START_DATE_VARIANCE | NUMBER | |||
FINISH_DATE_VARIANCE | NUMBER | |||
TASK_MANAGER_ID | NUMBER | (15) | ||
TASK_MANAGER | VARCHAR2 | (240) | ||
WBS_LEVEL | NUMBER | (3) | ||
WBS_NUMBER | VARCHAR2 | (240) | ||
STATUS_ICON_ACTIVE_IND | VARCHAR2 | (0) | ||
PERCENT_COMPLETE_ID | NUMBER | |||
STATUS_ICON_IND | VARCHAR2 | (0) | ||
PRIORITY_CODE | VARCHAR2 | (30) | ||
PRIORITY_DESCRIPTION | VARCHAR2 | (0) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
ORGANIZATION_NAME | VARCHAR2 | (0) | ||
COMPLETED_PERCENTAGE | NUMBER | |||
AS_OF_DATE | VARCHAR2 | (0) |
Cut, paste (and edit) the following text to query this object:
SELECT ELEMENT_NUMBER
, ELEMENT_NAME
, ELEMENT_VERSION_ID
, PROJ_ELEMENT_ID
, PROJECT_ID
, PARENT_STRUCTURE_VERSION_ID
, DISPLAY_SEQUENCE
, MILESTONE_FLAG
, MILESTONE_FLAG_MEANING
, CRITICAL_FLAG
, CRITICAL_FLAG_MEANING
, PROGRESS_STATUS_CODE
, PROGRESS_STATUS_MEANING
, NEW_SCHEDULED_START_DATE
, NEW_SCHEDULED_FINISH_DATE
, PREVIOUS_SCH_START_DATE
, PREVIOUS_SCH_FINISH_DATE
, START_DATE_VARIANCE
, FINISH_DATE_VARIANCE
, TASK_MANAGER_ID
, TASK_MANAGER
, WBS_LEVEL
, WBS_NUMBER
, STATUS_ICON_ACTIVE_IND
, PERCENT_COMPLETE_ID
, STATUS_ICON_IND
, PRIORITY_CODE
, PRIORITY_DESCRIPTION
, ORGANIZATION_ID
, ORGANIZATION_NAME
, COMPLETED_PERCENTAGE
, AS_OF_DATE
FROM APPS.PA_TASKS_PUBLISHING_V;
APPS.PA_TASKS_PUBLISHING_V is not referenced by any database object
|
|
|