APPS.FV_FACTS_TRX_REGISTER dependencies on AR_CASH_RECEIPTS_ALL

Line 2018: ar_cash_receipts_all acr,

2014: hca.cust_account_id
2015: INTO l_reference_4,
2016: l_reference_7
2017: FROM ar_receivable_applications_all ara,
2018: ar_cash_receipts_all acr,
2019: hz_cust_site_uses_all hcsu,
2020: hz_cust_acct_sites_all hcas,
2021: hz_cust_accounts hca
2022: WHERE ara.receivable_application_id = l_ar_source_id

Line 2047: ar_cash_receipts_all acr,

2043: hca.cust_account_id
2044: INTO l_reference_4,
2045: l_reference_7
2046: FROM ar_cash_receipt_history_all ara,
2047: ar_cash_receipts_all acr,
2048: hz_cust_site_uses_all hcsu,
2049: hz_cust_acct_sites_all hcas,
2050: hz_cust_accounts hca
2051: WHERE ara.cash_receipt_history_id = l_ar_source_id

Line 2076: ar_cash_receipts_all acr,

2072: hca.cust_account_id
2073: INTO l_reference_4,
2074: l_reference_7
2075: FROM ar_adjustments_all ara,
2076: ar_cash_receipts_all acr,
2077: hz_cust_site_uses_all hcsu,
2078: hz_cust_acct_sites_all hcas,
2079: hz_cust_accounts hca
2080: WHERE ara.adjustment_id = l_ar_source_id

Line 2105: ar_cash_receipts_all acr,

2101: hca.cust_account_id
2102: INTO l_reference_4,
2103: l_reference_7
2104: FROM ar_misc_cash_distributions_all ara,
2105: ar_cash_receipts_all acr,
2106: hz_cust_site_uses_all hcsu,
2107: hz_cust_acct_sites_all hcas,
2108: hz_cust_accounts hca
2109: WHERE ara.misc_cash_distribution_id = l_ar_source_id

Line 2235: ar_cash_receipts_all acr

2231: l_reference_5,
2232: l_reference_4
2233: FROM ar_misc_cash_distributions_all ara,
2234: ar_cash_receipt_history_all acrh,
2235: ar_cash_receipts_all acr
2236: WHERE ara.misc_cash_distribution_id = l_ar_source_id
2237: AND ara.cash_receipt_id = acr.cash_receipt_id
2238: AND ara.cash_receipt_id = acrh.cash_receipt_id
2239: group by acr.cash_receipt_id, acr.receipt_number;

Line 3228: FROM ar_cash_receipts_all

3224: CURSOR Receivables IS
3225: SELECT DECODE(l_rev_exists, 'Y', reversal_date, receipt_date),
3226: DECODE(l_rev_exists, 'Y', l_doc_creation_date_d,creation_date),
3227: DECODE(l_rev_exists, 'Y', l_doc_created_by_d, created_by)
3228: FROM ar_cash_receipts_all
3229: WHERE cash_receipt_id = to_number(l_refer2);
3230: CURSOR Receivables_Exists IS
3231: SELECT 'Y'
3232: FROM ar_cash_receipt_history_all

Line 3913: -- IF a row exits in Ar_Cash_Receipts_All

3909: ||' Ar_Receivable_Applications_All: '
3910: ||l_cash_receipt_hist_id);
3911: END IF;
3912: -- Use cash_receipt_history_id obtained above to find
3913: -- IF a row exits in Ar_Cash_Receipts_All
3914: OPEN Receivables_Exists;
3915: FETCH Receivables_Exists INTO l_rev_exists;
3916: CLOSE Receivables_Exists;
3917: IF (l_rev_exists = 'Y')