APPS.CSE_ASSET_UTIL_PKG dependencies on MTL_TRANSACTION_ACCOUNTS

Line 72: FROM mtl_transaction_accounts

68: debug(' primary_quantity : '||l_primary_quantity);
69:
70: SELECT sum(nvl(base_transaction_value,0))
71: INTO l_base_value
72: FROM mtl_transaction_accounts
73: WHERE transaction_id = p_mtl_transaction_id
74: AND primary_quantity > 0;
75:
76: debug(' base_transaction_value : '||l_base_value);

Line 909: FROM mtl_transaction_accounts mta,

905: CURSOR sla_ccid_cur(
906: p_mtl_txn_id IN number, p_acct_line_type IN number, p_cost_element_id in number, p_ledger_id IN number)
907: IS
908: SELECT xal.code_combination_id
909: FROM mtl_transaction_accounts mta,
910: xla_distribution_links xdl,
911: xla_ae_lines xal,
912: xla_ae_headers xah
913: WHERE mta.transaction_id = p_mtl_txn_id

Line 916: AND xdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'

912: xla_ae_headers xah
913: WHERE mta.transaction_id = p_mtl_txn_id
914: AND mta.accounting_line_type = p_acct_line_type
915: AND nvl(mta.cost_element_id,1) = p_cost_element_id
916: AND xdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'
917: AND xdl.source_distribution_id_num_1 = mta.inv_sub_ledger_id
918: AND xal.ae_header_id = xdl.ae_header_id
919: AND xal.ae_line_num = xdl.ae_line_num
920: AND xah.ae_header_id = xal.ae_header_id

Line 929: mtl_transaction_accounts mta

925: FROM xla_transaction_entities xlte,
926: xla_ae_headers xlaeh,
927: xla_ae_lines xlael,
928: xla_distribution_links xdl,
929: mtl_transaction_accounts mta
930: WHERE xlte.application_id = l_application_id
931: AND xlte.entity_code = l_entity_code
932: AND xlte.source_id_int_1 = p_mtl_txn_id
933: AND xlaeh.ledger_id = p_ledger_id