Results for “mtl_gl_batch_status”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.ORG_GL_BATCHES_V is an Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 reporting view owned by the APPS schema. It presents a denormalized, human-readable projection of Inventory-to-General-Ledger batch activity, joining raw batch records to their accounting period and to a manufacturing lookup that decodes batch status. Whereas the underlying table ORG_GL_BATCHES stores only numeric identifiers and codes, this view resolves those codes into descriptive meaning, making it suitable for direct consumption by reports, concurrent programs, and downstream integration extracts. Notably, the view's status column substitutes a decode of the sign of GL_BATCH_ID with lookup values from MFG_LOOKUPS, giving the report a business-friendly state label rather than a raw code.
Underlying Base Objects
The view is defined over three documented objects:
ORG_GL_BATCHES(SYNONYM) — aliased Z; the driving table holding the batch header data.ORG_ACCT_PERIODS(SYNONYM) — aliased Y; supplies the accounting period name and is joined on the composite key of organization and accounting period ID.MFG_LOOKUPS(VIEW) — aliased X; provides the meaning text for the status lookup.
All three are joined within the APPS schema, and access to the view does not require the caller to know the physical base tables. Because MFG_LOOKUPS is itself a view, the optimizer may expand it into the underlying lookup table during query resolution.
Key Columns
- GL_BATCH_DATE, CREATION_DATE — the batch accounting date and the record creation timestamp.
- Derived GL_BATCH_ID column — a DECODE of SIGN(GL_BATCH_ID): positive values return the ID, zero and negative values return NULL. This effectively filters out or masks non-standard batches at the column level.
- PERIOD_NAME — the accounting period from ORG_ACCT_PERIODS.
- MEANING — the decoded batch status text from MFG_LOOKUPS (
MTL_GL_BATCH_STATUS). The decode maps sign 0 to code '1', sign 1 to '2', sign -1 to '3', supplying status semantics. - DESCRIPTION, ORGANIZATION_ID, GL_BATCH_ID — the batch narrative and its organizational/identity keys.
- Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN, and ROWID for change tracking.
Common Use Cases and Queries
This view is typically used to report on Inventory-to-GL transfer batches, to reconcile accounting periods against posted batches, and to expose batch status to downstream interfaces. A typical query filters by organization and period:
SELECT ORGANIZATION_ID, GL_BATCH_ID, GL_BATCH_DATE, PERIOD_NAME, MEANING, DESCRIPTION FROM APPS.ORG_GL_BATCHES_V WHERE ORGANIZATION_ID = :p_org AND PERIOD_NAME = :p_period;SELECT MEANING, COUNT(*) FROM APPS.ORG_GL_BATCHES_V GROUP BY MEANING;— batch status distribution.SELECT * FROM APPS.ORG_GL_BATCHES_V WHERE GL_BATCH_DATE BETWEEN :p_from AND :p_to ORDER BY GL_BATCH_DATE;
Note that the query string "giststack youtube video downloader" is unrelated to this object and does not correspond to any documented EBS construct; no such reference appears in the ETRM metadata. APPS.ORG_GL_BATCHES_V remains a standard Inventory/GL integration reporting view in both 12.1.1 and 12.2.2, with the same definition across releases.
-
VIEW: APPS.ORG_GL_BATCHES_V 12.2.2
-
VIEW: APPS.ORG_GL_BATCHES_V 12.1.1
-
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: 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 →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2