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

VIEW: APPS.ICX_EDM_PROJECT_V

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

View Type

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


The ICX_EDM_PROJECT_V view returns project summary information for all
projects and seibans.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15)
Project / Seiban unique identifier
PROJECT_NUMBER VARCHAR2 (25)
Project / Seiban number
NAME VARCHAR2 (30)
Project / Seiban name
DESCRIPTION VARCHAR2 (250)
Project / Seiban description
ORGANIZATION_ID NUMBER

Project owning organization unique identifier
ORGANIZATION_NAME VARCHAR2 (240)
Project owning organization name
CATEGORY VARCHAR2 (0)
Project category - currently not used
TYPE VARCHAR2 (20)
Project type
STATUS VARCHAR2 (30)
Project status code
STATUS_DSP VARCHAR2 (80)
Project status name
START_DATE DATE

Project start date
END_DATE DATE

Project end date
LAST_ACCUMULATED_PERIOD VARCHAR2 (0)
Last project accumulation period - currently not used
Query Text

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


SELECT PROJECT_ID
,      PROJECT_NUMBER
,      NAME
,      DESCRIPTION
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      CATEGORY
,      TYPE
,      STATUS
,      STATUS_DSP
,      START_DATE
,      END_DATE
,      LAST_ACCUMULATED_PERIOD
FROM APPS.ICX_EDM_PROJECT_V;

Dependencies

[top of page]

APPS.ICX_EDM_PROJECT_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPA_PROJECTS_ALL
SynonymPA_PROJECT_STATUSES
SynonymPJM_SEIBAN_NUMBERS

APPS.ICX_EDM_PROJECT_V is not referenced by any database object