eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_GANTT_PKG SQL Statements

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

Line: 17


     Select DISTINCT
        BATCH_ID               ,
        BATCH_NO               ,
        BATCH_STATUS           ,
        BATCH_TYPE             ,
        START_DATE             ,
        END_DATE               ,
        PLAN_START_DATE        ,
        PLAN_CMPLT_DATE        ,
        ACTUAL_START           ,
        ACTUAL_END             ,
        FORMULA_ID             ,
        ROUTING_ID             ,
        ENFORCE_STEP_DEPENDENCY,
        TERMINATED_IND         ,
        FINITE_SCHEDULED_IND   ,
        PARENTLINE_ID
     from GME_GANTT_GTMP
     order by START_DATE;

Line: 111


     Select DISTINCT
        BATCH_ID               ,
        BATCH_NO               ,
        BATCH_STATUS           ,
        BATCH_TYPE             ,
        START_DATE             ,
        END_DATE               ,
        PLAN_START_DATE        ,
        PLAN_CMPLT_DATE        ,
        ACTUAL_START           ,
        ACTUAL_END             ,
        FORMULA_ID             ,
        ROUTING_ID             ,
        ENFORCE_STEP_DEPENDENCY,
        TERMINATED_IND         ,
        FINITE_SCHEDULED_IND   ,
        PARENTLINE_ID
      from GME_GANTT_GTMP
      order by START_DATE;

Line: 214


         SELECT i.inventory_item_id, i.concatenated_segments, i.description
           FROM mtl_system_items_kfv i
               ,gme_batch_header b
               ,gmd_recipe_validity_rules v
          WHERE b.batch_id = p_batch_id
            AND b.recipe_validity_rule_id = v.recipe_validity_rule_id
            AND v.inventory_item_id = i.inventory_item_id
            AND b.organization_id = i.organization_id;

Line: 225


         SELECT i.inventory_item_id, i.concatenated_segments, i.description
           FROM mtl_system_items_kfv i
               ,gme_batch_header b
               ,gme_material_details m
          WHERE b.batch_id = p_batch_id
            AND b.batch_id = m.batch_id
            AND m.organization_id = i.organization_id
            AND m.inventory_item_id = i.inventory_item_id
            AND m.line_type = 1
            AND m.line_no = 1;

Line: 238


         SELECT   SUM (plan_qty), NVL (SUM (actual_qty), 0), dtl_um
             FROM gme_material_details
            WHERE batch_id = p_batch_id
              AND line_type = 1
              AND inventory_item_id = p_inventory_item_id
         GROUP BY dtl_um;

Line: 332


      l_column_select_str1   VARCHAR2(200) :=  ' SELECT B.BATCH_ID BATCH_ID, B.BATCH_NO BATCH_NO, BATCH_STATUS, BATCH_TYPE, PLAN_START_DATE, ACTUAL_START_DATE, ';

Line: 333


      l_column_select_str2   VARCHAR2(200) :=  ' ACTUAL_CMPLT_DATE, PLAN_CMPLT_DATE, B.FORMULA_ID FORMULA_ID, NVL(ROUTING_ID, 0) ROUTING_ID, NVL(ENFORCE_STEP_DEPENDENCY, 0) ENFORCE_STEP_DEPENDENCY, ';

Line: 334


      l_column_select_str3   VARCHAR2(200) :=  ' NVL(TERMINATED_IND, 0) TERMINATED_IND , NVL(FINITE_SCHEDULED_IND, 0) FINITE_SCHEDULED_IND, NVL(PARENTLINE_ID,0) PARENTLINE_ID FROM GME_BATCH_HEADER B ';

Line: 335


      l_column_select_str4   VARCHAR2(200) :=  ' WHERE organization_id = :p_organization_id AND ';

Line: 336


      l_column_select_str5   VARCHAR2(200) :=  NULL;

Line: 339


          l_column_select_str5 := ' BATCH_NO LIKE :p_batch_no ';

Line: 341


          l_column_select_str5 := ' (lpad(batch_no,32,''0'') >= lpad(:p_batch_no,32,''0'') AND lpad(batch_no,32,''0'') <= lpad(:p_to_batch_no,32,''0'')) ';

Line: 349


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str1;

Line: 350


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 351


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 352


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 353


		 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 360


                      p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 361


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 362


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 363


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 364


		      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 374


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str1;

Line: 375


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 376


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 377


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 378


		      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 383


                      p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 384


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 385


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 386


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 387


		      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 395


                      p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 396


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 397


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 398


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 399


		      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 411


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str1;

Line: 412


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 413


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 414


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 415


			 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 418


                         p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 419


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 420


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 421


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 422


			 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 429


                      p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 430


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 431


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 432


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 433


		      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 439


                 p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 440


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 441


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 442


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 443


		 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 452


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str1;

Line: 453


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 454


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 455


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 456


		 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 458


                 p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 459


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 460


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 461


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 462


		 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 467


              p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 468


              p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 469


              p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 470


              p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 471


	      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 480


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str1;

Line: 481


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 482


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 483


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 484


		 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 489


                 p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 490


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 491


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 492


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 493


		 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 503


                    p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str1;

Line: 504


                    p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 505


                    p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 506


                    p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 507


		    p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 510


                    p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 511


                    p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 512


                    p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 513


                    p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 514


		    p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 523


                      p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 524


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 525


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 526


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 527


		      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 539


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str1;

Line: 540


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 541


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 542


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 543


			 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 546


                         p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 547


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 548


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 549


                         p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 550


			 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 557


                      p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 558


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 559


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 560


                      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 561


		      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 568


                 p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 569


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 570


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 571


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 572


		 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 582


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str1;

Line: 583


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 584


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 585


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 586


		 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 588


                 p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 589


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 590


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 591


                 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 592


		 p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 597


              p_string_to_exec(p_string_to_exec.LAST+1) := 'UNION ALL '|| l_column_select_str1;

Line: 598


              p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str2;

Line: 599


              p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str3;

Line: 600


              p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str4;

Line: 601


	      p_string_to_exec(p_string_to_exec.LAST+1) := l_column_select_str5;

Line: 673


      DELETE FROM GME_GANTT_GTMP;

Line: 675


      string_to_exec(1) := 'INSERT INTO GME_GANTT_GTMP ';

Line: 676


      string_to_exec(2) := '( SELECT BATCH_ID, BATCH_NO, BATCH_STATUS, BATCH_TYPE, ';

Line: 703


      string_to_exec(string_to_exec.LAST +1) := ' AND :p_sec_rsrc_ind      = 0) OR (EXISTS (SELECT 1 FROM GME_BATCH_STEP_RESOURCES D2 ';

Line: 855


            SELECT COUNT (*)
              FROM mtl_system_items_kfv i, gme_material_details m
             WHERE m.batch_id = p_batch_id
               AND m.inventory_item_id = i.inventory_item_id
               AND m.line_type = -1
               AND m.organization_id = i.organization_id
               AND i.concatenated_segments LIKE p_item_no;

Line: 865


            SELECT COUNT (*)
              FROM mtl_system_items_kfv i, gme_material_details m
             WHERE m.batch_id = p_batch_id
               AND m.inventory_item_id = i.inventory_item_id
               AND m.organization_id = i.organization_id
               AND m.line_type = 1
               AND i.concatenated_segments LIKE p_item_no;

Line: 962


               batch_id.DELETE;

Line: 1099


               batch_id.DELETE;

Line: 1274


         SELECT DISTINCT
                         --Bug3746919 bsatpute
                         DECODE
                            (step_status
                            ,1, date_to_clientdt (r.plan_start_date)
                            ,5, date_to_clientdt (b.actual_start_date)
                            ,date_to_clientdt (r.actual_start_date) )
                                                                  start_date
                        --NVL(date_to_clientDT(r.actual_start_date),date_to_clientDT(r.plan_start_date))  start_date
                         ,r.batchstep_no, r.step_status, r.plan_step_qty
                        ,DECODE (r.actual_step_qty
                                ,NULL, 0
                                ,r.actual_step_qty) actual_step_qty
                        ,date_to_clientdt (r.plan_start_date)
                        ,NVL (date_to_clientdt (r.actual_start_date)
                             ,date_to_clientdt (r.plan_start_date) )
                        ,date_to_clientdt (r.plan_cmplt_date)
                        ,NVL (date_to_clientdt (r.actual_cmplt_date)
                             ,date_to_clientdt (r.plan_cmplt_date) )
                        ,NVL (date_to_clientdt (r.step_close_date)
                             ,date_to_clientdt (SYSDATE) )
                        ,o.oprn_id, o.oprn_no, NVL (o.oprn_vers, 0)
                        ,o.oprn_desc
                        ,DECODE (o.oprn_class
                                ,NULL, '?'
                                ,o.oprn_class) oper_class
                        ,o.process_qty_um
                        ,DECODE
                            (step_status
                            ,3, date_to_clientdt (r.actual_cmplt_date)
                            ,date_to_clientdt (r.plan_cmplt_date) ) end_date
                        --bug3746919 bsatpute
                         ,NVL (r.terminated_ind, 0)
                    FROM gme_batch_steps r
                        ,gme_batch_step_resources d
                        ,gmd_operations o
                        ,gme_batch_header b
                   WHERE r.batch_id = p_batch_id
                     AND r.batch_id = d.batch_id
                     AND r.batch_id = b.batch_id
                     AND r.oprn_id = o.oprn_id
                     AND r.batchstep_id = d.batchstep_id
                     AND d.resources LIKE p_resource
                     AND (   d.prim_rsrc_ind = p_prim_rsrc_ind
                          OR d.prim_rsrc_ind = p_aux_rsrc_ind
                          OR d.prim_rsrc_ind = p_sec_rsrc_ind)
                ORDER BY 1;

Line: 1324


         SELECT oprn_class_desc
           FROM gmd_operation_class
          WHERE oprn_class = p_oper_class;

Line: 1350


         oprn_id.DELETE;

Line: 1461


         SELECT   a.activity, a.activity_desc, a.cost_analysis_code
                 ,c.cost_analysis_desc
                 ,MIN
                     (DECODE (r.step_status
                             ,1, date_to_clientdt (o.plan_start_date)
                             ,5, date_to_clientdt (b.actual_start_date)
                             ,date_to_clientdt (o.actual_start_date) ) )
                                                                  start_date
                 ,MAX
                     (DECODE (r.step_status
                             ,3, date_to_clientdt (o.actual_cmplt_date)
                             ,date_to_clientdt (o.plan_cmplt_date) ) )
                                                                    end_date
             FROM gme_batch_step_resources o
                 ,gme_batch_steps r
                 ,gme_batch_step_activities s
                 ,gmd_activities a
                 ,gme_batch_header b
                 ,cm_alys_mst c
            WHERE o.batch_id = p_batch_id
              AND r.batch_id = o.batch_id
              AND s.batch_id = r.batch_id
              AND b.batch_id = r.batch_id
              AND s.delete_mark = 0
              AND o.batchstep_activity_id = s.batchstep_activity_id
              AND r.batchstep_no = p_batchstep_no
              AND o.batchstep_id = r.batchstep_id
              AND s.activity = a.activity
              AND c.cost_analysis_code = a.cost_analysis_code
              AND o.resources LIKE p_resource
              AND (   o.prim_rsrc_ind = p_prim_rsrc_ind
                   OR o.prim_rsrc_ind = p_aux_rsrc_ind
                   OR o.prim_rsrc_ind = p_sec_rsrc_ind)
         GROUP BY a.activity
                 ,a.activity_desc
                 ,a.cost_analysis_code
                 ,c.cost_analysis_desc
         ORDER BY 5;

Line: 1518


         activity.DELETE;

Line: 1612


         SELECT   o.resources, c.resource_desc, o.prim_rsrc_ind
                 ,o.scale_type, NVL (o.plan_rsrc_count, 0)
                 ,DECODE (o.actual_rsrc_count
                         ,NULL, 0
                         ,o.actual_rsrc_count) actual_res_count
                 ,NVL (o.plan_rsrc_qty, 0)
                 ,DECODE (o.actual_rsrc_qty
                         ,NULL, 0
                         ,o.actual_rsrc_qty) actual_res_qty
                 ,NVL (o.plan_rsrc_usage, 0)
                 ,DECODE (o.actual_rsrc_usage
                         ,NULL, 0
                         ,o.actual_rsrc_usage) actual_res_usage
                 ,NVL (c.std_usage_um, ' '), NVL (o.offset_interval, 0)
                 --Swapna K Bug#2479773 17-MAR-2005 Rework
                  /* Null actual start date is sent as planned start date */
                  ,DECODE
                      (r.step_status
                      ,1, date_to_clientdt (o.plan_start_date)
                      ,5, date_to_clientdt (b.actual_start_date)
                      ,NVL (date_to_clientdt (o.actual_start_date)
                           ,date_to_clientdt (o.plan_start_date) ) )
                                                                  start_date
                 ,DECODE (r.step_status
                         ,3, date_to_clientdt (o.actual_cmplt_date)
                         ,date_to_clientdt (o.plan_cmplt_date) ) end_date
                 ,date_to_clientdt (o.plan_start_date)
                 ,date_to_clientdt (o.plan_cmplt_date)
                 ,NVL (date_to_clientdt (o.actual_start_date)
                      ,date_to_clientdt (o.plan_start_date) )
                 ,NVL (date_to_clientdt (o.actual_cmplt_date)
                      ,date_to_clientdt (o.plan_cmplt_date) )
                 ,NVL (f.process_qty_um, ' '), NVL (r.step_status, 0)
             FROM gme_batch_steps r
                 ,gme_batch_step_activities a
                 ,gme_batch_step_resources o
                 ,gmd_operations f
                 ,gme_batch_header b
                 ,cr_rsrc_mst c
            WHERE r.batch_id = p_batch_id
              AND b.batch_id = r.batch_id
              AND r.batchstep_no = p_batchstep_no
              AND a.batchstep_id = r.batchstep_id
              AND a.delete_mark = 0
              AND o.batchstep_id = a.batchstep_id
              AND o.batchstep_activity_id = a.batchstep_activity_id
              AND a.activity = p_activity
              AND f.oprn_id = r.oprn_id
              AND r.batch_id = o.batch_id
              AND o.resources = c.resources
              AND o.resources LIKE p_resource
              AND (   o.prim_rsrc_ind = p_prim_rsrc_ind
                   OR o.prim_rsrc_ind = p_aux_rsrc_ind
                   OR o.prim_rsrc_ind = p_sec_rsrc_ind)
         ORDER BY 13;

Line: 1695


         resources.DELETE;

Line: 1789


         SELECT b.formula_id, b.routing_id, b.recipe_validity_rule_id
               ,v.recipe_id
           FROM gme_batch_header b, gmd_recipe_validity_rules v
          WHERE b.batch_id = p_batch_id
            AND b.recipe_validity_rule_id = v.recipe_validity_rule_id(+);

Line: 1797


         SELECT routing_no, routing_vers, routing_desc
           FROM gmd_routings
          WHERE routing_id = p_routing_id;

Line: 1803


         SELECT formula_no, formula_vers, formula_desc1
           FROM fm_form_mst
          WHERE formula_id = p_formula_id;

Line: 1809


         SELECT recipe_no, recipe_version, recipe_description
           FROM gmd_recipes
          WHERE recipe_id = p_recipe_id;

Line: 1948


         SELECT p.calendar_code, c.description
           FROM mtl_parameters p, bom_calendars c
          WHERE p.organization_id = p_organization_id
                AND c.calendar_code = p.calendar_code;

Line: 1986


         SELECT MIN (date_to_clientdt (calendar_start_date) )
               ,MAX (date_to_clientdt (calendar_end_date) )
           FROM bom_calendars
          WHERE calendar_code = p_calendar_code;