DBA Data[Home] [Help]

APPS.ARP_BF_BILL dependencies on AR_CASH_RECEIPTS

Line 1788: ar_cash_receipts CR

1784: NULL,
1785: PS.org_id
1786: FROM
1787: ar_payment_schedules PS,
1788: ar_cash_receipts CR
1789: WHERE
1790: PS.customer_site_use_id = L_sites.site_id
1791: AND PS.cons_inv_id IS NULL
1792: AND PS.class = 'PMT'

Line 1839: ar_cash_receipts CR

1835: NULL,
1836: CR.org_id
1837: FROM
1838: ar_payment_schedules PS,
1839: ar_cash_receipts CR
1840: WHERE
1841: PS.customer_site_use_id = L_sites.site_id
1842: AND PS.cons_inv_id_rev IS NULL
1843: AND PS.invoice_currency_code = P_currency

Line 2248: ar_cash_receipts CR

2244: NULL,
2245: PS.org_id
2246: FROM
2247: ar_payment_schedules PS,
2248: ar_cash_receipts CR
2249: WHERE
2250: PS.customer_id = L_sites.customer_id
2251: AND PS.customer_site_use_id IS NULL
2252: AND PS.cons_inv_id IS NULL

Line 2300: ar_cash_receipts CR

2296: NULL,
2297: CR.org_id
2298: FROM
2299: ar_payment_schedules PS,
2300: ar_cash_receipts CR
2301: WHERE
2302: PS.customer_id =L_sites.customer_id
2303: AND PS.customer_site_use_id IS NULL
2304: AND PS.cons_inv_id_rev IS NULL