[Home] [Help]
2220: ct.PAYING_CUSTOMER_ID,
2221: ct.PAYING_SITE_USE_ID,
2222: ( 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)) ) dispute_amt
2223: FROM AR_PAYMENT_SCHEDULES ps,
2224: RA_CUSTOMER_TRX ct,
2225: HZ_CUST_ACCOUNTS acct,
2226: RA_TERMS trm
2227: WHERE ps.CLASS IN ('INV', 'DM', 'CB', 'DEP')
2228: AND ps.customer_trx_id = ct.customer_trx_id
2491: 0 PAYING_CUSTOMER_ID,
2492: 0 PAYING_SITE_USE_ID,
2493: 0 dispute_amt
2494: FROM AR_PAYMENT_SCHEDULES ps,
2495: RA_CUSTOMER_TRX_ALL ct,
2496: HZ_CUST_ACCOUNTS acct,
2497: RA_TERMS trm
2498: WHERE ps.customer_id = p_customer_id
2499: AND ( ps.CLASS = 'CM'
4973:
4974: 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,
4975: (decode( nvl(AMOUNT_DUE_ORIGINAL,0),0,1,(AMOUNT_DUE_ORIGINAL/abs(AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(amount_in_dispute,0)) )
4976: 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
4977: from ar_payment_schedules ps, ra_customer_trx_all ct
4978: where ps.CUSTOMER_TRX_ID = ct.CUSTOMER_TRX_ID(+)
4979: and ps.payment_schedule_id = p_payment_schedule_id;
4980:
4981: --Bug 4479224
5166: --Bug 4062938 - Handling of transactions with no site id
5167: decode(ps.customer_site_use_id, null, -1,ps.customer_site_use_id) as CUSTOMER_SITE_USE_ID,
5168: (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)) )
5169: FROM AR_PAYMENT_SCHEDULES ps,
5170: RA_CUSTOMER_TRX_ALL ct,
5171: HZ_CUST_ACCOUNTS acct,
5172: RA_TERMS trm
5173: WHERE ps.payment_schedule_id = p_payment_schedule_id
5174: AND ps.CLASS IN ('INV', 'DM', 'GUAR', 'CB', 'DEP', 'CM', 'PMT' ) -- CCA - hikumar