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_INV_CCA_PKG dependencies on OPI_DBI_CONC_PROG_RUN_LOG

Line 1113: opi_dbi_conc_prog_run_log log

1109: mmt.subinventory_code) subinventory_code,
1110: sum (mta.base_transaction_value) base_transaction_value
1111: FROM opi_dbi_mmt_cca_stg mmt,
1112: mtl_transaction_accounts mta,
1113: opi_dbi_conc_prog_run_log log
1114: WHERE log.etl_type = C_ETL_TYPE
1115: AND log.driving_table_code = C_LOG_MMT_DRV_TBL
1116: AND log.load_type = C_LOAD_INIT
1117: AND mmt.organization_id = log.bound_level_entity_id

Line 1279: l_from_bound_date OPI_DBI_CONC_PROG_RUN_LOG.from_bound_date%type;

1275: IS
1276: l_proc_name CONSTANT VARCHAR2 (40) := 'extract_adjustments_init';
1277: l_stmt_id NUMBER;
1278:
1279: l_from_bound_date OPI_DBI_CONC_PROG_RUN_LOG.from_bound_date%type;
1280: l_to_bound_date OPI_DBI_CONC_PROG_RUN_LOG.to_bound_date%type;
1281:
1282: BEGIN
1283:

Line 1280: l_to_bound_date OPI_DBI_CONC_PROG_RUN_LOG.to_bound_date%type;

1276: l_proc_name CONSTANT VARCHAR2 (40) := 'extract_adjustments_init';
1277: l_stmt_id NUMBER;
1278:
1279: l_from_bound_date OPI_DBI_CONC_PROG_RUN_LOG.from_bound_date%type;
1280: l_to_bound_date OPI_DBI_CONC_PROG_RUN_LOG.to_bound_date%type;
1281:
1282: BEGIN
1283:
1284: -- initialization block

Line 1289: FROM OPI_DBI_CONC_PROG_RUN_LOG

1285: l_stmt_id := 0;
1286:
1287: SELECT from_bound_date, to_bound_date
1288: INTO l_from_bound_date, l_to_bound_date
1289: FROM OPI_DBI_CONC_PROG_RUN_LOG
1290: WHERE driving_table_code = C_LOG_GTV_DRV_TBL
1291: AND etl_type = C_ETL_TYPE
1292: AND load_type = C_LOAD_INIT;
1293:

Line 1559: l_from_bound_date OPI_DBI_CONC_PROG_RUN_LOG.from_bound_date%type;

1555: PROCEDURE extract_exact_matches_init
1556: IS
1557: l_proc_name CONSTANT VARCHAR2 (40) := 'extract_exact_matches_init';
1558: l_stmt_id NUMBER;
1559: l_from_bound_date OPI_DBI_CONC_PROG_RUN_LOG.from_bound_date%type;
1560: l_to_bound_date OPI_DBI_CONC_PROG_RUN_LOG.to_bound_date%type;
1561:
1562: BEGIN
1563:

Line 1560: l_to_bound_date OPI_DBI_CONC_PROG_RUN_LOG.to_bound_date%type;

1556: IS
1557: l_proc_name CONSTANT VARCHAR2 (40) := 'extract_exact_matches_init';
1558: l_stmt_id NUMBER;
1559: l_from_bound_date OPI_DBI_CONC_PROG_RUN_LOG.from_bound_date%type;
1560: l_to_bound_date OPI_DBI_CONC_PROG_RUN_LOG.to_bound_date%type;
1561:
1562: BEGIN
1563:
1564: -- initialization block

Line 1569: FROM OPI_DBI_CONC_PROG_RUN_LOG

1565: l_stmt_id := 0;
1566:
1567: SELECT from_bound_date, to_bound_date
1568: INTO l_from_bound_date, l_to_bound_date
1569: FROM OPI_DBI_CONC_PROG_RUN_LOG
1570: WHERE driving_table_code = C_LOG_GTV_DRV_TBL
1571: AND etl_type = C_ETL_TYPE
1572: AND load_type = C_LOAD_INIT;
1573:

Line 2908: opi_dbi_conc_prog_run_log log

2904: mmt.subinventory_code) subinventory_code,
2905: sum (mta.base_transaction_value) base_transaction_value
2906: FROM mtl_material_transactions mmt,
2907: mtl_transaction_accounts mta,
2908: opi_dbi_conc_prog_run_log log
2909: WHERE log.etl_type = C_ETL_TYPE
2910: AND log.driving_table_code = C_LOG_MMT_DRV_TBL
2911: AND log.load_type = C_LOAD_INCR
2912: AND mmt.organization_id = log.bound_level_entity_id

Line 3064: l_from_bound_date OPI_DBI_CONC_PROG_RUN_LOG.from_bound_date%type;

3060: PROCEDURE extract_process_adj_incr (p_global_start_date IN DATE)
3061: IS
3062: l_proc_name CONSTANT VARCHAR2 (40) := 'extract_adjustments_init';
3063: l_stmt_id NUMBER;
3064: l_from_bound_date OPI_DBI_CONC_PROG_RUN_LOG.from_bound_date%type;
3065: l_to_bound_date OPI_DBI_CONC_PROG_RUN_LOG.to_bound_date%type;
3066:
3067: BEGIN
3068:

Line 3065: l_to_bound_date OPI_DBI_CONC_PROG_RUN_LOG.to_bound_date%type;

3061: IS
3062: l_proc_name CONSTANT VARCHAR2 (40) := 'extract_adjustments_init';
3063: l_stmt_id NUMBER;
3064: l_from_bound_date OPI_DBI_CONC_PROG_RUN_LOG.from_bound_date%type;
3065: l_to_bound_date OPI_DBI_CONC_PROG_RUN_LOG.to_bound_date%type;
3066:
3067: BEGIN
3068:
3069: -- initialization block

Line 3074: FROM OPI_DBI_CONC_PROG_RUN_LOG

3070: l_stmt_id := 0;
3071:
3072: SELECT from_bound_date, to_bound_date
3073: INTO l_from_bound_date, l_to_bound_date
3074: FROM OPI_DBI_CONC_PROG_RUN_LOG
3075: WHERE driving_table_code = C_LOG_GTV_DRV_TBL
3076: AND etl_type = C_ETL_TYPE
3077: AND load_type = C_LOAD_INCR;
3078:

Line 3326: l_from_bound_date OPI_DBI_CONC_PROG_RUN_LOG.from_bound_date%type;

3322: PROCEDURE extract_exact_matches_incr
3323: IS
3324: l_proc_name CONSTANT VARCHAR2 (40) := 'extract_exact_matches_incr';
3325: l_stmt_id NUMBER;
3326: l_from_bound_date OPI_DBI_CONC_PROG_RUN_LOG.from_bound_date%type;
3327: l_to_bound_date OPI_DBI_CONC_PROG_RUN_LOG.to_bound_date%type;
3328:
3329: BEGIN
3330:

Line 3327: l_to_bound_date OPI_DBI_CONC_PROG_RUN_LOG.to_bound_date%type;

3323: IS
3324: l_proc_name CONSTANT VARCHAR2 (40) := 'extract_exact_matches_incr';
3325: l_stmt_id NUMBER;
3326: l_from_bound_date OPI_DBI_CONC_PROG_RUN_LOG.from_bound_date%type;
3327: l_to_bound_date OPI_DBI_CONC_PROG_RUN_LOG.to_bound_date%type;
3328:
3329: BEGIN
3330:
3331: -- initialization block

Line 3336: FROM OPI_DBI_CONC_PROG_RUN_LOG

3332: l_stmt_id := 0;
3333:
3334: SELECT from_bound_date, to_bound_date
3335: INTO l_from_bound_date, l_to_bound_date
3336: FROM OPI_DBI_CONC_PROG_RUN_LOG
3337: WHERE driving_table_code = C_LOG_GTV_DRV_TBL
3338: AND etl_type = C_ETL_TYPE
3339: AND load_type = C_LOAD_INCR;
3340: