APPS.INV_OPM_REASON_CODE_MIGRATION SQL Statements

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

Line: 35

SELECT  b.reason_code,
        b.delete_mark,
        tl.reason_desc1,
        b.creation_date,
        b.created_by,
        b.last_updated_by,
        b.last_update_login
   FROM sy_reas_cds_b b, sy_reas_cds_tl tl,
        fnd_languages fl
  WHERE tl.language = fl.language_code
    AND fl.installed_flag = 'B'
    AND b.reason_code = tl.reason_code
    AND b.reason_id IS NULL;

Line: 64

         SELECT mtl_transaction_reasons_s.nextval
           INTO l_reason_id FROM DUAL;

Line: 67

         INSERT INTO mtl_transaction_reasons
                 (  reason_id
                  , reason_name
                  , description
                  , disable_date
                  , creation_date
                  , created_by
                  , last_update_date
                  , last_updated_by
                  , last_update_login) VALUES
		 (l_reason_id
		, l_rec.reason_code
		, l_rec.reason_desc1
                , DECODE(l_rec.delete_mark,1,SYSDATE,NULL)
		, SYSDATE
		, l_rec.created_by
		, SYSDATE
		, l_rec.last_updated_by
		, l_rec.last_update_login);

Line: 89

         UPDATE sy_reas_cds_b
            SET reason_id = l_reason_id
          WHERE reason_code = l_rec.reason_code;