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

VIEW: APPS.ICX_EDM_MFG_PLAN_V

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

View Type

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


The ICX_EDM_MFG_PLAN_V view returns manufacturing plan information by
project and task.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN VARCHAR2 (10)
Plan name
PLAN_DESCRIPTION VARCHAR2 (50)
Plan description
PLAN_TYPE_CODE NUMBER

Planning type code
PLAN_TYPE_DESCRIPTION VARCHAR2 (80)
Planning type description
ORGANIZATION_ID NUMBER

Inventory organization unique identifier
ORGANIZATION_NAME VARCHAR2 (240)
Inventory organization name
ORGANIZATION_CODE VARCHAR2 (3)
Inventory organization code
START_DATE DATE

Start date
COMPLETION_DATE DATE

Completion date
PLAN_HORIZON DATE

Plan horizon
PROJECT_ID NUMBER (15)
Project / Seiban unique identifier
TASK_ID NUMBER

Task unique identifier
Query Text

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


SELECT PLAN
,      PLAN_DESCRIPTION
,      PLAN_TYPE_CODE
,      PLAN_TYPE_DESCRIPTION
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      ORGANIZATION_CODE
,      START_DATE
,      COMPLETION_DATE
,      PLAN_HORIZON
,      PROJECT_ID
,      TASK_ID
FROM APPS.ICX_EDM_MFG_PLAN_V;

Dependencies

[top of page]

APPS.ICX_EDM_MFG_PLAN_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
ViewMFG_LOOKUPS
SynonymMRP_DESIGNATORS
SynonymMRP_GROSS_REQUIREMENTS
SynonymMRP_PLANS
SynonymMRP_RECOMMENDATIONS
SynonymMTL_PARAMETERS
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
SynonymPJM_SEIBAN_NUMBERS

APPS.ICX_EDM_MFG_PLAN_V is not referenced by any database object