APPS.FV_FACTS_TRX_REGISTER dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 1937: FROM ar_receivable_applications_all ara,

1933: --hca.party_id
1934: hca.cust_account_id
1935: INTO l_reference_4,
1936: l_reference_7
1937: FROM ar_receivable_applications_all ara,
1938: ar_cash_receipts_all acr,
1939: hz_cust_site_uses_all hcsu,
1940: hz_cust_acct_sites_all hcas,
1941: hz_cust_accounts hca

Line 3022: FROM ar_receivable_applications_all

3018: FROM ar_cash_receipt_history_all
3019: WHERE cash_receipt_history_id = TO_NUMBER(l_cash_receipt_hist_id);
3020: CURSOR Receivables_Applications IS
3021: SELECT cash_receipt_history_id
3022: FROM ar_receivable_applications_all
3023: WHERE receivable_application_id = TO_NUMBER(l_cash_receipt_hist_id);
3024: CURSOR Receivables_Hist
3025: (
3026: c_cash_receipt_hist_id NUMBER,

Line 3137: FROM ar_receivable_applications_all

3133: FROM ar_adjustments_all
3134: WHERE adjustment_id = l_refer2;
3135: CURSOR Receivables_CMA IS
3136: SELECT apply_date, creation_date, created_by
3137: FROM ar_receivable_applications_all
3138: WHERE receivable_application_id = l_refer2;
3139: CURSOR Receivables_Memos_Inv IS
3140: SELECT trx_date, creation_date, created_by
3141: FROM ra_customer_trx_all

Line 3692: ||' Ar_Receivable_Applications_All: '

3688: THEN
3689: l_cash_receipt_hist_id := l_temp_cr_hist_id;
3690: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3691: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CASH RECEIPT HIST ID EXITS IN'
3692: ||' Ar_Receivable_Applications_All: '
3693: ||l_cash_receipt_hist_id);
3694: END IF;
3695: -- Use cash_receipt_history_id obtained above to find
3696: -- IF a row exits in Ar_Cash_Receipts_All