DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on HZ_CUST_SITE_USES_ALL

Line 1939: hz_cust_site_uses_all hcsu,

1935: INTO l_reference_4,
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

Line 1968: hz_cust_site_uses_all hcsu,

1964: INTO l_reference_4,
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

Line 1997: hz_cust_site_uses_all hcsu,

1993: INTO l_reference_4,
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

Line 2026: hz_cust_site_uses_all hcsu,

2022: INTO l_reference_4,
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