DBA Data[Home] [Help]

APPS.FV_FACTS_TRX_REGISTER dependencies on HZ_CUST_SITE_USES_ALL

Line 2019: hz_cust_site_uses_all hcsu,

2015: INTO l_reference_4,
2016: l_reference_7
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

Line 2048: hz_cust_site_uses_all hcsu,

2044: INTO l_reference_4,
2045: l_reference_7
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

Line 2077: hz_cust_site_uses_all hcsu,

2073: INTO l_reference_4,
2074: l_reference_7
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

Line 2106: hz_cust_site_uses_all hcsu,

2102: INTO l_reference_4,
2103: l_reference_7
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