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.GMDQSVRS_APPROVAL_WF_PKG dependencies on GEM_LOOKUPS

Line 273: FROM gem_lookups

269: l_item_desc mtl_system_items_kfv.description%TYPE;
270:
271: CURSOR get_meaning (v_code VARCHAR2) IS
272: SELECT meaning
273: FROM gem_lookups
274: WHERE lookup_type = 'GMD_ERES_SOURCE'
275: AND lookup_code = v_code;
276:
277: l_lookup_code gem_lookups.meaning%TYPE;

Line 277: l_lookup_code gem_lookups.meaning%TYPE;

273: FROM gem_lookups
274: WHERE lookup_type = 'GMD_ERES_SOURCE'
275: AND lookup_code = v_code;
276:
277: l_lookup_code gem_lookups.meaning%TYPE;
278:
279: CURSOR get_location (v_loc_id NUMBER) IS
280: SELECT concatenated_segments loc
281: FROM mtl_item_locations_kfv

Line 308: GEM_LOOKUPS src_type ,

304: FROM GMD_MONITORING_SPEC_VRS V ,
305: GMD_SPECIFICATIONS_B S,
306: GMD_QC_STATUS_TL p,
307: GMD_QC_STATUS_TL t,
308: GEM_LOOKUPS src_type ,
309: MTL_ITEM_LOCATIONS_KFV locations,
310: MTL_PARAMETERS a,
311: HR_ALL_ORGANIZATION_UNITS hou
312: WHERE V.SPEC_ID = S.SPEC_ID