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.FUN_TRX_TYPES_PUB dependencies on RA_CUST_TRX_TYPES_ALL

Line 155: RA_CUST_TRX_TYPES_ALL ar,

151: ar.cust_trx_type_id,
152: ar.name ,
153: Nvl(ar.default_term, 4)
154: FROM FUN_TRX_TYPE_AR_MAPS tm,
155: RA_CUST_TRX_TYPES_ALL ar,
156: AR_MEMO_LINES_ALL_VL m
157: WHERE tm.trx_type_id = p_trx_type_id AND
158: tm.org_id = p_org_id AND
159: tm.ar_trx_type_id = ar.cust_trx_type_id AND

Line 174: RA_CUST_TRX_TYPES_ALL ar,

170: ar.cust_trx_type_id,
171: ar.name,
172: 4 default_term_id
173: FROM fun_system_options fun,
174: RA_CUST_TRX_TYPES_ALL ar,
175: AR_MEMO_LINES_ALL_VL m
176: WHERE fun.default_memo_line_id = m.memo_line_id
177: AND fun.default_ar_trx_type_id = ar.cust_trx_type_id
178: AND ar.org_id = m.org_id

Line 237: RA_CUST_TRX_TYPES_ALL ar

233: p_trx_date DATE)
234: IS
235: SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
236: FROM FUN_TRX_TYPE_AR_MAPS tm,
237: RA_CUST_TRX_TYPES_ALL ar
238: WHERE tm.trx_type_id = p_trx_type_id AND
239: tm.org_id = p_org_id AND
240: tm.org_id = ar.org_id AND
241: tm.ar_trx_type_id = ar.cust_trx_type_id AND

Line 249: RA_CUST_TRX_TYPES_ALL ar

245: p_trx_date DATE)
246: IS
247: SELECT decode(ar.creation_sign,'P',+1,'N',-1,'A',0)
248: FROM fun_system_options fun,
249: RA_CUST_TRX_TYPES_ALL ar
250: WHERE fun.default_ar_trx_type_id = ar.cust_trx_type_id
251: AND ar.org_id = p_org_id
252: AND p_trx_date BETWEEN Nvl(ar.start_date,p_trx_date) AND Nvl(ar.end_date, p_trx_date);
253: