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 795: FROM gmd_recipe_validity_rules v,gmd_Status_b s

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

Line 981: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

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

Line 1479: FROM gmd_recipe_validity_rules

1475:
1476: CURSOR Cur_get_max_pref (V_item_id NUMBER, V_organization_id NUMBER,
1477: V_start_date DATE, V_end_date DATE, V_recipe_use NUMBER) IS
1478: SELECT MAX(preference)
1479: FROM gmd_recipe_validity_rules
1480: WHERE inventory_item_id = v_item_id
1481: AND organization_id = v_organization_id
1482: AND recipe_use = v_recipe_use
1483: AND NVL(end_date, v_start_date) >= v_start_date