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

No comments:

Post a Comment

Post a Comment