APPS.OPI_DBI_COMMON_MOD_INCR_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 464: FROM mtl_material_transactions;

460:
461: l_stmt_id := 10;
462: SELECT nvl (max (transaction_id), -1) + 1
463: INTO l_max_mmt_plus_one
464: FROM mtl_material_transactions;
465:
466: l_stmt_id := 30;
467: SELECT nvl (max (transaction_id), -1) + 1
468: INTO l_max_wt_plus_one

Line 595: index(mmt1, MTL_MATERIAL_TRANSACTIONS_U1) */

591: NULL, sysdate,
592: mmt_bounds.last_transaction_date) last_transaction_date
593: FROM
594: (SELECT /*+ use_nl(uncosted mmt1)
595: index(mmt1, MTL_MATERIAL_TRANSACTIONS_U1) */
596: uncosted.organization_id,
597: uncosted.etl_id,
598: uncosted.source,
599: uncosted.uncosted_id next_start_txn_id,

Line 608: FROM mtl_material_transactions mmt,

604: log.organization_id,
605: log.etl_id,
606: log.source,
607: log.start_txn_id
608: FROM mtl_material_transactions mmt,
609: (SELECT organization_id,
610: etl_id,
611: source,
612: start_txn_id

Line 624: mtl_material_transactions mmt1

620: log.organization_id,
621: log.etl_id,
622: log.source,
623: log.start_txn_id) uncosted,
624: mtl_material_transactions mmt1
625: WHERE mmt1.organization_id+0 = uncosted.organization_id
626: AND mmt1.transaction_id BETWEEN uncosted.start_txn_id
627: AND uncosted.uncosted_id
628: GROUP BY