Results for “tl_text_base_attribute1”

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

Overview

ICX.ICX_CAT_ITEMS_TLP is a table owned by the ICX schema, the database account that underpins Oracle iProcurement. The TLP suffix denotes a translated (multi-language) "TL" table with a "_P" physical attribute, indicating that rows carry locale-specific content keyed by LANGUAGE. Functionally, the table stores catalog item definitions used by iProcurement's search, browse, and requisition flows — including punchout, supplier-hosted, and internally sourced items. Column headings such as SUPPLIER_PART_NUM, MANUFACTURER_PART_NUM, UNSPSC_CODE, and PICTURE_URL identify it squarely as a catalog content table that feeds iProcurement's item search UI.

From a Data Vault modeling perspective, ETRM classifies ICX_CAT_ITEMS_TLP as a standalone object — no FK-derived relationships were mined. This is a heuristic classification, not a definitive warehouse target; the table presents a wide attribute surface (339 columns) dominated by descriptive and attribute-band columns, making it more satellite-like than hub- or link-like in character. The table is marked VALID in the ICX schema and is documented at the 12.2.2 physical schema level.

Key Information Stored

The surrogate primary key is SYS_C00165714, comprising the composite columns RT_ITEM_ID and LANGUAGE. A unique index, ICX_CAT_ITEMS_TLP_U1, is defined on the same pair, confirming them as the de facto business-key candidate for row de-duplication. (RT_ITEM_ID is an internal row/translation identifier, not a business item number.)

• RT_ITEM_ID — internal item/row identity; part of the primary key.
• LANGUAGE — locale code enabling translated descriptions; the second PK column.
• ORG_ID — operating unit / inventory organization context.
• SUPPLIER_ID, SUPPLIER, SUPPLIER_PART_NUM — supplier identification and supplier part references.
• INTERNAL_ITEM_ID, INTERNAL_ITEM_NUM — link to internally sourced inventory items.
• MANUFACTURER, MANUFACTURER_PART_NUM — manufacturer details.
• DESCRIPTION, LONG_DESCRIPTION — catalog item descriptions (translated).
• PRIMARY_CATEGORY_ID, PRIMARY_CATEGORY_NAME — purchasing category assignment.
• UNSPSC_CODE — United Nations Standard Products and Services Code.
• ITEM_SOURCE_TYPE, SEARCH_TYPE — sourcing and search classification flags.
• LEAD_TIME, AVAILABILITY — procurement availability signals.
• PICTURE_URL, THUMBNAIL_IMAGE, ATTACHMENT_URL — media references.
• TEXT_BASE_ATTRIBUTE1–100, NUM_BASE_ATTRIBUTE1–100, TL_TEXT_BASE_ATTRIBUTE1–100 — descriptor-flex attribute bands (the bulk of the 339 columns).
• LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, REQUEST_ID, PROGRAM_ID — standard audit/WHO columns.

Common Use Cases and Queries

Typical usage centers on iProcurement Smart Form and search integration, catalog diagnostics, and reporting on supplier-hosted content. A representative query to enumerate translated rows for a given item:

SELECT RT_ITEM_ID, LANGUAGE, DESCRIPTION, SUPPLIER_PART_NUM
FROM   ICX.ICX_CAT_ITEMS_TLP
WHERE  RT_ITEM_ID = :p_rt_item_id
ORDER BY LANGUAGE;

To join iProcurement catalog content back to inventory, query on INTERNAL_ITEM_NUM against MTL_SYSTEM_ITEMS_B.SEGMENT1. For supplier punchout analysis, filter on SUPPLIER_ID and ITEM_SOURCE_TYPE. Reporting extracts for category spend use PRIMARY_CATEGORY_ID joined to ICX_CATEGORY_SETS or MTL_CATEGORIES_B. Validation scripts check whether translated rows exist for every active LANGUAGE in FND_LANGUAGES.

Related Objects

• ICX_CAT_ITEMS_TL / ICX_CAT_ITEMS_B — base/translated counterparts sharing RT_ITEM_ID.
• MTL_SYSTEM_ITEMS_B — joined via INTERNAL_ITEM_ID or SEGMENT1 for internal items.
• MTL_CATEGORIES_B / ICX_CATEGORY_SETS — category lookups via PRIMARY_CATEGORY_ID.
• POZ_SUPPLIERS / AP_SUPPLIERS — supplier detail via SUPPLIER_ID.
• FND_LANGUAGES — drives the LANGUAGE PK column.
• ICX_CAT_ITEMS_CTX — descriptor-flex context joined via RT_ITEM_ID.