[Home] [Help]
[Dependency Information]
VIEW: APPS.GEM_LOOKUPS
Object Details
Object Name: | GEM_LOOKUPS |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMA.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:
-
APPS
-
FND_LOOKUP_VALUES
APPS.GEM_LOOKUPS is referenced by following:
-
APPS
-
GMA_VALID_GRP
- show dependent code
-
GMA_VALID_GRP
- show dependent code
-
GMDFMVAL_PUB
- show dependent code
-
GMDQSPEC_APPROVAL_WF_PKG
- show dependent code
-
GMDQSVRS_APPROVAL_WF_PKG
- show dependent code
-
GMD_COA_DATA_OM
- show dependent code
-
GMD_CONC_REPLACE_PKG
- show dependent code
-
GMD_ERES_UTILS
- show dependent code
-
GMD_MBR_MATERIAL_V1
-
GMD_MBR_STEP_MATERIAL_V1
-
GMD_PARAMETERS_DTL_PKG
- show dependent code
-
GMD_QCR01USR_XMLP_PKG
- show dependent code
-
GMD_QCR02USR_XMLP_PKG
- show dependent code
-
GMD_QCR03USR_XMLP_PKG
- show dependent code
-
GMD_QCRCOA03_XMLP_PKG
- show dependent code
-
GMD_QC_ERES_UTILS
- show dependent code
-
GMD_QC_LABELS_UTIL
- show dependent code
-
GMD_QC_RESULTS_TREE_V
-
GMD_QC_TESTS_GRP
- show dependent code
-
GMD_QMREJ
- show dependent code
-
GMD_QMSED
- show dependent code
-
GMD_QMSMC
- show dependent code
-
GMD_QM_CONC_REPLACE_PKG
- show dependent code
-
GMD_RESULTS_GRP
- show dependent code
-
GMD_SAMPLES_GRP
- show dependent code
-
GMD_SAMPLES_PUB
- show dependent code
-
GMD_SPEC_VRS_GRP
- show dependent code
-
GMD_SS_APPROVAL_WF_PKG
- show dependent code
-
GMD_TEST_INTERVAL_PLANS_GRP
- show dependent code
-
GME_API_PUB
- show dependent code
-
GME_BATCHSTEP_RSRC_PVT
- show dependent code
-
GME_BATCH_STEPS_V
-
GME_MATERIAL_DETAILS_V
-
GME_MOBILE_LOVS
- show dependent code
-
GME_STEP_MATERIAL_DETAILS_V
-
GMF_MIGRATION
- show dependent code
-
GMF_SUBLEDGER_PKG
- show dependent code
-
GMF_SUBLEDGER_REPORT
- show dependent code
-
GMI_VALID_GRP
- show dependent code
-
GML_GMLUNALC_XMLP_PKG
- show dependent code
-
GML_ORUARPJ_XMLP_PKG
- show dependent code
-
GMP_EAM_JOBS_RESOURCES_V
-
IC_ITEM_HIERARCHY_V
-
INV_LABEL_PVT15
- show dependent code
-
MTL_MFG_BATCHES_SECURITY_V
-
MTL_MFG_BATCHES_V
-
MTL_WORK_ORDER_HEADER_V
-
OPI_EDW_JOB_DETAIL_FOPM_SZ
- show dependent code
-
OPI_EDW_OPM_JOB_DETAIL_FCV
-
PMIFV_BATCH_STATUS_V
-
PMIFV_BTCH_QCRSLT_V
-
PMIFV_QCRESULT_V
-
PMITS_ITEM_MASTER_V
-
PMITS_QC_SAMPLES_V
-
PMITS_RECIPE_VALIDITY_RULE_V
-
PMITS_ROUTING_DETAIL_V
-
PMITS_WAREHOUSE_MASTER_V
-
PMI_COST_ANALZ_PACK
- show dependent code
-
PMI_COST_ANALZ_PACK
- show dependent code