1) Payment Method Code at Supplier Level 1 2 3 4 5 6 7 8 9 10 11 12 13 SELECT supp.segment1 supplier_num, paym.payment_method_code FROM ap_suppliers supp, iby_external_payees_all payee, iby_ext_party_pmt_mthds paym WHERE supp.party_id = […]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 […]
In Oracle EBS R12 supplier web page, there are Address Book and Contact Directory that contain phone, fax and email information. A) To gather phone, fax, and email in Address Book we can use this […]
To find the tables involved in storing the Payment Data related to the Payable INVOICE ( Invoice_id = 166014 ). All the queries given in this post and their related posts were tested in R12.1.1 Instance. […]
To check the Payment Data related to the Payable INVOICE ( Invoice_id = 166014 ) in Sub-Ledger Accounting (XLA). All the queries given in this post and their related posts were tested in R12.1.1 Instance. XLA_EVENTS […]
We will find the tables involved in storing the Reconciliation and Currency Data related to the Payable INVOICE ( Invoice_id = 166014 ). All the queries given in this post and their related posts were tested in […]
We will find a query which fetches both invoice and prepayment information of a payable invoice ( Invoice_id = 166014 ). All the queries given in this post and their related posts were tested in […]
We will check the Data related to the Payable INVOICE ( Invoice_id = 166014 ) in Sub-Ledger Accounting (XLA). All the queries given in this post and their related posts were tested in R12.1.1 Instance. XLA_EVENTS SELECT DISTINCT xe.* […]
Tables involved in storing the Data related to an PAYABLE INVOICE ( Invoice_id = 166014 ) in various modules of Oracle Apps R12. All the queries given in this post and their related posts were tested in […]
Payment Process Requests Overview Under Funds disbursement page, users can submit Payment Process Requests (PPR) to generate payments. There is an option to submit a single Payment Process Request or schedule Payment Process Requests. There […]
Enterprise Resource Planning and Integrations BlogSpot 