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 2363: l_interface_lines_table := CRLF ||'ra_interface_lines_gt ril,';

2359: THEN
2360: /* 5921925 - modified gl_date logic for invoice API */
2361: IF p_request_id > 0
2362: THEN
2363: l_interface_lines_table := CRLF ||'ra_interface_lines_gt ril,';
2364: ELSE
2365: l_interface_lines_table := CRLF ||'ar_trx_header_gt ril,';
2366: END IF;
2367: END IF;

Line 2544: FROM ra_interface_lines_gt ril2

2540: REC distributions. This relates to bug 4483951, but the fix
2541: for that does not entirely resolve the problem */
2542: l_interface_table_pred := CRLF ||
2543: 'AND ril.rowid = (SELECT /*+ no_unnest */ min(ril2.rowid)
2544: FROM ra_interface_lines_gt ril2
2545: WHERE ril2.customer_trx_id = ct.customer_trx_id
2546: AND ril2.link_to_line_id is null)
2547: AND ril.customer_trx_id = ct.customer_trx_id ';
2548: