Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple.
Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 20 Vote(s) - 3.8 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need exact values of invoice status and accounted in query?
One of my clients required getting values of invoice status and accounted fields, the query which is used; there are no columns which are getting these values but functions instead.
And other is
These functions return values are not the same as shown on invoice Form, m too much confused how can handle it.

Thanks given by:
For invoice validation status, check this query, it will be helpfull
select ( decode ( apps.ap_invoices_pkg.get_approval_status
), 'FULL', 'Fully Applied', 'UNAPPROVED', 'Unvalidated',
'NEEDS REAPPROVAL', 'Needs Revalidation', 'APPROVED', 'Validated',
'NEVER APPROVED', 'Never Validated', 'CANCELLED', 'Cancelled', 'UNPAID', 'Unpaid', 'AVAILABLE', 'Available')) invoice_status
from ap_invoices_all l
where l.INVOICE_NUM = 'XXX'

Thanks given by:

Possibly Related Threads...
Thread Author Replies Views Last Post
  Invoice having too many lines in AP r12 Harish Duleep 2 1,322 09-26-2015, 02:11 PM
Last Post: rajagopal_23
  Different payment method for one invoice Rubab Ali 2 1,497 04-26-2015, 08:48 PM
Last Post: Hassan Habib
  Single payment for multiple invoice under same supplier R.V.Kumar 1 4,179 04-15-2015, 04:22 PM
Last Post: Ambarish
  How we can bring AP Invoice attachments through the FA Mass Additions Process in R12 Saleem Akhtar 1 1,613 03-23-2015, 07:40 PM
Last Post: ajkhan80
  How can we update the invoice number in AP Harish Duleep 1 1,258 02-23-2015, 08:22 PM
Last Post: ajkhan80
  How to create AP invoice for Delivered Quantity Santosh 1 1,090 02-18-2015, 09:12 PM
Last Post: ajkhan80
  How t query AR on Account Receipts Mukhtar Ali 1 2,411 02-01-2015, 08:03 PM
Last Post: Gopal Ayog
  Hold “no payee bank a/c” for invoice with Electronic payment method Anumeha Manish 1 983 01-18-2015, 08:12 PM
Last Post: ajkhan80
  How can check delay invoice listing Joseph George 1 919 01-14-2015, 06:06 PM
Last Post: Divya Omkar
  Invoice status “Needs Revalidation” Rachel Hannah 2 6,600 01-06-2015, 03:59 PM
Last Post: mramadhani

Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!