DBA Data[Home] [Help]

APPS.OPI_DBI_RES_OPM_PKG dependencies on OPI_DBI_RUN_LOG_CURR

Line 292: opi_dbi_run_log_curr rlc,

288: pol.gl_cost_mthd cost_mthd_code,
289: pol.co_code co_code
290: FROM
291: sy_uoms_mst hruom,
292: opi_dbi_run_log_curr rlc,
293: gme_resource_txns rtran,
294: sy_uoms_mst ruom,
295: cr_rsrc_dtl rdtl,
296: cr_rsrc_mst_b rmst,

Line 626: FROM opi_dbi_run_log_curr

622:
623: -- get boundary
624: SELECT Trunc(last_collection_date)
625: INTO l_last_collection_date
626: FROM opi_dbi_run_log_curr
627: WHERE etl_id = 5
628: AND source = 2;
629:
630: -- if not sysdate, start from the day after last_collection_date

Line 830: opi_dbi_run_log_curr rlc,

826: gme_material_details prod,
827: ic_item_mst_b item,
828: mtl_system_items_b msi,
829: gl_plcy_mst pol,
830: opi_dbi_run_log_curr rlc,
831: sy_uoms_mst hruom,
832: sy_uoms_mst ruom
833: WHERE
834: rlc.etl_id = 4