APPS.GMD_SPREAD_CALCULATE_PKG dependencies on FM_MATL_DTL

Line 741: FROM gmd_material_details_gtmp a , fm_matl_dtl b

737: WHERE formula_id = V_entity_id;
738:
739: CURSOR Cur_get_ingredient_qty(V_entity_id NUMBER) IS
740: SELECT a.qty , a.detail_uom , a.inventory_item_id
741: FROM gmd_material_details_gtmp a , fm_matl_dtl b
742: where a.entity_id = V_entity_id
743: and b.formula_id = V_entity_id
744: and a.inventory_item_id = b.inventory_item_id
745: and b.CONTRIBUTE_YIELD_IND = 'Y'

Line 751: FROM gmd_material_details_gtmp a , fm_matl_dtl b

747: and b.line_type = -1;
748:
749: CURSOR Cur_get_byproduct_qty(V_entity_id NUMBER) IS
750: SELECT a.qty , a.detail_uom , a.inventory_item_id
751: FROM gmd_material_details_gtmp a , fm_matl_dtl b
752: where a.entity_id = V_entity_id
753: and b.formula_id = V_entity_id
754: and a.inventory_item_id = b.inventory_item_id
755: and b.CONTRIBUTE_YIELD_IND = 'Y'

Line 761: FROM fm_matl_dtl b

757: and b.line_type = 2;
758:
759: CURSOR Cur_get_fixed_prod_qty(V_entity_id NUMBER) IS
760: SELECT b.qty , b.detail_uom , b.inventory_item_id
761: FROM fm_matl_dtl b
762: WHERE b.formula_id = V_entity_id
763: and b.CONTRIBUTE_YIELD_IND = 'Y'
764: and b.line_type = 1
765: and b.scale_type = 0;

Line 769: FROm fm_matl_dtl

765: and b.scale_type = 0;
766:
767: CURSOR Cur_get_product_percent(V_entity_id NUMBER) IS
768: SELECT prod_percent , inventory_item_id , detail_uom
769: FROm fm_matl_dtl
770: WHERE formula_id = V_entity_id
771: AND line_type = 1
772: AND line_no = 1;
773: