DBA Data[Home] [Help]

APPS.CST_XLA_PVT dependencies on MTL_TRANSACTION_ACCOUNTS

Line 295: FROM mtl_transaction_accounts

291: RETURN VARCHAR2
292: IS
293: CURSOR c IS
294: SELECT 'Y'
295: FROM mtl_transaction_accounts
296: WHERE transaction_id = p_transaction_id
297: AND organization_id = p_organization_id
298: AND accounting_line_type = 15;
299: l_res VARCHAR2(1);

Line 951: FROM MTL_TRANSACTION_ACCOUNTS

947: l_stmt_num := 15;
948:
949: SELECT count(*)
950: INTO l_mta_exists
951: FROM MTL_TRANSACTION_ACCOUNTS
952: WHERE TRANSACTION_ID = p_trx_info.transaction_id
953: AND rownum=1;
954:
955: l_stmt_num := 17;

Line 2260: FROM mtl_transaction_accounts

2256: MTL_MATERIAL_TRANSACTIONS mmt
2257: --{BUG#7505874
2258: ,(SELECT MAX(inv_sub_ledger_id) slid
2259: ,transaction_id trx_id
2260: FROM mtl_transaction_accounts
2261: GROUP BY transaction_id) mta
2262: --}
2263: WHERE
2264: mmt.TRANSACTION_SOURCE_ID = p_update_id