DBA Data[Home] [Help]

APPS.GME_CREATE_BATCH_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 254: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;

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

Line 352: FROM gmd_recipe_validity_rules

348:
349: CURSOR recipe_validity_rule_cursor (v_recipe_validity_rule_id NUMBER)
350: IS
351: SELECT *
352: FROM gmd_recipe_validity_rules
353: WHERE recipe_validity_rule_id = NVL (v_recipe_validity_rule_id, -1);
354:
355: CURSOR recipe_cursor (v_recipe_id NUMBER)
356: IS

Line 2960: gmd_recipe_validity_rules ffe

2956: fm_rout_hdr frh,
2957: fm_rout_dtl frd,
2958: mtl_system_items iim,
2959: gme_batch_header gbh,
2960: gmd_recipe_validity_rules ffe
2961: WHERE gbh.batch_id = x_batch_id
2962: AND ffm.formula_id = gbh.formula_id
2963: AND ffm.formula_id = fmd.formula_id
2964: AND iim.organization_id = NVL(ffe.organization_id,iim.organization_id)