APPS.INV_TXN_PURGE_MAIN SQL Statements

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

Line: 47

      SELECT   period_start_date
             , schedule_close_date
             , acct_period_id
          FROM org_acct_periods
         WHERE period_start_date <= p_purge_date
           AND open_flag = 'N'
           AND organization_id = p_orgid
           AND acct_period_id >= l_min_period_id
      ORDER BY acct_period_id;

Line: 71

    SELECT MIN(transaction_date)
      INTO l_min_mmt_date
      FROM mtl_material_transactions
     WHERE organization_id = p_orgid
       AND transaction_date <= p_purge_date;

Line: 82

      SELECT acct_period_id
        INTO l_min_period_id
        FROM org_acct_periods
       WHERE organization_id = p_orgid
         AND TRUNC(period_start_date) <= TRUNC(l_min_mmt_date)
         AND TRUNC(schedule_close_date) >= TRUNC(l_min_mmt_date)
         AND open_flag = 'N';

Line: 90

      SELECT COUNT(acct_period_id)
        INTO l_num_of_periods
        FROM org_acct_periods
       WHERE organization_id = p_orgid
         AND acct_period_id >= l_min_period_id
         AND TRUNC(period_start_date) <= TRUNC(p_purge_date)
         AND open_flag = 'N';

Line: 236

          SELECT COUNT(*)
            INTO l_count
            FROM fnd_concurrent_requests
           WHERE request_id = l_req_id
             AND phase_code = 'C';

Line: 260

         SELECT STATUS_CODE INTO l_status_code_tbl_type(idx)
         FROM  fnd_concurrent_requests
         WHERE request_id = l_reqstatus_tbl_type(idx) AND phase_code = 'C';