Results for “gl_category_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IC_GLED_CLS_VW is a read-only compatibility view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the GMI (Process Manufacturing Inventory) product family and exists to preserve backward compatibility for General Ledger (GL) classes. In the Process Manufacturing data model, GL classes are stored as OPM categories assigned to a category set flagged as GL_CLASS in GMI_CATEGORY_SETS. Older OPM code paths and interfaces expected a dedicated GL class table; this view reconstitutes that legacy presentation from the standard Oracle Inventory category tables, allowing dependent forms, reports, and integrations to continue functioning without schema changes.
The view is frequently referenced when users or developers search for gl_category_id, since the identifier for a GL class must be resolved through this view or its underlying category tables rather than a standalone GL class entity.
Underlying Base Objects
The ETRM metadata documents four referenced objects:
- MTL_CATEGORIES_V — the category view supplying the concatenated segment string, description, and audit columns.
- MTL_CATEGORY_SETS — the inventory category set header, providing STRUCTURE_ID and VALIDATE_FLAG.
- GMI_CATEGORY_SETS — the OPM extension table that identifies which category sets represent GL classes via OPM_CLASS = 'GL_CLASS'.
- MTL_CATEGORY_SET_VALID_CATS — the valid category assignments, used only when the category set enforces validation (VALIDATE_FLAG = 'Y').
The view is a UNION ALL of two branches. The first branch handles category sets where VALIDATE_FLAG is not 'Y'; the second branch joins MTL_CATEGORY_SET_VALID_CATS to restrict results to actively validated categories when VALIDATE_FLAG = 'Y'. Both branches join category set to structure to category on STRUCTURE_ID, and both filter on C.CATEGORY_CONCAT_SEGS = UPPER(SUBSTRB(C.CATEGORY_CONCAT_SEGS, 1, 8)), restricting output to concatenated GL class names of eight characters or fewer that are already uppercase.
Key Columns
- ICGL_CLASS — the GL class name, derived as the first eight bytes of the concatenated category segments.
- GL_CATEGORY_ID — the category identifier; this is the value returned when querying for the GL class key (analogous to the
gl_category_idsought by users). - ICGL_CLASS_DESC — the category description, truncated to seventy bytes.
- CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns carried through from MTL_CATEGORIES_V.
- TRANS_CNT — a hard-coded literal 0, retained for legacy column-count compatibility.
- DELETE_MARK — derived via DECODE on DISABLE_DATE: 0 when the category is active, 1 when disabled.
- TEXT_CODE — a TO_NUMBER(NULL) placeholder, present only to match the legacy column signature.
Common Use Cases and Queries
Typical scenarios include resolving a GL class name to its category ID, listing all enabled GL classes for a subledger interface, and validating that a GL class referenced by a process manufacturing transaction still exists and is active.
To locate a GL class by identifier:
SELECT gl_category_id, icgl_class, icgl_class_desc FROM apps.ic_gled_cls_vw WHERE gl_category_id = :p_category_id;
To list all active GL classes:
SELECT icgl_class, gl_category_id, icgl_class_desc FROM apps.ic_gled_cls_vw WHERE delete_mark = 0 ORDER BY icgl_class;
Because the view filters to uppercase, eight-character class names, rows outside that convention are excluded; integrations relying on longer or mixed-case GL class names should query MTL_CATEGORIES_V and GMI_CATEGORY_SETS directly.
-
View: IC_GLED_CLS_VW 12.2.2
This view is used for backward compatibility for GL classes.
APPS.IC_GLED_CLS_VW·↳ GMI_CATEGORY_SETS·↳ MTL_CATEGORIES_V·↳ MTL_CATEGORY_SETS·Explore GMI module →
-
View: IC_GLED_CLS_VW 12.1.1
This view is used for backward compatibility for GL classes.
APPS.IC_GLED_CLS_VW·↳ GMI_CATEGORY_SETS·↳ MTL_CATEGORIES_V·↳ MTL_CATEGORY_SETS·Explore GMI module →
-
In OPM Costing, this is where the Burden Percentages are established.
-
In OPM Costing, this is where the Burden Percentages are established.
-
Warehouse rules
-
View: PMITS_ITEM_MASTER_V 12.1.1
This is a view on top of OPM Item Master table. It contains all information relating to an item, such as lot/sublot control, unit of measure information, and all class and type designations.
APPS.PMITS_ITEM_MASTER_V·↳ GEM_LOOKUPS·↳ IC_ITEM_MST_VL·Explore PMI module →
-
View: PMITS_ITEM_MASTER_V 12.2.2
This is a view on top of OPM Item Master table. It contains all information relating to an item, such as lot/sublot control, unit of measure information, and all class and type designations.
APPS.PMITS_ITEM_MASTER_V·↳ GEM_LOOKUPS·↳ IC_ITEM_MST_VL·Explore PMI module →
-
Warehouse rules
-
GL Account Mapping information - contains the GL Account Mapping info. The Account mappings are defined for a Company, Account Title and attributes whose priority is >0 in gl_acct_hrc table. Note that these attributes are optional and a NU
-
GL Account Mapping information - contains the GL Account Mapping info. The Account mappings are defined for a Company, Account Title and attributes whose priority is >0 in gl_acct_hrc table. Note that these attributes are optional and a NU
-
View: IC_ITEM_MST_VL 12.2.2
OPM Items MLS enabled View
APPS.IC_ITEM_MST_VL·↳ IC_ITEM_MST_B·↳ IC_ITEM_MST_TL·Explore GMI module →
-
View: IC_ITEM_MST_VL 12.1.1
OPM Items MLS enabled View
APPS.IC_ITEM_MST_VL·↳ IC_ITEM_MST_B·↳ IC_ITEM_MST_TL·Explore GMI module →
-
This is the Item definition table. It contains all information relating to an item, such as lot/sublot control, unit of measure information, and all class and type designations.
-
This is the Item definition table. It contains all information relating to an item, such as lot/sublot control, unit of measure information, and all class and type designations.
-
VIEW: APPS.IC_GLED_CLS_VW 12.2.2
-
VIEW: GMI.IC_WHSE_INV# 12.2.2
-
VIEW: APPS.IC_GLED_CLS_VW 12.1.1
-
VIEW: GMF.GL_ACCT_MAP# 12.2.2
-
VIEW: GMI.IC_ITEM_MST_B# 12.2.2
-
VIEW: GMI.IC_WHSE_INV# 12.2.2
-
VIEW: GMF.GL_ACCT_MAP# 12.2.2
-
VIEW: GMI.IC_ITEM_MST_B# 12.2.2
-
VIEW: APPS.IC_ITEM_MST_VL 12.1.1
-
TABLE: GMF.GL_ACCT_MAP 12.1.1
-
TABLE: GMF.GL_ACCT_MAP 12.2.2
-
VIEW: APPS.IC_ITEM_MST_VL 12.2.2
-
TABLE: GMI.IC_WHSE_INV 12.2.2
-
TABLE: GMI.IC_WHSE_INV 12.1.1
-
TABLE: GMI.IC_ITEM_MST_B 12.2.2
-
TABLE: GMI.IC_ITEM_MST_B 12.1.1
-
APPS.GMIVDBL SQL Statements 12.1.1
-
APPS.GMIVDBL SQL Statements 12.2.2