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

VIEW: APPS.ICX_EDM_PROJECT_TASK_V

Object Details
Object Name: ICX_EDM_PROJECT_TASK_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_EDM_PROJECT_TASK_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


The ICX_EDM_PROJECT_TASK_V view returns all tasks.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER (15) Yes Task unique identifier
TASK_NUMBER VARCHAR2 (25) Yes Task number
NAME VARCHAR2 (20) Yes Task name
DESCRIPTION VARCHAR2 (250)
Task description
MANAGER VARCHAR2 (240)
Task manager
START_DATE DATE

Task start date
END_DATE DATE

Task end date
ORGANIZATION_NAME VARCHAR2 (240) Yes Task owning organization name
ORGANIZATION_ID NUMBER (15) Yes Task owning organization unique identifier
LOCATION_CODE VARCHAR2 (60)
Task owning orgniazation location
LOCATION_DESCRIPTION VARCHAR2 (240)
Task owning organization location description
PROJECT_ID NUMBER (15) Yes Project unique identifier
PROJECT_NUMBER VARCHAR2 (25) Yes Project number
PROJECT_NAME VARCHAR2 (30) Yes Project name
PROJECT_DESCRIPTION VARCHAR2 (250)
Project description
Query Text

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


SELECT TASK_ID
,      TASK_NUMBER
,      NAME
,      DESCRIPTION
,      MANAGER
,      START_DATE
,      END_DATE
,      ORGANIZATION_NAME
,      ORGANIZATION_ID
,      LOCATION_CODE
,      LOCATION_DESCRIPTION
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_DESCRIPTION
FROM APPS.ICX_EDM_PROJECT_TASK_V;

Dependencies

[top of page]

APPS.ICX_EDM_PROJECT_TASK_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
ViewPER_PEOPLE_F

APPS.ICX_EDM_PROJECT_TASK_V is not referenced by any database object