APPS.CST_UPD_GIR_MTA_WTA dependencies on MTL_TRANSACTION_ACCOUNTS

Line 128: mtl_transaction_accounts mta

124: mta.rowid,
125: mta.inv_sub_ledger_id,
126: sl.gl_sl_link_id
127: from cst_gl_summary_links_temp sl,
128: mtl_transaction_accounts mta
129: where mta.gl_batch_id = sl.gl_batch_id
130: and mta.reference_account = sl.reference_account
131: and sl.gl_currency_code = nvl(mta.currency_code, sl.ledger_currency_code)
132: and sl.ussgl_transaction_code = nvl(mta.ussgl_transaction_code, '*')

Line 146: TYPE inv_sub_ledger_id_type IS TABLE OF mtl_transaction_accounts.inv_sub_ledger_id%TYPE;

142: and R.reference_3 is null )) --Support Flexible Logic
143: and mta.encumbrance_type_id is null
144: order by sl.gl_sl_link_id;
145:
146: TYPE inv_sub_ledger_id_type IS TABLE OF mtl_transaction_accounts.inv_sub_ledger_id%TYPE;
147:
148: mta_rowid_tab gir_rowid_type;
149: inv_sub_ledger_id_tab inv_sub_ledger_id_type;
150:

Line 356: update mtl_transaction_accounts mta

352: END IF;
353:
354: l_stmnt_num := 80;
355: FORALL i in 1..mta_rowid_tab.count
356: update mtl_transaction_accounts mta
357: set mta.gl_sl_link_id = gl_sl_link_id_tab(i)
358: where mta.rowid = mta_rowid_tab(i);
359:
360: debug(' L'||l_count||': Updated '||SQL%ROWCOUNT||' rows in MTA');

Line 374: AND xdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'

370: xdl.ae_header_id,
371: xdl.ae_line_num
372: from xla_distribution_links xdl
373: where XDL.application_id = 707 /*Added for bug 16217359 */
374: AND xdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'
375: and xdl.source_distribution_id_num_1 = inv_sub_ledger_id_tab(i));
376:
377: debug(' L'||l_count||': Updated '||SQL%ROWCOUNT||' rows in XAL');
378: