APPS.FV_FACTS_TRX_REGISTER dependencies on AR_CASH_RECEIPTS_ALL

Line 1938: ar_cash_receipts_all acr,

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
1942: WHERE ara.receivable_application_id = l_ar_source_id

Line 1967: ar_cash_receipts_all acr,

1963: hca.cust_account_id
1964: INTO l_reference_4,
1965: l_reference_7
1966: FROM ar_cash_receipt_history_all ara,
1967: ar_cash_receipts_all acr,
1968: hz_cust_site_uses_all hcsu,
1969: hz_cust_acct_sites_all hcas,
1970: hz_cust_accounts hca
1971: WHERE ara.cash_receipt_history_id = l_ar_source_id

Line 1996: ar_cash_receipts_all acr,

1992: hca.cust_account_id
1993: INTO l_reference_4,
1994: l_reference_7
1995: FROM ar_adjustments_all ara,
1996: ar_cash_receipts_all acr,
1997: hz_cust_site_uses_all hcsu,
1998: hz_cust_acct_sites_all hcas,
1999: hz_cust_accounts hca
2000: WHERE ara.adjustment_id = l_ar_source_id

Line 2025: ar_cash_receipts_all acr,

2021: hca.cust_account_id
2022: INTO l_reference_4,
2023: l_reference_7
2024: FROM ar_misc_cash_distributions_all ara,
2025: ar_cash_receipts_all acr,
2026: hz_cust_site_uses_all hcsu,
2027: hz_cust_acct_sites_all hcas,
2028: hz_cust_accounts hca
2029: WHERE ara.misc_cash_distribution_id = l_ar_source_id

Line 2151: ar_cash_receipts_all acr

2147: l_reference_5,
2148: l_reference_4
2149: FROM ar_misc_cash_distributions_all ara,
2150: ar_cash_receipt_history_all acrh,
2151: ar_cash_receipts_all acr
2152: WHERE ara.misc_cash_distribution_id = l_ar_source_id
2153: AND ara.cash_receipt_id = acr.cash_receipt_id
2154: AND ara.cash_receipt_id = acrh.cash_receipt_id;
2155:

Line 3014: FROM ar_cash_receipts_all

3010: CURSOR Receivables IS
3011: SELECT DECODE(l_rev_exists, 'Y', reversal_date, receipt_date),
3012: DECODE(l_rev_exists, 'Y', l_doc_creation_date_d,creation_date),
3013: DECODE(l_rev_exists, 'Y', l_doc_created_by_d, created_by)
3014: FROM ar_cash_receipts_all
3015: WHERE cash_receipt_id = to_number(l_refer2);
3016: CURSOR Receivables_Exists IS
3017: SELECT 'Y'
3018: FROM ar_cash_receipt_history_all

Line 3696: -- IF a row exits in Ar_Cash_Receipts_All

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
3697: OPEN Receivables_Exists;
3698: FETCH Receivables_Exists INTO l_rev_exists;
3699: CLOSE Receivables_Exists;
3700: IF (l_rev_exists = 'Y')