DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MFG_LOOKUPS_V

Object Details
Object Name: MFG_LOOKUPS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MFG_LOOKUPS_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


MFG_LOOKUPS_V 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.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes Lookup Type
LOOKUP_CODE VARCHAR2 (30) Yes Lookup Code
MEANING VARCHAR2 (80) Yes Meaning
DESCRIPTION VARCHAR2 (240)
Description
ENABLED_FLAG VARCHAR2 (1) Yes Enabled Flag
START_DATE_ACTIVE DATE

Start Date
END_DATE_ACTIVE DATE

End Date
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
Query Text

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_V;

Dependencies

[top of page]

APPS.MFG_LOOKUPS_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.MFG_LOOKUPS_V is referenced by following:

SchemaAPPS
Package BodyWMS_RULES_WORKBENCH_PVT - show dependent code