AP Views (236)

AP - Payables — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

ViewDescription
APBV_AP_HOLDS Business view
APBV_AP_INVOICES Business view
APBV_AP_INVOICE_DISTRIBUTIONS Business view
APBV_AP_PAYMENTS Business view
APBV_AP_PAYMENT_TERMS Business view
APBV_BANK_ACCOUNTS Business view
APBV_BANK_BRANCHES Business view
APBV_CARDS
APBV_CREDIT_CARD_TRXNS Based on AP_CREDIT_CARD_TRXNS_ALL, this business view contains credit card transaction data.
APBV_EXPENSE_REPORT_HEADERS
APBV_EXPENSE_REPORT_LINES
APBV_EXPENSE_REPORT_PARAMS
APBV_EXP_REPORT_DISTS
APBV_POL_VIOLATIONS Based on AP_POL_VIOLATIONS_ALL, this business view contains expense policy violation data.
APFV_AP_HOLDS Business view
APFV_AP_INVOICES Business view
APFV_AP_INVOICE_DISTRIBUTIONS Business view
APFV_AP_INVOICE_LINES Business View
APFV_AP_INVOICE_PAYMENTS Business view
APFV_AP_PAYMENTS Business view
APFV_AP_PAYMENT_TERMS Business view
APFV_BANK_ACCOUNTS Business view
APFV_BANK_BRANCHES Business view
APFV_EXPENSE_REPORTS Business view
APFV_PAYMENT_SCHEDULES Business view
AP_ACTIVE_EXPENSE_REPORTS_V Active Expense Reports in Oracle Internet Expenses is based on this view
AP_AEL_GL_INV_V
AP_AEL_GL_PAY_V
AP_AEL_SL_INV_V
AP_AEL_SL_PAY_V
AP_AEL_SL_V
AP_AE_HEADERS_V
AP_AE_LINES_V
AP_ALLOCATED_LINES_V
AP_ALLOCATION_RULES_V
AP_APPLICABLE_LINES_V
AP_APPLY_PREPAYS_FR_PREPAY_V
AP_APPLY_PREPAYS_V
AP_AUD_EXPENSE_HEADERS_SEC_V
AP_AUD_QUEUE_SUMMARIES_V
AP_AWT_BUCKETS_V (Release 10SC only)
AP_AWT_TEMP_DISTRIBUTIONS_V (Release 10SC only)
AP_BANK_ACCOUNT_USES_V (Release 10SC only)
AP_BANK_BRANCHES_V View of AP_BANK_BRANCHES used in report
AP_BANK_CHARGE_BEAERER_SRS_V
AP_BATCHES_V (Release 10SC only)
AP_CARDS_V - Retrofitted
AP_CARD_EXPENSE_TYPE_V
AP_CARD_NOTIFICATIONS_V This view insures that multiple notifications for the same open transactions are not received in WebExpenses.
AP_CARD_SUPPLIERS_V This view holds all the information relating to Supplier, Supplier Site and Credit Card. There is one row per combination in this view.
AP_CHARGES_V
AP_CHARGE_ALLOCATIONS_V
AP_CHECKS_ALL_MRC_V MULTI-ORG MRC view
AP_CHECKS_MRC_V SINGLE-ORG MRC view
AP_CHECKS_V
AP_CHECKS_WWW_V (Release 10SC only)
AP_CHECK_STOCKS_ACTIVE_V (Release 10SC only)
AP_CHECK_STOCKS_V (Release 10SC Only)
AP_DISTRIBUTION_SETS_DSN_V (Release 10SC Only)
AP_DISTRIBUTION_SET_LINES_V (Release 10SC Only)
AP_DIST_PREPAY_APPLICATION_V Internal view
AP_DOCUMENTS_PAYABLE
AP_DOCUMENT_LINES_V
AP_DUPLICATE_VENDORS_V (Release 10SC Only)
AP_ENCUMBRANCE_LINES_V
AP_ENC_GL_INV_V
AP_ENC_GL_PAY_V
AP_EXPENSE_FEED_DISTS_OPEN_V Verify Open Transactions in Self-Service Expenses is based on this view
AP_EXPENSE_FEED_DISTS_V View Transaction History in Self-Service Expenses is based on this view
AP_EXPENSE_FEED_LINES_V
AP_EXPENSE_REPORT_HEADERS_V Expense Report History in Oracle Internet Expenses is based on this view
AP_EXPENSE_REPORT_HISTORY_V Expense Report History in Oracle Internet Expenses is based on this view
AP_EXPENSE_REPORT_LINES_V View for all expense report lines that are ready for payment or have already been paid.
AP_EXPENSE_REPORT_STATUS_V
AP_EXPENSE_REPORT_VIOLATIONS_V View for all expense report violations and corresponding expense report lines that are ready for payment or have already been paid.
AP_EXPENSE_TYPES_V Value Set for Expense Types in Details page in Oracle Internet Expenses is based on this view.
AP_EXTRACT_INVOICE_DTLS_BC_V
AP_FND_DOCUMENT_SEQUENCES_QF_V This is created for using in find window in Invoice Workbench
AP_HOLDS_HOLD_NAME_V (Release 10SC Only)
AP_HOLDS_OVERVIEW_V (Release 10SC Only)
AP_HOLDS_RELEASE_NAME_V (Release 10SC Only)
AP_HOLDS_V
AP_HOLD_CODES_HOLD_NAME_V (Release 10SC Only)
AP_HOLD_CODES_V (Release 10SC Only)
AP_INTERFACE_REJECTIONS_V - Retrofitted
AP_INVOICES_ALL_MRC_V MULTI-ORG MRC view
AP_INVOICES_DERIVED_V (Release 10SC Only)
AP_INVOICES_INTERFACE_V
AP_INVOICES_MRC_V SINGLE-ORG MRC view
AP_INVOICES_READY_TO_PAY_V
AP_INVOICES_UNION_PREPAYS_V (Release 10SC Only)
AP_INVOICES_V
AP_INVOICES_WWW_V (Release 10SC Only)
AP_INVOICE_DISTRIBUTIONS_V
AP_INVOICE_DISTS_ALL_MRC_V MULTI-ORG MRC view
AP_INVOICE_DISTS_INQUIRY_V
AP_INVOICE_DISTS_MRC_V SINGLE-ORG MRC view
AP_INVOICE_EXTRACT_DETAILS_V
AP_INVOICE_EXTRACT_DETAILS_VL
AP_INVOICE_EXTRACT_HEADER_V
AP_INVOICE_IMPORT_REJECTION_V
AP_INVOICE_IMPORT_SOURCES_V
AP_INVOICE_LINES_INTERFACE_V
AP_INVOICE_LINES_V
AP_INVOICE_PAYMENTS_ALL_MRC_V MULTI-ORG MRC view
AP_INVOICE_PAYMENTS_MRC_V SINGLE-ORG MRC view
AP_INVOICE_PAYMENTS_V
AP_INVOICE_PAYMENTS_WWW_V (Release 10SC Only)
AP_INVOICE_PAYMENT_HISTORY_V
AP_INVOICE_PREPAYS_V (Release 10SC Only)
AP_INVOICE_PRICE_VAR_V
AP_INV_SELECTION_CRITERIA_V (Release 10SC Only)
AP_JE_CATEGORIES_V
AP_LC_INVOICE_TYPES_DB_V (Release 10SC Only)
AP_LC_INVOICE_TYPES_V (Release 10SC Only)
AP_LC_PAYMENT_METHODS_V (Release 10SC Only)
AP_LC_QUICK_RELEASES_V (Release 10SC Only)
AP_LOOKUP_CODES
AP_LOOKUP_TYPES
AP_MAP_TYPES_VL Mapping Rules
AP_MATCH_CORRECTION_DISTS_V
AP_OIE_ADJUSTMENT_REASONS_V
AP_OIE_AUDIT_REASONS_V
AP_OIE_AUDIT_TYPES_V
AP_OIE_AUD_RETURN_REASONS_V
AP_OIE_AUTO_AUDIT_REASONS_V
AP_OIE_CC_TRX_CATEGORIES_V
AP_OIE_CC_VALIDATION_ERROR_V
AP_OIE_EXPENSE_CATEGORY_V
AP_OIE_FUEL_TYPE_V
AP_OIE_POL_VIOLATION_TYPES_V
AP_OIE_TICKET_CLASS_V
AP_OIE_TRAVEL_TYPES_V
AP_OIE_VEHICLE_CATEGORY_V
AP_OIE_VEHICLE_TYPE_V
AP_OTHER_PERIODS_PN_V
AP_OTHER_PERIODS_V (Release 10SC Only)
AP_OTHER_PERIOD_TYPES_PT_V (Release 10SC Only)
AP_PAYMENT_EXTRACT_DETAILS_V
AP_PAYMENT_EXTRACT_DETAILS_VL
AP_PAYMENT_EXTRACT_HEADER_V
AP_PAYMENT_HISTORY_MRC_V SINGLE-ORG MRC view
AP_PAYMENT_HIST_ALL_MRC_V SINGLE-ORG MRC view
AP_PA_HEADER_REF_V
AP_PBATCH_SETS_V
AP_PBATCH_SET_LINES_V
AP_POL_LOCATIONS_V AP_POL_LOCATIONS_V is a Policy Compliance-specific view that provides multi-lingual support (MLS) for locations that you define for policy s
AP_POL_LOCATIONS_VL AP_POL_LOCATIONS_VL is a Policy Compliance-specific view that provides multi-lingual support (MLS) for locations that you define for policy
AP_POL_VIOLATIONS_V
AP_PO_CORRECTIONS_V
AP_PO_DETAILS_V
AP_PO_DISTRIBUTIONS_AP2_V - Retrofitted
AP_PO_HEADERS_EXTRACT_V
AP_PO_LINES_EXTRACT_V
AP_PO_SHIPMENTS_V This view shows PO shipment information to users who are entering invoices in Internet Supplier Portal
AP_PO_USRDEF_LOOKUP_CODES_V - Retrofitted
AP_PO_VENDORS_EXTRACT_V
AP_PO_VENDOR_SITES_EXTRACT_V
AP_PREPAYAPP_EXTRACT_DTLS_BC_V
AP_PREPAY_DEF_TAX_EXTRACT_V
AP_RECEIPT_CORRECTIONS_V
AP_RECEIPT_STATUS_V
AP_RECURRING_PAYMENTS_V
AP_SEC_V This view restricts the user to only view records defined in their security profile and organization profile.
AP_SHIPPING_NETWORK_LOCATIONS No Longer Used - MOAC
AP_SHIP_BILL_TO_LOCATIONS_V
AP_SLA_INVOICES_TRANSACTION_V
AP_SLA_PAYMENTS_TRANSACTION_V
AP_SOB_INFO_V
AP_SRS_ACCTG_CURR_V
AP_SRS_PAYEE_V
AP_SRS_REGION_NAMES_V This view provides a list of available tax regions for the 1099 Payments report.
AP_SRS_SOB_NAME_V - Retrofitted
AP_SYSTEM_PARAMETERS_EXTRACT_V
AP_SYSTEM_PARAMETERS_MRC_V SINGLE-ORG view
AP_SYSTEM_PARAMS_ALL_MRC_V MULTI-ORG MRC view
AP_TAX_CODES_ACTIVE_V (Release 10SC Only)
AP_TAX_CODES_NAMES_V (Release 10SC Only)
AP_TAX_CODES_TN_V (Release 10SC Only)
AP_TAX_CODES_V (Release 10SC Only)
AP_TAX_CODES_VAL_V (Release 10SC Only)
AP_TAX_LINES_SUMMARY_V
AP_TERMS_BAT_PAY_TERMS_V (Release 10SC Only)
AP_TERMS_V (Release 10SC Only)
AP_TERMS_VAL_V (Release 10SC Only)
AP_TERMS_VL
AP_TOLERANCES AP_TOLERANCE
AP_TRANSMISSION_CODES_V This view displays the transmission codes,bank names and associated branch names.
AP_TRIAL_BALANCE_MRC_V - Retrofitted
AP_UNAPPLY_PREPAYS_FR_PREPAY_V
AP_UNAPPLY_PREPAYS_V
AP_USERS_V
AP_VENDORS_V
AP_VENDOR_DISP_V (Release 10SC Only)
AP_VENDOR_SITES_V (Release 10SC Only)
AP_VIEW_PREPAYS_FR_PREPAY_V -Retrofitted
AP_VIEW_PREPAYS_V
AP_WEB_APPROVER_LOV_V Dummy view for override approver for Web Expenses interface
AP_WEB_DFLEX_LOV_V - Retrofitted
AP_WEB_EXP_TYPE_ITEM_V
AP_WEB_PA_PROJECTS_TASKS_V In Oracle Internet Expenses, both the view projects and Task Function and the Task Number List of Values are based on this view
AP_WEB_PA_PROJECTS_V The Project number list of values in Oracle Internet Expenses is based on this view
AP_WEB_PEOPLE_LOV_V View used for Overriding Approver LOV in Internet Expenses
AP_WEB_SIGNING_LIMITS_V Retrofitted
AP_WFAPPROVAL_HISTORY_V
AP_XML_BATCHLEVEL2_V
AP_XML_BATCHLEVEL_V
AP_XML_INVOICE2_LEVEL_V
AP_XML_PAYMENTACCOUNTLEVEL_V
AP_XML_PAYMENTLEVEL_V
AP_XML_PAYMENTLINE2_LEVEL_V
AP_ZX_DEF_TAX_EXTRACT_V
FINANCIALS_PURGES_V (Release 10SC Only)
FINANCIALS_SYSTEM_PARAMS_MRC_V - Retrofitted
FIN_SYSTEM_PARAMS_ALL_MRC_V - Retrofitted
FND_DOCUMENT_SEQUENCES_AP_V (Release 10SC Only)
FND_DOC_SEQ_CATEGORIES_AP_V (Release 10SC Only)
FND_ID_SEGMENT_NAME_AP_V (Release 10SC Only)
GL_JE_BATCHES_AP_V (Release 10SC Only)
OIE_ATTENDEES
OIE_MGR_RPT_V Reporting View for Expenses Management Reporting
OIE_SRS_CARD_NUMBER_V
PA_EXPENDITURE_TYPES_AP_V (Release 10SC Only)
PA_PROJECTS_AP_V (Release 10SC Only)
PA_PROJECT_TASKS_AP_V (Release 10SC Only)
PA_TASKS_AP_V (Release 10SC Only)
PO_AP_RECEIPT_MATCH_V
PO_VENDORS
PO_VENDORS_ACTIVE_AP_V
PO_VENDORS_ALL_V (Release 10SC Only)
PO_VENDORS_AP_V
PO_VENDOR_CONTACTS
PO_VENDOR_SITES_ALL
PO_VENDOR_SITES_ALL_V (Release 10SC Only)
PO_VENDOR_SITES_AP_V
PO_VENDOR_SITES_PAY_AP_V