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


VIEW: APPS.IGI_LOOKUPS

Object Details
Object Name: IGI_LOOKUPS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGI.IGI_LOOKUPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


IGI_LOOKUPS is a view of selected columns from the table
FND_LOOKUP_VALUES. This view contains information about the
available QuickCodes in the language under which Oracle Applications
is currently running at your site. Oracle Application Object Library uses
this view to display information for LOVs.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes As FND_LOOKUP_VALUES table
LOOKUP_CODE VARCHAR2 (30) Yes As FND_LOOKUP_VALUES table
MEANING VARCHAR2 (80) Yes As FND_LOOKUP_VALUES table
DESCRIPTION VARCHAR2 (240)
As FND_LOOKUP_VALUES table
ENABLED_FLAG VARCHAR2 (1) Yes As FND_LOOKUP_VALUES table
START_DATE_ACTIVE DATE

As FND_LOOKUP_VALUES table
END_DATE_ACTIVE DATE

As FND_LOOKUP_VALUES table
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
FROM APPS.IGI_LOOKUPS;

Dependencies

[top of page]

APPS.IGI_LOOKUPS references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.IGI_LOOKUPS is referenced by following:

SchemaAPPS
Package BodyIGC_CC_ARCHIVE_PURGE_PKG - show dependent code
Package BodyIGC_CC_COMPLETE_COVER_PKG - show dependent code
Package BodyIGC_CC_MPFS_PROCESS_PKG - show dependent code
Package BodyIGC_CC_OPEN_INTERFACE_PKG - show dependent code
Package BodyIGC_CC_REVALUE_PROCESS_PKG - show dependent code
Package BodyIGC_CC_REVAL_FIX_PROCESS_PKG - show dependent code
Package BodyIGC_CC_YEP_PROCESS_PKG - show dependent code
Package BodyIGC_UPGRADE_DATA_R12 - show dependent code
Package BodyIGIDOSL - show dependent code
Package BodyIGIRCBAP - show dependent code
Package BodyIGIRRPI - show dependent code
Package BodyIGIRX_IAC_PROJ - show dependent code
ViewIGI_AR_CUSTOMERS_V
ViewIGI_CBR_GL_JOURNAL_SOURCES_V
Package BodyIGI_CIS2007_CDROM_PKG - show dependent code
Package BodyIGI_CIS2007_IGIPPADR_PKG - show dependent code
Package BodyIGI_CIS2007_IGIPSUPR_PKG - show dependent code
Package BodyIGI_CIS2007_IGIPVERP_PKG - show dependent code
Package BodyIGI_CIS_IGIPMTHP_PKG - show dependent code
ViewIGI_EXP_DUS_IN_TUS_V
ViewIGI_EXP_DUS_NOT_IN_TUS_V
ViewIGI_EXP_DUS_V
ViewIGI_EXP_EPTU_TRANS_V
ViewIGI_EXP_TRAN_UNIT_V
ViewIGI_EXP_TUS_V
ViewIGI_GCC_GL_FA_INST_OPS
ViewIGI_GCC_INSTALLED_OPTIONS
Package BodyIGI_GEN - show dependent code
Package BodyIGI_GEN_VERT - show dependent code
Package BodyIGI_IAC_EXTRACT_PKG - show dependent code
Package BodyIGI_IGIPSAPR_XMLP_PKG - show dependent code
Package BodyIGI_IGIPSIAP_XMLP_PKG - show dependent code
ViewIGI_ITR_CHARGE_HEADERS_SS_V
ViewIGI_ITR_CHARGE_HEADERS_V
ViewIGI_ITR_CHARGE_LINES_SS_V
ViewIGI_RPI_UPDATE_HDR_V
ViewIGI_SAP_EXCEPTIONS_V
ViewIGI_STP_BATCHES_V
ViewIGI_STP_PACKAGES_V