APPS.GMD_API_GRP dependencies on GMD_RECIPES_B

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

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

Line 979: FROM gmd_recipes_b

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

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

1698: LocalInfoRecord c_get_recipe_info%ROWTYPE;
1699:
1700: CURSOR c_get_version(l_recipe_no VARCHAR2) IS
1701: SELECT max(recipe_version)
1702: FROM gmd_recipes_b
1703: WHERE recipe_no = l_recipe_no;
1704: LocalVersRecord c_get_version%ROWTYPE;
1705:
1706: CURSOR c_check_recipe(l_recipe_no VARCHAR2) IS

Line 1708: FROM gmd_recipes_b

1704: LocalVersRecord c_get_version%ROWTYPE;
1705:
1706: CURSOR c_check_recipe(l_recipe_no VARCHAR2) IS
1707: SELECT *
1708: FROM gmd_recipes_b
1709: WHERE recipe_no = l_recipe_no;
1710: LocalCheckRecord c_check_recipe%ROWTYPE;
1711:
1712: CURSOR c_get_item(l_item_id NUMBER) IS