APPS.OPI_EDW_OPM_RES_UTIL_F_C SQL Statements

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

Line: 27

     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,
      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 */
      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,
      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_OPM_RES_UTIL_FCV
    WHERE LAST_UPDATE_DATE BETWEEN L_FROM_DATE AND L_TO_DATE;

Line: 179

      edw_log.put_line('Inserting into local staging table ');

Line: 182

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

Line: 187

      edw_log.put_line('For all views types, inserted '||nvl(g_row_count,0)||
        ' rows into local staging table ');

Line: 194

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

Line: 207

      rollback;   -- Rollback insert into local staging

Line: 208

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