APPS.CSE_GL_INTERFACE_PKG dependencies on MTL_TRANSACTION_ACCOUNTS

Line 80: from cst_acct_info_v caiv, mtl_transaction_accounts mta

76: WHERE nvl(xlte.source_id_int_1 , '-99') = c_mtl_transaction_id
77: AND xlte.entity_code = 'MTL_ACCOUNTING_EVENTS'
78: AND xlte.application_id = 707
79: and xlte.ledger_id in (select distinct caiv.ledger_id
80: from cst_acct_info_v caiv, mtl_transaction_accounts mta
81: where mta.transaction_id = c_mtl_transaction_id
82: and mta.organization_id = caiv.organization_id )
83: AND xlaeh.entity_id = xlte.entity_id
84: AND xlaeh.gl_transfer_status_code = 'NT' ;

Line 286: mtl_transaction_accounts mta,

282: c_trf_txn_id IN NUMBER )
283: IS
284: SELECT distinct caiv.ledger_id , mmt.transaction_id
285: FROM cst_acct_info_v caiv,
286: mtl_transaction_accounts mta,
287: mtl_material_transactions mmt
288: WHERE mta.transaction_id = c_mtl_transaction_id
289: AND mta.organization_id = caiv.organization_id
290: AND mmt.transaction_id = c_mtl_transaction_id

Line 295: mtl_transaction_accounts mta ,

291: AND mmt.transaction_action_id <> 3
292: UNION
293: SELECT distinct caiv.ledger_id , mmt.transaction_id
294: FROM cst_acct_info_v caiv,
295: mtl_transaction_accounts mta ,
296: mtl_material_transactions mmt
297: WHERE mta.transaction_id in ( c_mtl_transaction_id , c_trf_txn_id )
298: AND mta.organization_id = caiv.organization_id
299: AND mmt.transaction_id in ( c_mtl_transaction_id , c_trf_txn_id )

Line 668: mtl_transaction_accounts mta

664: l_mta_encumbrance_type_id,
665: l_mta_organization_id,
666: l_mta_actual_flag
667: FROM
668: mtl_transaction_accounts mta
669: WHERE
670: mta.transaction_id = xla_header_rec.source_id_int_1
671: AND mta.organization_id = xla_header_rec.source_id_int_2
672: AND rownum = 1 ;