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.GMDFMVAL_PUB dependencies on GMD_MATERIAL_EFFECTIVITIES_VW

Line 1012: FROM gmd_material_effectivities_vw vw

1008: CURSOR get_item_substitution (vFormula_id Number
1009: ,vItem_id Number
1010: ,vDate Date) IS
1011: SELECT *
1012: FROM gmd_material_effectivities_vw vw
1013: WHERE vw.formula_id = vFormula_id
1014: AND vw.line_item_id = vItem_id
1015: AND vw.start_date <= vDate
1016: AND (vw.end_date IS NULL OR

Line 1278: FROM gmd_material_effectivities_vw

1274:
1275: --Check substitution records for the formulaline_id.
1276: SELECT count(*)
1277: INTO l_subst_recs
1278: FROM gmd_material_effectivities_vw
1279: WHERE formula_id = get_fmline_rec.formula_id
1280: AND formulaline_id = get_fmline_rec.formulaline_id;
1281:
1282: IF l_subst_recs <= 1 THEN