APPS.GME_CREATE_BATCH_PVT dependencies on FM_MATL_DTL

Line 253: l_formula_material fm_matl_dtl%ROWTYPE;

249: ,x_return_status OUT NOCOPY VARCHAR2)
250: IS
251: l_in_batch_header gme_batch_header%ROWTYPE;
252: l_formula_master fm_form_mst%ROWTYPE;
253: l_formula_material fm_matl_dtl%ROWTYPE;
254: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;
255: l_item_master mtl_system_items_kfv%ROWTYPE;
256: l_gme_material_detail gme_material_details%ROWTYPE;
257: l_text_header gme_text_header%ROWTYPE;

Line 364: FROM fm_matl_dtl a, gmd_recipes_b b

360:
361: CURSOR formula_details_cursor (v_recipe_id NUMBER)
362: IS
363: SELECT a.*
364: FROM fm_matl_dtl a, gmd_recipes_b b
365: WHERE a.formula_id = b.formula_id AND b.recipe_id = v_recipe_id
366: ORDER BY line_no;
367:
368: CURSOR fm_text_tbl_cursor (v_text_code NUMBER)

Line 2955: fm_matl_dtl fmd,

2951: ),
2952: ffm.total_output_qty,
2953: frd.step_qty
2954: FROM fm_form_mst ffm,
2955: fm_matl_dtl fmd,
2956: fm_rout_hdr frh,
2957: fm_rout_dtl frd,
2958: mtl_system_items iim,
2959: gme_batch_header gbh,