DBA Data[Home] [Help]

APPS.GME_CREATE_BATCH_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 183: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;

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;
187: l_text_string gme_text_table.text%TYPE;

Line 272: FROM gmd_recipe_validity_rules

268:
269: CURSOR recipe_validity_rule_cursor (v_recipe_validity_rule_id NUMBER)
270: IS
271: SELECT *
272: FROM gmd_recipe_validity_rules
273: WHERE recipe_validity_rule_id = NVL (v_recipe_validity_rule_id, -1);
274:
275: CURSOR recipe_cursor (v_recipe_id NUMBER)
276: IS

Line 2645: gmd_recipe_validity_rules ffe

2641: fm_rout_hdr frh,
2642: fm_rout_dtl frd,
2643: mtl_system_items iim,
2644: gme_batch_header gbh,
2645: gmd_recipe_validity_rules ffe
2646: WHERE gbh.batch_id = x_batch_id
2647: AND ffm.formula_id = gbh.formula_id
2648: AND ffm.formula_id = fmd.formula_id
2649: AND iim.organization_id = NVL(ffe.organization_id,iim.organization_id)