APPS.GMD_STATUS_CODE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39

   *     select operation_status from gmd_operations_vl where oprn_id is in
   *            (select oprn_id from fm_rout_dtl where routing_id is current routing)
   *     IF any operation_status returned by select is On-hold, Obsolete or less than
   *        the TO_STATUS of the routing, set the boolean to FALSE.
   *   IF the entity is Recipes THEN
   *     select formula_status from fm_form_mst where formula_id is in
   *            (select formula_id from gmd_recipes where recipe_id is current recipe)
   *     select routing_status from fm_rout_hdr where routing_id is in
   *            (select routing_id from gmd_recipes where recipe_id is current recipe)
   *     IF either formula or routing status returned by select is on-hold, obsolete
   *        or less than the TO_STATUS of the recipe, set the boolean to FALSE.
   *   IF the entity is Validity Rules THEN
   *     select recipe_status from gmd_recipes where recipe_id is in
   *            (select recipe_id from gmd_recipe_validity_rules where
   *                   recipe_validity_rule_id is current recipe_validity_rule_id)
   *     IF recipe_status returned by select is on-hold, obsolete or
   *        less than the TO_STATUS of the validity_rule, set the boolean to FALSE.
   * END IF;

Line: 90

          Select        o.operation_status
            From        gmd_operations_vl o, fm_rout_dtl r
           Where    o.oprn_id = r.oprn_id
             and    r.routing_id = P_Entity_id;

Line: 115

          Select        f.formula_status, g.routing_id
            From        fm_form_mst f, gmd_recipes g
           Where    g.formula_id = f.formula_id
             and    g.recipe_id = P_Entity_id;

Line: 132

          Select        r.routing_status
            From        fm_rout_hdr r
           Where    r.routing_id = l_routing_defined;

Line: 151

          Select        g.recipe_status
            From        gmd_recipe_validity_rules vr, gmd_recipes g
           Where    vr.recipe_id = g.recipe_id
             and    vr.recipe_validity_rule_id = P_Entity_id;

Line: 172

              SELECT    g.recipe_status FROM  gmd_recipe_validity_rules vr, gmd_recipes_b g
                                        WHERE vr.recipe_id               = g.recipe_id
                                        AND   vr.recipe_validity_rule_id = p_Entity_id;

Line: 199

      SELECT COUNT(*)
      FROM   gmd_recipes r,gmd_recipe_validity_rules v
      WHERE  r.recipe_id = l_recipe_id
         AND r.recipe_id = v.recipe_id
         AND (r.recipe_status BETWEEN 700 AND 799
              OR r.recipe_Status BETWEEN 400 AND 499
              OR r.recipe_Status BETWEEN 900 AND 999)
         AND EXISTS (select 1
                     from   gme_batch_header
                     Where  batch_status IN (1,2,3,-3)
                     AND    recipe_validity_rule_id = v.recipe_validity_rule_id);

Line: 212

     SELECT Count(*)
     FROM  gmd_recipes
     WHERE routing_id = l_routing_id
        AND (recipe_status between 700 and 799
           OR recipe_status between 400 and 499
           OR recipe_status between 900 and 999) ;

Line: 221

     SELECT count(*)
     FROM  fm_rout_hdr h,fm_rout_dtl d
      WHERE h.routing_id = d.routing_id
           AND d.oprn_id = l_oprn_id
           AND (h.routing_status between 700 and 799
                OR h.routing_Status between 400 and 499
                OR h.routing_Status between 900 and 999);

Line: 230

     SELECT count(*)
     FROM   gmd_operations_vl o,gme_batch_steps s
      WHERE o.oprn_id = l_oprn_id
            AND o.oprn_id = s.oprn_id
            AND  (o.operation_status  BETWEEN 400 and 499
                  OR o.operation_status BETWEEN 700 AND 799
                  OR o.operation_status BETWEEN 900 AND 999);

Line: 240

     SELECT count(*)
     FROM  gmd_recipes
     WHERE formula_id = l_formula_id
       AND (recipe_status between 700 and 799
            OR recipe_status between 400 and 499
            OR recipe_status between 900 and 999);

Line: 248

     SELECT count(*)
     FROM   gme_batch_header
     WHERE recipe_validity_rule_id = l_validity_rule_id
     AND   batch_status IN (1,2,3,-3);

Line: 325

      SELECT rework_status
      FROM GMD_STATUS_NEXT
      WHERE current_status = p_from_status
      AND target_status  = p_to_status
      AND pending_status IS NOT NULL;

Line: 346

      SELECT pending_status
      FROM GMD_STATUS_NEXT
      WHERE current_status = p_from_status
      AND target_status  = p_to_status;