DBA Data[Home] [Help]

APPS.GMD_QMSED dependencies on GEM_LOOKUPS

Line 173: gem_lookups WHERE LOOKUP_TYPE='GMD_QC_SAMPLE_DISP'

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

Line 342: gem_lookups WHERE LOOKUP_TYPE='GMD_QC_SOURCE'

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