MSC_DIM_ORDER_TYPE_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ID NAME DESCRIPTION LEVEL_ID |
問合せ
| 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 |