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!

Link between PA_DRAFT_INVOICES_ALL and PA_DRAFT_REVENUES_ALL

Discussion in 'Oracle Apps Technical' started by jagadekara, Oct 3, 2013.

  1. jagadekara

    jagadekara Forum Guru

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

    I need the link between PA_DRAFT_INVOICES_ALL and PA_DRAFT_REVENUES_ALL.

    Thanks in advance...
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    You can use project_id to link them.
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Bharat,
    Thanks for your reply. But i already used project_id but getting duplicate rows. So I need some more join condition between these tables.