1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to get GL_TRANSFER_STATUS for INVOICE_ID IN R12

Discussion in 'Oracle Apps Technical' started by ekramulhoda, Dec 10, 2012.

  1. ekramulhoda

    ekramulhoda Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Hi Every Body,

    I want to get GL_TRANSFER_STATUS of a invoice In R12.

    I mean i want a sql which will be giving me gl_transfer_status of invoice_id

    Regards and Thanks,
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi to get GL Transfer Status in R12 Check the following Query....

    Code (SQL):
    SELECT aia.invoice_id
          ,aia.invoice_num
          ,SUM(aid.amount) invoice_amount
          ,xah.gl_transfer_status_code
      FROM ap_invoices_all aia
          ,ap_invoice_distributions_all aid
          ,xla_events xe
          ,xla_ae_headers xah
     WHERE aia.invoice_id=aid.invoice_id
       AND aid.accounting_event_id=xe.event_id
       AND xah.entity_id=xe.entity_id
       AND aia.org_id=:P_ORG_ID
       AND aia.invoice_num=:P_INV_NUM
    GROUP BY aia.invoice_id
          ,aia.invoice_num
          ,xah.gl_transfer_status_code
     
    Ecor likes this.