Thursday, 26 December 2013

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;

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete