[Home] [Help]
APPS.GMD_TECH_PARAMS dependencies on IC_ITEM_MST
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: