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