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_BOM_RES_M_C SQL Statements

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

Line: 69


 l_rows_inserted            Number:=0;

Line: 87


   Insert Into EDW_BRES_PLANT_LSTG(
     ALL_FK,
     ALL_FK_KEY,
     CREATION_DATE,
     DESCRIPTION,
     ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     NAME,
     ORGANIZATION_CODE,
     ORGANIZATION_NAME,
     PLANT_DP,
     PLANT_PK,
     REQUEST_ID,
     ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     OPERATION_CODE,
     COLLECTION_STATUS)
   select
     ALL_FK,
     NULL, --ALL_FK_KEY,
     CREATION_DATE,
     substrb(DESCRIPTION,1,240),
     NULL, --ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     SUBSTRB(NAME,1,320),
     ORGANIZATION_CODE,
     SUBSTRB(ORGANIZATION_NAME,1,500),
     PLANT_DP,
     PLANT_PK,
     NULL, --REQUEST_ID,
     NULL, --ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     NULL, -- OPERATION_CODE
     'READY'
   from EDW_BRES_PLANT_LCV
   where last_update_date between l_push_date_range1 and l_push_date_range2;

Line: 133


   l_rows_inserted := sql%rowcount;

Line: 135


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

Line: 143


   EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

Line: 158


 l_rows_inserted            Number:=0;

Line: 176


   Insert Into EDW_BRES_PLANT1_LSTG(
     ALL_FK,
     ALL_FK_KEY,
     CREATION_DATE,
     DESCRIPTION,
     ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     NAME,
     ORGANIZATION_CODE,
     ORGANIZATION_NAME,
     PLANT_DP,
     PLANT_PK,
     REQUEST_ID,
     ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     OPERATION_CODE,
     COLLECTION_STATUS)
   select
     ALL_FK,
     NULL, --ALL_FK_KEY,
     CREATION_DATE,
     substrb(DESCRIPTION,1,240),
     NULL, --ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     substrb(NAME,1,320),
     ORGANIZATION_CODE,
     SUBSTRB(ORGANIZATION_NAME,1,500),
     PLANT_DP,
     PLANT_PK,
     NULL, --REQUEST_ID,
     NULL, --ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     NULL, -- OPERATION_CODE
     'READY'
   from EDW_BRES_PLANT_LCV
   where last_update_date between l_push_date_range1 and l_push_date_range2;

Line: 222


   l_rows_inserted := sql%rowcount;

Line: 224


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

Line: 232


   EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

Line: 247


 l_rows_inserted            Number:=0;

Line: 263


   Insert Into EDW_BRES_RESOURCE_LSTG(
     AVAIL_24_HRS_FLAG,
     CREATION_DATE,
     DEPARTMENT_FK,
     DEPARTMENT_FK_KEY,
     DESCRIPTION,
     ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     MAXIMUM_RATE,
     MINIMUM_RATE,
     NAME,
     REQUEST_ID,
     RESOURCE_CATEGORY1_FK,
     RESOURCE_CATEGORY1_FK_KEY,
     RESOURCE_CATEGORY2_FK,
     RESOURCE_CATEGORY2_FK_KEY,
     RESOURCE_CODE,
     RESOURCE_DP,
     RESOURCE_GROUP_FK,
     RESOURCE_GROUP_FK_KEY,
     RESOURCE_PK,
     ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     OPERATION_CODE,
     COLLECTION_STATUS)
   select
     AVAIL_24_HRS_FLAG,
     CREATION_DATE,
     DEPARTMENT_FK,
     NULL, --DEPARTMENT_FK_KEY,
     substrb(DESCRIPTION,1,240),
     NULL, --ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     MAXIMUM_RATE,
     MINIMUM_RATE,
     substrb(NAME,1,320),
     NULL, --REQUEST_ID,
     RESOURCE_CATEGORY1_FK,
     NULL, --RESOURCE_CATEGORY1_FK_KEY,
     RESOURCE_CATEGORY2_FK,
     NULL, --RESOURCE_CATEGORY2_FK_KEY,
     RESOURCE_CODE,
     RESOURCE_DP,
     RESOURCE_GROUP_FK,
     NULL, --RESOURCE_GROUP_FK_KEY,
     RESOURCE_PK,
     NULL, --ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     NULL, -- OPERATION_CODE
     'READY'
   from EDW_BRES_RESOURCE_LCV
   where last_update_date between l_push_date_range1 and l_push_date_range2;

Line: 325


   l_rows_inserted := sql%rowcount;

Line: 327


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

Line: 335


   EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

Line: 349


 l_rows_inserted            Number:=0;

Line: 365


   Insert Into EDW_BRES_RESGROUP_LSTG(
     ALL_FK,
     ALL_FK_KEY,
     CREATION_DATE,
     DESCRIPTION,
     ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     NAME,
     REQUEST_ID,
     RESOURCE_GROUP,
     RESOURCE_GROUP_DP,
     RESOURCE_GROUP_PK,
     ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     OPERATION_CODE,
     COLLECTION_STATUS)
   select
     ALL_FK,
     NULL, --ALL_FK_KEY,
     CREATION_DATE,
     substrb(DESCRIPTION,1,240),
     NULL, --ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     substrb(NAME,1,320),
     NULL, --REQUEST_ID,
     RESOURCE_GROUP,
     RESOURCE_GROUP_DP,
     RESOURCE_GROUP_PK,
     NULL, --ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     NULL, -- OPERATION_CODE
     'READY'
   from EDW_BRES_RESGROUP_LCV
   where last_update_date between l_push_date_range1 and l_push_date_range2;

Line: 409


   l_rows_inserted := sql%rowcount;

Line: 411


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

Line: 419


   EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

Line: 433


 l_rows_inserted            Number:=0;

Line: 450


   Insert Into EDW_BRES_RESTYPE_LSTG(
     ALL_FK,
     ALL_FK_KEY,
     CREATION_DATE,
     DESCRIPTION,
     ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     NAME,
     REQUEST_ID,
     RESOURCE_TYPE,
     RESOURCE_TYPE_DP,
     RESOURCE_TYPE_PK,
     ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     OPERATION_CODE,
     COLLECTION_STATUS)
   select
     ALL_FK,
     NULL, --ALL_FK_KEY,
     CREATION_DATE,
     substrb(DESCRIPTION,1,240),
     NULL, --ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     substrb(NAME,1,320),
     NULL, --REQUEST_ID,
     RESOURCE_TYPE,
     RESOURCE_TYPE_DP,
     RESOURCE_TYPE_PK,
     NULL, --ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     NULL, -- OPERATION_CODE
     'READY'
   from EDW_BRES_RESTYPE_LCV
   where last_update_date between l_push_date_range1 and l_push_date_range2;

Line: 494


   l_rows_inserted := sql%rowcount;

Line: 496


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

Line: 504


   EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

Line: 520


 l_rows_inserted            Number:=0;

Line: 536


   Insert Into EDW_BRES_RESCAT_LSTG(
     CREATION_DATE,
     DESCRIPTION,
     ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     NAME,
     PLANT_FK,
     PLANT_FK_KEY,
     REQUEST_ID,
     RESOURCE_CATEGORY,
     RESOURCE_CATEGORY_DP,
     RESOURCE_CATEGORY_PK,
     RESOURCE_TYPE_FK,
     RESOURCE_TYPE_FK_KEY,
     ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     OPERATION_CODE,
     COLLECTION_STATUS)
   select
     CREATION_DATE,
     substrb(DESCRIPTION,1,240),
     NULL, --ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     substrb(NAME,1,320),
     PLANT_FK,
     NULL, --PLANT_FK_KEY,
     NULL, --REQUEST_ID,
     NULL, --RESOURCE_CATEGORY,
     RESOURCE_CATEGORY_DP,
     RESOURCE_CATEGORY_PK,
     RESOURCE_TYPE_FK,
     NULL, --RESOURCE_TYPE_FK_KEY,
     NULL, --ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     NULL, -- OPERATION_CODE
     'READY'
   from EDW_BRES_RESCAT_LCV
   where last_update_date between l_push_date_range1 and l_push_date_range2;

Line: 584


   l_rows_inserted := sql%rowcount;

Line: 586


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

Line: 594


   EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

Line: 608


 l_rows_inserted            Number:=0;

Line: 625


   Insert Into EDW_BRES_PARENT_DEPT_LSTG(
     CREATION_DATE,
     DEPARTMENT_CLASS_FK,
     DEPARTMENT_CLASS_FK_KEY,
     DEPARTMENT_CODE,
     DESCRIPTION,
     ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     NAME,
     PARENT_DEPARTMENT_DP,
     PARENT_DEPARTMENT_PK,
     REQUEST_ID,
     ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     OPERATION_CODE,
     COLLECTION_STATUS)
   select
     CREATION_DATE,
     DEPARTMENT_CLASS_FK, --DEPARTMENT_CLASS_FK,
     NULL, --DEPARTMENT_CLASS_FK_KEY,
     SUBSTRB(DEPARTMENT_CODE,1,20),
     SUBSTRB(DESCRIPTION,1,240),
     NULL, --ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     SUBSTRB(NAME,1,320),
     DEPARTMENT_DP, --PARENT_DEPARTMENT_DP,
     DEPARTMENT_PK, --PARENT_DEPARTMENT_PK,
     NULL, --REQUEST_ID,
     NULL, --ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     NULL, -- OPERATION_CODE
     'READY'
   from EDW_BRES_DEPT_LCV
   where last_update_date between l_push_date_range1 and l_push_date_range2;

Line: 669


   l_rows_inserted := sql%rowcount;

Line: 671


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

Line: 679


   EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

Line: 695


 l_rows_inserted            Number:=0;

Line: 711


   Insert Into EDW_BRES_DEPT_LSTG(
     CREATION_DATE,
     DEPARTMENT_CODE,
     DEPARTMENT_DP,
     DEPARTMENT_PK,
     DESCRIPTION,
     ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     NAME,
     PARENT_DEPARTMENT_FK,
     PARENT_DEPARTMENT_FK_KEY,
     REQUEST_ID,
     ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     OPERATION_CODE,
     COLLECTION_STATUS)
   select
     CREATION_DATE,
     DEPARTMENT_CODE,
     DEPARTMENT_DP,
     DEPARTMENT_PK,
     substrb(DESCRIPTION,1,240),
     NULL, --ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     substrb(NAME,1,320),
     PARENT_DEPARTMENT_FK,
     NULL, --PARENT_DEPARTMENT_FK_KEY,
     NULL, --REQUEST_ID,
     NULL, --ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     NULL, -- OPERATION_CODE
     'READY'
   from EDW_BRES_DEPT_LCV
   where last_update_date between l_push_date_range1 and l_push_date_range2;

Line: 756


   l_rows_inserted := sql%rowcount;

Line: 758


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

Line: 766


   EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;

Line: 782


 l_rows_inserted            Number:=0;

Line: 798


   Insert Into EDW_BRES_DEPT_CLASS_LSTG(
     CREATION_DATE,
     DEPARTMENT_CLASS,
     DEPARTMENT_CLASS_DP,
     DEPARTMENT_CLASS_PK,
     DESCRIPTION,
     ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     NAME,
     PLANT_FK,
     PLANT_FK_KEY,
     REQUEST_ID,
     ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     OPERATION_CODE,
     COLLECTION_STATUS)
   select
     CREATION_DATE,
     DEPARTMENT_CLASS,
     DEPARTMENT_CLASS_DP,
     DEPARTMENT_CLASS_PK,
     substrb(DESCRIPTION,1,240),
     NULL, --ERROR_CODE,
     INSTANCE,
     LAST_UPDATE_DATE,
     substrb(NAME,1,320),
     PLANT_FK,
     NULL, --PLANT_FK_KEY,
     NULL, --REQUEST_ID,
     NULL, --ROW_ID,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
     NULL, -- OPERATION_CODE
     'READY'
   from EDW_BRES_DEPT_CLASS_LCV
   where last_update_date between l_push_date_range1 and l_push_date_range2;

Line: 843


   l_rows_inserted := sql%rowcount;

Line: 845


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

Line: 853


   EDW_BOM_RES_M_C.g_row_count:=EDW_BOM_RES_M_C.g_row_count+l_rows_inserted;