[Home] [Help] [Dependency Information]
Object Name: | MFG_LOOKUPS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INV.MFG_LOOKUPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
MFG_LOOKUPS is a view of selected columns from the table
FND_LOOKUP_VALUES. This view contains information about the
available QuickCodes for Orace Manufacturing in the language
under which Oracle Applications is currently running at your site.
Oracle Applications uses this view to display information
for LOVs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Yes | Lookup type |
LOOKUP_CODE | NUMBER | Numeric code of this lookup within its type | ||
MEANING | VARCHAR2 | (80) | Yes | Lookup meaning |
DESCRIPTION | VARCHAR2 | (240) | Description of lookup | |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Whether lookup is enabled or not |
START_DATE_ACTIVE | DATE | Date lookup becomes active | ||
END_DATE_ACTIVE | DATE | Date lookup becomes inactive | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.MFG_LOOKUPS;
|
|
|