What is the table that stores the AP Invoice notes?
AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOICE' and SOURCE_OBJECT_UID being the invoice_id of the payables invoice.
Query :
select
zn.note_txt
from
ap_invoices_all aia,
zmm_notes zn
where
invoice_num=:P_Invoice_Num
and zn.SOURCE_OBJECT_UID =aia.invoice_id
and zn.SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOICE'
--and zn.ATTRIBUTE_CATEGORY='GENERAL'
I appreciate the effort you put into creating this article. The content is clear, informative, and presented in an engaging manner. It is refreshing to read a post that focuses on useful information instead of unnecessary filler. Great work and keep writing! Madhuri Chart
ReplyDeleteMadhuri Panel Chart
Mumbai Mail Chart
Thank you for sharing this useful information
ReplyDeleteBuild practical Oracle skills with Oracle online training covering SQL, PL/SQL, Oracle Database, and DBA concepts. Learn with expert guidance, hands-on practice, and career-focused training. Call +91 8179191999.
Best blog for Oracle Students and Freshers👇👇👇
What Is Oracle? A Complete Beginner’s Guide for Students and Freshers in 2026–27