APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on RA_CUSTOMER_TRX_LINES

Line 774: FROM ra_customer_trx_lines rctl

770: IF (p_retcode = g_SUCCESS) THEN
771: BEGIN
772: SELECT SUM(NVL(rctl.amount_due_remaining, rctl.quantity_invoiced*rctl.unit_selling_price))
773: INTO l_total_line_amount
774: FROM ra_customer_trx_lines rctl
775: WHERE rctl.customer_trx_id = p_parent_invoice_id;
776: IF (fnd_log.level_statement >= g_CURRENT_LOG_LEVEL) THEN
777: debug (l_module_name,'l_total_line_amount='||l_total_line_amount);
778: END IF;

Line 783: l_location := l_module_name||'.select_ra_customer_trx_lines';

779: EXCEPTION
780: WHEN OTHERS THEN
781: p_retcode := g_FAILURE;
782: p_errbuf := SQLERRM;
783: l_location := l_module_name||'.select_ra_customer_trx_lines';
784: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
785: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_errbuf) ;
786: END;
787: END IF;

Line 851: FROM ra_customer_trx_lines rctl

847: END LOOP;
848:
849: IF (p_prorate_charge = 'L') THEN
850: FOR inv_lines_rec IN (SELECT *
851: FROM ra_customer_trx_lines rctl
852: WHERE rctl.customer_trx_id = p_parent_invoice_id) LOOP
853: IF (fnd_log.level_statement >= g_CURRENT_LOG_LEVEL) THEN
854: debug (l_module_name,'inv_lines_rec.amount_due_remaining='||inv_lines_rec.amount_due_remaining);
855: debug (l_module_name,'inv_lines_rec.quantity_invoiced='||inv_lines_rec.quantity_invoiced);

Line 1308: FROM ra_customer_trx_lines rctl

1304: g_request_id,
1305: p_finance_charge_group_hdr_id,
1306: p_finance_charge_group_dtl_id,
1307: p_charge_id
1308: FROM ra_customer_trx_lines rctl
1309: WHERE rctl.customer_trx_id = l_dm_invoice_id;
1310: EXCEPTION
1311: WHEN OTHERS THEN
1312: p_retcode := g_FAILURE;

Line 2350: (SELECT 'X' FROM ra_customer_trx_lines_all ral

2346: IF (p_retcode = g_SUCCESS) THEN
2347: BEGIN
2348: /* Bug 13035171. Replaced clause AND rctt.type IN ('DM','INV') with
2349: AND( rctt.type ='INV' OR (rctt.type ='DM' and not exists
2350: (SELECT 'X' FROM ra_customer_trx_lines_all ral
2351: WHERE description = 'Accrue Federal Finance Charges'
2352: AND ral.customer_trx_id = ract.customer_trx_id )))
2353: in both insert statements below. Assign Finance Charges report should display
2354: finance charges assigned to invoices and debit memos not created by the Accrue

Line 2403: ( SELECT 'X' FROM ra_customer_trx_lines_all ral

2399: WHERE ract.cust_trx_type_id = rctt.cust_trx_type_id
2400: AND ract.complete_flag = 'Y'
2401: --AND rctt.type IN ('DM','INV')
2402: AND( rctt.type ='INV' OR (rctt.type ='DM' AND NOT EXISTS
2403: ( SELECT 'X' FROM ra_customer_trx_lines_all ral
2404: WHERE description = 'Accrue Federal Finance Charges'
2405: AND ral.customer_trx_id = ract.customer_trx_id )))
2406:
2407: /* AND NVL(ract.interface_header_attribute3,'XX') NOT IN (SELECT charge_type

Line 2481: ( SELECT 'X' FROM ra_customer_trx_lines_all ral

2477: AND fcfc.enabled_flag = 'Y'
2478: AND fcfc.waive_flag = 'N'
2479: --AND rctt.type IN ('DM','INV')
2480: AND( rctt.type ='INV' OR (rctt.type ='DM' AND NOT EXISTS
2481: ( SELECT 'X' FROM ra_customer_trx_lines_all ral
2482: WHERE description = 'Accrue Federal Finance Charges'
2483: AND ral.customer_trx_id = ract.customer_trx_id )))
2484: AND fcgd.finance_charge_group_hdr_id = fcgh.finance_charge_group_hdr_id
2485: AND fcgh.enabled_flag = 'Y'