eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_FACTS_TRX_REGISTER dependencies on HZ_CUST_ACCOUNTS

Line 1941: hz_cust_accounts hca

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
1943: AND ara.cash_receipt_id = acr.cash_receipt_id
1944: AND hcsu.site_use_id = acr.customer_site_use_id
1945: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id

Line 1970: hz_cust_accounts hca

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
1972: AND ara.cash_receipt_id = acr.cash_receipt_id
1973: AND hcsu.site_use_id = acr.customer_site_use_id
1974: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id

Line 1999: hz_cust_accounts hca

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
2001: AND ara.associated_cash_receipt_id = acr.cash_receipt_id
2002: AND hcsu.site_use_id = acr.customer_site_use_id
2003: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id

Line 2028: hz_cust_accounts hca

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
2030: AND ara.cash_receipt_id = acr.cash_receipt_id
2031: AND hcsu.site_use_id = acr.customer_site_use_id
2032: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id

Line 2373: FROM hz_cust_accounts hzca, fv_facts_customers_v fcv

2369: BEGIN
2370: l_feeder_flag := 'Y';
2371: SELECT hzca.customer_class_code, fcv.eliminations_id
2372: INTO l_vendor_type, l_eliminations_id
2373: FROM hz_cust_accounts hzca, fv_facts_customers_v fcv
2374: WHERE hzca.cust_account_id = to_number(l_reference_7)
2375: AND fcv.customer_id = hzca.cust_account_id;
2376: EXCEPTION
2377: WHEN NO_DATA_FOUND THEN