Results for “jai_boe_headers_v”

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

Overview

JAI_BOE_HEADERS_V is an APPS-owned database view within the JA (Asia/Pacific Localizations) product family, specifically associated with the Bill of Entry (BOE) functionality used in India localization. The view presents consolidated Bill of Entry header information, joining the core BOE header table with descriptive attributes from human resources, inventory organizations, vendors, and lookup tables. It is intended for reporting, enquiry screens, and integration scenarios where a denormalized, user-friendly representation of BOE header data is required rather than the raw normalized table structure.

The user search term "consolidated_flag" corresponds directly to the CONSOLIDATED_FLAG column exposed by this view, which is sourced from the underlying JAI_CMN_BOE_HDRS table. This flag indicates whether a given Bill of Entry header represents a consolidated BOE, allowing downstream processes and reports to distinguish consolidated entries from individual ones.

Underlying Base Objects

The documented view metadata for Oracle EBS 12.2.2 lists the following referenced base objects: FND_GLOBAL (PACKAGE), HR_GENERAL (PACKAGE), HR_LOCATIONS (VIEW), HR_OPERATING_UNITS (VIEW), HR_SECURITY (PACKAGE), JAI_CMN_BOE_AGENTS (SYNONYM), JAI_CMN_BOE_HDRS (SYNONYM), JA_LOOKUPS (VIEW), ORG_ORGANIZATION_DEFINITIONS (VIEW), PO_VENDORS (VIEW), and PO_VENDOR_SITES_ALL (VIEW).

The primary driver is JAI_CMN_BOE_HDRS (JBH), which holds the BOE header records. Human resources views supply operating unit and location descriptions. ORG_ORGANIZATION_DEFINITIONS provides the inventory organization name. Vendor information is obtained through PO_VENDORS and PO_VENDOR_SITES_ALL, while JA_LOOKUPS supplies meaning values for BOE_TYPE, PORT_TYPE, and STATUS. The JAI_CMN_BOE_AGENTS synonym provides customs agent details. FND_GLOBAL and HR_SECURITY packages participate in the view's security and session context.

Key Columns

• BOE_ID / ORG_ID / ORGANIZATION_ID — Primary identifiers for the BOE header, operating unit, and inventory organization.
• CONSOLIDATED_FLAG — Indicates whether the BOE header is consolidated; the searched column.
• BOE_TYPE_MEANING / STATUS_DESC / PORT_TYPE_DESC — Decoded lookup meanings for type, status, and port type.
• AGENT_CODE / AGENT_NAME / AUTH_NUM / AUTH_NAME — Customs agent and authority attributes.
• VENDOR_NUMBER / VENDOR_NAME / VENDOR_SITE_CODE — Supplier details for the BOE.
• BOE_AMOUNT / AMOUNT_APPLIED / AMOUNT_WRITTEN_OFF / DEPB_AMOUNT — Monetary amounts associated with the BOE.
• CURRENCY_CODE / CURRENCY_RATE / CURRENCY_RATE_TYPE / CURRENCY_RATE_DATE — Currency conversion attributes.
• IGM_NUMBER / MAWB_NUMBER / HAWB_NUMBER / BOL_NUMBER / ROTATION_NO — Shipping and transport reference numbers.
• ATTRIBUTE1 through ATTRIBUTE15 / ATTRIBUTE_CATEGORY — Descriptive flexfield columns.
• LEGAL_ENTITY_ID / INVOICE_NUM — Legal entity and invoice references.

Common Use Cases and Queries

Typical use cases include BOE enquiry screens, customs reporting, reconciliation of BOE amounts against invoices, and integration extracts. The CONSOLIDATED_FLAG is frequently used to filter consolidated versus non-consolidated BOEs in reporting.

Sample query to retrieve consolidated BOE headers:

• SELECT boe_id, org_name, organization_name, boe_type_meaning, boe_date, vendor_name, boe_amount, status_desc
• FROM apps.jai_boe_headers_v
• WHERE consolidated_flag = 'Y'
• AND org_id = :p_org_id
• ORDER BY boe_date DESC;

A second scenario joins this view to BOE line tables to analyze amount applied versus written off, filtered by status and legal entity, supporting customs duty reconciliation and period-end reporting.