eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on RA_CUSTOMER_TRX_LINES_ALL

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'