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 4676: gem_lookups l

4672: CURSOR Cur_disposition(p_sample_id NUMBER) IS
4673: SELECT l.lookup_code,
4674: l.meaning
4675: FROM gmd_sample_spec_disp ssd,
4676: gem_lookups l
4677: WHERE ssd.sample_id = p_sample_id
4678: AND l.lookup_type = 'GMD_QC_SAMPLE_DISP'
4679: AND l.lookup_code = ssd.disposition ;
4680:

Line 5494: gem_lookups gem

5490: /* CURSOR Cur_formulaline IS
5491: SELECT fd.line_no,
5492: gem.meaning
5493: FROM fm_matl_dtl fd,
5494: gem_lookups gem
5495: WHERE fd.formula_id = P_formula_id
5496: AND fd.formulaline_id = P_formulaline_id
5497: AND fd.inventory_item_id = P_inventory_item_id
5498: AND gem.lookup_type = 'GMD_FORMULA_ITEM_TYPE'

Line 5505: gem_lookups gem

5501: CURSOR Cur_batchline IS
5502: SELECT line_no,
5503: gem.meaning
5504: FROM gme_material_details md,
5505: gem_lookups gem
5506: WHERE batch_id = P_batch_id
5507: AND material_detail_id = P_material_detail_id
5508: AND inventory_item_id = P_inventory_item_id
5509: AND organization_id = P_organization_id