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!

Need Query to get Ap Invoice Distribution amount with tax.

Discussion in 'Oracle Apps Technical' started by jagadekara, Nov 14, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    I need a query to display Ap invoice distribution amount with tax.

    I have 1 distribution Item line and 3 miscellaneous tax lines on that. So I need total amount in one line.
    Like that I have 2 Item lines and 3 miscellaneous tax lines belongs to first item line.
    So I need first dist amount with tax and second dist amount with out tax.

    Any help appreciated....
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    What is the line type of those TAX Lines in Distribution table ? Is it TAX only right ?
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi bharat,

    it's MISCELLANEOUS type.
     
  4. Akrishna

    Akrishna Active Member

    Messages:
    8
    Likes Received:
    1
    Trophy Points:
    85
    Hi ,

    Please Use jai_ap_match_inv_taxes table for payable taxes link it.
     
  5. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks Krishna,

    I got it now. For PO related invoices I used your table.

    For non PO Related tax I used JAI_AP_INVOICE_LINES table.

    So in both tables I joined with parent_invoice_line_number