Results for “cz_repository_main_hgrid_v”

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

Overview

CZ_REPOSITORY_MAIN_HGRID_V is an APPS-owned database view within the Oracle E-Business Suite Configurator (CZ) product module. It presents a consolidated, hierarchical-grid-oriented projection of the Configurator repository, joining repository entry metadata with model checkout state, project associations, localized object-type descriptions, effectivity information, and UI image paths. In EBS 12.1.1 and 12.2.2 the view is reported as VALID and is primarily consumed by the Configurator developer and model-maintenance user interfaces, but it is equally usable for reporting and integration purposes where a flat, denormalized read of repository objects is required.

The view exposes several status-oriented attributes — most notably USER_LOCK_STATUS, LOCK_STATUS, and DELETED_FLAG — that make it a convenient source for queries about record locking, checkout ownership, and whether a model can be edited. This directly addresses the common search term lock_status: the view provides both a numeric lock indicator (USER_LOCK_STATUS) and a lookup-derived descriptive value (LOCK_STATUS).

Underlying Base Objects

The view is defined over a documented set of base objects in the APPS schema, including:

• CZ_RP_ENTRIES (synonym) — the core repository entry table supplying object type, object ID, enclosing folder, name, description, notes, and audit columns.
• CZ_DEVL_PROJECTS (synonym) — supplies checkout state, product key, organization/inventory identifiers, model type, and origination system reference.
• CZ_EFFECTIVITY_SETS (synonym) — provides effectivity date ranges.
• CZ_ITEM_MASTERS and CZ_PS_NODES (synonyms) — used to resolve the referenced part number for project-type objects.
• CZ_PROPERTIES and CZ_UI_TEMPLATES (synonyms) — participate in property and template joins.
• CZ_RPOBJECTTYPES_LKV (view) — the object-type lookup view.
• CZ_LOCALIZED_TEXTS_VL, CZ_UI_PATHED_IMAGES_V (views) — localized text and image path resolution.
• FND_LOOKUPS (view), FND_GLOBAL (package) — lookup values and session user context.
• CZ_DEVELOPER_UTILS_PVT (package) — provides translated descriptions and repository path generation functions.

Key Columns

• OBJECT_TYPE / OBJECT_ID — identify the repository entry and its detailed classification.
• NAME / DESCRIPTION / NOTES — descriptive attributes; descriptions are translated for USG object types.
• USER_LOCK_STATUS — numeric indicator derived via DECODE on CHECKOUT_USER: '0' when unlocked, '1' when locked by the current session user, and '2' when locked by another user.
• LOCK_STATUS — descriptive lookup value from FND_LOOKUPS (CZ_YES_NO_TYPE), returned for project-type entries.
• DELETED_FLAG / SEEDED_FLAG — deletion and seed-data state.
• CHECKOUT_USER / CHECKOUT_TIME — current lock owner and lock timestamp.
• PATH — repository path resolved by CZ_DEVELOPER_UTILS_PVT.
• IS_MODEL_EDITABLE / HAS_ENTITY_PRIV — editability and privilege flags.
• PRODUCT_KEY, ORGANIZATION_ID, INVENTORY_ITEM_ID, MODEL_TYPE, REF_PART_NBR — model identification attributes.
• IMAGE_FILE / FULL_IMAGE_PATH / ALT_TEXT — UI presentation attributes.
• EFFECTIVE_FROM (and related effectivity columns) — effectivity definition.

Common Use Cases and Queries

Typical uses include identifying locked models, auditing checkout ownership, driving hierarchical-grid displays, and reporting on repository contents. Example queries:

• Locked models owned by another user:

SELECT object_id, name, checkout_user, checkout_time FROM cz_repository_main_hgrid_v WHERE object_type = 'PRJ' AND user_lock_status = '2';

• Displaying the descriptive lock value for projects:

SELECT object_id, name, lock_status FROM cz_repository_main_hgrid_v WHERE object_type = 'PRJ';

• Filtering active, non-deleted repository entries with their resolved path:

SELECT object_id, object_type, name, path FROM cz_repository_main_hgrid_v WHERE deleted_flag = 'N';