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 783: FROM gmd_operations_b o,gmd_Status_b s

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

Line 971: FROM gmd_operations_b

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