APPS.OPI_EDW_UOM_CONV_F_C SQL Statements

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

Line: 16

 l_rows_inserted            Number:=0;

Line: 76

   Insert Into OPI_EDW_UOM_CONV_FSTG@EDW_APPS_TO_WH(
     BASE_UOM,
     CONVERSION_RATE,
     EDW_BASE_UOM_FK,
     EDW_CONVERSION_RATE,
     EDW_UOM_FK,
     INSTANCE_FK,
     INVENTORY_ITEM_ID,
     UOM,
     UOM_CONV_PK,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE10,
     USER_ATTRIBUTE11,
     USER_ATTRIBUTE12,
     USER_ATTRIBUTE13,
     USER_ATTRIBUTE14,
     USER_ATTRIBUTE15,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     USER_ATTRIBUTE6,
     USER_ATTRIBUTE7,
     USER_ATTRIBUTE8,
     USER_ATTRIBUTE9,
     USER_FK1,
     USER_FK2,
     USER_FK3,
     USER_FK4,
     USER_FK5,
     USER_MEASURE1,
     USER_MEASURE2,
     USER_MEASURE3,
     USER_MEASURE4,
     USER_MEASURE5,
     OPERATION_CODE,
     COLLECTION_STATUS,
     CLASS_CONVERSION_FLAG)
   select
     BASE_UOM,
     CONVERSION_RATE,
     NVL(EDW_BASE_UOM_FK,'NA_EDW'),
     EDW_CONVERSION_RATE,
     NVL(EDW_UOM_FK,'NA_EDW'),
     NVL(INSTANCE_FK,'NA_EDW'),
     INVENTORY_ITEM_ID,
     UOM,
     UOM_CONV_PK,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE10,
     USER_ATTRIBUTE11,
     USER_ATTRIBUTE12,
     USER_ATTRIBUTE13,
     USER_ATTRIBUTE14,
     USER_ATTRIBUTE15,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     USER_ATTRIBUTE6,
     USER_ATTRIBUTE7,
     USER_ATTRIBUTE8,
     USER_ATTRIBUTE9,
     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'),
     USER_MEASURE1,
     USER_MEASURE2,
     USER_MEASURE3,
     USER_MEASURE4,
     USER_MEASURE5,
     NULL, -- OPERATION_CODE
     'NOT-COLLECTIBLE',
     CLASS_CONVERSION_FLAG
   from OPI_EDW_UOM_CONV_FCV@apps_to_apps
   where last_update_date between l_date1 and l_date2;

Line: 154

   l_rows_inserted := sql%rowcount;

Line: 157

   edw_log.put_line('Inserted'||to_char(nvl(sql%rowcount,0))||
         ' rows into the staging table');