APPS.GMD_API_GRP dependencies on GMD_RECIPE_VALIDITY_RULES

Line 631: FROM gmd_recipes a , gmd_recipe_validity_rules b , mtl_parameters c

627:
628: ELSIF (Entity = 'VALIDITY') THEN
629: SELECT c.organization_code , a.owner_organization_id
630: INTO l_owner_orgn_code, l_orgn_id
631: FROM gmd_recipes a , gmd_recipe_validity_rules b , mtl_parameters c
632: WHERE b.recipe_validity_rule_id = Entity_id
633: AND a.recipe_id = b.recipe_id
634: AND a.owner_organization_id = c.organization_id ;
635:

Line 798: FROM gmd_recipe_validity_rules v,gmd_Status_b s

794: r.routing_status = s.status_code;
795:
796: CURSOR Cur_get_vrttyp(pobject_id NUMBER) IS
797: SELECT s.status_type
798: FROM gmd_recipe_validity_rules v,gmd_Status_b s
799: WHERE v.recipe_validity_rule_id = pobject_id AND
800: v.validity_rule_status = s.status_code;
801: BEGIN
802: IF (pObject_id IS NOT NULL) THEN

Line 984: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

980: WHere recipe_id = vEntity_id;
981: ELSIF (vEntity = 'VALIDITY') THEN
982: Select r.recipe_no, r.recipe_version, r.recipe_no||' - '||r.recipe_version
983: INTO l_object_name, l_object_version, l_object_name_and_version
984: FROM gmd_recipes_b r, gmd_recipe_validity_rules v
985: WHere v.recipe_id = vEntity_id
986: AND v.recipe_id = r.recipe_id;
987: END IF;
988: END IF;

Line 1485: FROM gmd_recipe_validity_rules

1481:
1482: CURSOR Cur_get_max_pref (V_item_id NUMBER, V_organization_id NUMBER,
1483: V_start_date DATE, V_end_date DATE, V_recipe_use NUMBER) IS
1484: SELECT MAX(preference)
1485: FROM gmd_recipe_validity_rules
1486: WHERE inventory_item_id = v_item_id
1487: AND organization_id = v_organization_id
1488: AND recipe_use = v_recipe_use
1489: AND NVL(end_date, v_start_date) >= v_start_date