[Home] [Help]
1122: -- 'PSA_TRX_DIST' ref30
1123: 'RA_CUST_TRX_LINE_GL_DIST' ref30
1124: FROM
1125: ar_lookups l,
1126: ra_customer_trx ct,
1127: ra_cust_trx_line_gl_dist ctlgd,
1128: ra_cust_trx_types ctt,
1129: hz_cust_accounts hca,
1130: psa_lookup_codes l1,
1507: DECODE( SUBSTR(ard.source_type,1,5),
1508: 'EXCH_', DECODE (cr.currency_code, l_func_curr, ctinv.invoice_currency_code, cr.currency_code), ctinv.invoice_currency_code), cr.currency_code),
1509: 'CM', ctcm.invoice_currency_code) currency,
1510: DECODE (to_NUMBER(l1.lookup_code), 1, psa_rct_dist.mf_cash_ccid,
1511: 2, DECODE(ra.application_type, 'CM', psa_mfar_utils.get_rec_ccid (ra.applied_customer_trx_id, ra.customer_trx_id), crh.account_code_combINation_id),
1512: 3, ra.code_combINation_id,
1513: 4, psa_trx_dist.mf_receivables_ccid,
1514: 5, psa_rct_dist.discount_ccid,
1515: 6, ra.earned_discount_ccid,
1602: (SELECT * FROM ar_distributions
1603: WHERE source_table = 'RA'
1604: AND source_id = p_receivable_application_id
1605: AND rownum = 1) ard,
1606: ra_customer_trx ctcm,
1607: ra_customer_trx ctinv,
1608: ra_cust_trx_types ctt,
1609: ar_cash_receipt_history crh,
1610: psa_mf_rct_dist_all psa_rct_dist,
1603: WHERE source_table = 'RA'
1604: AND source_id = p_receivable_application_id
1605: AND rownum = 1) ard,
1606: ra_customer_trx ctcm,
1607: ra_customer_trx ctinv,
1608: ra_cust_trx_types ctt,
1609: ar_cash_receipt_history crh,
1610: psa_mf_rct_dist_all psa_rct_dist,
1611: psa_mf_trx_dist_all psa_trx_dist,
1617: AND psa_trx_dist.cust_trx_line_gl_dist_id = psa_rct_dist.cust_trx_line_gl_dist_id
1618: /* For MFAR we consider only thr APP rows */
1619: AND 'APP' = DECODE(ra.application_type, 'CASH',ra.status, 'CM','APP')
1620: AND ra.cash_receipt_id = cr.cash_receipt_id(+)
1621: AND ra.customer_trx_id = ctcm.customer_trx_id(+)
1622: AND ra.applied_customer_trx_id = ctinv.customer_trx_id(+)
1623: AND ctinv.cust_trx_type_id = ctt.cust_trx_type_id(+)
1624: AND ra.cash_receipt_id = crh.cash_receipt_id(+)
1625: AND l1.lookup_type = 'PSA_CARTESIAN_JOIN'
1691: (SELECT * FROM ar_distributions
1692: WHERE source_table = 'RA'
1693: AND source_id = p_receivable_application_id
1694: AND rownum = 1) ard,
1695: ra_customer_trx ctcm,
1696: ra_cust_trx_line_gl_dist gld,
1697: ra_cust_trx_line_gl_dist gld_inv,
1698: ra_customer_trx ctinv,
1699: ra_cust_trx_types ctt,
1694: AND rownum = 1) ard,
1695: ra_customer_trx ctcm,
1696: ra_cust_trx_line_gl_dist gld,
1697: ra_cust_trx_line_gl_dist gld_inv,
1698: ra_customer_trx ctinv,
1699: ra_cust_trx_types ctt,
1700: ar_cash_receipt_history crh,
1701: psa_mf_rct_dist_all psa_rct_dist,
1702: psa_mf_trx_dist_all psa_trx_dist,
1707: AND psa_trx_dist.cust_trx_line_gl_dist_id = psa_rct_dist.cust_trx_line_gl_dist_id
1708: AND psa_rct_dist.cust_trx_line_gl_dist_id = gld_inv.cust_trx_line_gl_dist_id
1709: AND gld_inv.ACCOUNT_class = 'REV' /* For MFAR we consider only thr APP rows */
1710: AND 'APP' = DECODE(ra.application_type, 'CASH',ra.status, 'CM','APP')
1711: AND ra.customer_trx_id = ctcm.customer_trx_id(+)
1712: /* Bug 3397563, check for On Account Credit Memo */
1713: AND ctcm.previous_customer_trx_id IS NULL
1714: AND ctcm.customer_trx_id = gld.customer_trx_id
1715: AND gld.account_class = 'REV'
1712: /* Bug 3397563, check for On Account Credit Memo */
1713: AND ctcm.previous_customer_trx_id IS NULL
1714: AND ctcm.customer_trx_id = gld.customer_trx_id
1715: AND gld.account_class = 'REV'
1716: AND ra.customer_trx_id = ctcm.customer_trx_id(+)
1717: AND ra.applied_customer_trx_id = ctinv.customer_trx_id(+)
1718: AND ctinv.cust_trx_type_id = ctt.cust_trx_type_id(+)
1719: AND ra.cash_receipt_id = crh.cash_receipt_id(+)
1720: AND l1.lookup_type = 'PSA_CARTESIAN_JOIN'
1812: (SELECT * FROM ar_distributions
1813: WHERE source_table = 'RA'
1814: AND source_id = p_receivable_application_id
1815: AND rownum = 1) ard,
1816: ra_customer_trx ctinv,
1817: ra_cust_trx_types ctt,
1818: ar_cash_receipt_history crhnew,
1819: ar_cash_receipt_history crhold,
1820: psa_mf_rct_dist_all psa_rct_dist,
2554: 'PSA_ADJ_DIST' ref30
2555: FROM ar_adjustments adj,
2556: psa_mf_adj_dist_all psa_adj_dist,
2557: psa_mf_trx_dist_all psa_trx_dist,
2558: ra_customer_trx ct,
2559: ra_cust_trx_line_gl_dist ctlgd,
2560: ra_cust_trx_types ctt,
2561: psa_lookup_codes l
2562: WHERE psa_adj_dist.adjustment_id = adj.adjustment_id
3798: DECODE (ra.application_type, 'CASH', cr.doc_sequence_value,
3799: 'CM', ctcm.doc_sequence_value) doc_num,
3800: cr.currency_code currency,
3801: DECODE (to_NUMBER(l1.lookup_code), 1, psa_rct_dist.mf_cash_ccid,
3802: 2, DECODE(ra.application_type, 'CM', psa_mfar_utils.get_rec_ccid (ra.applied_customer_trx_id, ra.customer_trx_id), crh.account_code_combINation_id),
3803: 3, ar_trx_dist.code_combINation_id,
3804: 4, ar_trx_dist.code_combINation_id,
3805: 5, psa_rct_dist.discount_ccid,
3806: 6, ra.earned_discount_ccid,
3869: 'CM', 'RA_CUST_TRX_LINE_GL_DIST') ref30
3870: FROM
3871: ar_receivable_applications ra,
3872: ar_cash_receipts cr,
3873: ra_customer_trx ctcm,
3874: ra_customer_trx ctinv,
3875: ra_cust_trx_types ctt,
3876: ar_cash_receipt_history crh,
3877: psa_mf_rct_dist_all psa_rct_dist,
3870: FROM
3871: ar_receivable_applications ra,
3872: ar_cash_receipts cr,
3873: ra_customer_trx ctcm,
3874: ra_customer_trx ctinv,
3875: ra_cust_trx_types ctt,
3876: ar_cash_receipt_history crh,
3877: psa_mf_rct_dist_all psa_rct_dist,
3878: psa_mf_trx_dist_all psa_trx_dist,
3887: AND ar_trx_dist.cust_trx_line_gl_dist_id = psa_rct_dist.cust_trx_line_gl_dist_id
3888: /* For MFAR we consider only thr APP rows */
3889: AND ra.status = 'APP'
3890: AND ra.cash_receipt_id = cr.cash_receipt_id(+)
3891: AND ra.customer_trx_id = ctcm.customer_trx_id(+)
3892: AND ra.applied_customer_trx_id = ctinv.customer_trx_id(+)
3893: AND ctinv.cust_trx_type_id = ctt.cust_trx_type_id(+)
3894: AND ra.cash_receipt_id = crh.cash_receipt_id(+)
3895: AND l1.lookup_type = 'PSA_CARTESIAN_JOIN'