Friday, January 14, 2022

IBY_EXTERNAL_PAYEES_ALL

This table captures Payment related details of the Supplier. For Example: The Supplier's remittance advice, the default Payment method Code for this supplier or the bank charges in case of SWIFT payments, etc. This information can be setup at Supplier Level or  Supplier Site Level.

SELECT iepa.* 
  FROM iby_external_payees_all iepa 
 WHERE iepa.payee_party_id = 123456
at
Labels:

1 comment:

Subscribe to: Post Comments (Atom)

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...