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 1658: , gem_lookups gl

1654: SELECT ffm.formula_no, ffm.formula_vers
1655: FROM gmd_recipes grec
1656: , fm_form_mst ffm
1657: , fm_matl_dtl fmd
1658: , gem_lookups gl
1659: , gmd_status s
1660: WHERE s.status_code = ffm.formula_status
1661: AND gl.lookup_code = fmd.line_type
1662: AND gl.lookup_type = 'LINE_TYPE'

Line 1678: , gem_lookups gl

1674: SELECT ffm.formula_id, ffm.formula_vers
1675: FROM gmd_recipes grec
1676: , fm_form_mst ffm
1677: , fm_matl_dtl fmd
1678: , gem_lookups gl
1679: , gmd_status s
1680: WHERE s.status_code = ffm.formula_status
1681: AND gl.lookup_code = fmd.line_type
1682: AND gl.lookup_type = 'LINE_TYPE'

Line 4168: FROM gem_lookups

4164: IS
4165:
4166: CURSOR c_coa_type IS
4167: SELECT 1
4168: FROM gem_lookups
4169: WHERE lookup_type = 'GMD_QC_CERTIFICATE_TYPE'
4170: AND lookup_code = p_coa_type;
4171:
4172: dummy PLS_INTEGER;