APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_RECIPE_VALIDITY_RULES

Line 630: FROM gmd_recipe_validity_rules

626: X_step_tbl rcp_steps;
627:
628: CURSOR Cur_get_vr IS
629: SELECT *
630: FROM gmd_recipe_validity_rules
631: WHERE recipe_id = p_recipe_id;
632: TYPE rcp_vr IS TABLE OF Cur_get_vr%ROWTYPE INDEX BY BINARY_INTEGER;
633: X_vr_tbl rcp_vr;
634:

Line 852: INSERT INTO gmd_recipe_validity_rules(recipe_validity_rule_id, recipe_id, organization_id, inventory_item_id, revision, recipe_use, preference,

848: END IF;
849:
850: IF X_cnt > 0 THEN
851: --End 3037410
852: INSERT INTO gmd_recipe_validity_rules(recipe_validity_rule_id, recipe_id, organization_id, inventory_item_id, revision, recipe_use, preference,
853: start_date, end_date, min_qty, max_qty, std_qty, detail_uom, inv_min_qty,
854: inv_max_qty, text_code, attribute_category, attribute1, attribute2, attribute3,
855: attribute4, attribute5, attribute6, attribute7, attribute8, attribute9,
856: attribute10, attribute11, attribute12, attribute13, attribute14, attribute15,