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 789: FROM gmd_routings_b r,gmd_Status_b s

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

Line 966: FROM gmd_routings_b

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

Line 1671: FROM GMD_ROUTINGS_B

1667:
1668: -- Kapil LCF-GMO ME : Bug#5458666
1669: CURSOR c_get_routing_info IS
1670: SELECT routing_no , routing_vers
1671: FROM GMD_ROUTINGS_B
1672: WHERE routing_id = p_routing_id;
1673: LocalRoutRecord c_get_routing_info%ROWTYPE;
1674:
1675: CURSOR c_get_recipe_id IS