Results for “assets_addition_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APFV_AP_INVOICE_PAYMENTS is a business view owned by the APPS schema within the Oracle Payables (AP) product. Registered in ETRM with the description "Business view," it exposes the association between invoices and their payments as recorded in Oracle E-Business Suite. Each row represents one invoice payment record — the link between a specific invoice and a specific payment — enriched with denormalized attributes drawn from the related invoice, payment (check), and set of books records. Unlike an operational form or a base table accessed directly by concurrent programs, this view is intended for reporting, inquiry, and integration scenarios where a flattened, human-readable projection of the invoice-to-payment relationship is required.
Underlying Base Objects
The view text is defined over five documented base objects referenced through APPS synonyms: AP_INVOICE_PAYMENTS, AP_CHECKS_ALL, AP_INVOICES_ALL, AP_PAYMENT_SCHEDULES_ALL, and the GL_SETS_OF_BOOKS view. AP_INVOICE_PAYMENTS (aliased as AIP) supplies the driving rows and the core payment-against-invoice attributes. AP_CHECKS_ALL (aliased as AC) supplies the payment instrument attributes, including the check number, check date, check amount, currency, and the bank account name. AP_INVOICES_ALL (aliased as AI) contributes invoice header information such as invoice number, invoice date, invoice amount, amount paid, and description. AP_PAYMENT_SCHEDULES_ALL (aliased as APS) is referenced for identifiers such as the external bank account. GL_SETS_OF_BOOKS provides the set of books name through GSOB.NAME. The view text also carries UNIQUE ATTRIBUTES and REGULAR ATTRIBUTES annotations, a pattern typical of Oracle ETRM-designated business views, and embeds lookup resolution directives (for example, resolving INVOICE_PAYMENT_TYPE and CHECK_TYPE against AP_LOOKUP_CODES).
Key Columns
- BANK_ACCOUNT_TYPE / BANK_ACCOUNT_NUMBER / BANK_NUMBER — sourced from AIP; the bank account type is the attribute most directly relevant to the user's search term "bank_account_type," representing the type of the disbursement bank account associated with the payment.
- PAYMENT_NUMBER, INVOICE_PAYMENT_TYPE, PAYMENT_TYPE — identifiers and translated lookup descriptions describing the nature of the payment relationship.
- AMOUNT, INVOICE_BASE_AMOUNT, PAYMENT_BASE_AMOUNT, DISCOUNT_TAKEN, DISCOUNT_LOST — monetary attributes expressed in both transaction and base currency terms.
- CHECK_NUMBER, CHECK_DATE, CHECK_AMOUNT, CHECK_CURRENCY_CODE, CHECK_TYPE, CHECK_STATUS — resoled from AP_CHECKS_ALL, giving the payment instrument details.
- INVOICE_NUMBER, INVOICE_DATE, INVOICE_AMOUNT, AMOUNT_PAID, DESCRIPTION — resolved from AP_INVOICES_ALL.
- SET_OF_BOOKS_NAME — resolved from GL_SETS_OF_BOOKS for ledger-level reporting.
- ID columns — EXTERNAL_BANK_ACCOUNT_ID, APS_EXTERNAL_BANK_ACCOUNT_ID, ACCTS_PAY_CODE_COMBINATION_ID, ASSET_CODE_COMBINATION_ID, CHECK_ID, GAIN_CODE_COMBINATION_ID, INVOICE_PAYMENT_ID — supporting joins and drilldowns.
Common Use Cases and Queries
Typical scenarios include reconciling invoice payments to checks, listing payments by bank account type, auditing discount activity, and feeding downstream reporting where a single flattened row per invoice-payment pairing is preferable to multi-table joins. A representative query using the searched attribute is:
SELECT INVOICE_NUMBER, PAYMENT_NUMBER, BANK_ACCOUNT_NUMBER, BANK_ACCOUNT_TYPE, CHECK_NUMBER, CHECK_DATE, AMOUNT FROM APPS.APFV_AP_INVOICE_PAYMENTS WHERE BANK_ACCOUNT_TYPE = :p_type;SELECT INVOICE_NUMBER, PAYMENT_NUMBER, CHECK_STATUS, CHECK_AMOUNT, SET_OF_BOOKS_NAME FROM APPS.APFV_AP_INVOICE_PAYMENTS WHERE CHECK_DATE BETWEEN :from_date AND :to_date;
Because the view resolves lookups and foreign keys internally, report authors avoid writing their own joins to AP_LOOKUP_CODES, AP_CHECKS_ALL, and AP_INVOICES_ALL, reducing maintenance overhead and keeping reporting logic consistent with Oracle's delivered metadata.
-
Business view
APPS.APFV_AP_INVOICE_PAYMENTS·↳ AP_CHECKS_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS·Explore AP module →
-
Business view
APPS.APFV_AP_INVOICE_PAYMENTS·↳ AP_CHECKS_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS·Explore AP module →
-
Displays records of invoice payments coupled with CIS Payment Voucher details.
APPS.IGI_CIS_INVOICE_PAYMENTS·↳ AP_INVOICE_PAYMENTS·↳ IGI_CIS_PAYMENT_VOUCHERS·Explore IGI module →
-
Displays records of invoice payments coupled with CIS Payment Voucher details.
APPS.IGI_CIS_INVOICE_PAYMENTS·↳ AP_INVOICE_PAYMENTS·↳ IGI_CIS_PAYMENT_VOUCHERS·Explore IGI module →
-
View: AP_INVOICE_PAYMENTS_V 12.2.2
APPS.AP_INVOICE_PAYMENTS_V·↳ AP_CHECKS_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS·Explore AP module →
-
View: AP_INVOICE_PAYMENTS_V 12.1.1
APPS.AP_INVOICE_PAYMENTS_V·↳ AP_CHECKS_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS·Explore AP module →
-
APPS.AP_INVOICE_DISTS_INQUIRY_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES·↳ AP_INCOME_TAX_REGIONS·Explore AP module →
-
APPS.AP_INVOICE_DISTS_INQUIRY_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES·↳ AP_INCOME_TAX_REGIONS·Explore AP module →
-
APPS.AP_INVOICE_DISTRIBUTIONS_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES_ALL·↳ AP_INCOME_TAX_REGIONS·Explore AP module →
-
View: FII_AP_INV_PAYMTS_FCV 12.1.1
Internal view used for warehouse data extraction.
APPS.FII_AP_INV_PAYMTS_FCV·↳ EDW_CURRENCY·↳ FIIBV_AP_INV_PAYMTS_FCV·↳ FII_FLEX_MAPPING·Explore FII module →
-
Copy of AP_INVOICE_DISTRIBUTIONS and two more columns for investment tax
-
View of project-related invoice distributions in AP
APPS.PA_TRANSFER_AP_INVOICES_VIEW·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS·↳ AP_SYSTEM_PARAMETERS·Explore PA module →
-
View of project-related invoice distributions in AP for NL
APPS.PA_NL_TRANSFER_AP_INV_VIEW·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ MTL_SYSTEM_ITEMS·↳ PO_DISTRIBUTIONS·Explore PA module →
-
View of project-related invoice distributions in AP for NL
APPS.PA_NL_TRANSFER_AP_INV_VIEW·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ MTL_SYSTEM_ITEMS·↳ PO_DISTRIBUTIONS·Explore PA module →
-
View of project-related invoice distributions in AP
APPS.PA_TRANSFER_AP_INVOICES_VIEW·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS·↳ AP_SELF_ASSESSED_TAX_DIST·Explore PA module →
-
Invoice payment records
-
Invoice payment records
-
Invoice distribution line information
-
APPS.AP_INVOICE_DISTRIBUTIONS_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES_ALL·↳ AP_INCOME_TAX_REGIONS·Explore AP module →
-
None. Internal Table.
APPS.FIIBV_AP_INV_PAYMTS_FCV·↳ AP_CHECKS_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS_ALL·Explore FII module →
-
Interface table for AP invoice payments fact.
-
ap_self_assessed_tax_dist contains self assessed tax distributions
-
Copy of AP_INVOICE_DISTRIBUTIONS and two more columns for investment tax
-
Invoice distribution line information
-
Used in the table handler for inserting records into IGI_INVOICE_DISTRIBUTIONS_ALL.
APPS.IGI_INVOICE_DISTRIBUTIONS_V·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ IGI_INVOICE_DISTRIBUTIONS·Explore IGI module →
-
Used in the table handler for inserting records into IGI_INVOICE_DISTRIBUTIONS_ALL.
APPS.IGI_INVOICE_DISTRIBUTIONS_V·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ IGI_INVOICE_DISTRIBUTIONS·Explore IGI module →
-
Table: FII_AP_INV_PAYMTS_F 12.1.1
AP invoice payments fact table
-
ap_self_assessed_tax_dist contains self assessed tax distributions
-
MULTI-ORG MRC view
Not implemented in this database·Explore AP module →
-
MULTI-ORG MRC view
Not implemented in this database·Explore AP module →
-
VIEW: AP.JE_NO_INVEST_LINES# 12.2.2
-
SINGLE-ORG MRC view
Not implemented in this database·Explore AP module →
-
SINGLE-ORG MRC view
Not implemented in this database·Explore AP module →
-
View: FII_AP_INV_PAYMTS_FCV 12.2.2
Internal view used for warehouse data extraction.
Not implemented in this database·Explore FII module →