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

VIEW: APPS.EDW_MRP_DCDM_DM_LCV

Object Details
Object Name: EDW_MRP_DCDM_DM_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewISC.EDW_MRP_DCDM_DM_LCV
ViewMRP.EDW_MRP_DCDM_DM_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 Demand Class collection program to retrieve Demand Class level information from the DEMAND_CLASS lookup type.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DEMAND_CLASS_PK VARCHAR2 (61)
Unique identifier
ALL_FK CHAR (3)
Foreign key to the top level of the Demand Class dimension
CREATION_DATE DATE
Yes Standard Who column
DEMAND_CLASS VARCHAR2 (30) Yes Demand Class
DEMAND_CLASS_DP VARCHAR2 (111)
Unique Demand Class name
DESCRIPTION VARCHAR2 (240)
Demand Class description
INSTANCE_CODE VARCHAR2 (30)
Instance code refering to the source application
LAST_UPDATE_DATE DATE
Yes Standard Who column
NAME VARCHAR2 (80) Yes Alternate Demand Class name
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 DEMAND_CLASS_PK
,      ALL_FK
,      CREATION_DATE
,      DEMAND_CLASS
,      DEMAND_CLASS_DP
,      DESCRIPTION
,      INSTANCE_CODE
,      LAST_UPDATE_DATE
,      NAME
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM APPS.EDW_MRP_DCDM_DM_LCV;

Dependencies

[top of page]

APPS.EDW_MRP_DCDM_DM_LCV references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
SynonymFND_LOOKUP_VALUES

APPS.EDW_MRP_DCDM_DM_LCV is not referenced by any database object