DBA Data[Home] [Help]

APPS.OPI_DBI_WIP_SCRAP_INIT_PKG dependencies on OPI_DBI_RUN_LOG_CURR

Line 375: OPI_DBI_RUN_LOG_CURR. The collection therefore proceeds to extract

371: organizations.
372:
373: Collections begin from the global start for every discrete organization
374: for the transaction range recorded in the current log table,
375: OPI_DBI_RUN_LOG_CURR. The collection therefore proceeds to extract
376: every transaction per discrete org upto the first uncosted transaction.
377:
378: To ensure that the bounds are good, we call the init_end_bounds_setup API
379: from the Common Module Initial load.

Line 514: opi_dbi_run_log_curr log

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

Line 552: -- success to the OPI_DBI_RUN_LOG_CURR.

548:
549:
550:
551: -- If the entire collection was successful, then try and report this
552: -- success to the OPI_DBI_RUN_LOG_CURR.
553: l_stmt_id := 30;
554: IF (NOT (opi_dbi_common_mod_incr_pkg.etl_report_success
555: (WIP_SCRAP_ETL, OPI_SOURCE))) THEN
556: