APPS.FII_PA_UOM_CONV_F_C SQL Statements

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

Line: 20

 l_rows_inserted            Number:=0;

Line: 74

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
  'PA-' || lookup_code,                  -- BASE_UOM,
  1,                                     -- CONVERSION_RATE,
  null,                                  -- EDW_BASE_UOM_FK,
  null,                                  -- EDW_CONVERSION_RATE,
  null,                                  -- EDW_UOM_FK,
  NVL(l_instance_code,'NA_EDW'),         -- INSTANCE_FK,
  0,                                     -- INVENTORY_ITEM_ID,
  'PA-' || lookup_code,                  -- UOM,
  'STANDARD-PA-' || lookup_code || '-' ||
     l_instance_code,			 -- UOM_CONV_PK,
  null, null, null, null, null, null, null,
  null, null, null, null, null, null, null, null,
  'NA_EDW',
  'NA_EDW',
  'NA_EDW',
  'NA_EDW',
  'NA_EDW',
  null, null, null, null, null,
  NULL,
  'NOT-COLLECTIBLE',
  'N'
from PA_LOOKUPS@APPS_TO_APPS
where lookup_type = 'UNIT'
and   last_update_date between l_date1 and l_date2;

Line: 140

  l_rows_inserted := nvl(sql%rowcount,0);

Line: 144

     edw_log.put_line('Inserted ' || to_char(l_rows_inserted) ||
           ' rows into the staging table');