APPS.GMD_FETCH_OPRN SQL Statements

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

Line: 20

    SELECT 1
    FROM   gmd_operations_vl
    WHERE  oprn_id = p_oprn_id;

Line: 112

  select  o.oprn_no, o.oprn_desc, o.oprn_vers,o.oprn_id,
         a.activity,fm.activity_desc, a.oprn_line_id, a.activity_factor,a.offset_interval,
         a.sequence_dependent_ind, a.break_ind, a.max_break, a.text_code, a.creation_date,
         o.minimum_transfer_qty, a.material_ind, a.created_by,a.last_updated_by,
         a.last_update_date, a.last_update_login, a.attribute_category,
         a.attribute1,  a.attribute2, a.attribute3,  a.attribute4,
         a.attribute5, a.attribute6, a.attribute7,  a.attribute8,
         a.attribute9, a.attribute10, a.attribute11,  a.attribute12,
         a.attribute13, a.attribute14, a.attribute15,  a.attribute16,
         a.attribute17, a.attribute18, a.attribute19,  a.attribute20,
         a.attribute21, a.attribute22, a.attribute23,  a.attribute24,
         a.attribute25, a.attribute26, a.attribute27,  a.attribute28,
         a.attribute29, a.attribute30
  from     gmd_operations_vl o, gmd_operation_activities a, fm_actv_mst fm
  where   a.oprn_id = p_oprn_id
     and  a.oprn_id = o.oprn_id
     and  a.activity = fm.activity
--Added the order by for the bug 12613037.
  ORDER BY a.sequence_dependent_ind, a.oprn_line_id;

Line: 164

       	 x_oprn_act_out(i).last_updated_by 	:= get_rec.last_updated_by 	;

Line: 165

 	 x_oprn_act_out(i).last_update_date 	:= get_rec.last_update_date 	;

Line: 166

 	 x_oprn_act_out(i).last_update_login 	:= get_rec.last_update_login	;

Line: 250

  select
         o.oprn_id,o.oprn_no,o.oprn_vers, o.oprn_desc,
         a.activity,
         res.oprn_line_id,res.resources, res.resource_usage, res.resource_count,
         res.process_qty, prim_rsrc_ind, scale_type, cost_analysis_code, res.cost_cmpntcls_id,
         res.resource_usage_uom, res.offset_interval, nvl(l.max_capacity,m.max_capacity) max_capacity,
         nvl(l.min_capacity,m.min_capacity) min_capacity,
         nvl(l.capacity_um,m.capacity_um) capacity_uom, a.sequence_dependent_ind,
         nvl(l.capacity_constraint,m.capacity_constraint) capacity_constraint,
         nvl(l.capacity_tolerance, m.capacity_tolerance) capacity_tolerance,
         res.resource_process_uom, PROCESS_PARAMETER_1, PROCESS_PARAMETER_2,PROCESS_PARAMETER_3,
         PROCESS_PARAMETER_4, PROCESS_PARAMETER_5, res.text_code, res.created_by,
         res.last_updated_by,  res.last_update_date, res.creation_date, res.last_update_login,
         res.attribute_category,
         res.attribute1,  res.attribute2, res.attribute3, res.attribute4,
         res.attribute5, res.attribute6, res.attribute7,  res.attribute8,
         res.attribute9, res.attribute10,  res.attribute11,  res.attribute12,
         res.attribute13, res.attribute14, res.attribute15,  res.attribute16,
         res.attribute17, res.attribute18, res.attribute19,  res.attribute20,
         res.attribute21, res.attribute22,res.attribute23,  res.attribute24,
         res.attribute25, res.attribute26, res.attribute27,  res.attribute28,
         res.attribute29, res.attribute30
FROM    gmd_operations_vl o,gmd_operation_activities a, gmd_operation_resources res,
         cr_rsrc_mst m, cr_rsrc_dtl l
where   a.oprn_id = p_oprn_id
 and    o.oprn_id = a.oprn_id
and     a.oprn_line_id = res.oprn_line_id
and     m.resources = res.resources
AND     m.resources = l.resources (+)
AND    l.orgn_code (+) = p_orgn_code
--Added the order by for the bug 12613037.
ORDER BY a.sequence_dependent_ind, res.offset_interval, res.resources, res.oprn_line_id;

Line: 331

       	 x_oprn_resc_rec(i).last_updated_by 	:= get_rec.last_updated_by	;

Line: 333

 	 x_oprn_resc_rec(i).last_update_date 	:= get_rec.last_update_date 	;

Line: 335

 	 x_oprn_resc_rec(i).last_update_login 	:= get_rec.last_update_login	;

Line: 419

      SELECT p.*,g.parameter_name,g.parameter_description,g.units,g.parameter_type
      FROM   gmd_oprn_process_parameters_v1 p, gmp_process_parameters g
      WHERE  p.oprn_line_id = P_oprn_line_id
      AND    p.resources = P_resources
      AND    p.parameter_id = g.parameter_id
            ORDER BY sequence_no;

Line: 451

        X_oprn_resc_proc_param_tbl(X_row).last_updated_by := l_oprn_rec.last_updated_by;

Line: 452

        X_oprn_resc_proc_param_tbl(X_row).last_update_date := l_oprn_rec.last_update_date;

Line: 453

        X_oprn_resc_proc_param_tbl(X_row).last_update_login := l_oprn_rec.last_update_login;