2 Replies Latest reply: Jun 20, 2014 5:03 AM by 1498181 RSS

    how can i get the exact values of invoice status and accounted in my query?

    1498181

      Hi,

       

      I need to get values of invoice status and accounted fields in my query. there are no columns which are getting these values but functions instead.

      apps.AP_INVOICES_PKG.GET_POSTING_STATUS(invoice_id)

      AND

      APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS(invoice_id,invoice_amount,payment_status_flag,invoice_type_lookup_code)

       

      But these functions return values are not the same as shown on invoice Form.