APPS.FV_FACTS_TRX_REGISTER dependencies on HZ_CUST_ACCOUNTS

Line 2021: hz_cust_accounts hca

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
2023: AND ara.cash_receipt_id = acr.cash_receipt_id
2024: AND hcsu.site_use_id = acr.customer_site_use_id
2025: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id

Line 2050: hz_cust_accounts hca

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
2052: AND ara.cash_receipt_id = acr.cash_receipt_id
2053: AND hcsu.site_use_id = acr.customer_site_use_id
2054: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id

Line 2079: hz_cust_accounts hca

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
2081: AND ara.associated_cash_receipt_id = acr.cash_receipt_id
2082: AND hcsu.site_use_id = acr.customer_site_use_id
2083: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id

Line 2108: hz_cust_accounts hca

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
2110: AND ara.cash_receipt_id = acr.cash_receipt_id
2111: AND hcsu.site_use_id = acr.customer_site_use_id
2112: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id

Line 2462: FROM hz_cust_accounts hzca, fv_facts_customers_v fcv

2458: BEGIN
2459: l_feeder_flag := 'Y';
2460: SELECT hzca.customer_class_code, fcv.eliminations_id
2461: INTO l_vendor_type, l_eliminations_id
2462: FROM hz_cust_accounts hzca, fv_facts_customers_v fcv
2463: WHERE hzca.cust_account_id = to_number(l_reference_7)
2464: AND fcv.customer_id = hzca.cust_account_id;
2465:
2466: -- Added for bug 7256357

Line 2580: l_cust_class_code hz_cust_accounts_all.customer_class_code%TYPE;

2576: --SELECT dept_id||main_account
2577: --FROM fv_be_trx_dtls
2578: --WHERE transaction_id = to_number(l_reference_1);
2579: l_doc_number fv_be_trx_hdrs.doc_number%TYPE;
2580: l_cust_class_code hz_cust_accounts_all.customer_class_code%TYPE;
2581: BEGIN
2582: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2583: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2584: 'BUDGETARY TRANSACTION');

Line 2599: hz_cust_accounts hzca

2595: --Added for bug 7256357
2596: SELECT hzca.customer_class_code
2597: INTO l_cust_class_code
2598: FROM ra_customer_trx rct,
2599: hz_cust_accounts hzca
2600: WHERE rct.trx_number = l_doc_number
2601: AND rct.set_of_books_id = g_set_of_books_id
2602: AND hzca.cust_account_id = rct.bill_to_customer_id;
2603:

Line 5902: hz_cust_accounts_all hzca

5898: END IF;
5899: SELECT hzca.customer_class_code
5900: INTO l_cust_class_code
5901: FROM ra_customer_trx_all rct,
5902: hz_cust_accounts_all hzca
5903: WHERE rct.trx_number = p_reimb_agree_seg_val
5904: AND rct.set_of_books_id = g_set_of_books_id
5905: AND hzca.cust_account_id = rct.bill_to_customer_id;
5906:

Line 5945: hz_cust_accounts_all hzca

5941: END IF;
5942: SELECT hzca.customer_class_code
5943: INTO l_cust_class_code
5944: FROM ra_customer_trx_all rct,
5945: hz_cust_accounts_all hzca
5946: WHERE rct.trx_number = p_reimb_agree_seg_val
5947: AND rct.set_of_books_id = g_set_of_books_id
5948: AND hzca.cust_account_id = rct.bill_to_customer_id;
5949: