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

Line 1707: , gem_lookups gl

1703: SELECT ffm.formula_no, ffm.formula_vers
1704: FROM gmd_recipes grec
1705: , fm_form_mst ffm
1706: , fm_matl_dtl fmd
1707: , gem_lookups gl
1708: , gmd_status s
1709: WHERE s.status_code = ffm.formula_status
1710: AND gl.lookup_code = fmd.line_type
1711: AND gl.lookup_type = 'LINE_TYPE'

Line 1727: , gem_lookups gl

1723: SELECT ffm.formula_id, ffm.formula_vers
1724: FROM gmd_recipes grec
1725: , fm_form_mst ffm
1726: , fm_matl_dtl fmd
1727: , gem_lookups gl
1728: , gmd_status s
1729: WHERE s.status_code = ffm.formula_status
1730: AND gl.lookup_code = fmd.line_type
1731: AND gl.lookup_type = 'LINE_TYPE'

Line 4331: FROM gem_lookups

4327: IS
4328:
4329: CURSOR c_coa_type IS
4330: SELECT 1
4331: FROM gem_lookups
4332: WHERE lookup_type = 'GMD_QC_CERTIFICATE_TYPE'
4333: AND lookup_code = p_coa_type;
4334:
4335: dummy PLS_INTEGER;