eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QMREJ dependencies on GEM_LOOKUPS

Line 66: from gmd_sampling_events gse, mtl_parameters mp, gem_lookups glk

62:
63: /*Cursor to get the common fields in the workflow notification*/
64: CURSOR common_fields IS
65: select mp.organization_code, gse.sample_type, glk.meaning
66: from gmd_sampling_events gse, mtl_parameters mp, gem_lookups glk
67: where gse.sampling_event_id = l_event_key
68: and gse.organization_id = mp.organization_id
69: and glk.lookup_type = 'GMD_QC_SPEC_TYPE'
70: and gse.sample_type = glk.lookup_code;

Line 74: from gmd_sampling_events gse, gem_lookups glk

70: and gse.sample_type = glk.lookup_code;
71:
72: CURSOR common_fields1 IS
73: select glk.meaning
74: from gmd_sampling_events gse, gem_lookups glk
75: where gse.sampling_event_id = l_event_key
76: and glk.lookup_type = 'GMD_QC_SOURCE'
77: and gse.source = glk.lookup_code;
78:

Line 81: from gmd_sampling_events gse, gem_lookups glk

77: and gse.source = glk.lookup_code;
78:
79: CURSOR common_fields2 IS
80: select glk.meaning
81: from gmd_sampling_events gse, gem_lookups glk
82: where gse.sampling_event_id = l_event_key
83: and glk.lookup_type = 'GMD_QC_MONITOR_RULE_TYPE'
84: and gse.source = glk.lookup_code;
85: