DBA Data[Home] [Help]

APPS.OPI_DBI_WIP_SCRAP_INCR_PKG dependencies on OPI_DBI_RUN_LOG_CURR

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

335: (OPI) organizations.
336:
337: Collected transactions must be past the global start for every discrete
338: organization and lie in the transaction range recorded in the current
339: log table, OPI_DBI_RUN_LOG_CURR. The collection therefore proceeds to
340: extract every transaction per discrete org upto the first uncosted
341: transaction.
342:
343: To ensure that the bounds are good, we call the incr_end_bounds_setup API

Line 480: opi_dbi_run_log_curr log

476: FROM mtl_material_transactions mmt,
477: mtl_transaction_accounts mta,
478: wip_entities we,
479: wip_discrete_jobs wdj,
480: opi_dbi_run_log_curr log
481: WHERE log.source = OPI_SOURCE
482: AND log.etl_id = WIP_SCRAP_ETL
483: AND mmt.organization_id = log.organization_id
484: AND mmt.transaction_id >= log.start_txn_id

Line 516: -- success to the OPI_DBI_RUN_LOG_CURR.

512: NON_PLANNED_ITEM, 'N',
513: 'Y');
514:
515: -- If the entire collection was successful, then try and report this
516: -- success to the OPI_DBI_RUN_LOG_CURR.
517: l_stmt_id := 30;
518: IF (NOT (opi_dbi_common_mod_incr_pkg.etl_report_success
519: (WIP_SCRAP_ETL, OPI_SOURCE))) THEN
520: