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

Oracle Fusion SQL Queries to get Sales Person/Sales Representative information for an Order

1) Get sales person details if the Sales Person ID is known SELECT  jrs.SALESREP_NUMBER  ,         jrs.status           ,         jrs.START_...