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

VIEW: APPS.EDW_MRP_PNDM_PLN_LCV

Object Details
Object Name: EDW_MRP_PNDM_PLN_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewISC.EDW_MRP_PNDM_PLN_LCV
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is used by the Plan Name collection program to retrieve Plan level information from the MRP_PLAN_TYPE lookup type.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_NAME_PK VARCHAR2 (82)
Unique identifier
COMPLETION_DATE DATE

Date/time the Plan was completed
CREATION_DATE DATE
Yes Standard Who column
DESCRIPTION VARCHAR2 (50)
Plan description
INCLUDE_PO_FLAG NUMBER

Flag to indicate if Purchase Orders were included in the plan
INCLUDE_WIP_FLAG NUMBER

Flag to indicate if Work in Process inventories were included in the plan
INSTANCE VARCHAR2 (30)
Instance code refering to the source application
LAST_UPDATE_DATE DATE
Yes Standard Who column
NAME VARCHAR2 (15)
Alternate Plan name
PLAN_CUTOFF_DATE DATE

Cutoff date of the plan. The cutoff date is used to determine the end date when selecting entries into the plan (for example, when loading forecast entries into the plan, end date = cutoff date + carry forward days).
PLAN_NAME VARCHAR2 (15)
Plan name
PLAN_NAME_DP VARCHAR2 (45)
Unique Plan name
PLAN_RESERVE_FLAG NUMBER

Flag to indicate if supply was reserved against demand
PLAN_SAFETY_STOCK NUMBER

Flag to indicate if safety stock was calculated for each item during the execution of the plan
PLAN_TYPE VARCHAR2 (80) Yes Type of the plan. Indicates if the Plan was an MRP, CRP, MPS, or Supply Chain plan.
USER_ATTRIBUTE1 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User attribute
Query Text

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


SELECT PLAN_NAME_PK
,      COMPLETION_DATE
,      CREATION_DATE
,      DESCRIPTION
,      INCLUDE_PO_FLAG
,      INCLUDE_WIP_FLAG
,      INSTANCE
,      LAST_UPDATE_DATE
,      NAME
,      PLAN_CUTOFF_DATE
,      PLAN_NAME
,      PLAN_NAME_DP
,      PLAN_RESERVE_FLAG
,      PLAN_SAFETY_STOCK
,      PLAN_TYPE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM APPS.EDW_MRP_PNDM_PLN_LCV;

Dependencies

[top of page]

APPS.EDW_MRP_PNDM_PLN_LCV references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
ViewMFG_LOOKUPS
SynonymMRP_PLANS
SynonymMTL_PARAMETERS

APPS.EDW_MRP_PNDM_PLN_LCV is not referenced by any database object