Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    MAK
    Query to connect AP invoice lines with Line approvalsAnswered
    Topic posted October 25, 2019 by MAK, last edited October 25, 2019, tagged Payables 
    29 Views, 1 Comment
    Title:
    Query to connect AP invoice lines with Line approvals
    Summary:
    Query to connect AP invoice lines with Line approvals
    Content:

    Hi,

    I am trying to create a query to list the invoice line and line level approvals.. I am not able to find the line level link in AP_INV_APRVL_HIST_ALL .. It lists all the approvals for all the lines.

    Any help is appreciated and I thank you in advance..

    Regards,

     

    Best Comment

    Sudhakara Rao Kovuru

    Try to connect with line_number then you may get it....

    AP_INV_APRVL_HIST_ALL             -- INVOICE_ID, LINE_NUMBER  

    AP_INVOICES_ALL                         --INVOICE_ID
    AP_INVOICE_LINES_ALL            -- INVOICE_ID, LINE_NUMBER   

    Comment

     

    • Sudhakara Rao Kovuru

      Try to connect with line_number then you may get it....

      AP_INV_APRVL_HIST_ALL             -- INVOICE_ID, LINE_NUMBER  

      AP_INVOICES_ALL                         --INVOICE_ID
      AP_INVOICE_LINES_ALL            -- INVOICE_ID, LINE_NUMBER