APPS.GMD_API_GRP dependencies on GMD_ROUTINGS_B

Line 653: FROM gmd_routings_b a, mtl_parameters b

649:
650: ELSIF (Entity = 'ROUTING') THEN
651: SELECT b.organization_code, b.organization_id
652: INTO l_Owner_orgn_code, l_orgn_id
653: FROM gmd_routings_b a, mtl_parameters b
654: WHERE a.routing_id = Entity_id
655: AND a.owner_organization_id = b.organization_id;
656:
657: /* Check if user has access to this formula orgn */

Line 792: FROM gmd_routings_b r,gmd_Status_b s

788: o.operation_status = s.status_code;
789:
790: CURSOR Cur_get_rtsttyp(pobject_id NUMBER) IS
791: SELECT s.status_type
792: FROM gmd_routings_b r,gmd_Status_b s
793: WHERE r.routing_id = pobject_id AND
794: r.routing_status = s.status_code;
795:
796: CURSOR Cur_get_vrttyp(pobject_id NUMBER) IS

Line 969: FROM gmd_routings_b

965: WHere formula_id = vEntity_id;
966: ELSIF (vEntity = 'ROUTING') THEN
967: Select routing_no, routing_vers, routing_no||' - '||routing_vers
968: INTO l_object_name, l_object_version, l_object_name_and_version
969: FROM gmd_routings_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

Line 1678: FROM GMD_ROUTINGS_B

1674:
1675: -- Kapil LCF-GMO ME : Bug#5458666
1676: CURSOR c_get_routing_info IS
1677: SELECT routing_no , routing_vers
1678: FROM GMD_ROUTINGS_B
1679: WHERE routing_id = p_routing_id;
1680: LocalRoutRecord c_get_routing_info%ROWTYPE;
1681:
1682: CURSOR c_get_recipe_id IS