APPS.OPI_DBI_WIP_COMP_INCR_PKG dependencies on OPI_DBI_RUN_LOG_CURR

Line 374: log table, OPI_DBI_RUN_LOG_CURR. The collection therefore proceeds to

370: (OPI) organizations.
371:
372: Collected transactions must be past the global start for every discrete
373: organization and lie in the transaction range recorded in the current
374: log table, OPI_DBI_RUN_LOG_CURR. The collection therefore proceeds to
375: extract every transaction per discrete org upto the first uncosted
376: transaction.
377:
378: To ensure that the bounds are good, we call the incr_end_bounds_setup API

Line 503: (SELECT /*+ leading(log) use_nl(log mmt) index(log, OPI_DBI_RUN_LOG_CURR_N1) index(mmt, mtl_material_transactions_u1) */

499: s_user_id,
500: s_user_id,
501: s_login_id
502: FROM mtl_system_items_b msi,
503: (SELECT /*+ leading(log) use_nl(log mmt) index(log, OPI_DBI_RUN_LOG_CURR_N1) index(mmt, mtl_material_transactions_u1) */
504: mmt.organization_id,
505: mmt.inventory_item_id,
506: trunc (mmt.transaction_date) trx_date,
507: mmt.primary_quantity mmt_quantity,

Line 513: opi_dbi_run_log_curr log

509: FROM mtl_material_transactions mmt,
510: mtl_transaction_accounts mta,
511: wip_entities we,
512: wip_discrete_jobs wdj,
513: opi_dbi_run_log_curr log
514: WHERE log.source = OPI_SOURCE
515: AND log.etl_id = WIP_COMPLETION_ETL
516: AND mmt.organization_id = log.organization_id
517: AND mmt.transaction_id >= log.start_txn_id

Line 549: -- success to the OPI_DBI_RUN_LOG_CURR.

545: NON_PLANNED_ITEM, 'N',
546: 'Y');
547:
548: -- If the entire collection was successful, then try and report this
549: -- success to the OPI_DBI_RUN_LOG_CURR.
550: l_stmt_id := 30;
551: IF (NOT (opi_dbi_common_mod_incr_pkg.etl_report_success
552: (WIP_COMPLETION_ETL, OPI_SOURCE))) THEN
553: