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

VIEW: APPS.PJM_PROJECT_MFG_PLAN_V

Object Details
Object Name: PJM_PROJECT_MFG_PLAN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPJM.PJM_PROJECT_MFG_PLAN_V
Subobject Name:
Status: VALID

View Type

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


PJM_PROJECT_MFG_PLAN_V returns manufacturing plans that include project references in their requirements (demand) or recommendations.
This view corresponds to the Plan Summary web inquiry region.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15)
System-generated number that uniquely identifies a project or seiban
TASK_ID NUMBER (15)
System-generated number that uniquely identifies a task
PLAN_NAME VARCHAR2 (10) Yes MRP plan identifier
PLAN_DESCRIPTION VARCHAR2 (50)
MRP plan description
PLAN_TYPE_CODE NUMBER
Yes Current planning type code, MRP or MPS
PLAN_TYPE VARCHAR2 (80)
Current planning type description
ORGANIZATION_ID NUMBER

Inventory organization unique identifier
ORGANIZATION_NAME VARCHAR2 (240) Yes Inventory organization name
START_DATE DATE

Planner start date and time
COMPLETION_DATE DATE

Planner completion date and time
PLAN_HORIZON DATE
Yes Plan horizon/current plan cutoff date
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      PLAN_NAME
,      PLAN_DESCRIPTION
,      PLAN_TYPE_CODE
,      PLAN_TYPE
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      START_DATE
,      COMPLETION_DATE
,      PLAN_HORIZON
FROM APPS.PJM_PROJECT_MFG_PLAN_V;

Dependencies

[top of page]

APPS.PJM_PROJECT_MFG_PLAN_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
ViewMFG_LOOKUPS
SynonymMRP_DESIGNATORS
SynonymMRP_GROSS_REQUIREMENTS
SynonymMRP_PLANS
SynonymMRP_PLAN_ORGANIZATIONS
SynonymMRP_RECOMMENDATIONS

APPS.PJM_PROJECT_MFG_PLAN_V is not referenced by any database object