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_QMSED dependencies on GEM_LOOKUPS

Line 171: gem_lookups WHERE LOOKUP_TYPE='GMD_QC_SAMPLE_DISP'

167: b.organization_id = a.organization_id;
168:
169:
170: SELECT meaning INTO l_sample_DISPOSITION FROM
171: gem_lookups WHERE LOOKUP_TYPE='GMD_QC_SAMPLE_DISP'
172: AND lookup_code=l_sample_disposition;
173:
174: ELSIF l_event_name = 'oracle.apps.gmd.qm.samplingevent.disposition' THEN
175:

Line 340: gem_lookups WHERE LOOKUP_TYPE='GMD_QC_SOURCE'

336: END IF;
337: l_log:='Resolving Lookups';
338: /* Resolve Lookups */
339: SELECT meaning INTO l_sample_source FROM
340: gem_lookups WHERE LOOKUP_TYPE='GMD_QC_SOURCE'
341: AND lookup_code=l_sample_source;
342:
343: l_log:='Resolved Lookups';
344: /* Get First Approver */