APPS.FV_GTAS_TRX_REGISTER dependencies on AR_CASH_RECEIPTS_ALL

Line 2602: ar_cash_receipts_all acr,

2598: to_char(hca.cust_account_id)
2599: INTO l_reference_4,
2600: l_reference_7
2601: FROM ar_receivable_applications_all ara,
2602: ar_cash_receipts_all acr,
2603: hz_cust_site_uses_all hcsu,
2604: hz_cust_acct_sites_all hcas,
2605: hz_cust_accounts hca
2606: WHERE ara.receivable_application_id = l_ar_source_id

Line 2632: ar_cash_receipts_all acr,

2628: to_char(hca.cust_account_id)
2629: INTO l_reference_4,
2630: l_reference_7
2631: FROM ar_cash_receipt_history_all ara,
2632: ar_cash_receipts_all acr,
2633: hz_cust_site_uses_all hcsu,
2634: hz_cust_acct_sites_all hcas,
2635: hz_cust_accounts hca
2636: WHERE ara.cash_receipt_history_id = l_ar_source_id

Line 2662: ar_cash_receipts_all acr,

2658: to_char(hca.cust_account_id)
2659: INTO l_reference_4,
2660: l_reference_7
2661: FROM ar_adjustments_all ara,
2662: ar_cash_receipts_all acr,
2663: hz_cust_site_uses_all hcsu,
2664: hz_cust_acct_sites_all hcas,
2665: hz_cust_accounts hca
2666: WHERE ara.adjustment_id = l_ar_source_id

Line 2689: ar_cash_receipts_all acr,

2685: to_char(hca.cust_account_id)
2686: INTO l_reference_4,
2687: l_reference_7
2688: FROM ar_misc_cash_distributions_all ara,
2689: ar_cash_receipts_all acr,
2690: hz_cust_site_uses_all hcsu,
2691: hz_cust_acct_sites_all hcas,
2692: hz_cust_accounts hca
2693: WHERE ara.misc_cash_distribution_id = l_ar_source_id

Line 2813: ar_cash_receipts_all acr

2809: l_reference_5,
2810: l_reference_4
2811: FROM ar_misc_cash_distributions_all ara,
2812: ar_cash_receipt_history_all acrh,
2813: ar_cash_receipts_all acr
2814: WHERE ara.misc_cash_distribution_id = l_ar_source_id
2815: AND ara.cash_receipt_id = acr.cash_receipt_id
2816: AND ara.cash_receipt_id = acrh.cash_receipt_id
2817: group by acr.cash_receipt_id, acr.receipt_number;

Line 3387: FROM ar_cash_receipts_all

3383: CURSOR Receivables IS
3384: SELECT DECODE(l_rev_exists, 'Y', reversal_date, receipt_date),
3385: DECODE(l_rev_exists, 'Y', l_doc_creation_date_d,creation_date),
3386: DECODE(l_rev_exists, 'Y', l_doc_created_by_d, created_by)
3387: FROM ar_cash_receipts_all
3388: WHERE cash_receipt_id = to_number(l_refer2);
3389:
3390: CURSOR Receivables_Exists IS
3391: SELECT 'Y'

Line 4011: -- IF a row exits in Ar_Cash_Receipts_All

4007: ||' Ar_Receivable_Applications_All: '
4008: ||l_cash_receipt_hist_id);
4009:
4010: -- Use cash_receipt_history_id obtained above to find
4011: -- IF a row exits in Ar_Cash_Receipts_All
4012: OPEN Receivables_Exists;
4013: FETCH Receivables_Exists INTO l_rev_exists;
4014: CLOSE Receivables_Exists;
4015: IF (l_rev_exists = 'Y') THEN