DBA Data[Home] [Help]

APPS.OPI_DBI_COMMON_MOD_INCR_PKG dependencies on MTL_PARAMETERS

Line 406: in MTL_PARAMETERS for the discrete org rows of the Material transactions,

402: that the upper bound is strictly higher than all transactions to be
403: collected.
404:
405: For the initial load, we need not worry about finding newly defined orgs
406: in MTL_PARAMETERS for the discrete org rows of the Material transactions,
407: because the data was seeded a few minutes ago.
408:
409: Date Author Action
410: 04/21/03 Dinkar Gupta Wrote Function

Line 479: -- MTL_PARAMETERS since the last incremental run. This org must

475: INTO l_to_bound_date
476: FROM DUAL;
477:
478: -- It is possible that a new discrete org was defined in
479: -- MTL_PARAMETERS since the last incremental run. This org must
480: -- get a record in current log table, OPI_DBI_RUN_LOG_CURR so that
481: -- it can be picked up in subsequent extractions. This need only be
482: -- done for OPI orgs.
483:

Line 553: FROM mtl_parameters

549: s_request_id
550: FROM (SELECT JOB_TXN_ETL etl_id FROM dual
551: ) etls,
552: (SELECT organization_id
553: FROM mtl_parameters
554: WHERE process_enabled_flag <> 'Y' -- not OPM org
555: MINUS
556: SELECT organization_id -- all distinct orgs
557: FROM opi_dbi_run_log_curr