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.OEXPURGE dependencies on RA_CUSTOMER_TRX

Line 170: FROM ra_customer_trx_lines rctl,

166: p_order_type_name VARCHAR2 ) RETURN NUMBER IS
167:
168: CURSOR SO_PROBLEM_CHECK IS
169: SELECT 'Open invoices for this sales order'
170: FROM ra_customer_trx_lines rctl,
171: ra_customer_trx rct
172: WHERE rctl.interface_line_attribute1 = p_order_number
173: AND rctl.interface_line_attribute2 = p_order_type_name
174: AND rctl.customer_trx_id = rct.customer_trx_id

Line 171: ra_customer_trx rct

167:
168: CURSOR SO_PROBLEM_CHECK IS
169: SELECT 'Open invoices for this sales order'
170: FROM ra_customer_trx_lines rctl,
171: ra_customer_trx rct
172: WHERE rctl.interface_line_attribute1 = p_order_number
173: AND rctl.interface_line_attribute2 = p_order_type_name
174: AND rctl.customer_trx_id = rct.customer_trx_id
175: AND rct.complete_flag = 'N';