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'


2 comments:

  1. 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
    Madhuri Panel Chart
    Mumbai Mail Chart

    ReplyDelete
  2. Thank you for sharing this useful information

    Build 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

    ReplyDelete

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_...