[Home] [Help]
2617: 0 PAYING_CUSTOMER_ID,
2618: 0 PAYING_SITE_USE_ID,
2619: 0 dispute_amt
2620: FROM AR_PAYMENT_SCHEDULES ps,
2621: RA_CUSTOMER_TRX_ALL ct,
2622: HZ_CUST_ACCOUNTS acct,
2623: RA_TERMS trm
2624: WHERE ps.customer_id = p_customer_id
2625: AND ( ps.CLASS = 'CM'
5608:
5609: select class, amount_due_remaining, cash_receipt_id, ps.CUSTOMER_ID, ct.PAYING_CUSTOMER_ID, ps.CUSTOMER_SITE_USE_ID,ct.PAYING_SITE_USE_ID, ps.customer_trx_id,
5610: (decode( nvl(AMOUNT_DUE_ORIGINAL,0),0,1,(AMOUNT_DUE_ORIGINAL/abs(AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(amount_in_dispute,0)) )
5611: into l_trx_class, l_amount_due_remaining, l_cash_receipt_id, l_pay_for_cust_id, l_paying_cust_id, l_pay_for_cust_site_id, l_paying_cust_site_id, l_customer_trx_id, l_dispute_amount
5612: from ar_payment_schedules ps, ra_customer_trx_all ct
5613: where ps.CUSTOMER_TRX_ID = ct.CUSTOMER_TRX_ID(+)
5614: and ps.payment_schedule_id = p_payment_schedule_id;
5615:
5616: --Bug 4479224
5811: --Bug 4062938 - Handling of transactions with no site id
5812: decode(ps.customer_site_use_id, null, -1,ps.customer_site_use_id) as CUSTOMER_SITE_USE_ID,
5813: (decode( nvl(ps.AMOUNT_DUE_ORIGINAL,0),0,1,(ps.AMOUNT_DUE_ORIGINAL/abs(ps.AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(ps.amount_in_dispute,0)) )
5814: FROM AR_PAYMENT_SCHEDULES ps,
5815: RA_CUSTOMER_TRX_ALL ct,
5816: HZ_CUST_ACCOUNTS acct,
5817: RA_TERMS trm
5818: WHERE ps.payment_schedule_id = p_payment_schedule_id
5819: AND ps.CLASS IN ('INV', 'DM', 'GUAR', 'CB', 'DEP', 'CM', 'PMT' ) -- CCA - hikumar