eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_HR_MVMNT_TYP_M_C SQL Statements

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

Line: 15


 l_rows_inserted            Number:=0;

Line: 76


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

Line: 100


    l_rows_inserted NUMBER :=0;

Line: 105


   Insert Into
    EDW_HR_MVMT_MVMNTS_LSTG@EDW_APPS_TO_WH(
    CREATION_DATE,
    GAIN_TYPE_LVL1_FK,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOSS_TYPE_LVL1_FK,
    MOVEMENT_CMBN_ID,
    MOVEMENT_DP,
    MOVEMENT_PK,
    NAME,
    REC_TYPE_LVL1_FK,
    SEP_TYPE_LVL1_FK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select CREATION_DATE,
    NVL(GAIN_TYPE_LVL1_FK, 'NA_EDW'),
INSTANCE,
LAST_UPDATE_DATE,
    NVL(LOSS_TYPE_LVL1_FK, 'NA_EDW'),
MOVEMENT_CMBN_ID,
MOVEMENT_DP,
MOVEMENT_PK,
NAME,
    NVL(REC_TYPE_LVL1_FK, 'NA_EDW'),
    NVL(SEP_TYPE_LVL1_FK, 'NA_EDW'),
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_MVMNTS_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 147


   l_rows_inserted := sql%rowcount;

Line: 148


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 149


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

Line: 164


    l_rows_inserted NUMBER :=0;

Line: 169


   Insert Into
    EDW_HR_MVMT_GAIN_1_LSTG@EDW_APPS_TO_WH(
    CREATION_DATE,
    GAIN_TYPE_LVL1_DP,
    GAIN_TYPE_LVL1_ID,
    GAIN_TYPE_LVL1_PK,
    GAIN_TYPE_LVL2_FK,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOOKUP_CODE,
    NAME,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select CREATION_DATE,
GAIN_TYPE_LVL1_DP,
GAIN_TYPE_LVL1_ID,
GAIN_TYPE_LVL1_PK,
    NVL(GAIN_TYPE_LVL2_FK, 'NA_EDW'),
INSTANCE,
LAST_UPDATE_DATE,
LOOKUP_CODE,
NAME,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_GAIN_1_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 207


   l_rows_inserted := sql%rowcount;

Line: 208


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 209


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

Line: 224


    l_rows_inserted NUMBER :=0;

Line: 229


   Insert Into
    EDW_HR_MVMT_LOSS_1_LSTG@EDW_APPS_TO_WH(
    CREATION_DATE,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOOKUP_CODE,
    LOSS_TYPE_LVL1_DP,
    LOSS_TYPE_LVL1_ID,
    LOSS_TYPE_LVL1_PK,
    LOSS_TYPE_LVL2_FK,
    NAME,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select CREATION_DATE,
INSTANCE,
LAST_UPDATE_DATE,
LOOKUP_CODE,
LOSS_TYPE_LVL1_DP,
LOSS_TYPE_LVL1_ID,
LOSS_TYPE_LVL1_PK,
    NVL(LOSS_TYPE_LVL2_FK, 'NA_EDW'),
NAME,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_LOSS_1_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 267


   l_rows_inserted := sql%rowcount;

Line: 268


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 269


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

Line: 284


    l_rows_inserted NUMBER :=0;

Line: 289


   Insert Into
    EDW_HR_MVMT_RCTMNT_1_LSTG@EDW_APPS_TO_WH(
    CREATION_DATE,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOOKUP_CODE,
    NAME,
    REC_TYPE_LVL1_DP,
    REC_TYPE_LVL1_ID,
    REC_TYPE_LVL1_PK,
    REC_TYPE_LVL2_FK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select CREATION_DATE,
INSTANCE,
LAST_UPDATE_DATE,
LOOKUP_CODE,
NAME,
REC_TYPE_LVL1_DP,
REC_TYPE_LVL1_ID,
REC_TYPE_LVL1_PK,
    NVL(REC_TYPE_LVL2_FK, 'NA_EDW'),
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_RCTMNT_1_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 327


   l_rows_inserted := sql%rowcount;

Line: 328


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 329


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

Line: 344


    l_rows_inserted NUMBER :=0;

Line: 349


   Insert Into
    EDW_HR_MVMT_SPRTN_1_LSTG@EDW_APPS_TO_WH(
    CREATION_DATE,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOOKUP_CODE,
    NAME,
    SEP_TYPE_LVL1_DP,
    SEP_TYPE_LVL1_ID,
    SEP_TYPE_LVL1_PK,
    SEP_TYPE_LVL2_FK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select CREATION_DATE,
INSTANCE,
LAST_UPDATE_DATE,
LOOKUP_CODE,
NAME,
SEP_TYPE_LVL1_DP,
SEP_TYPE_LVL1_ID,
SEP_TYPE_LVL1_PK,
    NVL(SEP_TYPE_LVL2_FK, 'NA_EDW'),
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_SPRTN_1_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 387


   l_rows_inserted := sql%rowcount;

Line: 388


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 389


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

Line: 404


    l_rows_inserted NUMBER :=0;

Line: 409


   Insert Into
    EDW_HR_MVMT_GAIN_2_LSTG@EDW_APPS_TO_WH(
    CREATION_DATE,
    GAIN_TYPE_LVL2_DP,
    GAIN_TYPE_LVL2_ID,
    GAIN_TYPE_LVL2_PK,
    GAIN_TYPE_LVL3_FK,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOOKUP_CODE,
    NAME,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select CREATION_DATE,
GAIN_TYPE_LVL2_DP,
GAIN_TYPE_LVL2_ID,
GAIN_TYPE_LVL2_PK,
    NVL(GAIN_TYPE_LVL3_FK, 'NA_EDW'),
INSTANCE,
LAST_UPDATE_DATE,
LOOKUP_CODE,
NAME,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_GAIN_2_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 447


   l_rows_inserted := sql%rowcount;

Line: 448


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 449


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

Line: 464


    l_rows_inserted NUMBER :=0;

Line: 469


   Insert Into
    EDW_HR_MVMT_LOSS_2_LSTG@EDW_APPS_TO_WH(
    CREATION_DATE,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOOKUP_CODE,
    LOSS_TYPE_LVL2_DP,
    LOSS_TYPE_LVL2_ID,
    LOSS_TYPE_LVL2_PK,
    LOSS_TYPE_LVL3_FK,
    NAME,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select CREATION_DATE,
INSTANCE,
LAST_UPDATE_DATE,
LOOKUP_CODE,
LOSS_TYPE_LVL2_DP,
LOSS_TYPE_LVL2_ID,
LOSS_TYPE_LVL2_PK,
    NVL(LOSS_TYPE_LVL3_FK, 'NA_EDW'),
NAME,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_LOSS_2_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 507


   l_rows_inserted := sql%rowcount;

Line: 508


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 509


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

Line: 524


    l_rows_inserted NUMBER :=0;

Line: 529


   Insert Into
    EDW_HR_MVMT_RCTMNT_2_LSTG@EDW_APPS_TO_WH(
    CREATION_DATE,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOOKUP_CODE,
    NAME,
    REC_TYPE_LVL2_DP,
    REC_TYPE_LVL2_ID,
    REC_TYPE_LVL2_PK,
    REC_TYPE_LVL3_FK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select CREATION_DATE,
INSTANCE,
LAST_UPDATE_DATE,
LOOKUP_CODE,
NAME,
REC_TYPE_LVL2_DP,
REC_TYPE_LVL2_ID,
REC_TYPE_LVL2_PK,
    NVL(REC_TYPE_LVL3_FK, 'NA_EDW'),
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_RCTMNT_2_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 567


   l_rows_inserted := sql%rowcount;

Line: 568


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 569


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

Line: 584


    l_rows_inserted NUMBER :=0;

Line: 589


   Insert Into
    EDW_HR_MVMT_SPRTN_2_LSTG@EDW_APPS_TO_WH(
    CREATION_DATE,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOOKUP_CODE,
    NAME,
    SEP_TYPE_LVL2_DP,
    SEP_TYPE_LVL2_ID,
    SEP_TYPE_LVL2_PK,
    SEP_TYPE_LVL3_FK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select CREATION_DATE,
INSTANCE,
LAST_UPDATE_DATE,
LOOKUP_CODE,
NAME,
SEP_TYPE_LVL2_DP,
SEP_TYPE_LVL2_ID,
SEP_TYPE_LVL2_PK,
    NVL(SEP_TYPE_LVL3_FK, 'NA_EDW'),
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_SPRTN_2_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 627


   l_rows_inserted := sql%rowcount;

Line: 628


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 629


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

Line: 644


    l_rows_inserted NUMBER :=0;

Line: 649


   Insert Into
    EDW_HR_MVMT_GAIN_3_LSTG@EDW_APPS_TO_WH(
    ALL_FK,
    CREATION_DATE,
    GAIN_TYPE_LVL3_DP,
    GAIN_TYPE_LVL3_ID,
    GAIN_TYPE_LVL3_PK,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOOKUP_CODE,
    NAME,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select     NVL(ALL_FK, 'NA_EDW'),
CREATION_DATE,
GAIN_TYPE_LVL3_DP,
GAIN_TYPE_LVL3_ID,
GAIN_TYPE_LVL3_PK,
INSTANCE,
LAST_UPDATE_DATE,
LOOKUP_CODE,
NAME,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_GAIN_3_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 687


   l_rows_inserted := sql%rowcount;

Line: 688


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 689


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

Line: 704


    l_rows_inserted NUMBER :=0;

Line: 709


   Insert Into
    EDW_HR_MVMT_LOSS_3_LSTG@EDW_APPS_TO_WH(
    ALL_FK,
    CREATION_DATE,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOOKUP_CODE,
    LOSS_TYPE_LVL3_DP,
    LOSS_TYPE_LVL3_ID,
    LOSS_TYPE_LVL3_PK,
    NAME,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select     NVL(ALL_FK, 'NA_EDW'),
CREATION_DATE,
INSTANCE,
LAST_UPDATE_DATE,
LOOKUP_CODE,
LOSS_TYPE_LVL3_DP,
LOSS_TYPE_LVL3_ID,
LOSS_TYPE_LVL3_PK,
NAME,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_LOSS_3_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 747


   l_rows_inserted := sql%rowcount;

Line: 748


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 749


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

Line: 764


    l_rows_inserted NUMBER :=0;

Line: 769


   Insert Into
    EDW_HR_MVMT_RCTMNT_3_LSTG@EDW_APPS_TO_WH(
    ALL_FK,
    CREATION_DATE,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOOKUP_CODE,
    NAME,
    REC_TYPE_LVL3_DP,
    REC_TYPE_LVL3_ID,
    REC_TYPE_LVL3_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select     NVL(ALL_FK, 'NA_EDW'),
CREATION_DATE,
INSTANCE,
LAST_UPDATE_DATE,
LOOKUP_CODE,
NAME,
REC_TYPE_LVL3_DP,
REC_TYPE_LVL3_ID,
REC_TYPE_LVL3_PK,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_RCTMNT_3_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 807


   l_rows_inserted := sql%rowcount;

Line: 808


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 809


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

Line: 824


    l_rows_inserted NUMBER :=0;

Line: 829


   Insert Into
    EDW_HR_MVMT_SPRTN_3_LSTG@EDW_APPS_TO_WH(
    ALL_FK,
    CREATION_DATE,
    INSTANCE,
    LAST_UPDATE_DATE,
    LOOKUP_CODE,
    NAME,
    SEP_TYPE_LVL3_DP,
    SEP_TYPE_LVL3_ID,
    SEP_TYPE_LVL3_PK,
    USER_ATTRIBUTE1,
    USER_ATTRIBUTE2,
    USER_ATTRIBUTE3,
    USER_ATTRIBUTE4,
    USER_ATTRIBUTE5,
    OPERATION_CODE,
    COLLECTION_STATUS)
   select     NVL(ALL_FK, 'NA_EDW'),
CREATION_DATE,
INSTANCE,
LAST_UPDATE_DATE,
LOOKUP_CODE,
NAME,
SEP_TYPE_LVL3_DP,
SEP_TYPE_LVL3_ID,
SEP_TYPE_LVL3_PK,
USER_ATTRIBUTE1,
USER_ATTRIBUTE2,
USER_ATTRIBUTE3,
USER_ATTRIBUTE4,
USER_ATTRIBUTE5,
    NULL, -- OPERATION_CODE
    'READY'
   from EDW_HR_MVMT_SPRTN_3_LCV@APPS_TO_APPS
   where last_update_date between l_date1 and l_date2;

Line: 867


   l_rows_inserted := sql%rowcount;

Line: 868


   EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

Line: 869


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