[Home] [Help]
View: MFG_LOOKUPS
Product: | INV - Inventory |
Description: | MFG_LOOKUPS is a view of selected columns from the table FND_LOOKUP_VALUES. |
Implementation/DBA Data: |
APPS.MFG_LOOKUPS
|
View Text
SELECT LV. LOOKUP_TYPE
, TO_NUMBER( LV.LOOKUP_CODE) LOOKUP_CODE
, LV. MEANING
, LV. DESCRIPTION
, LV. ENABLED_FLAG
, LV. START_DATE_ACTIVE
, LV. END_DATE_ACTIVE
, LV. CREATED_BY
, LV. CREATION_DATE
, LV. LAST_UPDATE_DATE
, LV. LAST_UPDATED_BY
, LV. LAST_UPDATE_LOGIN
FROM FND_LOOKUP_VALUES LV
WHERE LV.LANGUAGE = USERENV('LANG')
AND LV.VIEW_APPLICATION_ID = 700
AND LV.SECURITY_GROUP_ID = 0
Columns
Name |
LOOKUP_TYPE |
LOOKUP_CODE |
MEANING |
DESCRIPTION |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |