[Home] [Help]
32: TYPE TrxType IS RECORD
33: (
34: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,
35: CmPsIdFlag VARCHAR2(1),
36: TrxNumber ra_customer_trx.trx_number%TYPE
37: );
38: --
39: -- RECORD holder for pertinent information from a receivable application
40: -- of status = 'APP'
353: ) amount,
354: a.code_combination_id ccid,
355: substrb(a.type,1,15) accntclass
356: FROM ar_adjustments a,
357: ra_customer_trx ct,
358: ra_cust_trx_types ctt
359: WHERE a.payment_schedule_id = cp_ps_id
360: AND a.receivables_trx_id <> -1
361: AND a.status = 'A'
1471: igira.arc_posting_control_id PostingControlId
1472: FROM ar_receivable_applications ra,
1473: igi_ar_rec_applications igira,
1474: ra_cust_trx_types ctt,
1475: ra_customer_trx ct,
1476: ar_cash_receipts cr,
1477: ar_cash_receipt_history crh,
1478: ra_customer_trx ctcm,
1479: ar_lookups l,
1474: ra_cust_trx_types ctt,
1475: ra_customer_trx ct,
1476: ar_cash_receipts cr,
1477: ar_cash_receipt_history crh,
1478: ra_customer_trx ctcm,
1479: ar_lookups l,
1480: ar_lookups l_cat,
1481: hz_parties, -- Bug 3902175
1482: hz_cust_accounts, -- Bug 3902175
1488: AND ra.status||'' = 'APP'
1489: AND ra.receivable_application_id = igira.receivable_application_id
1490: AND ra.cash_receipt_id = cr.cash_receipt_id(+)
1491: AND ra.cash_receipt_history_id = crh.cash_receipt_history_id(+)
1492: AND ra.customer_trx_id = ctcm.customer_trx_id(+)
1493: AND ctcm.previous_customer_trx_id IS NULL
1494: AND ra.applied_customer_trx_id = ct.customer_trx_id
1495: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1496: AND hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175