[Home] [Help]
View: EDW_MRP_DCDM_DM_LCV
Product: | ISC - Supply Chain Intelligence |
Description: | This is the collection view for the Demand Class level of the Demand Class dimension |
Implementation/DBA Data: |
APPS.EDW_MRP_DCDM_DM_LCV
|
View Text
SELECT FND.LOOKUP_CODE||'-'||INST.INSTANCE_CODE
, 'ALL'
, FND.CREATION_DATE
, FND.LOOKUP_CODE
, FND.MEANING||'-'||INST.INSTANCE_CODE
, FND.DESCRIPTION
, INST.INSTANCE_CODE
, FND.LAST_UPDATE_DATE
, FND.MEANING
, NULL
, NULL
, NULL
, NULL
, NULL
FROM FND_LOOKUP_VALUES FND
, EDW_LOCAL_INSTANCE INST
WHERE FND.LOOKUP_TYPE='DEMAND_CLASS'
AND FND.LANGUAGE = USERENV('LANG')
AND FND.VIEW_APPLICATION_ID = 3
AND FND.SECURITY_GROUP_ID = 0
Columns
Name |
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 |