[Home] [Help]
462: FROM
463: psa_mf_misc_dist_all mfd,
464: psa_lookup_codes l1,
465: ar_misc_cash_distributions mcd,
466: ar_distributions ard,
467: ar_cash_receipts cr,
468: ar_cash_receipt_history crh,
469: ar_distributions ard2
470: WHERE
465: ar_misc_cash_distributions mcd,
466: ar_distributions ard,
467: ar_cash_receipts cr,
468: ar_cash_receipt_history crh,
469: ar_distributions ard2
470: WHERE
471: l1.lookup_type = 'PSA_CARTESIAN_JOIN'
472: AND l1.lookup_code IN ('1','2')
473: AND mfd.misc_cash_distribution_id = mcd.misc_cash_distribution_id
521: 'AR_CASH_RECEIPT_HISTORY' ref30
522: FROM
523: ar_cash_receipt_history crh,
524: psa_receivables_trx_all psa,
525: ar_distributions ard,
526: ar_cash_receipts cr
527: WHERE
528: crh.status <> 'REVERSED'
529: AND crh.posting_control_id = l_pst_ctrl_id
1598: 'CM', 'RA_CUST_TRX_LINE_GL_DIST') ref30
1599: FROM
1600: ar_receivable_applications ra,
1601: ar_cash_receipts cr,
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,
1687: DECODE(ra.application_type, 'CASH', 'PSA_RCT_DIST',
1688: 'CM', 'RA_CUST_TRX_LINE_GL_DIST') ref30
1689: FROM
1690: ar_receivable_applications ra,
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,
1808: 'PSA_RCT_DIST' ref30
1809: FROM
1810: ar_receivable_applications ra,
1811: ar_cash_receipts cr,
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,
2457: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (adj.adjustment_id, 'ADJ', l_sob_id)
2458: , 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE';
2459:
2460: -- Bug 2982757
2461: -- Modified cursor to fetch adjustment ccid from ar_distributions
2462: -- New function created get_adj_ccid
2463:
2464: -- Bug 3168282 (Tpradhan)
2465: -- Selected the value ussgl_transaction_code in the Cursor below. Also inserted the same value into gl_interface table.
3578: CURSOR c_adj_ccid (c_adjustment_id NUMBER)
3579: IS
3580: SELECT ard.code_combination_id adj_ccid
3581: FROM ar_adjustments_all adj,
3582: ar_distributions_all ard
3583: WHERE adj.adjustment_id = c_adjustment_id
3584: AND adj.adjustment_id = ard.source_id
3585: AND ard.source_table = 'ADJ'
3586: AND ard.source_type IN ('ADJ', 'FINCHRG');
3605: CURSOR c_adj_ard_id (c_adjustment_id NUMBER)
3606: IS
3607: SELECT ard.line_id adj_ard_id
3608: FROM ar_adjustments_all adj,
3609: ar_distributions_all ard
3610: WHERE adj.adjustment_id = c_adjustment_id
3611: AND adj.adjustment_id = ard.source_id
3612: AND ard.source_table = 'ADJ'
3613: AND ard.source_type IN ('ADJ', 'FINCHRG');
3632: CURSOR c_misc_ard_id (c_misc_cash_dist_id NUMBER)
3633: IS
3634: SELECT ard.line_id misc_ard_id
3635: FROM ar_misc_cash_distributions_all mcd,
3636: ar_distributions_all ard
3637: WHERE mcd.misc_cash_distribution_id = c_misc_cash_dist_id
3638: AND mcd.misc_cash_distribution_id = ard.source_id
3639: AND ard.source_table = 'MCD';
3640:
4157: FROM
4158: psa_mf_misc_dist_all mfd,
4159: psa_lookup_codes l1,
4160: ar_misc_cash_distributions_all mcd,
4161: ar_distributions_all ard,
4162: ar_cash_receipts_all cr,
4163: ar_cash_receipt_history_all crh
4164: WHERE
4165: l1.lookup_type = 'PSA_CARTESIAN_JOIN'