APPS.GMD_SPREAD_CALCULATE_PKG dependencies on FM_MATL_DTL

Line 753: FROM gmd_material_details_gtmp a , fm_matl_dtl b

749: WHERE formula_id = l_formula_id;
750:
751: CURSOR Cur_get_ingredient_qty(V_entity_id NUMBER) IS
752: SELECT a.qty , a.detail_uom , a.inventory_item_id
753: FROM gmd_material_details_gtmp a , fm_matl_dtl b
754: where a.entity_id = V_entity_id
755: and b.formula_id = l_formula_id
756: and a.inventory_item_id = b.inventory_item_id
757: and b.CONTRIBUTE_YIELD_IND = 'Y'

Line 766: FROM fm_matl_dtl b

762: FROM gmd_material_details_gtmp a
763: where a.entity_id = V_entity_id
764: and a.line_type = -1
765: and a.inventory_item_id NOT IN (SELECT b.inventory_item_id
766: FROM fm_matl_dtl b
767: WHERE b.formula_id = l_formula_id
768: and b.line_type = -1);
769:
770:

Line 773: FROM gmd_material_details_gtmp a , fm_matl_dtl b

769:
770:
771: CURSOR Cur_get_byproduct_qty(V_entity_id NUMBER) IS
772: SELECT a.qty , a.detail_uom , a.inventory_item_id
773: FROM gmd_material_details_gtmp a , fm_matl_dtl b
774: where a.entity_id = V_entity_id
775: and b.formula_id = l_formula_id
776: and a.inventory_item_id = b.inventory_item_id
777: and b.CONTRIBUTE_YIELD_IND = 'Y'

Line 786: FROM fm_matl_dtl b

782: FROM gmd_material_details_gtmp a
783: where a.entity_id = V_entity_id
784: and a.line_type = 2
785: and a.inventory_item_id NOT IN (SELECT b.inventory_item_id
786: FROM fm_matl_dtl b
787: WHERE b.formula_id = l_formula_id
788: and b.line_type = 2);
789:
790: CURSOR Cur_get_fixed_prod_qty(V_entity_id NUMBER) IS

Line 792: FROM fm_matl_dtl b

788: and b.line_type = 2);
789:
790: CURSOR Cur_get_fixed_prod_qty(V_entity_id NUMBER) IS
791: SELECT b.qty , b.detail_uom , b.inventory_item_id
792: FROM fm_matl_dtl b
793: WHERE b.formula_id = V_entity_id
794: and b.CONTRIBUTE_YIELD_IND = 'Y'
795: and b.line_type = 1
796: and b.scale_type = 0;

Line 800: FROm fm_matl_dtl

796: and b.scale_type = 0;
797:
798: CURSOR Cur_get_product_percent(V_entity_id NUMBER) IS
799: SELECT prod_percent , inventory_item_id , detail_uom
800: FROm fm_matl_dtl
801: WHERE formula_id = V_entity_id
802: AND line_type = 1
803: AND line_no = 1;
804: