AR Interface Table - Line Details

-- INTERFACE LINES DETAILS

 

SELECT hca.account_number act_no

     , hca.cust_account_id cust_id

     , hp.party_number party_no

     , hp.party_name

     , rila.INTERFACE_LINE_ATTRIBUTE4

     , rila.interface_line_attribute2 crris

     , rila.trx_number

     , rila.trx_date

     , rila.interface_line_id int_line_id

     , rila.org_id

     , rila.batch_source_name batch

     , rila.interface_line_id line_id

     , rila.interface_line_attribute1 attrib1

     , gl.NAME sob

     , rila.amount

     , rila.line_number

     , rila.quantity

     , rila.unit_selling_price

     , rila.memo_line_name

     , rila.last_update_date

     , rila.description

     , rila.*

     , '---> ERRORS'

     , riea.interface_line_id

     , riea.MESSAGE_TEXT

     , riea.invalid_value

  FROM ar.ra_interface_lines_all rila

     , ar.ar_receipt_methods arm

     , gl.gl_ledgers gl

     , apps.hz_cust_accounts hca

     , apps.hz_parties hp

     , ar.ra_interface_errors_all riea

 WHERE rila.receipt_method_id = arm.receipt_method_id(+)

   AND rila.set_of_books_id = gl.ledger_id(+)

   AND rila.orig_system_bill_customer_id = hca.cust_account_id

   AND hp.party_id = hca.party_id

   AND rila.interface_line_id = riea.interface_line_id(+)

   AND 1 = 1;