Monday 2 September 2024

AP Invoice Notes related Table details in Oracle Fusion

 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

AP Invoice Notes related Table details in Oracle Fusion

 What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...