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

Line 5321: gem_lookups l

5317: CURSOR Cur_disposition(p_sample_id NUMBER) IS
5318: SELECT l.lookup_code,
5319: l.meaning
5320: FROM gmd_sample_spec_disp ssd,
5321: gem_lookups l
5322: WHERE ssd.sample_id = p_sample_id
5323: AND l.lookup_type = 'GMD_QC_SAMPLE_DISP'
5324: AND l.lookup_code = ssd.disposition ;
5325:

Line 6162: gem_lookups gem

6158: /* CURSOR Cur_formulaline IS
6159: SELECT fd.line_no,
6160: gem.meaning
6161: FROM fm_matl_dtl fd,
6162: gem_lookups gem
6163: WHERE fd.formula_id = P_formula_id
6164: AND fd.formulaline_id = P_formulaline_id
6165: AND fd.inventory_item_id = P_inventory_item_id
6166: AND gem.lookup_type = 'GMD_FORMULA_ITEM_TYPE'

Line 6173: gem_lookups gem

6169: CURSOR Cur_batchline IS
6170: SELECT line_no,
6171: gem.meaning
6172: FROM gme_material_details md,
6173: gem_lookups gem
6174: WHERE batch_id = P_batch_id
6175: AND material_detail_id = P_material_detail_id
6176: AND inventory_item_id = P_inventory_item_id
6177: AND organization_id = P_organization_id