Monday, 5 September 2011

Query for the Invoice Number(AP) Which are not Transfer to GL Done in SONA

1st  Method:


SELECT  DISTINCT
              b.invoice_id,
              b.invoice_num,
              b.invoice_date,
              b.gl_date,
              b.invoice_currency_code,
              b.invoice_amount,
              b.invoice_type_lookup_code,
              a.period_name,
              a.dist_code_combination_id  
FROM    ap_invoice_distributions_all a,
               ap_invoices_all b
WHERE   a.invoice_id = b.invoice_id
AND         b.invoice_date BETWEEN  '1-AUG-2011' AND  '31-AUG-2011'
AND       a.posted_flag = 'N'
AND         b.org_id = 246

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete