DBA Data[Home] [Help]

APPS.AR_BILLS_MAIN dependencies on AR_TRANSACTION_HISTORY

Line 2141: from ar_transaction_history

2137:
2138:
2139: Cursor Cposted (CustomerTrxId NUMBER) IS SELECT
2140: customer_trx_id
2141: from ar_transaction_history
2142: where customer_trx_id = CUSTOMERTRXID
2143: and posting_control_id <> -3
2144: and gl_posted_date IS NOT NULL;
2145:

Line 2510: AR_TRANSACTION_HISTORY H

2506: AR_receipt_METHODS METH,
2507: CE_BANK_BRANCHES_V ABB,
2508: HZ_CUST_SITE_USES SITE,
2509: ap_bank_accounts ABA,
2510: AR_TRANSACTION_HISTORY H
2511: where trx.legal_entity_id = ' || p_le_id ||
2512: ' and TRX.drawee_id = cust_acct.cust_account_id
2513: and cust_acct.party_id = party.party_id
2514: and TRX.customer_trx_id = PAYS.customer_trx_id