APPS.ARP_AUTO_ACCOUNTING dependencies on RA_INTERFACE_LINES_GT

Line 579: FOR c01_rec IN (select interface_line_id from ra_interface_lines_gt

575:
576: -- Since, we cannot derive the receivables account for a invoice,
577: -- we insert error for each invoice line.
578:
579: FOR c01_rec IN (select interface_line_id from ra_interface_lines_gt
580: WHERE customer_trx_id = -1 * p_interface_line_id
581: AND request_id = p_request_id ) LOOP
582: insert_into_error_table(
583: c01_rec.interface_line_id,

Line 2381: l_interface_lines_table := CRLF ||'ra_interface_lines_gt ril,';

2377: THEN
2378: /* 5921925 - modified gl_date logic for invoice API */
2379: IF p_request_id > 0
2380: THEN
2381: l_interface_lines_table := CRLF ||'ra_interface_lines_gt ril,';
2382: ELSE
2383: l_interface_lines_table := CRLF ||'ar_trx_header_gt ril,';
2384: END IF;
2385: END IF;

Line 2562: FROM ra_interface_lines_gt ril2

2558: REC distributions. This relates to bug 4483951, but the fix
2559: for that does not entirely resolve the problem */
2560: l_interface_table_pred := CRLF ||
2561: 'AND ril.rowid = (SELECT /*+ no_unnest */ min(ril2.rowid)
2562: FROM ra_interface_lines_gt ril2
2563: WHERE ril2.customer_trx_id = ct.customer_trx_id
2564: AND ril2.link_to_line_id is null)
2565: AND ril.customer_trx_id = ct.customer_trx_id ';
2566: