Results for “inventory_organization_id”
50+ results
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:
- MESSAGE_ID — foreign key to
AR_STANDARD_TEXT_B, identifying the legal message text to be applied. - RULE_ID, RULE_DATA_ID, EXCEPTION_CODE, and ORG_ID — together these constitute the unique index
JL_ZZ_AR_TX_LGL_MSG_U1, the business-key candidate that guarantees one message assignment per rule, rule data value, exception, and operating unit. - INVENTORY_ITEM_FLAG and INVENTORY_ORGANIZATION_ID — indicate whether the legal message is scoped to an inventory item and, if so, which inventory organization.
- START_DATE_ACTIVE and END_DATE_ACTIVE — define the effective date range during which the message assignment is valid.
- ORG_ID — multi-org operating unit discriminator.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Who columns for audit tracking.
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'andINVENTORY_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_ACTIVEto flag stale configuration.
These queries support localization compliance teams verifying that every taxable scenario maps to a legally required message.
Related Objects
- AR_STANDARD_TEXT_B — primary FK target via
JL_ZZ_AR_TX_LGL_MSG_ALL.MESSAGE_ID = AR_STANDARD_TEXT_B.STANDARD_TEXT_ID; supplies the base message text. - AR_STANDARD_TEXT_TL — translation table providing language-specific message content for the base text.
- JL_ZZ_AR_TX_RULES_ALL — parent tax rule definition referenced conceptually through
RULE_ID. - JL_ZZ_AR_TX_RULE_DATA_ALL — rule data values referenced through
RULE_DATA_ID. - JL_ZZ_AR_TX_EXCEPTIONS_ALL — exception definitions referenced through
EXCEPTION_CODE. - HR_OPERATING_UNITS / FND_ORG_ACCESS — resolve
ORG_IDand enforce multi-org security. - MTL_SYSTEM_ITEMS_B / MTL_PARAMETERS — context for
INVENTORY_ITEM_FLAGand inventory organization scoping.
-
Latin Tax Legal Messages Information
-
View: POR_PROJECT_LOV_V 12.2.2
List of Values for Projects
APPS.POR_PROJECT_LOV_V·↳ FND_PROFILE·↳ MRP_GET_PROJECT·↳ MTL_PARAMETERS·Explore ICX module →
-
Supplier Items View
APPS.ICX_PO_SUPPLIER_ITEMS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore ICX module →
-
View: POR_PROJECT_LOV_V 12.1.1
List of Values for Projects
APPS.POR_PROJECT_LOV_V·↳ FND_PROFILE·↳ MRP_GET_PROJECT·↳ MTL_PARAMETERS·Explore ICX module →
-
APPS.AP_SHIP_BILL_TO_LOCATIONS_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore AP module →
-
No Longer Used - MOAC
APPS.AP_SHIPPING_NETWORK_LOCATIONS·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore AP module →
-
View: PJM_PROJECTS_ORG_V 12.2.2
Project Manufacturing enabled Project / Seiban view
APPS.PJM_PROJECTS_ORG_V·↳ FND_PROFILE·↳ PA_CROSS_BUSINESS_GRP·↳ PA_PROJECT_UTILS·Explore PJM module →
-
View: PO_LOCATIONS_VAL_V 12.1.1
- Retrofitted
APPS.PO_LOCATIONS_VAL_V·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore PO module →
-
APPS.AP_SHIP_BILL_TO_LOCATIONS_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore AP module →
-
Brazilian Tax Legal Messages;no longer used
-
Latin Tax Legal Messages Information
-
No Longer Used - MOAC
APPS.AP_SHIPPING_NETWORK_LOCATIONS·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore AP module →
-
View: PO_SHIP_TO_LOC_ORG_V 12.2.2
10SC ONLY - Retrofitted
APPS.PO_SHIP_TO_LOC_ORG_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
View: PO_SHIP_TO_LOC_ORG_V 12.1.1
10SC ONLY - Retrofitted
APPS.PO_SHIP_TO_LOC_ORG_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
Displays all items from ASL
APPS.POS_PO_SUPPLIER_ITEMS_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_PARAMETERS·Explore POS module →
-
View: PJM_PROJECTS_ORG_V 12.1.1
Project Manufacturing enabled Project / Seiban view
APPS.PJM_PROJECTS_ORG_V·↳ FND_PROFILE·↳ PA_CROSS_BUSINESS_GRP·↳ PA_PROJECT_UTILS·Explore PJM module →
-
APPS.POS_PO_SUPPLIER_ITEMS_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_PARAMETERS·Explore PO module →
-
View: HRFV_GB_LOCATIONS 12.1.1
Business view template from which the flexfield view is generated.
APPS.HRFV_GB_LOCATIONS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_BIS·↳ HR_GENERAL·Explore PER module →
-
View: HR_LOCATIONS_ALL_PO_V 12.1.1
Used to support user interface
APPS.HR_LOCATIONS_ALL_PO_V·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore PER module →
-
View: HR_LOCATIONS_ALL_PO_V 12.2.2
Used to support user interface
APPS.HR_LOCATIONS_ALL_PO_V·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore PER module →
-
View: PJM_PROJECTS_ORG_OU_V 12.2.2
APPS.PJM_PROJECTS_ORG_OU_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_PROJECTS_ALL_EXPEND_V·Explore PJM module →
-
View: PJM_PROJECTS_ORG_OU_V 12.1.1
APPS.PJM_PROJECTS_ORG_OU_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_PROJECTS_ALL_EXPEND_V·Explore PJM module →
-
View: ICX_POR_REQ_ASLS 12.1.1
APPS.ICX_POR_REQ_ASLS·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_LANGUAGES·↳ GL_SETS_OF_BOOKS·Explore ICX module →
-
View: HR_LOCATIONS_NO_JOIN 12.2.2
USed to support user interface.
APPS.HR_LOCATIONS_NO_JOIN·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·Explore PER module →
-
View: PO_LOCATIONS_VAL_V 12.2.2
- Retrofitted
APPS.PO_LOCATIONS_VAL_V·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore PO module →
-
View: ICX_POR_REQ_ASLS 12.2.2
APPS.ICX_POR_REQ_ASLS·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ FND_LANGUAGES·Explore ICX module →
-
Brazilian Tax Legal Messages;no longer used
-
Supplier Items View
APPS.ICX_PO_SUPPLIER_ITEMS_V·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore ICX module →
-
Table to Store the Deatils of Purchasing and Payables Transactions
-
Table to Store the Deatils of Purchasing and Payables Transactions
-
View: JL_ZZ_AR_TX_LGM_V 12.2.2
APPS.JL_ZZ_AR_TX_LGM_V·↳ AR_STANDARD_TEXT_VL·↳ AR_SYSTEM_PARAMETERS_ALL·↳ JL_ZZ_AR_TX_LGL_MSG·Explore JL module →
-
View: JL_ZZ_AR_TX_LGM_V 12.1.1
APPS.JL_ZZ_AR_TX_LGM_V·↳ AR_STANDARD_TEXT_VL·↳ AR_SYSTEM_PARAMETERS_ALL·↳ JL_ZZ_AR_TX_LGL_MSG·Explore JL module →
-
View: XLA_REQ_ENC_AEL_GL_V 12.1.1
APPS.XLA_REQ_ENC_AEL_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: JAI_PLA_ENTRY_AEL_V 12.2.2
Base view of PLA entry
APPS.JAI_PLA_ENTRY_AEL_V·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
View: HRFV_US_LOCATIONS 12.1.1
Business view template from which the flexfield view is generated.
APPS.HRFV_US_LOCATIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_BIS·Explore PER module →
-
APPS.POS_PO_SUPPLIER_ITEMS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS_VL·Explore PO module →
-
View: HRFV_GB_LOCATIONS 12.2.2
Business view template from which the flexfield view is generated.
APPS.HRFV_GB_LOCATIONS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_BIS·↳ HR_GENERAL·Explore PER module →
-
View: HRFV_LOCATIONS 12.1.1
Business view template from which the flexfield view is generated.
APPS.HRFV_LOCATIONS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_BIS·↳ HR_GENERAL·Explore PER module →
-
APPS.AP_RECEIPT_CORRECTIONS_V·↳ AP_INVOICES_ALL·↳ AP_INVOICE_LINES_ALL·↳ AP_LOOKUP_CODES·Explore AP module →
-
View: WSH_HR_LOCATIONS_V 12.2.2
APPS.WSH_HR_LOCATIONS_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore WSH module →
-
View: WSH_HR_LOCATIONS_V 12.1.1
APPS.WSH_HR_LOCATIONS_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore WSH module →
-
View: JL_ZZ_AR_TX_LGL_MSG_V 12.1.1
APPS.JL_ZZ_AR_TX_LGL_MSG_V·↳ AR_MEMO_LINES·↳ AR_STANDARD_TEXT_VL·↳ AR_SYSTEM_PARAMETERS_ALL·Explore JL module →
-
View: PO_HR_LOCATIONS 12.2.2
- Retrofitted
APPS.PO_HR_LOCATIONS·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
View: PO_AP_RECEIPT_MATCH_V 12.1.1
APPS.PO_AP_RECEIPT_MATCH_V·↳ AP_LOOKUP_CODES·↳ AP_TAX_CODES_ALL·↳ AP_TERMS·Explore PO module →
-
APPS.AP_RECEIPT_CORRECTIONS_V·↳ AP_INVOICES·↳ AP_INVOICE_LINES_ALL·↳ AP_LOOKUP_CODES·Explore AP module →
-
View: JL_ZZ_AR_TX_LGL_MSG_V 12.2.2
APPS.JL_ZZ_AR_TX_LGL_MSG_V·↳ AR_MEMO_LINES·↳ AR_STANDARD_TEXT_VL·↳ AR_SYSTEM_PARAMETERS_ALL·Explore JL module →
-
APPS.JAI_PO_OSP_DISP_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSP_DISP_AEL_V·Explore JA module →
-
View: JAI_AP_STDIST_AEL_SL_V 12.2.2
APPS.JAI_AP_STDIST_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_AP_STDIST_AEL_V·Explore JA module →