ZCA_LOOKUPS
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ZCA
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
LOOKUP_TYPE LOOKUP_CODE SET_ID MEANING DESCRIPTION |
問合せ
| SQL_Statement |
|---|
|
SELECT LOOKUP_TYPE, LOOKUP_CODE, SET_ID, MEANING, DESCRIPTION FROM FND_LOOKUP_VALUES_VL WHERE VIEW_APPLICATION_ID = 10054 AND SET_ID = 0 AND ENABLED_FLAG = 'Y' AND sysdate BETWEEN nvl(START_DATE_ACTIVE,sysdate-1) AND nvl(END_DATE_ACTIVE,sysdate+1) |