Search Results jai_cmn_boe_dtls




Overview
Explore in AI Chat

Overview

The JAI_CMN_BOE_DTLS table is a core transactional data object within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as the detail line table for BOE (Bill of Entry) Invoices. This table stores the individual line items that constitute a BOE invoice, which is a critical document for customs and excise duty accounting in several Asia/Pacific jurisdictions. Its role is to record the granular transactional details—such as item, quantity, value, and duty calculations—that roll up to a header record, enabling comprehensive tracking, reporting, and compliance for import and excise transactions.

Key Information Stored

As a detail table, JAI_CMN_BOE_DTLS holds line-level attributes for each BOE invoice. The primary key structure, consisting of BOE_ID and LINE_NUMBER, uniquely identifies each line item and enforces its relationship to a parent header. While the specific column list is not detailed in the provided metadata, typical data stored in such a table includes product or item identifiers, unit of measure, invoiced quantity, unit price, line extended amount, and various duty-related fields like assessable value, duty rate, and calculated duty amount. The BOE_ID column is the foreign key that links every detail line back to its corresponding master record in the JAI_CMN_BOE_HDRS table.

Common Use Cases and Queries

This table is central to generating detailed BOE registers, duty liability reports, and audit trails for customs authorities. Common operational and reporting queries involve joining the detail lines with the header and related master data (e.g., items, organizations) to analyze import transactions. A fundamental query pattern is retrieving all line items for a specific BOE invoice or for a range of dates to review duty calculations. For example:

  • SELECT d.boe_id, d.line_number, d.item_id, d.quantity, d.unit_price, d.duty_amount FROM jai_cmn_boe_dtls d WHERE d.boe_id = :p_boe_id ORDER BY d.line_number;

Another critical use case is reconciliation, where the sum of detail line amounts is validated against the header total, or duty amounts are aggregated for periodic tax filing.

Related Objects

The JAI_CMN_BOE_DTLS table has a direct and essential relationship with the BOE invoice header table, as documented in the provided metadata. The primary related objects are:

  • JAI_CMN_BOE_HDRS: This is the parent header table. The relationship is enforced by a foreign key where JAI_CMN_BOE_DTLS.BOE_ID references JAI_CMN_BOE_HDRS. All detail lines must correspond to a valid header record. A typical join uses JAI_CMN_BOE_DTLS.BOE_ID = JAI_CMN_BOE_HDRS.BOE_ID.
  • JAI_CMN_BOE_DTLS_PK: This is the primary key constraint on the table itself, defined on the columns (BOE_ID, LINE_NUMBER).

While not listed in the excerpt, this detail table may also be referenced by various localization-specific reports, interfaces, and tax calculation engines within the JA module.