Results for “ap_payments”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.JG_ZZ_AP_CONTRA_V is a globalization (JG) reporting view in Oracle E-Business Suite that presents contra-entry accounting line detail for Payables transactions, with specific tailoring for the AP_PAYMENTS event entity. The view consolidates subledger accounting data held in the XLA schema (XLA_AE_HEADERS, XLA_AE_LINES, XLA_EVENTS, XLA_TRANSACTION_ENTITIES) with a Payables staging table (JG_ZZ_AP_TMP_ACCOUNT) and enriches it with general ledger account information from GL_CODE_COMBINATIONS and tax rate names from ZX_RATES_VL. It is principally used in the context of country-specific localization reporting for Payables, where contra accounts, tax lines, and accounting class details must be presented in a statutory or reconciliation format. Because it is a view rather than a table, it exposes no stored data of its own; it is a queryable projection intended for reporting, extraction, and diagnostic purposes rather than for transactional updates.
Underlying Base Objects
The view is defined over the following documented objects:
- JG_ZZ_AP_TMP_ACCOUNT — a Payables temporary/staging table holding accounting line attributes such as set of books, accounting event, code combination, line number, line type field, account, and account description.
- XLA_AE_HEADERS — subledger accounting event headers, filtered to
application_id = 200(Payables), joined on ledger and event. - XLA_AE_LINES — subledger accounting lines, filtered to
application_id = 200, joined on AE header and AE line number. - XLA_EVENTS and XLA_TRANSACTION_ENTITIES — joined to derive ledger and entity code, filtered to
application_id = 200. - GL_CODE_COMBINATIONS — used to obtain account type (for example, liability) and to determine how certain columns are populated.
- ZX_RATES_VL — the tax rate view, outer-joined on tax rate ID to supply the tax rate name.
Key Columns
- SET_OF_BOOKS_ID — the ledger identifier from the staging table.
- ACCOUNTING_EVENT_ID — the subledger accounting event key linking Payables activity to its XLA records.
- CODE_COMBINATION_ID — the accounting flexfield combination for the line.
- LINE_NUMBER — the line sequence, suppressed (NULL) for liability accounts and for the
AP_PAYMENTSentity. - LINE_TYPE_CODE / LINE_TYPE — the accounting class code from XLA_AE_LINES and the line type field from the staging table.
- TAX_NAME — the tax rate name, also suppressed for liability accounts and
AP_PAYMENTS. - DESCRIPTION — the accounting line description, similarly suppressed in the same conditions.
- ACCOUNT / ACCOUNT_DESC — the account and its description.
- ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR — entered and accounted debit/credit amounts.
Common Use Cases and Queries
The view is typically queried to reconcile Payables accounting entries and contra lines, particularly for payment-related events. A representative query for investigating payment accounting is:
SELECT accounting_event_id, code_combination_id, line_type_code, entered_dr, entered_cr, accounted_dr, accounted_cre FROM apps.jg_zz_ap_contra_v WHERE accounting_event_id = :event_id ORDER BY line_number;- Joining back to GL_CODE_COMBINATIONS to identify liability versus expense accounts, and filtering by
set_of_books_idto isolate a ledger. - Extracting contra-entry amounts for statutory localization reports where
AP_PAYMENTSlines must be excluded from line-number and tax-name presentation.
Because the view embeds hard-coded application_id = 200 filters, it is effectively restricted to Payables subledger data and cannot be reused for other subledgers without modification.
-
VIEW: APPS.JG_ZZ_AP_CONTRA_V 12.2.2
-
VIEW: APPS.JG_ZZ_AP_CONTRA_V 12.1.1
-
View: JG_ZZ_AP_CONTRA_V 12.1.1
Subledger contra account balances for Payables
APPS.JG_ZZ_AP_CONTRA_V·↳ GL_CODE_COMBINATIONS·↳ JG_ZZ_AP_TMP_ACCOUNT·↳ XLA_AE_HEADERS·Explore JG module →
-
View: JG_ZZ_AP_CONTRA_V 12.2.2
Subledger contra account balances for Payables
APPS.JG_ZZ_AP_CONTRA_V·↳ GL_CODE_COMBINATIONS·↳ JG_ZZ_AP_TMP_ACCOUNT·↳ XLA_AE_HEADERS·Explore JG module →
-
Lookup Type: GATHER_TYPES 12.1.1
Transaction type to gather
-
Lookup Type: GATHER_TYPES 12.2.2
Transaction type to gather
-
Transaction Type
-
Transaction Type
-
Transaction Type
-
Transaction Type