[Home] [Help]
22: TYPE TrxType IS RECORD
23: (
24: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,
25: CmPsIdFlag VARCHAR2(1),
26: TrxNumber ra_customer_trx.trx_number%TYPE,
27: OrgId ra_customer_trx.org_id%TYPE
28: );
29: --
30: -- RECORD holder for pertinent information from a receivable application
23: (
24: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,
25: CmPsIdFlag VARCHAR2(1),
26: TrxNumber ra_customer_trx.trx_number%TYPE,
27: OrgId ra_customer_trx.org_id%TYPE
28: );
29: --
30: -- RECORD holder for pertinent information from a receivable application
31: -- of status = 'APP'
338: ) amount,
339: a.code_combination_id ccid,
340: substrb(a.type,1,15) accntclass
341: FROM ar_adjustments a,
342: ra_customer_trx ct,
343: ra_cust_trx_types ctt
344: WHERE a.payment_schedule_id = cp_ps_id
345: AND a.receivables_trx_id <> -1
346: AND a.status = 'A'
1478: ra.posting_control_id PostingControlId,
1479: ct.org_id OrgID
1480: FROM ar_receivable_applications ra,
1481: ra_cust_trx_types ctt,
1482: ra_customer_trx ct,
1483: ar_cash_receipts cr,
1484: ar_cash_receipt_history crh,
1485: ra_customer_trx ctcm,
1486: ar_lookups l,
1481: ra_cust_trx_types ctt,
1482: ra_customer_trx ct,
1483: ar_cash_receipts cr,
1484: ar_cash_receipt_history crh,
1485: ra_customer_trx ctcm,
1486: ar_lookups l,
1487: ar_lookups l_cat,
1488: hz_cust_accounts cust
1489: WHERE ra.gl_date BETWEEN p_Report.GlDateFrom
1492: AND nvl(ra.confirmed_flag,'Y') = 'Y'
1493: AND ra.status||'' = 'APP'
1494: AND ra.cash_receipt_id = cr.cash_receipt_id(+)
1495: AND ra.cash_receipt_history_id = crh.cash_receipt_history_id(+)
1496: AND ra.customer_trx_id = ctcm.customer_trx_id(+)
1497: AND ctcm.previous_customer_trx_id IS NULL
1498: AND ra.applied_customer_trx_id = ct.customer_trx_id
1499: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1500: AND l.lookup_type = 'AR_CARTESIAN_JOIN'