Results for “gl_batch_id_dsp”
6 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.ORG_GL_BATCHES_V view is an Oracle E-Business Suite inventory object that exposes General Ledger batch header information associated with inventory organizations and accounting periods. In the Oracle EBS 12.1.1 and 12.2.2 environments described by the ETRM documentation, the view carries a status of VALID and resides in the APPS schema under the INV – Inventory product. Its documented description is the terse notation "10SC ONLY," indicating that the object was designed for a specific configuration or localization context rather than general availability across all implementations. The view is intended to present a denormalized, readable projection of the ORG_GL_BATCHES base data, enriched with period names from ORG_ACCT_PERIODS and status descriptions from MFG_LOOKUPS, so that integrators and report developers can retrieve batch-level accounting information without performing the underlying joins themselves.
Underlying Base Objects
According to the documented view text, ORG_GL_BATCHES_V is defined over three referenced objects: ORG_GL_BATCHES, ORG_ACCT_PERIODS (documented as a synonym), and MFG_LOOKUPS (documented as a view). The primary driving object is ORG_GL_BATCHES, aliased as Z, which supplies the batch identifiers, dates, description, organization, and audit columns. ORG_ACCT_PERIODS, aliased as Y, is joined on both ORGANIZATION_ID and ACCT_PERIOD_ID to resolve the corresponding PERIOD_NAME. MFG_LOOKUPS, aliased as X, is joined on LOOKUP_TYPE equal to 'MTL_GL_BATCH_STATUS' and an ENABLED_FLAG of 'Y', providing the MEANING column that is exposed as STATUS. The join to MFG_LOOKUPS uses a DECODE on the sign of GL_BATCH_ID, mapping zero to lookup code '1', positive values to '2', and negative values to '3', with a default of '3'. This construct derives a display status from the sign of the batch identifier.
Key Columns
- GL_BATCH_DATE — the accounting batch date carried from ORG_GL_BATCHES; this is the column most commonly searched for when users query "gl_batch_date" against this view.
- GL_BATCH_ID — the raw batch identifier from the base table.
- GL_BATCH_ID_DSP — a display expression that returns the batch ID only when the SIGN of the value is positive, returning NULL for zero or negative values.
- PERIOD_NAME — the accounting period name resolved from ORG_ACCT_PERIODS for the batch's organization and period.
- STATUS — the lookup meaning derived from MFG_LOOKUPS for batch status.
- ORGANIZATION_ID — the inventory organization to which the batch belongs.
- DESCRIPTION — free-text description of the batch.
- Audit columns — CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN, and ROW_ID.
Common Use Cases and Queries
This view is typically used in custom reports, concurrent program extracts, and integration interfaces that require a consolidated view of GL batch activity by organization and period. Typical filters include organization and batch date range, or status.
A representative query retrieving batches by organization and date is:
- SELECT organization_id, gl_batch_id, gl_batch_date, period_name, status FROM org_gl_batches_v WHERE gl_batch_date BETWEEN :start_date AND :end_date AND organization_id = :org_id ORDER BY gl_batch_date;
- SELECT gl_batch_id, gl_batch_date, period_name, status, description FROM org_gl_batches_v WHERE status = :status_meaning;
Because the view synthesizes the GL_BATCH_ID_DSP and STATUS columns through DECODE logic, ad hoc queries should reference only the exposed columns rather than reimplementing the status derivation. Given its "10SC ONLY" designation, the view should be validated for availability in the target instance before being used in production reports.
-
View: ORG_GL_BATCHES_V 12.2.2
10SC ONLY
APPS.ORG_GL_BATCHES_V·↳ MFG_LOOKUPS·↳ ORG_ACCT_PERIODS·↳ ORG_GL_BATCHES·Explore INV module →
-
View: ORG_GL_BATCHES_V 12.1.1
10SC ONLY
APPS.ORG_GL_BATCHES_V·↳ MFG_LOOKUPS·↳ ORG_ACCT_PERIODS·↳ ORG_GL_BATCHES·Explore INV module →
-
VIEW: APPS.ORG_GL_BATCHES_V 12.2.2
-
VIEW: APPS.ORG_GL_BATCHES_V 12.1.1
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2