DBA Data[Home] [Help]

APPS.GMD_ITEM_TECHNICAL_DATA_PUB dependencies on FM_MATL_DTL

Line 528: FROM fm_form_mst a, fm_matl_dtl b

524: AND lot_number = l_lot_no;
525:
526: CURSOR Cur_check_formula (l_item_id NUMBER, l_form_id NUMBER) IS
527: SELECT a.formula_id
528: FROM fm_form_mst a, fm_matl_dtl b
529: WHERE b.inventory_item_id = l_item_id
530: AND a.formula_id = b.formula_id
531: AND a.formula_id <> 0
532: AND b.line_type = 1