Results for “inv_org_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JAI_INV_RGCO_AEL_V is a validity-confirmed APPS schema view belonging to the JA (Asia/Pacific Localizations) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is documented as the "Base view of RG consolidation" and is designed to expose RG (Register) consolidation activity in the standard Oracle Subledger Accounting (SLA/XLA) event and journal-line reporting shape. The column list closely mirrors the structure of standard Accounting Event Line (AEL) extract views, presenting journal headers, journal lines, accounting dates, currencies, conversion details and account combinations alongside the RG consolidation transaction identifiers.

The view provides the reporting and integration layer for consolidating RG registers maintained by the JA localization for taxation and statutory registers. The presence of columns such as INV_ORG_CODE, INV_ORG_ID, INV_ORG_NAME, TRX_CLASS, TRX_HDR_ID and TRX_HDR_TABLE indicates the view is intended to plug RG consolidation activity into generic accounting extract or reconciliation reports. Users searching for inv_org_code reach this view because inventory organization code is one of its primary descriptive columns, allowing RG consolidation entries to be attributed to the inventory organization that generated them.

Underlying Base Objects

The view is defined over the following documented base objects: JAI_CMN_RG_CONSLDATIONS, JAI_CMN_RG_PLA_HDRS, GL_JE_HEADERS, GL_JE_LINES, GL_IMPORT_REFERENCES, GL_JE_CATEGORIES, GL_JE_SOURCES, GL_DAILY_CONVERSION_TYPES, PO_VENDORS, AP_SUPPLIER_SITES_ALL, ORG_ORGANIZATION_DEFINITIONS and HR_LOCATIONS. The HR_GENERAL and HR_SECURITY packages are referenced as security dependencies, indicating the view participates in HR organization security enforcement carried by ORG_ORGANIZATION_DEFINITIONS and HR_LOCATIONS.

JAI_CMN_RG_CONSLDATIONS is the primary driver, holding the consolidation records, while JAI_CMN_RG_PLA_HDRS provides the PLA / RG register header with TR6 challan details. GL_JE_HEADERS and GL_JE_LINES supply the corresponding GL journal image, GL_IMPORT_REFERENCES links the RG consolidation back to the GL journal import reference, GL_JE_CATEGORIES and GL_JE_SOURCES resolve user-facing category and source names, and GL_DAILY_CONVERSION_TYPES supplies the currency conversion type. PO_VENDORS and AP_SUPPLIER_SITES_ALL identify the vendor authority and site, and ORG_ORGANIZATION_DEFINITIONS plus HR_LOCATIONS supply the inventory organization code, name and location description.

Key Columns

• EVENT_TYPE — literal 'RG REGISTERS CONSOLIDATION', used to distinguish this event class in extracts.
• SET_OF_BOOK_ID — from GL_JE_HEADERS.LEDGER_ID, the ledger of the accounting entry.
• INV_ORG_ID, INV_ORG_CODE, INV_ORG_NAME — inventory organization identifier, code and name from ORG_ORGANIZATION_DEFINITIONS; INV_ORG_CODE is the frequently-searched column.
• TRX_CLASS / TRX_CLASS_NAME — literals 'JAI INV RGCO' and 'RG CONSOLIDATION'.
• TRX_HDR_ID / TRX_HDR_TABLE — consolidation ID and source table JAI_CMN_RG_CONSLDATIONS.
• JE_CATEGORY, USER_JE_CATEGORY_NAME, JE_SOURCE, USER_JE_SOURCE_NAME — journal category and source codes with user names.
• JE_HEADER_ID, JE_LINE_NUM — the GL journal header and line identifiers.
• ENTERED_DEBIT, ENTERED_CREDIT, ACCOUNT_DEBIT, ACCOUNT_CREDIT — entered and accounted debit/credit amounts.
• ACCOUNT_ID, ACCOUNTING_DATE — code combination identifier and effective accounting date.
• CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE, CURRENCY_USER_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE — currency conversion attributes.
• PAYMENTS_ID, VENDOR_ID, AUTHORITY, VENDOR_SITE_ID, LOCATION — payment, vendor authority and vendor site details.
• TR6_CHALLAN_NUMBER, TR6_CHALLAN_DATE — statutory TR6 challan references from the RG PLA header.
• LOCATION_ID, LOCATION_NAME, CONSOLIDATION_DATE — RG location and consolidation date, plus standard WHO audit columns.

Common Use Cases and Queries

Typical usage includes statutory RG register reconciliation, mapping consolidation entries back to GL journals, and inventory-organization-level reporting of tax register activity. Because INV_ORG_CODE is exposed directly, reporting by organization is straightforward and does not require joining ORG_ORGANIZATION_DEFINITIONS separately.

Sample query restricted by inventory organization code:

• SELECT inv_org_code, consolidation_date, tr6_challan_number, vendor_id, authority, account_debit, account_credit, entered_currency FROM apps.jai_inv_rgco_ael_v WHERE inv_org_code = :p_org_code ORDER BY consolidation_date, je_header_id, je_line_num;

Sample query reconciling RG consolidation to GL by ledger and accounting period:

• SELECT set_of_book_id, je_header_id, je_line_num, je_category, account_id, accounting_date, account_debit, account_credit FROM apps.jai_inv_rgco_ael_v WHERE inv_org_id = :p_org_id AND accounting_date BETWEEN :p_from_date AND :p_to_date;

Sample query aggregating authority-wise RG totals:

• SELECT inv_org_code, vendor_id, authority, SUM(account_credit) total_credit, SUM(account_debit) total_debit FROM apps.jai_inv_rgco_ael_v GROUP BY inv_org_code, vendor_id, authority;

Where RG functionality is not enabled or no consolidation records exist, the view returns no rows. Query performance is generally acceptable when filtered by inventory organization, ledger or consolidation date, since these map to the driving JAI_CMN_RG_CONSLDATIONS and GL_JE_LINES columns.