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 OraERP.com 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, Simple and Absolutely Free.
Oracle Training

Thread Rating:
  • 17 Vote(s) - 3.82 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need exact values of invoice status and accounted in query?
#1
Hello,
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.
apps.AP_INVOICES_PKG.GET_POSTING_STATUS(invoice_id)
And other is
APPS.AP_INVOICES_PKG.GET_APPROVAL_STATUS(invoice_id,invoice_amount,payment_status_flag,invoice_type_lookup_code)
These functions return values are not the same as shown on invoice Form, m too much confused how can handle it.

Thanks,
Chakra
Reply
Thanks given by:
#2
Hi,
For invoice validation status, check this query, it will be helpfull
select ( decode ( apps.ap_invoices_pkg.get_approval_status
(invoice_id,
invoice_amount,
payment_status_flag,
invoice_type_lookup_code
), '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'

Regards,
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  Invoice having too many lines in AP r12 Harish Duleep 2 1,046 09-26-2015, 02:11 PM
Last Post: rajagopal_23
  Different payment method for one invoice Rubab Ali 2 1,242 04-26-2015, 08:48 PM
Last Post: Hassan Habib
  Single payment for multiple invoice under same supplier R.V.Kumar 1 3,995 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,187 03-23-2015, 07:40 PM
Last Post: ajkhan80
  How can we update the invoice number in AP Harish Duleep 1 1,015 02-23-2015, 08:22 PM
Last Post: ajkhan80
  How to create AP invoice for Delivered Quantity Santosh 1 884 02-18-2015, 09:12 PM
Last Post: ajkhan80
  How t query AR on Account Receipts Mukhtar Ali 1 1,711 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 851 01-18-2015, 08:12 PM
Last Post: ajkhan80
  How can check delay invoice listing Joseph George 1 781 01-14-2015, 06:06 PM
Last Post: Divya Omkar
  Invoice status “Needs Revalidation” Rachel Hannah 2 5,348 01-06-2015, 03:59 PM
Last Post: mramadhani



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