DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1940: hz_cust_acct_sites_all hcas,

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

Line 1969: hz_cust_acct_sites_all hcas,

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

Line 1998: hz_cust_acct_sites_all hcas,

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

Line 2027: hz_cust_acct_sites_all hcas,

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