Results for “sequence_num”

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

Overview

PV_GE_CHKLST_ITEMS_VL is a bilingual (MLS) validation view owned by the APPS schema in Oracle E-Business Suite, defined over the PV - Partner Management product. Its name follows the standard Oracle naming convention for views that join a "_B" base table with its "_TL" translation table, producing a single row per checklist item whose translatable attribute is resolved to the language of the current session. The "GE" in the object name aligns with the generic checklist framework used by Partner Management to define reusable checklist item master definitions, and the checklist items referenced here are specialized by the USED_BY_ENTITY_ID column into specific business contexts.

The view is read-only and is intended as a reporting and integration access layer rather than a transactional entity. Records retrieved from it would be collected during form or concurrent program processing and then stored against a checklist instance in the appropriate transaction table.

Underlying Base Objects

The view is defined over two documented base objects:

• PV_GE_CHKLST_ITEMS_B (synonym) - the base table holding non-translatable checklist item attributes and administrative columns.
• PV_GE_CHKLST_ITEMS_TL (synonym) - the translation table holding the translatable CHECKLIST_ITEM_NAME for each item.

The join predicate in the documented view text is B.CHECKLIST_ITEM_ID = T.CHECKLIST_ITEM_ID AND T.LANGUAGE = USERENV('LANG'). Because USERENV('LANG') returns the language code of the current database session, the view returns exactly one translated row per item, in whichever language the reporting user is connected under. In a multi-language EBS installation, the same CHECKLIST_ITEM_ID can therefore yield different CHECKLIST_ITEM_NAME values depending on session language, an important consideration for extraction and data warehouse loading.

Key Columns

The view exposes the ROWID of the base row as ROW_ID, together with a Row Who set of audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the OBJECT_VERSION_NUMBER used for optimistic locking.

• CHECKLIST_ITEM_ID - primary identifier of the checklist item master row.
• CHECKLIST_ITEM_NAME - the translated display name of the item, sourced from PV_GE_CHKLST_ITEMS_TL.
• ARC_USED_BY_ENTITY_CODE - the archive/usage entity code that classifies which business group the checklist item applies to.
• USED_BY_ENTITY_ID - the identifier of the owning business entity; it is this column that a user searching for USED_BY_ENTITY_ID is typically trying to resolve, and it must be combined with ARC_USED_BY_ENTITY_CODE to interpret which entity type the ID refers to. It is a polymorphic foreign key and cannot be joined to a single lookup table.
• SEQUENCE_NUM - ordering of the item within its checklist definition.
• IS_REQUIRED_FLAG and ENABLED_FLAG - control whether the item must be completed and whether it is currently active.

Common Use Cases and Queries

Typical uses include listing enabled checklist items per entity, auditing item ordering, and feeding integration extracts. A representative query, filtered to the entity the user is interested in and joined to the convention that entity code disambiguates the ID, is shown below.

• Enumerating active items for a specific business entity:
  SELECT CHECKLIST_ITEM_ID, CHECKLIST_ITEM_NAME, SEQUENCE_NUM, IS_REQUIRED_FLAG
FROM APPS.PV_GE_CHKLST_ITEMS_VL
WHERE ARC_USED_BY_ENTITY_CODE = :p_entity_code
AND USED_BY_ENTITY_ID = :p_entity_id
AND ENABLED_FLAG = 'Y'
ORDER BY SEQUENCE_NUM;
• Identifying all items that are not required within a checklist.
• Resolving a translated item name for a given CHECKLIST_ITEM_ID.
• Auditing recently modified items using LAST_UPDATE_DATE.

Because USED_BY_ENTITY_ID is polymorphic, callers must supply the corresponding ARC_USED_BY_ENTITY_CODE, or they risk returning items matched against unrelated entity types that happen to share the same numeric identifier.