DBA Data[Home] [Help]

APPS.EDW_MTL_INVENTORY_LOC_M_C SQL Statements

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

Line: 14

 l_rows_inserted            Number:=0;
Line: 57

   edw_log.put_line('Total rows inserted : '||g_row_count);
Line: 82

    l_rows_inserted NUMBER :=0;
Line: 87

   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;
Line: 125

   l_rows_inserted := sql%rowcount;
Line: 127

   EDW_MTL_INVENTORY_LOC_M_C.g_lowest_level_count := l_rows_inserted;
Line: 129

   EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
Line: 130

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

    l_rows_inserted NUMBER :=0;
Line: 147

   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;
Line: 183

   l_rows_inserted := sql%rowcount;
Line: 184

   EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
Line: 185

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

    l_rows_inserted NUMBER :=0;
Line: 202

   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;
Line: 242

   l_rows_inserted := sql%rowcount;
Line: 243

   EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
Line: 244

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

    l_rows_inserted NUMBER :=0;
Line: 261

   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;
Line: 307

   l_rows_inserted := sql%rowcount;
Line: 308

   EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
Line: 309

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

    l_rows_inserted NUMBER :=0;
Line: 326

   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;
Line: 364

   l_rows_inserted := sql%rowcount;
Line: 365

   EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
Line: 366

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

    l_rows_inserted NUMBER :=0;
Line: 383

   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;
Line: 421

   l_rows_inserted := sql%rowcount;
Line: 422

   EDW_MTL_INVENTORY_LOC_M_C.g_row_count := EDW_MTL_INVENTORY_LOC_M_C.g_row_count + l_rows_inserted ;
Line: 423

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