[Home] [Help]
36: (
37: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,
38: CmPsIdFlag VARCHAR2(1),
39: Class ar_payment_schedules.class%TYPE,
40: TrxNumber ra_customer_trx.trx_number%TYPE
41: );
42: --
43: -- RECORD holder for pertinent information from a receivable application
44: -- of status = 'APP'
388: ) amount,
389: a.code_combination_id ccid,
390: substrb(a.type,1,15) accntclass
391: FROM ar_adjustments a,
392: ra_customer_trx ct,
393: ra_cust_trx_types ctt
394: WHERE a.payment_schedule_id = cp_ps_id
395: AND a.receivables_trx_id <> -1
396: AND a.type = cp_type
1386: ) ChargesApplied
1387: FROM ar_receivable_applications ra,
1388: igi_ar_rec_applications igira,
1389: ra_cust_trx_types ctt,
1390: ra_customer_trx ct,
1391: ar_cash_receipts cr,
1392: ar_cash_receipt_history crh,
1393: ra_customer_trx ctcm,
1394: ar_lookups l
1389: ra_cust_trx_types ctt,
1390: ra_customer_trx ct,
1391: ar_cash_receipts cr,
1392: ar_cash_receipt_history crh,
1393: ra_customer_trx ctcm,
1394: ar_lookups l
1395: WHERE igira.arc_posting_control_id = p_Post.UnpostedPostingControlId
1396: AND igira.receivable_application_id = ra.receivable_application_id
1397: AND trunc(ra.gl_date) >= p_Post.GlDateFrom
1400: AND nvl(ra.confirmed_flag,'Y') = 'Y'
1401: AND ra.status||'' in ( 'APP','ACTIVITY')
1402: AND ra.cash_receipt_id = cr.cash_receipt_id(+)
1403: AND ra.cash_receipt_history_id = crh.cash_receipt_history_id(+)
1404: AND ra.customer_trx_id = ctcm.customer_trx_id(+)
1405: AND ctcm.previous_customer_trx_id IS NULL
1406: AND ra.applied_customer_trx_id = ct.customer_trx_id
1407: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1408: AND l.lookup_type = 'AR_CARTESIAN_JOIN'