[Home] [Help]
View: AMW_LOOKUPS
| Product: | AMW - Internal Controls Manager (Obsolete) |
|---|
| Description: | selection of lookups from fnd_lookup_values for ICM product |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, TAG
FROM FND_LOOKUP_VALUES
WHERE LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = '242'
AND SECURITY_GROUP_ID = TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 1)
, ' '
, '0'
, NULL
, '0'
, SUBSTRB(USERENV('CLIENT_INFO')
, 55
, 10)))
Columns
| Name |
| LOOKUP_TYPE |
| LOOKUP_CODE |
| MEANING |
| DESCRIPTION |
| ENABLED_FLAG |
| START_DATE_ACTIVE |
| END_DATE_ACTIVE |
| TAG |