APPS.GMD_API_GRP dependencies on GMD_OPERATIONS_B

Line 668: FROM gmd_operations_b a, mtl_parameters b

664: END IF;
665: ELSIF (Entity = 'OPERATION') THEN
666: SELECT b.organization_code, b.organization_id
667: INTO l_Owner_orgn_code, l_orgn_id
668: FROM gmd_operations_b a, mtl_parameters b
669: WHERE a.oprn_id = Entity_id
670: AND a.owner_organization_id = b.organization_id;
671:
672: /* Check if user has access to this formula orgn */

Line 786: FROM gmd_operations_b o,gmd_Status_b s

782: r.recipe_status = s.status_code;
783:
784: CURSOR Cur_get_osttyp(pobject_id NUMBER) IS
785: SELECT s.status_type
786: FROM gmd_operations_b o,gmd_Status_b s
787: WHERE o.oprn_id = pobject_id AND
788: o.operation_status = s.status_code;
789:
790: CURSOR Cur_get_rtsttyp(pobject_id NUMBER) IS

Line 974: FROM gmd_operations_b

970: WHere routing_id = vEntity_id;
971: ELSIF (vEntity = 'OPERATION') THEN
972: Select oprn_no, oprn_vers, oprn_no||' - '||oprn_vers
973: INTO l_object_name, l_object_version, l_object_name_and_version
974: FROM gmd_operations_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