APPS.INV_MGD_MVT_RESET_TRANS SQL Statements

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

Line: 109

    UPDATE
      mtl_movement_statistics
    SET
      movement_status    = 'O'
    , edi_sent_flag      = 'N'
    , last_updated_by    = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
    , last_update_date   = SYSDATE
    , report_reference   = NULL
    WHERE  entity_org_id = p_legal_entity_id
      AND  zone_code     = p_zone_code
      AND  stat_type     = p_stat_type
      AND  usage_type    = p_usage_type
      AND  period_name   = p_period_name
      AND  document_source_type = NVL(p_document_source_type,
                                  document_source_type)
      AND  movement_status NOT IN ('I', 'P');

Line: 127

    UPDATE
      mtl_movement_statistics
    SET
      movement_status    = 'O'
    , edi_sent_flag      = 'N'
    , last_updated_by    = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
    , last_update_date   = SYSDATE
    , report_reference   = NULL
    WHERE  entity_org_id = p_legal_entity_id
      AND  zone_code     = p_zone_code
      AND  stat_type     = p_stat_type
      AND  usage_type    = p_usage_type
      AND  period_name   = p_period_name
      AND  document_source_type = NVL(p_document_source_type,
                                  document_source_type)
      AND  movement_status = 'I';

Line: 144

    UPDATE
      mtl_movement_statistics
    SET
      movement_status    = 'O'
    , edi_sent_flag      = 'N'
    , last_updated_by    = NVL(TO_NUMBER(FND_PROFILE.Value('USER_ID')),0)
    , last_update_date   = SYSDATE
    , report_reference   = NULL
    WHERE  entity_org_id = p_legal_entity_id
      AND  zone_code     = p_zone_code
      AND  stat_type     = p_stat_type
      AND  usage_type    = p_usage_type
      AND  period_name   = p_period_name
      AND  document_source_type = NVL(p_document_source_type,
                                  document_source_type)
      AND  movement_status <> 'P';