815: l_stmt_num := 15;
816:
817: SELECT count(*)
818: INTO l_mta_exists
819: FROM MTL_TRANSACTION_ACCOUNTS
820: WHERE TRANSACTION_ID = p_trx_info.transaction_id
821: AND rownum=1;
822:
823: l_stmt_num := 17;
2003: MTL_MATERIAL_TRANSACTIONS mmt
2004: --{BUG#7505874
2005: ,(SELECT MAX(inv_sub_ledger_id) slid
2006: ,transaction_id trx_id
2007: FROM mtl_transaction_accounts
2008: GROUP BY transaction_id) mta
2009: --}
2010: WHERE
2011: mmt.TRANSACTION_SOURCE_ID = p_update_id