APPS.OPI_EDW_OPI_RES_UTIL_F_C SQL Statements

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

Line: 28

   Insert Into opi_edw_res_util_fstg
     (res_util_pk,
      locator_fk,
      res_fk,
      trx_date_fk,
      uom_fk,
      instance_fk,
      USER_FK1,USER_FK2,USER_FK3, USER_FK4, USER_FK5,
      act_res_usage,
      avail_res,
      department,
      trx_date,
      USER_MEASURE1,USER_MEASURE2, USER_MEASURE3,
      USER_MEASURE4, USER_MEASURE5,
      last_update_date,
      creation_date,
      USER_ATTRIBUTE1,
      USER_ATTRIBUTE2,
      USER_ATTRIBUTE3,
      USER_ATTRIBUTE4,
      USER_ATTRIBUTE5,
      USER_ATTRIBUTE6,
      USER_ATTRIBUTE7,
      USER_ATTRIBUTE8,
      USER_ATTRIBUTE9,
      USER_ATTRIBUTE10,
      USER_ATTRIBUTE11,
      USER_ATTRIBUTE12,
      USER_ATTRIBUTE13,
      USER_ATTRIBUTE14,
      USER_ATTRIBUTE15,
      collection_status)
     SELECT /*+ ALL_ROWS */
     Nvl(res_util_pk,'NA_EDW'),
     Nvl(locator_fk,'NA_EDW'),
     Nvl(res_fk,'NA_EDW'),
     Nvl(trx_date_fk,'NA_EDW'),
     Nvl(uom_fk,'NA_EDW'),
     Nvl(instance_fk,'NA_EDW'),
     NVL(USER_FK1,'NA_EDW'),
     NVL(USER_FK2,'NA_EDW'),
     NVL(USER_FK3,'NA_EDW'),
     NVL(USER_FK4,'NA_EDW'),
     NVL(USER_FK5,'NA_EDW'),
     act_res_usage,
     avail_res,
     department,
     trx_date,
     USER_MEASURE1,
     USER_MEASURE2,
     USER_MEASURE3,
     USER_MEASURE4,
     USER_MEASURE5,
     Sysdate,
     Sysdate,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     USER_ATTRIBUTE6,
     USER_ATTRIBUTE7,
     USER_ATTRIBUTE8,
     USER_ATTRIBUTE9,
     USER_ATTRIBUTE10,
     USER_ATTRIBUTE11,
     USER_ATTRIBUTE12,
     USER_ATTRIBUTE13,
     USER_ATTRIBUTE14,
     USER_ATTRIBUTE15,
     'LOCAL READY'
     FROM opi_edw_opi_res_util_fcv;

Line: 187

   edw_log.put_line('Inserting into local push log table ');

Line: 195

   edw_log.put_line('Inserting into local staging table for view type 1');

Line: 205

   edw_log.put_line('Inserted '||nvl(l_row_count,0)||
		    ' rows into the local staging table');

Line: 207

   edw_log.put_line( 'The system time after insert is ' ||
        to_char(sysdate,'MM/DD/YYYY HH24:MI:SS') );

Line: 236

      rollback;   -- Rollback insert into local staging

Line: 237

      edw_log.put_line('Inserting into local staging have failed');