[Home] [Help]
View: MRPBV_DEMAND_CLASSES
View Text
SELECT DEMAND_CLASS.LOOKUP_CODE
, DEMAND_CLASS.MEANING
, DEMAND_CLASS.DESCRIPTION
, DEMAND_CLASS.START_DATE_ACTIVE
, DEMAND_CLASS.END_DATE_ACTIVE
, LKUP.MEANING
, DEMAND_CLASS.LAST_UPDATE_DATE
, DEMAND_CLASS.LAST_UPDATED_BY
, DEMAND_CLASS.CREATION_DATE
, DEMAND_CLASS.CREATED_BY
FROM FND_COMMON_LOOKUPS LKUP
, FND_COMMON_LOOKUPS DEMAND_CLASS
WHERE DEMAND_CLASS.LOOKUP_TYPE = 'DEMAND_CLASS'
AND LKUP.LOOKUP_TYPE ='YES_NO'
AND LKUP.LOOKUP_CODE = DEMAND_CLASS.ENABLED_FLAG WITH READ ONLY
Columns
Name |
DEMAND_CLASS |
MEANING |
DESCRIPTION |
START_EFFECTIVE_DATE |
END_EFFECTIVE_DATE |
ENABLED_FLAG |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |