APPS.WIP_MTLTEMPPROC_GRP SQL Statements

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

Line: 77

                                     p_delete_stack => fnd_api.g_false,
                                     p_separator => ' ');

Line: 82

      update mtl_material_transactions_temp
         set process_flag = 'E',
             error_code = substr(l_errCode,1,240),
             error_explanation = substr(x_errorMsg,1,240)
       where transaction_header_id = p_txnHdrID
         and process_flag in ('Y', 'W')
         and transaction_source_type_id = 5
         and transaction_action_id in (wip_constants.isscomp_action,
                                       wip_constants.retcomp_action,
                                       wip_constants.issnegc_action,
                                       wip_constants.retnegc_action);

Line: 153

    select transaction_source_type_id,
           wip_entity_type,
           transaction_source_id,
           organization_id,
           transaction_action_id
      into l_txnSrcTypID,
           l_wipEntityType,
           l_wipEntityID,
           l_orgID,
           l_txnActionID
      from mtl_material_transactions_temp
     where transaction_temp_id = p_txnTmpID;

Line: 185

        select entity_type
          into l_wipEntityType
          from wip_entities
         where wip_entity_id = l_wipEntityID
           and organization_id = l_orgID;