APPS.ARP_GROUP_INV dependencies on RA_CUSTOMER_TRX

Line 59: ra_customer_trx ct,

55: ct.customer_trx_id,
56: ct.org_id
57: FROM
58: ar_payment_schedules ps,
59: ra_customer_trx ct,
60: ra_cust_trx_types tt
61: WHERE
62: ct.cust_trx_type_id = tt.cust_trx_type_id
63: AND ct.customer_trx_id = ps.customer_trx_id

Line 436: FROM ra_customer_trx ct

432: and li.customer_trx_id IS NOT NULL
433: AND cons_billing_number IS NOT NULL
434: AND NVL(interface_status, '~') <> 'P' -- Only consider unprocessed Transactions
435: AND EXISTS (SELECT 1
436: FROM ra_customer_trx ct
437: WHERE ct.customer_trx_id = li.customer_trx_id)
438: ORDER BY cons_billing_number, customer_trx_id;
439:
440: /* bug3886862 check if there is cons inv with the number */