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!

IN AP what is link b/w payment table to invoice table & checks table to holds table

Discussion in 'Oracle Apps Technical' started by sravan.kaurn, Sep 27, 2014.

  1. sravan.kaurn

    sravan.kaurn Active Member

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    100
    hi ,

    in AP module what is the link b/w payment table to invoice table & checks table to holds table, reply with ur answers

    thanks and regards,
    sravan
     
  2. nilesh.dudhane

    nilesh.dudhane Active Member

    Messages:
    42
    Likes Received:
    2
    Trophy Points:
    135
    Location:
    India
    Re: IN AP what is link b/w payment table to invoice table & checks table to holds tab

    Code (SQL):

    SELECT aia.*
    FROM
    ap_invoices_all aia,
    ap_invoice_payments_all aipa,
    ap_checks_all aca
    WHERE aca.check_id=aipa.check_id
    AND aipa.invoice_id=aia.invoice_id
     
     
  3. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Re: IN AP what is link b/w payment table to invoice table & checks table to holds tab

    Hi,

    Holds are applied against Invoices - invoice_id is the key to join.

    ap_holds_all.invoice_id = ap_invoices_all.invoice_id


    Regards,
    Yowan Cristo