DBA Data[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: