APPS.GMD_VALIDITY_RULES dependencies on GMD_VAL_RULE_GTMP

Line 201: FROM GMD_VAL_RULE_GTMP;

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

Line 251: DELETE FROM GMD_VAL_RULE_GTMP;

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

Line 1300: FROM GMD_VAL_RULE_GTMP;

1296: ORDER BY R.Recipe_no,R.Recipe_version, V.Recipe_use,Orgn_code, Preference,S.Status_type;
1297:
1298: CURSOR Cur_get_VR IS
1299: SELECT *
1300: FROM GMD_VAL_RULE_GTMP;
1301:
1302: CURSOR Cur_get_form_id (v_recipe_id NUMBER, V_inventory_item_id NUMBER) IS
1303: SELECT rcp.formula_id, SUM(qty), MAX(detail_uom)
1304: FROM gmd_recipes rcp, fm_matl_dtl d

Line 1329: DELETE FROM GMD_VAL_RULE_GTMP;

1325:
1326: X_return_status := Fnd_api.G_ret_sts_success;
1327:
1328: /* Delete from this table for any existing data */
1329: DELETE FROM GMD_VAL_RULE_GTMP;
1330:
1331: IF (P_item_id IS NOT NULL) THEN
1332: FOR Get_rec IN Get_val_item LOOP
1333: X_return_status := Fnd_api.G_ret_sts_success;

Line 1672: INSERT INTO GMD_VAL_RULE_GTMP(

1668: PROCEDURE insert_val_temp_tbl (p_val_rec IN GMD_RECIPE_VALIDITY_RULES%ROWTYPE
1669: ,p_unit_cost IN NUMBER
1670: ,p_total_cost IN NUMBER) IS
1671: BEGIN
1672: INSERT INTO GMD_VAL_RULE_GTMP(
1673: recipe_validity_rule_id, recipe_id , orgn_code , recipe_use ,
1674: preference , start_date , end_date , min_qty ,
1675: max_qty , std_qty , inv_min_qty , inv_max_qty ,
1676: text_code , attribute_category , attribute1 , attribute2 ,