APPS.ARP_GROUP_INV dependencies on RA_INTERFACE_LINES_GT

Line 550: FROM ra_interface_lines_gt l

546: SELECT l.interface_line_id,
547: l_message_text,
548: l.cons_billing_number,
549: l.org_id
550: FROM ra_interface_lines_gt l
551: WHERE l.request_id = p_request_id
552: AND l.cons_billing_number IS NOT NULL
553: AND nvl(l.interface_status,'~') <> 'P'
554: AND l.link_to_line_id is null

Line 558: FROM ra_interface_errors e, ra_interface_lines_gt l2

554: AND l.link_to_line_id is null
555: AND l.customer_trx_id is not null
556: AND EXISTS
557: ( SELECT /*+ leading(L2) use_nl_with_index(E, RA_INTERFACE_ERRORS_N1) */ 'x'
558: FROM ra_interface_errors e, ra_interface_lines_gt l2
559: WHERE e.INTERFACE_LINE_ID = l2.INTERFACE_LINE_ID
560: AND l2.cons_billing_number = l.cons_billing_number
561: AND l2.request_id = l.request_id );
562: