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.OPI_DBI_REP_UOM_STD_CONV_PKG dependencies on OPI_DBI_REP_UOM_CONV_STG

Line 323: INTO opi_dbi_rep_uom_conv_stg (

319: --
320: -- In case there are multiple measures tied to the same reporting UOM,
321: -- we need to pick distinct reporting UOMs, irrespective of the measures.
322: INSERT /*+ append */
323: INTO opi_dbi_rep_uom_conv_stg (
324: inventory_item_id,
325: from_uom_code,
326: from_uom_class,
327: rep_uom_code,

Line 423: INTO opi_dbi_rep_uom_conv_stg (

419: --
420: -- In case there are multiple measures tied to the same reporting UOM,
421: -- we need to pick distinct reporting UOMs, irrespective of the measures.
422: INSERT /*+ append */
423: INTO opi_dbi_rep_uom_conv_stg (
424: inventory_item_id,
425: from_uom_code,
426: from_uom_class,
427: rep_uom_code,

Line 549: 2. OPI_DBI_REP_UOM_CONV_STG

545: Cleans up tables prior to the initial load run.
546:
547: Truncates:
548: 1. OPI_DBI_REP_UOM_STD_CONV_F
549: 2. OPI_DBI_REP_UOM_CONV_STG
550:
551: Deletes:
552: 1. Rows from OPI_DBI_CONC_PROG_RUN_LOG where row type = REP_UOM.
553:

Line 583: 'OPI_DBI_REP_UOM_CONV_STG');

579:
580: l_stmt_id := 20;
581: -- Truncate the staging table
582: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
583: 'OPI_DBI_REP_UOM_CONV_STG');
584:
585: l_stmt_id := 30;
586: -- Delete all rows for this ETL from the log table
587: DELETE

Line 707: opi_dbi_rep_uom_conv_stg stg

703: s_program_login_id,
704: s_program_application_id,
705: s_request_id
706: FROM
707: opi_dbi_rep_uom_conv_stg stg
708: WHERE stg.inventory_item_id = C_STD_RATE_ITEM_ID;
709:
710: return;
711:

Line 802: 'OPI_DBI_REP_UOM_CONV_STG');

798:
799: l_stmt_id := 100;
800: -- Commit all data finally by truncating the staging table.
801: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
802: 'OPI_DBI_REP_UOM_CONV_STG');
803: print_stage_done_mesg (l_proc_name, l_stmt_id);
804:
805: errbuf := '';
806: retcode := C_SUCCESS;

Line 903: 1. OPI_DBI_REP_UOM_CONV_STG

899:
900: Cleans up tables prior to the incremental load run.
901:
902: Truncates:
903: 1. OPI_DBI_REP_UOM_CONV_STG
904:
905: Verifies:
906: 1. There is exactly one row for this ETL in the run log.
907:

Line 930: 'OPI_DBI_REP_UOM_CONV_STG');

926:
927: l_stmt_id := 10;
928: -- Truncate the staging table
929: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
930: 'OPI_DBI_REP_UOM_CONV_STG');
931:
932: l_stmt_id := 20;
933: -- Delete all rows for this ETL from the log table
934: SELECT count (1)

Line 1022: FROM opi_dbi_rep_uom_conv_stg

1018: s_program_id program_id,
1019: s_program_login_id program_login_id,
1020: s_program_application_id program_application_id,
1021: s_request_id request_id
1022: FROM opi_dbi_rep_uom_conv_stg
1023: WHERE inventory_item_id = C_STD_RATE_ITEM_ID) new
1024: ON ( base.from_uom_code = new.from_uom_code
1025: AND base.rep_uom_code = new.rep_uom_code)
1026: WHEN MATCHED THEN UPDATE

Line 1191: 'OPI_DBI_REP_UOM_CONV_STG');

1187:
1188: l_stmt_id := 100;
1189: -- Commit all data finally by truncating the log table.
1190: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
1191: 'OPI_DBI_REP_UOM_CONV_STG');
1192: print_stage_done_mesg (l_proc_name, l_stmt_id);
1193:
1194: errbuf := '';
1195: retcode := C_SUCCESS;