The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_rows_inserted Number:=0;
edw_log.put_line('Total rows inserted : '||g_row_count);
l_rows_inserted NUMBER :=0;
Insert Into
EDW_MTL_ILDM_LOCATOR_LSTG@EDW_APPS_TO_WH(
CREATION_DATE,
DESCRIPTION,
ENABLED_FLAG,
INSTANCE_CODE,
LAST_UPDATE_DATE,
LOCATOR_DP,
LOCATOR_NAME,
LOCATOR_PK,
NAME,
STOCK_ROOM_FK,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
OPERATION_CODE,
COLLECTION_STATUS)
select CREATION_DATE,
DESCRIPTION,
ENABLED_FLAG,
INSTANCE_CODE,
LAST_UPDATE_DATE,
LOCATOR_DP,
LOCATOR_NAME,
LOCATOR_PK,
NAME,
NVL(STOCK_ROOM_FK, 'NA_EDW'),
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
NULL, -- OPERATION_CODE
'READY'
from EDW_MTL_ILDM_LOCATOR_LCV@APPS_TO_APPS
where last_update_date between l_date1 and l_date2;
l_rows_inserted := sql%rowcount;
EDW_MTL_INVENTORY_LOC_M_C.g_lowest_level_count := l_rows_inserted;
EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
' rows into the staging table');
l_rows_inserted NUMBER :=0;
Insert Into
EDW_MTL_ILDM_SUB_INV_LSTG@EDW_APPS_TO_WH(
CREATION_DATE,
DESCRIPTION,
INSTANCE_CODE,
LAST_UPDATE_DATE,
NAME,
PLANT_FK,
STOCK_ROOM,
STOCK_ROOM_DP,
STOCK_ROOM_PK,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
OPERATION_CODE,
COLLECTION_STATUS)
select CREATION_DATE,
DESCRIPTION,
INSTANCE_CODE,
LAST_UPDATE_DATE,
NAME,
NVL(PLANT_FK, 'NA_EDW'),
STOCK_ROOM,
STOCK_ROOM_DP,
STOCK_ROOM_PK,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
NULL, -- OPERATION_CODE
'READY'
from EDW_MTL_ILDM_SUB_INV_LCV@APPS_TO_APPS
where last_update_date between l_date1 and l_date2;
l_rows_inserted := sql%rowcount;
EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
' rows into the staging table');
l_rows_inserted NUMBER :=0;
Insert Into
EDW_MTL_ILDM_PLANT_LSTG@EDW_APPS_TO_WH(
OPERATING_UNIT_FK,
CREATION_DATE,
DESCRIPTION,
INSTANCE_CODE,
LAST_UPDATE_DATE,
NAME,
ORGANIZATION_CODE,
ORGANIZATION_NAME,
PLANT_DP,
PLANT_PK,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
OPM_ORGANIZATION_FK,
OPERATION_CODE,
COLLECTION_STATUS)
select NVL(Operating_Unit_FK, 'NA_EDW'),
CREATION_DATE,
DESCRIPTION,
INSTANCE_CODE,
LAST_UPDATE_DATE,
NAME,
ORGANIZATION_CODE,
ORGANIZATION_NAME,
PLANT_DP,
PLANT_PK,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
NVL(OPM_Organization_FK, 'NA_EDW'),
NULL, -- OPERATION_CODE
'READY'
from EDW_MTL_ILDM_PLANT_LCV@APPS_TO_APPS
where last_update_date between l_date1 and l_date2;
l_rows_inserted := sql%rowcount;
EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
' rows into the staging table');
l_rows_inserted NUMBER :=0;
Insert Into
EDW_MTL_ILDM_OU_LSTG@EDW_APPS_TO_WH(
OPERATING_UNIT_PK,
OPERATING_UNIT_DP,
NAME,
BUSINESS_GROUP,
DATE_FROM,
DATE_TO,
INT_EXT_FLAG,
ORG_TYPE,
ORG_CODE,
PRIMARY_CST_MTHD,
INSTANCE,
ALL_FK,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
CREATION_DATE,
LAST_UPDATE_DATE,
OPERATION_CODE,
COLLECTION_STATUS)
select OPERATING_UNIT_PK,
OPERATING_UNIT_DP,
NAME,
BUSINESS_GROUP,
DATE_FROM,
DATE_TO,
INT_EXT_FLAG,
ORG_TYPE,
ORG_CODE,
PRIMARY_CST_MTHD,
INSTANCE,
NVL(ALL_FK, 'NA_EDW'),
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
CREATION_DATE,
LAST_UPDATE_DATE,
NULL, -- OPERATION_CODE
'READY'
from EDW_MTL_ILDM_OU_LCV@APPS_TO_APPS
where last_update_date between l_date1 and l_date2;
l_rows_inserted := sql%rowcount;
EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
' rows into the staging table');
l_rows_inserted NUMBER :=0;
Insert Into
EDW_MTL_ILDM_PORG_LSTG@EDW_APPS_TO_WH(
OPM_COMPANY_FK,
CREATION_DATE,
DESCRIPTION,
INSTANCE_CODE,
LAST_UPDATE_DATE,
NAME,
OPM_ORGANIZATION_CODE,
OPM_ORGANIZATION_NAME,
OPM_ORGANIZATION_DP,
OPM_ORGANIZATION_PK,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
OPERATION_CODE,
COLLECTION_STATUS)
select NVL(OPM_COMPANY_FK, 'NA_EDW'),
CREATION_DATE,
DESCRIPTION,
INSTANCE_CODE,
LAST_UPDATE_DATE,
NAME,
OPM_ORGANIZATION_CODE,
OPM_ORGANIZATION_NAME,
OPM_ORGANIZATION_DP,
OPM_ORGANIZATION_PK,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
NULL, -- OPERATION_CODE
'READY'
from EDW_MTL_ILDM_PORG_LCV@APPS_TO_APPS
where last_update_date between l_date1 and l_date2;
l_rows_inserted := sql%rowcount;
EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
' rows into the staging table');
l_rows_inserted NUMBER :=0;
Insert Into
EDW_MTL_ILDM_PCMP_LSTG@EDW_APPS_TO_WH(
OPERATING_UNIT_FK,
OPM_COMPANY_NAME,
OPM_COMPANY_DP,
OPM_COMPANY_PK,
CREATION_DATE,
DESCRIPTION,
INSTANCE_CODE,
LAST_UPDATE_DATE,
NAME,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
OPM_COMPANY_CODE,
OPERATION_CODE,
COLLECTION_STATUS)
select NVL(OPERATING_UNIT_FK, 'NA_EDW'),
OPM_COMPANY_NAME,
OPM_COMPANY_DP,
OPM_COMPANY_PK,
CREATION_DATE,
DESCRIPTION,
INSTANCE_CODE,
LAST_UPDATE_DATE,
NAME,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
OPM_COMPANY_CODE,
NULL, -- OPERATION_CODE
'READY'
from EDW_MTL_ILDM_PCMP_LCV@APPS_TO_APPS
where last_update_date between l_date1 and l_date2;
l_rows_inserted := sql%rowcount;
EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
' rows into the staging table');