[Home] [Help]
1127: ra_cust_trx_line_gl_dist ctlgd,
1128: ra_cust_trx_types ctt,
1129: hz_cust_accounts hca,
1130: psa_lookup_codes l1,
1131: psa_mf_trx_dist_all psa_trx_dist
1132: WHERE
1133: ctlgd.customer_trx_id = p_customer_trx_id
1134: AND ctlgd.customer_trx_id = ct.customer_trx_id
1135: AND l.lookup_type = 'AUTOGL_TYPE'
1348:
1349:
1350: -- ========================= FND LOG ===========================
1351: psa_utils.debug_other_string(g_state_level,l_full_path,
1352: ' --> updating psa_mf_trx_dist_all with posting control id ');
1353: -- ========================= FND LOG ===========================
1354:
1355: UPDATE psa_mf_trx_dist_all ptda
1356: SET ptda.posting_control_id = l_pst_ctrl_id
1351: psa_utils.debug_other_string(g_state_level,l_full_path,
1352: ' --> updating psa_mf_trx_dist_all with posting control id ');
1353: -- ========================= FND LOG ===========================
1354:
1355: UPDATE psa_mf_trx_dist_all ptda
1356: SET ptda.posting_control_id = l_pst_ctrl_id
1357: WHERE ptda.cust_trx_line_gl_dist_id IN
1358: (SELECT cust_trx_line_gl_dist_id FROM ra_cust_trx_line_gl_dist rct
1359: WHERE rct.posting_control_id = l_pst_ctrl_id);
1360:
1361: IF (SQL%FOUND) THEN
1362: -- ========================= FND LOG ===========================
1363: psa_utils.debug_other_string(g_state_level,l_full_path,
1364: ' --> (PSA_MF_TRX_DIST_ALL) Updated Posting control id for '
1365: || SQL%ROWCOUNT);
1366: -- ========================= FND LOG ===========================
1367: END IF;
1368:
1367: END IF;
1368:
1369: -- Bug 3671841, making the call to delete stray records.
1370:
1371: DELETE FROM psa_mf_trx_dist_all
1372: WHERE posting_control_id = l_pst_ctrl_id
1373: AND cust_trx_line_gl_dist_id NOT IN
1374: ( SELECT cust_trx_line_gl_dist_id FROM ra_cust_trx_line_gl_dist rct
1375: WHERE rct.posting_control_id = l_pst_ctrl_id);
1375: WHERE rct.posting_control_id = l_pst_ctrl_id);
1376:
1377: -- ========================= FND LOG ===========================
1378: psa_utils.debug_other_string(g_state_level,l_full_path,
1379: ' --> DELETE FROM psa_mf_trx_dist_all ==> ' || SQL%ROWCOUNT);
1380: psa_utils.debug_other_string(g_state_level,l_full_path,
1381: ' --> END of TRANSACTIONS '
1382: || to_char (sysdate, 'DD/MM/YYYY HH:MI:SS'));
1383: -- ========================= FND LOG ===========================
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,
1612: psa_lookup_codes l1
1613: WHERE
1614: psa_rct_dist.receivable_application_id = p_receivable_application_id
1615: AND psa_rct_dist.ue_discount_ccid IS NULL
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,
1703: psa_lookup_codes l1
1704: WHERE
1705: psa_rct_dist.receivable_application_id = p_receivable_application_id
1706: AND psa_rct_dist.receivable_application_id = ra.receivable_application_id
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,
1821: psa_mf_trx_dist_all psa_trx_dist,
1822: psa_lookup_codes l1
1823: WHERE
1824: psa_rct_dist.receivable_application_id = p_receivable_application_id
1825: AND psa_rct_dist.ue_discount_ccid IS NOT NULL
2553: '3', 'ADJ_FINCHRG') ref29,
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
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,
3879: ra_cust_trx_line_gl_dist ar_trx_dist,
3880: psa_lookup_codes l1
3881: WHERE
3882: psa_rct_dist.receivable_application_id = p_receivable_application_id