MSC_DIM_ORDER_TYPE_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME DESCRIPTION LEVEL_ID

Query

SQL_Statement
SELECT FLV.LOOKUP_CODE AS ID, FLV.MEANING AS NAME, FLV.MEANING AS DESCRIPTION, 76 AS LEVEL_ID FROM FND_LOOKUP_VALUES_VL FLV WHERE FLV.LOOKUP_TYPE ='MSC_ORDER_TYPE' AND to_number (FLV.LOOKUP_CODE) > 0