DBA Data[Home] [Help]

APPS.OPI_DBI_WIP_COMP_INIT_PKG dependencies on OPI_DBI_RUN_LOG_CURR

Line 409: OPI_DBI_RUN_LOG_CURR. The collection therefore proceeds to extract

405: organizations.
406:
407: Collections begin from the global start for every discrete organization
408: for the transaction range recorded in the current log table,
409: OPI_DBI_RUN_LOG_CURR. The collection therefore proceeds to extract
410: every transaction per discrete org upto the first uncosted transaction.
411:
412: To ensure that the bounds are good, we call the init_end_bounds_setup API
413: from the Common Module Initial load.

Line 547: opi_dbi_run_log_curr log

543: FROM mtl_material_transactions mmt,
544: mtl_transaction_accounts mta,
545: wip_entities we,
546: wip_discrete_jobs wdj,
547: opi_dbi_run_log_curr log
548: WHERE log.source = OPI_SOURCE
549: AND log.etl_id = WIP_COMPLETION_ETL
550: AND mmt.organization_id = log.organization_id
551: AND mmt.transaction_id >= log.start_txn_id

Line 585: -- success to the OPI_DBI_RUN_LOG_CURR.

581:
582:
583:
584: -- If the entire collection was successful, then try and report this
585: -- success to the OPI_DBI_RUN_LOG_CURR.
586: l_stmt_id := 30;
587: IF (NOT (opi_dbi_common_mod_incr_pkg.etl_report_success
588: (WIP_COMPLETION_ETL, OPI_SOURCE))) THEN
589: