APPS.GMD_VALIDITY_RULES dependencies on GMD_VAL_RULE_GTMP

Line 200: FROM GMD_VAL_RULE_GTMP;

196: WHERE organization_id = p_organization_id;
197:
198: CURSOR Cur_get_VR IS
199: SELECT *
200: FROM GMD_VAL_RULE_GTMP;
201:
202: CURSOR get_form_prod(l_formula_id NUMBER) IS
203: SELECT inventory_item_id, qty, detail_uom
204: FROM fm_matl_dtl

Line 250: DELETE FROM GMD_VAL_RULE_GTMP;

246:
247: /* Bug No.6346013 - Start */
248:
249: /* Delete from this table for any existing data */
250: DELETE FROM GMD_VAL_RULE_GTMP;
251:
252: /* Bug No.6346013 - End */
253:
254: -- NPD Convergence. Get FM_YIELD_TYPE profile value for the organization.

Line 1278: FROM GMD_VAL_RULE_GTMP;

1274: ORDER BY R.Recipe_no,R.Recipe_version, V.Recipe_use,Orgn_code, Preference,S.Status_type;
1275:
1276: CURSOR Cur_get_VR IS
1277: SELECT *
1278: FROM GMD_VAL_RULE_GTMP;
1279:
1280: CURSOR Cur_get_form_id (v_recipe_id NUMBER, V_inventory_item_id NUMBER) IS
1281: SELECT rcp.formula_id, SUM(qty), MAX(detail_uom)
1282: FROM gmd_recipes rcp, fm_matl_dtl d

Line 1307: DELETE FROM GMD_VAL_RULE_GTMP;

1303:
1304: X_return_status := Fnd_api.G_ret_sts_success;
1305:
1306: /* Delete from this table for any existing data */
1307: DELETE FROM GMD_VAL_RULE_GTMP;
1308:
1309: IF (P_item_id IS NOT NULL) THEN
1310: FOR Get_rec IN Get_val_item LOOP
1311: X_return_status := Fnd_api.G_ret_sts_success;

Line 1650: INSERT INTO GMD_VAL_RULE_GTMP(

1646: PROCEDURE insert_val_temp_tbl (p_val_rec IN GMD_RECIPE_VALIDITY_RULES%ROWTYPE
1647: ,p_unit_cost IN NUMBER
1648: ,p_total_cost IN NUMBER) IS
1649: BEGIN
1650: INSERT INTO GMD_VAL_RULE_GTMP(
1651: recipe_validity_rule_id, recipe_id , orgn_code , recipe_use ,
1652: preference , start_date , end_date , min_qty ,
1653: max_qty , std_qty , inv_min_qty , inv_max_qty ,
1654: text_code , attribute_category , attribute1 , attribute2 ,