My Portfolio

Here is reference note for API table definitions based out of my for previous article for   Oracle API Availability -Oracle Assets (FA) . FA_ACE_BOOKS FA_ACE_BOOKS, the ACE conversion table, is organized into the following columns which store ACE information: FA_BUDGET_INTERFACE FA_BUDGET_INTERFACE, the budget interface table, is organized into columns in which Oracle Assets stores budget information. FA_INV_INTERFACE To use the Physical Inventory feature in Oracle Assets, you must load physical inventory data that you have collected into the FA_INV_INTERFACE table in Oracle Assets. FA_PRODUCTION_INTERFACE FA_PRODUCTION_INTERFACE, the production interface table, is organized into columns in which Oracle Assets stores production information. Enter values for the following required columns Name   Null?   Type ASSET_NUMBER NOT NULL VARCHAR2(30) PRODUCTION NOT NULL NUMBER START_DATE NOT NULL DATE END_DATE NOT NULL DATE

In this post, we will 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.  AP_TERMS SELECT   * FROM    AP_TERMS WHERE   term_id  IN         (   SELECT   DISTINCT  terms_id             FROM    AP_INVOICES_ALL               WHERE   invoice_id  =   '166014'         );          AP_TERMS_LINES   SELECT   * FROM    AP_TERMS_LINES WHERE   term_id  IN         (   SELECT   DISTINCT  terms_id      ...