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!

SQL Query - AP Invoice/Payment and SLA - URGENT HELP PLEASE!!

Discussion in 'Oracle Apps Technical' started by vchandra, Dec 16, 2010.

  1. vchandra

    vchandra Guest

    Friends!! I am looking for an SQL query (on R12) to pull all Invoice and Payment Details. It should atleast contain the following:

    Data Source
    A/P Check Number
    Purchase Order Number
    PO Line Item Number
    Supplier Number
    G/L Code (Distribution)
    G/L Code (SLA)
    Payment Date
    Payment Amount
    Currency Code
    Invoice Number
    Invoice Date
    Invoice Description

    Can you please help??? The key is that it should be the flattened detail (Cartesian Product - Header, Line and Distribution ) of invoice and payment detail and the GL account that is hit at the distribution level in AP and GL/Account that is hit in SLA including payment information?
  2. kiran.marla

    kiran.marla Forum Genius

    Likes Received:
    Trophy Points:
    Have you tried earlier. If yes, submit your query here, we can make corrections for it.