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'
No comments:
Post a Comment