APPS.OPI_DBI_BOUNDS_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 755: FROM mtl_material_transactions mmt;

751: else
752: l_max_trx_id := -1;
753: l_stmt_no :=40;
754: SELECT max(transaction_id)+1 INTO l_max_trx_id
755: FROM mtl_material_transactions mmt;
756:
757: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN
758: l_debug_msg := 'Max transaction_id from MMT is '||to_char(l_max_trx_id)
759: ||' as on '||to_char(sysdate);

Line 819: FROM mtl_material_transactions mmt

815: l_request_id
816: FROM mtl_parameters mp ,
817: (
818: SELECT /*+ no_merge parallel(mmt) */ organization_id,min(transaction_id) transaction_id
819: FROM mtl_material_transactions mmt
820: WHERE transaction_date >= l_global_start_date
821: GROUP BY organization_id
822: )min_trx ,
823: (

Line 825: FROM mtl_material_transactions mmt

821: GROUP BY organization_id
822: )min_trx ,
823: (
824: SELECT /*+ no_merge parallel(mmt) */ organization_id,min(transaction_id) transaction_id
825: FROM mtl_material_transactions mmt
826: WHERE costed_flag in('N','E')
827: AND transaction_date >= l_global_start_date --Bug 5096963
828: GROUP BY organization_id
829: )uncosted_trx

Line 973: FROM mtl_material_transactions mmt;

969:
970: l_max_trx_id := -1;
971: l_stmt_no :=20;
972: SELECT max(transaction_id)+1 INTO l_max_trx_id
973: FROM mtl_material_transactions mmt;
974:
975: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN
976: l_debug_msg := 'Max transaction_id from MMT is '||to_char(l_max_trx_id)||' as on '||to_char(sysdate);
977: opi_dbi_bounds_pkg.write(g_pkg_name, l_proc_name, l_stmt_no, l_debug_msg);

Line 1012: FROM mtl_material_transactions mmt

1008: l_program_application_id,
1009: l_request_id
1010: from
1011: (SELECT /*+ no_merge parallel(mmt) */ organization_id,min(transaction_id) transaction_id
1012: FROM mtl_material_transactions mmt
1013: WHERE costed_flag in('N','E')
1014: AND transaction_id >= (SELECT from_bound_id FROM opi_dbi_conc_prog_run_log plog
1015: WHERE plog.etl_type = p_etl_type
1016: AND plog.load_type = p_load_type

Line 1407: mtl_material_transactions mmt

1403: 'Data Issue?') stop_reason,
1404: nvl (mmt.transaction_date, sysdate) data_until
1405: FROM opi_dbi_conc_prog_run_log log,
1406: mtl_parameters mp,
1407: mtl_material_transactions mmt
1408: WHERE log.driving_table_code = 'MMT'
1409: AND log.to_bound_id = mmt.transaction_id (+)
1410: AND log.bound_level_entity_id = mp.organization_id
1411: AND log.etl_type = p_etl_type