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


VIEW: APPS.GEM_LOOKUPS

Object Details
Object Name: GEM_LOOKUPS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMA.GEM_LOOKUPS
Subobject Name:
Status: VALID

View Type

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


View of all OPM Lookups


[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 value meaning
DESCRIPTION VARCHAR2 (240)
value description
ENABLED_FLAG VARCHAR2 (1) Yes enabled flag
START_DATE_ACTIVE DATE

start active date
END_DATE_ACTIVE DATE

end active date
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.GEM_LOOKUPS;

Dependencies

[top of page]

APPS.GEM_LOOKUPS references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.GEM_LOOKUPS is referenced by following:

SchemaAPPS
PL/SQL PackageGMA_VALID_GRP - show dependent code
Package BodyGMA_VALID_GRP - show dependent code
Package BodyGMDFMVAL_PUB - show dependent code
Package BodyGMDQSPEC_APPROVAL_WF_PKG - show dependent code
Package BodyGMDQSVRS_APPROVAL_WF_PKG - show dependent code
Package BodyGMD_COA_DATA_OM - show dependent code
Package BodyGMD_CONC_REPLACE_PKG - show dependent code
Package BodyGMD_ERES_UTILS - show dependent code
ViewGMD_MBR_MATERIAL_V1
ViewGMD_MBR_STEP_MATERIAL_V1
Package BodyGMD_PARAMETERS_DTL_PKG - show dependent code
Package BodyGMD_QCR01USR_XMLP_PKG - show dependent code
Package BodyGMD_QCR02USR_XMLP_PKG - show dependent code
Package BodyGMD_QCR03USR_XMLP_PKG - show dependent code
Package BodyGMD_QCRCOA03_XMLP_PKG - show dependent code
Package BodyGMD_QC_ERES_UTILS - show dependent code
Package BodyGMD_QC_LABELS_UTIL - show dependent code
ViewGMD_QC_RESULTS_TREE_V
Package BodyGMD_QC_TESTS_GRP - show dependent code
Package BodyGMD_QMREJ - show dependent code
Package BodyGMD_QMSED - show dependent code
Package BodyGMD_QMSMC - show dependent code
Package BodyGMD_QM_CONC_REPLACE_PKG - show dependent code
Package BodyGMD_RESULTS_GRP - show dependent code
Package BodyGMD_SAMPLES_GRP - show dependent code
Package BodyGMD_SAMPLES_PUB - show dependent code
Package BodyGMD_SPEC_VRS_GRP - show dependent code
Package BodyGMD_SS_APPROVAL_WF_PKG - show dependent code
Package BodyGMD_TEST_INTERVAL_PLANS_GRP - show dependent code
Package BodyGME_API_PUB - show dependent code
Package BodyGME_BATCHSTEP_RSRC_PVT - show dependent code
ViewGME_BATCH_STEPS_V
ViewGME_MATERIAL_DETAILS_V
Package BodyGME_MOBILE_LOVS - show dependent code
ViewGME_STEP_MATERIAL_DETAILS_V
Package BodyGMF_MIGRATION - show dependent code
Package BodyGMF_SUBLEDGER_PKG - show dependent code
Package BodyGMF_SUBLEDGER_REPORT - show dependent code
Package BodyGMI_VALID_GRP - show dependent code
Package BodyGML_GMLUNALC_XMLP_PKG - show dependent code
Package BodyGML_ORUARPJ_XMLP_PKG - show dependent code
ViewGMP_EAM_JOBS_RESOURCES_V
ViewIC_ITEM_HIERARCHY_V
Package BodyINV_LABEL_PVT15 - show dependent code
ViewMTL_MFG_BATCHES_SECURITY_V
ViewMTL_MFG_BATCHES_V
ViewMTL_WORK_ORDER_HEADER_V
Package BodyOPI_EDW_JOB_DETAIL_FOPM_SZ - show dependent code
ViewOPI_EDW_OPM_JOB_DETAIL_FCV
ViewPMIFV_BATCH_STATUS_V
ViewPMIFV_BTCH_QCRSLT_V
ViewPMIFV_QCRESULT_V
ViewPMITS_ITEM_MASTER_V
ViewPMITS_QC_SAMPLES_V
ViewPMITS_RECIPE_VALIDITY_RULE_V
ViewPMITS_ROUTING_DETAIL_V
ViewPMITS_WAREHOUSE_MASTER_V
Package BodyPMI_COST_ANALZ_PACK - show dependent code
PL/SQL PackagePMI_COST_ANALZ_PACK - show dependent code