Results for “inventory_item_flag”

50+ results




Overview
Explore in AI Chat

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

Overview

The JL.JL_ZZ_AR_TX_LGL_MSG_ALL table is a Latin America Localizations (JL) data object that stores legal message assignments for Latin American tax reporting. Within Oracle EBS 12.1.1 and 12.2.2, it functions as an intersection between tax rule configuration and the standard text messages displayed on printed invoices and legal tax documents. Each row associates a specific tax rule, rule data value, and optional exception condition with a standard text message that carries legal or fiscal significance for the localization country.

The ALL suffix indicates the table is partitioned or org-striped by operating unit through the ORG_ID column, consistent with multi-org access control. From a modeling perspective, the FK structure — a single foreign key to AR_STANDARD_TEXT_B for message content plus a business-key unique index — suggests the table leans toward a satellite classification, capturing descriptive message-assignment attributes that depend on a parent rule identity rather than acting as an independent hub or a pure link between two hubs.

Key Information Stored

The table is documented with 14 columns. Key columns include:

Common Use Cases and Queries

Typical usage centers on resolving which legal text should print on a tax document given a rule and item context. A representative join resolves the message body through the standard text table:

  • Report the legal message text active for a given rule: SELECT m.RULE_ID, m.MESSAGE_ID, t.TEXT FROM JL_ZZ_AR_TX_LGL_MSG_ALL m, AR_STANDARD_TEXT_B t WHERE m.MESSAGE_ID = t.STANDARD_TEXT_ID AND TRUNC(SYSDATE) BETWEEN m.START_DATE_ACTIVE AND NVL(m.END_DATE_ACTIVE, SYSDATE);
  • Filter by operating unit: add AND m.ORG_ID = :org_id.
  • Item-specific message lookup: filter on INVENTORY_ITEM_FLAG = 'Y' and INVENTORY_ORGANIZATION_ID.
  • Configuration audit: list assignments by RULE_ID and EXCEPTION_CODE to verify coverage against legal requirements.
  • Validity reporting: identify assignments with expired END_DATE_ACTIVE to flag stale configuration.

These queries support localization compliance teams verifying that every taxable scenario maps to a legally required message.

Related Objects