[Home] [Help]
24: (
25: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,
26: CmPsIdFlag VARCHAR2(1),
27: Class ar_payment_schedules.class%TYPE,
28: TrxNumber ra_customer_trx.trx_number%TYPE,
29: OrgId ra_customer_trx.org_id%TYPE
30: );
31: --
32: -- RECORD holder for pertinent information from a receivable application
25: PaymentScheduleId ar_payment_schedules.payment_schedule_id%TYPE,
26: CmPsIdFlag VARCHAR2(1),
27: Class ar_payment_schedules.class%TYPE,
28: TrxNumber ra_customer_trx.trx_number%TYPE,
29: OrgId ra_customer_trx.org_id%TYPE
30: );
31: --
32: -- RECORD holder for pertinent information from a receivable application
33: -- of status = 'APP'
478: ) amount,
479: a.code_combination_id ccid,
480: substrb(a.type,1,15) accntclass
481: FROM ar_adjustments a,
482: ra_customer_trx ct,
483: ra_cust_trx_types ctt
484: WHERE a.payment_schedule_id = cp_ps_id
485: AND a.receivables_trx_id <> -1
486: AND a.type = cp_type
1706: ) ChargesApplied,
1707: ct.org_id OrgId
1708: FROM ar_receivable_applications ra,
1709: ra_cust_trx_types ctt,
1710: ra_customer_trx ct,
1711: ar_cash_receipts cr,
1712: ar_cash_receipt_history crh,
1713: ra_customer_trx ctcm,
1714: ar_lookups l
1709: ra_cust_trx_types ctt,
1710: ra_customer_trx ct,
1711: ar_cash_receipts cr,
1712: ar_cash_receipt_history crh,
1713: ra_customer_trx ctcm,
1714: ar_lookups l
1715: WHERE ra.posting_control_id = p_Post.UnpostedPostingControlId
1716: AND ra.gl_date BETWEEN p_Post.GlDateFrom
1717: AND p_Post.GlDateTo
1719: AND nvl(ra.confirmed_flag,'Y') = 'Y'
1720: AND ra.status||'' = 'APP' -- Bug 2187023
1721: AND ra.cash_receipt_id = cr.cash_receipt_id(+)
1722: AND ra.cash_receipt_history_id = crh.cash_receipt_history_id(+)
1723: AND ra.customer_trx_id = ctcm.customer_trx_id(+)
1724: AND ctcm.previous_customer_trx_id IS NULL
1725: AND ra.applied_customer_trx_id = ct.customer_trx_id
1726: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1727: AND l.lookup_type = 'AR_CARTESIAN_JOIN'
1821: -- '2', NVL(-ra.receivables_charges_applied,0)
1822: -- ) ChargesApplied
1823: -- FROM ar_receivable_apps_mrc_v ra,
1824: -- ra_cust_trx_types ctt,
1825: -- ra_customer_trx ct,
1826: -- ar_cash_receipts cr,
1827: -- ar_cash_receipt_hist_mrc_v crh,
1828: -- ra_customer_trx_mrc_v ctcm,
1829: -- ar_lookups l
1824: -- ra_cust_trx_types ctt,
1825: -- ra_customer_trx ct,
1826: -- ar_cash_receipts cr,
1827: -- ar_cash_receipt_hist_mrc_v crh,
1828: -- ra_customer_trx_mrc_v ctcm,
1829: -- ar_lookups l
1830: -- WHERE ra.posting_control_id = p_Post.UnpostedPostingControlId
1831: -- AND ra.gl_date BETWEEN p_Post.GlDateFrom
1832: -- AND p_Post.GlDateTo
1834: -- AND nvl(ra.confirmed_flag,'Y') = 'Y'
1835: -- AND ra.status||'' = 'APP' -- Bug 2187023
1836: -- AND ra.cash_receipt_id = cr.cash_receipt_id(+)
1837: -- AND ra.cash_receipt_history_id = crh.cash_receipt_history_id(+)
1838: -- AND ra.customer_trx_id = ctcm.customer_trx_id(+)
1839: -- AND ctcm.previous_customer_trx_id IS NULL
1840: -- AND ra.applied_customer_trx_id = ct.customer_trx_id
1841: -- AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1842: -- AND l.lookup_type = 'AR_CARTESIAN_JOIN'
2583: AND receivable_application_id IN (
2584: SELECT ra.receivable_application_id
2585: FROM ar_receivable_applications ra
2586: WHERE p_CategoryCode = 'CMAPP'
2587: AND ra.customer_trx_id = p_BalanceId
2588: UNION
2589: SELECT ra.receivable_application_id
2590: FROM ar_receivable_applications ra
2591: WHERE p_CategoryCode = 'TRADE'