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.ARP_BF_BILL dependencies on AR_CASH_RECEIPTS

Line 1737: ar_cash_receipts CR

1733: NULL,
1734: PS.org_id
1735: FROM
1736: ar_payment_schedules PS,
1737: ar_cash_receipts CR
1738: WHERE
1739: PS.customer_site_use_id = L_sites.site_id
1740: AND PS.cons_inv_id IS NULL
1741: AND PS.class = 'PMT'

Line 1774: ar_cash_receipts CR

1770: NULL,
1771: CR.org_id
1772: FROM
1773: ar_payment_schedules PS,
1774: ar_cash_receipts CR
1775: WHERE
1776: PS.customer_site_use_id = L_sites.site_id
1777: AND PS.cons_inv_id_rev IS NULL
1778: AND PS.invoice_currency_code = P_currency

Line 2141: ar_cash_receipts CR

2137: NULL,
2138: PS.org_id
2139: FROM
2140: ar_payment_schedules PS,
2141: ar_cash_receipts CR
2142: WHERE
2143: PS.customer_id = L_sites.customer_id
2144: AND PS.customer_site_use_id IS NULL
2145: AND PS.cons_inv_id IS NULL

Line 2179: ar_cash_receipts CR

2175: NULL,
2176: CR.org_id
2177: FROM
2178: ar_payment_schedules PS,
2179: ar_cash_receipts CR
2180: WHERE
2181: PS.customer_id =L_sites.customer_id
2182: AND PS.customer_site_use_id IS NULL
2183: AND PS.cons_inv_id_rev IS NULL