APPS.EAM_MRI_UTILS SQL Statements

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

Line: 14

        ' select interface_id
          from eam_meter_readings_interface mri' ||
        ' where mri.group_id = :x_group_id'||
        ' and mri.process_phase = '|| WIP_CONSTANTS.ML_VALIDATION ||
        ' and mri.process_status in ('|| WIP_CONSTANTS.RUNNING||
                                ','||WIP_CONSTANTS.PENDING||
                                ','||WIP_CONSTANTS.WARNING ||') and '||
        replace(p_where_clause, '    ',' ');

Line: 82

              ' UPDATE  eam_meter_readings_interface mri'||
              ' SET PROCESS_STATUS = ' ||P_New_Process_Status|| '
                WHERE   GROUP_ID = ' || P_Group_Id || '
                AND     PROCESS_PHASE = ' || WIP_CONSTANTS.ML_VALIDATION || '
                AND     PROCESS_STATUS IN ('|| WIP_CONSTANTS.RUNNING||
                                           ','||WIP_CONSTANTS.PENDING||
                                           ','||WIP_CONSTANTS.WARNING ||')'||
              ' AND  ' || replace(p_where_clause, '    ',' ');

Line: 93

              ' UPDATE  eam_meter_readings_interface mri'||
              ' SET PROCESS_STATUS = :process_status
                WHERE   GROUP_ID = :group_id
                AND     PROCESS_PHASE = WIP_CONSTANTS.ML_VALIDATION
                AND     PROCESS_STATUS IN (WIP_CONSTANTS.RUNNING,
                                          WIP_CONSTANTS.PENDING,
                                          WIP_CONSTANTS.WARNING)
               AND ' ||  replace(p_where_clause, '    ',' ');