APPS.OPI_DBI_COMMON_MOD_INIT_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 447: FROM mtl_material_transactions;

443:
444: l_stmt_id := 10;
445: SELECT nvl (max (transaction_id), -1) + 1
446: INTO l_max_mmt_plus_one
447: FROM mtl_material_transactions;
448:
449: -- Storing sysdate in a local variable for insertion into log as we do not want to miss any
450: -- horizon between OPM and OPI inserts.
451: l_stmt_id := 20;

Line 463: SELECT /*+ parallel(mtl_material_transactions) */

459: -- then just pick a transaction_id one higher than the max of
460: -- of MMT.
461:
462: l_stmt_id := 30;
463: SELECT /*+ parallel(mtl_material_transactions) */
464: nvl (min (transaction_id), l_max_mmt_plus_one)
465: INTO l_mmt_start_txn_id
466: FROM mtl_material_transactions
467: WHERE transaction_date >= p_global_start_date;

Line 466: FROM mtl_material_transactions

462: l_stmt_id := 30;
463: SELECT /*+ parallel(mtl_material_transactions) */
464: nvl (min (transaction_id), l_max_mmt_plus_one)
465: INTO l_mmt_start_txn_id
466: FROM mtl_material_transactions
467: WHERE transaction_date >= p_global_start_date;
468:
469: -- Create a row for each discrete org for the Job Transactions ETL
470: --(Scrap, WIP completions, Material Usage) with the start

Line 539: FROM (SELECT /*+ PARALLEL (mtl_material_transactions) */

535: next_start_txn_id,
536: decode (uncosted.uncosted_id,
537: NULL, STOP_ALL_COSTED,
538: STOP_UNCOSTED) stop_reason_code
539: FROM (SELECT /*+ PARALLEL (mtl_material_transactions) */
540: min (transaction_id) uncosted_id,
541: organization_id
542: FROM mtl_material_transactions
543: WHERE costed_flag IN ('N', 'E')

Line 542: FROM mtl_material_transactions

538: STOP_UNCOSTED) stop_reason_code
539: FROM (SELECT /*+ PARALLEL (mtl_material_transactions) */
540: min (transaction_id) uncosted_id,
541: organization_id
542: FROM mtl_material_transactions
543: WHERE costed_flag IN ('N', 'E')
544: AND transaction_id > l_mmt_start_txn_id
545: GROUP BY organization_id) uncosted,
546: (SELECT /*+ parallel (mtl_parameters) */

Line 552: mtl_material_transactions mmt

548: FROM mtl_parameters
549: WHERE process_enabled_flag <> 'Y') orgs
550: WHERE orgs.organization_id = uncosted.organization_id (+))
551: mmt_bounds,
552: mtl_material_transactions mmt
553: WHERE mmt_bounds.organization_id = mmt.organization_id (+)
554: AND (mmt.transaction_id BETWEEN mmt_bounds.start_txn_id AND
555: mmt_bounds.next_start_txn_id
556: OR mmt.transaction_id IS NULL)

Line 1264: mtl_material_transactions mmt

1260: 'Data Issue?') stop_reason,
1261: nvl (mmt.transaction_date, sysdate) data_until
1262: FROM opi_dbi_run_log_curr log,
1263: mtl_parameters mp,
1264: mtl_material_transactions mmt
1265: WHERE source = OPI_SOURCE
1266: AND etl_id = JOB_TXN_ETL -- any ETL is good enough
1267: AND log.next_start_txn_id = mmt.transaction_id (+)
1268: AND log.organization_id = mp.organization_id;