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_TECH_PARAMS dependencies on FM_MATL_DTL

Line 270: FROM ic_item_mst i, fm_matl_dtl d

266:
267: CURSOR Cur_ic_item IS
268: SELECT i.item_no, i.item_id, i.item_um, d.line_type, d.qty,
269: d.item_um line_um, d.line_no, d.formulaline_id, NVL(d.tpformula_id,0) tpformula_id
270: FROM ic_item_mst i, fm_matl_dtl d
271: WHERE formula_id = p_formula_id
272: AND i.item_id = d.item_id
273: ORDER BY d.line_type, d.line_no;
274:

Line 279: FROM lm_item_dat i, fm_matl_dtl f

275: CURSOR Cur_lm_attrib IS
276: SELECT i.orgn_code, i.item_id, i.tech_parm_name, i.num_data,
277: i.text_data, i.boolean_data, NVL(f.tpformula_id,0) tpformula_id,
278: f.line_type, f.line_no
279: FROM lm_item_dat i, fm_matl_dtl f
280: WHERE orgn_code = p_lab_type
281: AND i.item_id = f.item_id
282: AND f.formula_id = p_formula_id
283: AND NVL(i.formula_id,0) = NVL(f.tpformula_id,0)