[Home] [Help]
1483: 2. MFAR Reversal of Core Receivable Account
1484: 3. MFAR Remittance Account
1485: 4. MFAR reversal of Core Remittance Account ( derived from Transaction Dist A/c)
1486:
1487: In AR_CASH_RECEIPT_HISTORY_ALL, account_code_combination_id stores remittance account if status = 'REMITTED'
1488: account_code_combination_id stores Cash account if status = 'CLEARED'
1489: For MFAR Entries, the description should be appropriately changed based on Remittance requirement.
1490: ###############################################################################
1491: */
4113: IS
4114:
4115: CURSOR c_crh_post
4116: IS
4117: SELECT cash_receipt_history_id FROM ar_cash_receipt_history_all
4118: WHERE posting_control_id = l_pst_ctrl_id
4119: AND cash_receipt_history_id NOT IN
4120: (SELECT cash_receipt_history_id FROM psa_misc_posting);
4121:
4120: (SELECT cash_receipt_history_id FROM psa_misc_posting);
4121:
4122: CURSOR c_create_dist
4123: IS
4124: SELECT cr.cash_receipt_id FROM ar_cash_receipts_all cr, ar_cash_receipt_history_all crh
4125: WHERE cr.cash_receipt_id = crh.cash_receipt_id
4126: -- AND crh.status = 'CLEARED'
4127: AND fnd_date.date_to_canonical (crh.gl_date) BETWEEN fnd_date.date_to_canonical (TO_DATE (l_gl_start_date ||' 00:00:00','YYYY/MM/DD HH24:MI:SS'))
4128: AND fnd_date.date_to_canonical (TO_DATE (l_post_through_date ||' 00:00:00','YYYY/MM/DD HH24:MI:SS'));
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'
4166: AND l1.lookup_code IN ('1','2')
4167: AND mfd.misc_cash_distribution_id = mcd.misc_cash_distribution_id