DBA Data[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on MTL_TRANSACTION_ACCOUNTS

Line 863: FROM mtl_transaction_accounts mta,

859: CURSOR sla_ccid_cur(
860: p_mtl_txn_id IN number, p_acct_line_type IN number, p_cost_element_id in number, p_ledger_id IN number)
861: IS
862: SELECT xal.code_combination_id
863: FROM mtl_transaction_accounts mta,
864: xla_distribution_links xdl,
865: xla_ae_lines xal,
866: xla_ae_headers xah
867: WHERE mta.transaction_id = p_mtl_txn_id

Line 870: AND xdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'

866: xla_ae_headers xah
867: WHERE mta.transaction_id = p_mtl_txn_id
868: AND mta.accounting_line_type = p_acct_line_type
869: AND nvl(mta.cost_element_id,1) = p_cost_element_id
870: AND xdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'
871: AND xdl.source_distribution_id_num_1 = mta.inv_sub_ledger_id
872: AND xal.ae_header_id = xdl.ae_header_id
873: AND xal.ae_line_num = xdl.ae_line_num
874: AND xah.ae_header_id = xal.ae_header_id

Line 883: mtl_transaction_accounts mta

879: FROM xla_transaction_entities xlte,
880: xla_ae_headers xlaeh,
881: xla_ae_lines xlael,
882: xla_distribution_links xdl,
883: mtl_transaction_accounts mta
884: WHERE xlte.application_id = l_application_id
885: AND xlte.entity_code = l_entity_code
886: AND xlte.source_id_int_1 = p_mtl_txn_id
887: AND xlaeh.ledger_id = p_ledger_id