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

VIEW: APPS.EDW_PLAN_NAME_FKV

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

View Type

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


This view builds and returns foreign keys to the Plan Name dimension. Plan Name foreign keys are based on lookup code values found in the MRP_PLAN_TYPE lookup type.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_FK VARCHAR2 (82)
Plan Name foreign key
COMPILE_DESIGNATOR VARCHAR2 (10) Yes Compile Designator: MPS, MRP or DRP plan identifier
ORGANIZATION_ID NUMBER
Yes Organization Id
Query Text

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


SELECT PLAN_FK
,      COMPILE_DESIGNATOR
,      ORGANIZATION_ID
FROM APPS.EDW_PLAN_NAME_FKV;

Dependencies

[top of page]

APPS.EDW_PLAN_NAME_FKV references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
ViewMFG_LOOKUPS
SynonymMRP_PLANS
SynonymMTL_PARAMETERS

APPS.EDW_PLAN_NAME_FKV is not referenced by any database object