APPS.GME_CREATE_BATCH_PVT dependencies on FM_MATL_DTL

Line 182: l_formula_material fm_matl_dtl%ROWTYPE;

178: ,x_return_status OUT NOCOPY VARCHAR2)
179: IS
180: l_in_batch_header gme_batch_header%ROWTYPE;
181: l_formula_master fm_form_mst%ROWTYPE;
182: l_formula_material fm_matl_dtl%ROWTYPE;
183: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;
184: l_item_master mtl_system_items_kfv%ROWTYPE;
185: l_gme_material_detail gme_material_details%ROWTYPE;
186: l_text_header gme_text_header%ROWTYPE;

Line 284: FROM fm_matl_dtl a, gmd_recipes_b b

280:
281: CURSOR formula_details_cursor (v_recipe_id NUMBER)
282: IS
283: SELECT a.*
284: FROM fm_matl_dtl a, gmd_recipes_b b
285: WHERE a.formula_id = b.formula_id AND b.recipe_id = v_recipe_id
286: ORDER BY line_no;
287:
288: CURSOR fm_text_tbl_cursor (v_text_code NUMBER)

Line 2640: fm_matl_dtl fmd,

2636: )
2637: )
2638: / (ffm.total_output_qty * frd.step_qty)
2639: FROM fm_form_mst ffm,
2640: fm_matl_dtl fmd,
2641: fm_rout_hdr frh,
2642: fm_rout_dtl frd,
2643: mtl_system_items iim,
2644: gme_batch_header gbh,