APPS.GMD_API_GRP dependencies on GMD_RECIPES

Line 615: FROM gmd_recipes_b a, mtl_parameters b

611:
612: ELSIF (Entity = 'RECIPE') THEN
613: SELECT b.organization_code, b.organization_id
614: INTO l_owner_orgn_code, l_orgn_id
615: FROM gmd_recipes_b a, mtl_parameters b
616: WHERE recipe_id = Entity_id
617: AND a.owner_organization_id = b.organization_id;
618:
619: /* Check if user has access to this Recipe orgn */

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 777: FROM gmd_recipes_b r,gmd_Status_b s

773: f.formula_status = s.status_code;
774:
775: CURSOR Cur_get_rsttyp(pobject_id NUMBER) IS
776: SELECT s.status_type
777: FROM gmd_recipes_b r,gmd_Status_b s
778: WHERE r.recipe_id = pobject_id AND
779: r.recipe_status = s.status_code;
780:
781: CURSOR Cur_get_osttyp(pobject_id NUMBER) IS

Line 842: FROM gmd_recipes

838: X_parent_check OUT NOCOPY BOOLEAN) IS
839: X_status VARCHAR2(5);
840: CURSOR Cur_get_recp_sts(entity_id NUMBER) IS
841: SELECT recipe_status
842: FROM gmd_recipes
843: WHERE recipe_id = entity_id
844: AND ((recipe_status between 700 and 799
845: OR recipe_status between 400 and 499));
846:

Line 976: FROM gmd_recipes_b

972: WHere oprn_id = vEntity_id;
973: ELSIF (vEntity = 'RECIPE') THEN
974: Select recipe_no, recipe_version, recipe_no||' - '||recipe_version
975: INTO l_object_name, l_object_version, l_object_name_and_version
976: FROM gmd_recipes_b
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

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 1695: FROM gmd_recipes_b

1691: LocalInfoRecord c_get_recipe_info%ROWTYPE;
1692:
1693: CURSOR c_get_version(l_recipe_no VARCHAR2) IS
1694: SELECT max(recipe_version)
1695: FROM gmd_recipes_b
1696: WHERE recipe_no = l_recipe_no;
1697: LocalVersRecord c_get_version%ROWTYPE;
1698:
1699: CURSOR c_check_recipe(l_recipe_no VARCHAR2) IS

Line 1701: FROM gmd_recipes_b

1697: LocalVersRecord c_get_version%ROWTYPE;
1698:
1699: CURSOR c_check_recipe(l_recipe_no VARCHAR2) IS
1700: SELECT *
1701: FROM gmd_recipes_b
1702: WHERE recipe_no = l_recipe_no;
1703: LocalCheckRecord c_check_recipe%ROWTYPE;
1704:
1705: CURSOR c_get_item(l_item_id NUMBER) IS