[Home] [Help]
2165: IS SELECT
2166: customer_trx_id
2167: FROM
2168: ar_batches b ,
2169: ar_payment_schedules p
2170: where p.customer_trx_id = CUSTOMERTRXID
2171: and p.reserved_type = 'REMITTANCE'
2172: and p.reserved_value=b.batch_id
2173: and b.status='OP';
2276: LINES.customer_trx_line_id
2277: FROM
2278: RA_CUSTOMER_TRX TRX ,
2279: RA_CUST_TRX_TYPES TYPES,
2280: AR_PAYMENT_SCHEDULES PAYS ,
2281: HZ_CUST_ACCOUNTS CUST_ACCT ,
2282: HZ_PARTIES PARTY,
2283: AR_RECEIPT_METHODS METH,
2284: CE_BANK_BRANCHES_V ABB,
2397: NULL /* Customer_trx_line_id */
2398: FROM
2399: RA_CUST_TRX_TYPES TYPES,
2400: RA_CUSTOMER_TRX TRX ,
2401: AR_PAYMENT_SCHEDULES PAYS ,
2402: HZ_CUST_ACCOUNTS CUST_ACCT ,
2403: HZ_PARTIES PARTY,
2404: AR_receipt_METHODS METH,
2405: CE_BANK_BRANCHES_V ABB,
2419: and PAYS.selected_for_receipt_batch_id is null
2420: and not exists
2421: (select 1
2422: from ra_customer_trx_lines sub,
2423: ar_payment_schedules ps
2424: where sub.br_ref_customer_trx_id = TRX.customer_trx_id
2425: and ps.customer_trx_id = trx.customer_trx_id
2426: and ( ( ps.amount_due_remaining = 0 and
2427: sub.customer_trx_id <> ' || customer_trx_id || ' )' ||
2499: NULL /* Customer_TRX_LINE_ID */
2500: FROM
2501: RA_CUST_TRX_TYPES TYPES,
2502: RA_CUSTOMER_TRX TRX ,
2503: AR_PAYMENT_SCHEDULES PAYS ,
2504: HZ_CUST_ACCOUNTS CUST_ACCT ,
2505: HZ_PARTIES PARTY,
2506: AR_receipt_METHODS METH,
2507: CE_BANK_BRANCHES_V ABB,
2525: and H.status = ''UNPAID''
2526: and not exists
2527: (select 1
2528: from ra_customer_trx_lines linesub,
2529: ar_payment_schedules paysub ,
2530: ra_customer_trx billsub
2531: where linesub.br_ref_customer_trx_id = TRX.customer_trx_id
2532: and linesub.customer_trx_id = billsub.customer_trx_id
2533: and billsub.customer_trx_id = paysub.customer_trx_id