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.JL_AR_AUTOINV_PKG dependencies on RA_INTERFACE_LINES

Line 39: FROM ra_interface_lines

35: orig_system_bill_address_id) orig_system_address_id,
36: batch_source_name,
37: trx_date,
38: org_id
39: FROM ra_interface_lines
40: WHERE nvl(interface_status, '~') <> 'P'
41: AND ((nvl(trx_date,sysdate-1) BETWEEN
42: nvl(p_invoice_date_from,nvl(trx_date,sysdate)) AND
43: nvl(p_invoice_date_to, nvl(trx_date,sysdate)))

Line 310: UPDATE ra_interface_lines

306:
307: END;
308:
309: IF nvl(l_new_batch_source_name,trx_lines_rec.batch_source_name) <> trx_lines_rec.batch_source_name THEN
310: UPDATE ra_interface_lines
311: SET batch_source_name = l_new_batch_source_name
312: WHERE rowid = trx_lines_rec.rowid;
313: INSERT INTO RA_INTERFACE_ERRORS(INTERFACE_LINE_ID, MESSAGE_TEXT, INVALID_VALUE, ORG_ID)
314: VALUES(trx_lines_rec.interface_line_attribute1,

Line 405: p_low_trans_number IN ra_interface_lines.trx_number%TYPE,

401: p_low_gl_date IN VARCHAR2 ,
402: p_high_gl_date IN VARCHAR2 ,
403: p_low_ship_date IN VARCHAR2,
404: p_high_ship_date IN VARCHAR2,
405: p_low_trans_number IN ra_interface_lines.trx_number%TYPE,
406: p_high_trans_number IN ra_interface_lines.trx_number%TYPE ,
407: p_low_sales_order_num IN ra_interface_lines.sales_order%TYPE ,
408: p_high_sales_order_num IN ra_interface_lines.sales_order%TYPE,
409: p_low_invoice_date IN VARCHAR2 ,

Line 406: p_high_trans_number IN ra_interface_lines.trx_number%TYPE ,

402: p_high_gl_date IN VARCHAR2 ,
403: p_low_ship_date IN VARCHAR2,
404: p_high_ship_date IN VARCHAR2,
405: p_low_trans_number IN ra_interface_lines.trx_number%TYPE,
406: p_high_trans_number IN ra_interface_lines.trx_number%TYPE ,
407: p_low_sales_order_num IN ra_interface_lines.sales_order%TYPE ,
408: p_high_sales_order_num IN ra_interface_lines.sales_order%TYPE,
409: p_low_invoice_date IN VARCHAR2 ,
410: p_high_invoice_date IN VARCHAR2 ,

Line 407: p_low_sales_order_num IN ra_interface_lines.sales_order%TYPE ,

403: p_low_ship_date IN VARCHAR2,
404: p_high_ship_date IN VARCHAR2,
405: p_low_trans_number IN ra_interface_lines.trx_number%TYPE,
406: p_high_trans_number IN ra_interface_lines.trx_number%TYPE ,
407: p_low_sales_order_num IN ra_interface_lines.sales_order%TYPE ,
408: p_high_sales_order_num IN ra_interface_lines.sales_order%TYPE,
409: p_low_invoice_date IN VARCHAR2 ,
410: p_high_invoice_date IN VARCHAR2 ,
411: p_low_ship_to_cust_num IN hz_cust_accounts.account_number%TYPE ,

Line 408: p_high_sales_order_num IN ra_interface_lines.sales_order%TYPE,

404: p_high_ship_date IN VARCHAR2,
405: p_low_trans_number IN ra_interface_lines.trx_number%TYPE,
406: p_high_trans_number IN ra_interface_lines.trx_number%TYPE ,
407: p_low_sales_order_num IN ra_interface_lines.sales_order%TYPE ,
408: p_high_sales_order_num IN ra_interface_lines.sales_order%TYPE,
409: p_low_invoice_date IN VARCHAR2 ,
410: p_high_invoice_date IN VARCHAR2 ,
411: p_low_ship_to_cust_num IN hz_cust_accounts.account_number%TYPE ,
412: p_high_ship_to_cust_num IN hz_cust_accounts.account_number%TYPE ,