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

Line 96: FROM GEM_LOOKUPS

92:
93: CURSOR c_get_priority ( p_priority VARCHAR2)
94: IS
95: SELECT meaning
96: FROM GEM_LOOKUPS
97: WHERE LOOKUP_TYPE = 'GMD_QC_TEST_PRIORITY'
98: AND LOOKUP_CODE = p_priority;
99:
100: CURSOR c_get_source ( p_source VARCHAR2)

Line 103: FROM GEM_LOOKUPS

99:
100: CURSOR c_get_source ( p_source VARCHAR2)
101: IS
102: SELECT meaning
103: FROM GEM_LOOKUPS
104: WHERE LOOKUP_TYPE = 'GMD_QC_SOURCE'
105: AND LOOKUP_CODE = p_source;
106:
107: --JD changed plant_code to organization_id.

Line 256: FROM GEM_LOOKUPS

252:
253: -- Bug 3088216: added retain as to sample labels
254: CURSOR c_get_retain_as(p_retain_as VARCHAR2) IS
255: SELECT meaning
256: FROM GEM_LOOKUPS
257: WHERE LOOKUP_TYPE = 'GMD_QC_RETAIN_AS'
258: AND LOOKUP_CODE = p_retain_as;
259:
260: --JD Added cursor to get orgn_code for display.