Search Results jai_cmn_lines

Overview

JAI_CMN_LINES is a transactional table owned by the JA schema within the Asia/Pacific Localizations (JA) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description states that it stores ASBN (Advance Shipping and Billing Notice) information, positioning it as the localization extension that captures excise-related receipt and shipment data used primarily for Indian statutory compliance and related reporting flows. The table maintains 25 physical columns and is anchored by the unique index JAI_CMN_LINES_PK on CMN_LINE_ID.

From a Data Vault modeling perspective, the inferred classification is a link entity. This classification is a heuristic derived from the six foreign key relationships embedded in the table, which connect purchasing documents (PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL) with receiving documents (RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, RCV_TRANSACTIONS_INTERFACE). The presence of excise invoice attributes alongside these cross-domain references reinforces the role of the table as an associative bridge capturing transaction-level detail across the procure-to-receive lifecycle.

Key Information Stored

The column set spans purchasing references, receiving references, item detail, pricing, and localization-specific excise attributes. The most significant columns are summarized below.

CMN_LINE_ID — Surrogate primary key defined by the JAI_CMN_LINES_PK unique index; uniquely identifies each ASBN line record.
SHIPMENT_NUMBER — Business identifier of the shipment associated with the ASBN line.
PO_HEADER_ID, PO_LINE_ID, PO_LINE_LOCATION_ID — Foreign keys to PO_HEADERS_ALL, PO_LINES_ALL, and PO_LINE_LOCATIONS_ALL respectively, linking the ASBN line to the originating purchase order header, line, and shipment schedule.
PO_NUMBER, LINE_NUM — Denormalized purchasing document number and line number for reporting convenience.
SHIPMENT_HEADER_ID, SHIPMENT_LINE_ID — Foreign keys to RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES, tying the record to the actual receipt.
SHIPMENT_LINE_NUM — Display line number of the corresponding receiving shipment line.
INTERFACE_TRANSACTION_ID — Foreign key to RCV_TRANSACTIONS_INTERFACE, used during the receiving interface import lifecycle.
HEADER_INTERFACE_ID — Interface header reference for the inbound conversion or receipt process.
ITEM_ID — Inventory item reference for the received material.
QUANTITY, UOM_CODE — Received/ASBN quantity and its unit of measure.
PO_UNIT_PRICE, CURRENCY_CODE — Purchase price and currency used for value computation, typically for excise assessment.
EXCISE_INV_NUMBER, EXCISE_INV_DATE — Localization-specific excise invoice number and date, central to Indian excise reporting.
CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — Standard EBS audit and concurrency-control columns; OBJECT_VERSION_NUMBER supports optimistic locking in OA Framework-based extensions.

Common Use Cases and Queries

The table is queried primarily for excise reporting, ASBN reconciliation, and purchasing-to-receiving traceability. A typical pattern joins back to purchasing and receiving tables using the documented foreign keys.

Reconcile ASBN lines to purchase orders: SELECT l.cmn_line_id, l.po_number, l.line_num, l.quantity, p.authorization_status FROM jai_cmn_lines l, po_headers_all p WHERE l.po_header_id = p.po_header_id
Trace receipts for excise reporting: joining JAI_CMN_LINES to RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES on SHIPMENT_HEADER_ID and SHIPMENT_LINE_ID to obtain receipt dates that pair with EXCISE_INV_DATE.
Interface error investigation: selecting rows by INTERFACE_TRANSACTION_ID or HEADER_INTERFACE_ID where the RCV interface has rejected or held a receipt, using the ID to correlate with the receiving interface tables.
Period-end excise register: aggregating QUANTITY × PO_UNIT_PRICE by CURRENCY_CODE and EXCISE_INV_DATE to feed statutory filings.

Related Objects

The following objects are the most significant dependencies based on the documented foreign key layout. Each is joined on the column named above.

PO_HEADERS_ALL — joined via JAI_CMN_LINES.PO_HEADER_ID; supplies PO header context.
PO_LINES_ALL — joined via JAI_CMN_LINES.PO_LINE_ID; supplies PO line detail.
PO_LINE_LOCATIONS_ALL — joined via JAI_CMN_LINES.PO_LINE_LOCATION_ID; supplies shipment schedule detail.
RCV_SHIPMENT_HEADERS — joined via JAI_CMN_LINES.SHIPMENT_HEADER_ID; supplies receipt header information.
RCV_SHIPMENT_LINES — joined via JAI_CMN_LINES.SHIPMENT_LINE_ID; supplies receipt line detail.
RCV_TRANSACTIONS_INTERFACE — joined via JAI_CMN_LINES.INTERFACE_TRANSACTION_ID; supports interface processing and reconciliation.

Collectively, these relationships confirm that JAI_CMN_LINES functions as the localization bridge between Oracle Purchasing and Oracle Receiving, extending standard receipt data with the excise attributes required for Asia/Pacific statutory compliance.

Table: JAI_CMN_LINES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_LINES, object_name:JAI_CMN_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the ASBN information , implementation_dba_data: JA.JAI_CMN_LINES ,
Table: JAI_CMN_LINES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_LINES, object_name:JAI_CMN_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the ASBN information , implementation_dba_data: JA.JAI_CMN_LINES ,
VIEW: JA.JAI_CMN_LINES# 12.2.2
owner:JA, object_type:VIEW, object_name:JAI_CMN_LINES#, status:VALID,
VIEW: JA.JAI_CMN_LINES# 12.2.2
SYNONYM: APPS.JAI_CMN_LINES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JAI_CMN_LINES, status:VALID,
SYNONYM: APPS.JAI_CMN_LINES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JAI_CMN_LINES, status:VALID,
Table: RCV_SHIPMENT_HEADERS 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SHIPMENT_HEADERS, object_name:RCV_SHIPMENT_HEADERS, status:VALID, product: PO - Purchasing , description: Shipment and receipt header information , implementation_dba_data: PO.RCV_SHIPMENT_HEADERS ,
TABLE: JA.JAI_CMN_LINES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_LINES, object_name:JAI_CMN_LINES, status:VALID,
Table: RCV_SHIPMENT_HEADERS 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SHIPMENT_HEADERS, object_name:RCV_SHIPMENT_HEADERS, status:VALID, product: PO - Purchasing , description: Shipment and receipt header information , implementation_dba_data: PO.RCV_SHIPMENT_HEADERS ,
Table: RCV_TRANSACTIONS_INTERFACE 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_TRANSACTIONS_INTERFACE, object_name:RCV_TRANSACTIONS_INTERFACE, status:VALID, product: PO - Purchasing , description: Receiving transactions interface table , implementation_dba_data: PO.RCV_TRANSACTIONS_INTERFACE ,
TABLE: JA.JAI_CMN_LINES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_LINES, object_name:JAI_CMN_LINES, status:VALID,
PACKAGE BODY: APPS.JAI_AP_MATCH_TAX_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_AP_MATCH_TAX_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_RCV_RT_TRIGGER_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_RCV_RT_TRIGGER_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_PO_HOOK_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_PO_HOOK_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_PO_HOOK_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_PO_HOOK_PKG, status:VALID,
Table: RCV_TRANSACTIONS_INTERFACE 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_TRANSACTIONS_INTERFACE, object_name:RCV_TRANSACTIONS_INTERFACE, status:VALID, product: PO - Purchasing , description: Receiving transactions interface table , implementation_dba_data: PO.RCV_TRANSACTIONS_INTERFACE ,
PACKAGE BODY: APPS.JAI_AP_MATCH_TAX_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_AP_MATCH_TAX_PKG, status:VALID,
PACKAGE BODY: APPS.JAI_AP_ST_REVERSE_PROCESS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_AP_ST_REVERSE_PROCESS, status:VALID,
Table: RCV_SHIPMENT_LINES 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SHIPMENT_LINES, object_name:RCV_SHIPMENT_LINES, status:VALID, product: PO - Purchasing , description: Receiving shipment line information , implementation_dba_data: PO.RCV_SHIPMENT_LINES ,
PACKAGE BODY: APPS.JAI_RCV_TAX_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_RCV_TAX_PKG, status:VALID,
Table: RCV_SHIPMENT_LINES 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.RCV_SHIPMENT_LINES, object_name:RCV_SHIPMENT_LINES, status:VALID, product: PO - Purchasing , description: Receiving shipment line information , implementation_dba_data: PO.RCV_SHIPMENT_LINES ,
PACKAGE BODY: APPS.JAI_RCV_TAX_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_RCV_TAX_PKG, status:VALID,
Table: PO_LINE_LOCATIONS_ALL 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_ALL, object_name:PO_LINE_LOCATIONS_ALL, status:VALID, product: PO - Purchasing , description: Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINE_LOCATIONS_ALL ,
Table: PO_LINE_LOCATIONS_ALL 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINE_LOCATIONS_ALL, object_name:PO_LINE_LOCATIONS_ALL, status:VALID, product: PO - Purchasing , description: Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINE_LOCATIONS_ALL ,
VIEW: APPS.JAI_PO_RCV_TAXES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_PO_RCV_TAXES_V, object_name:JAI_PO_RCV_TAXES_V, status:VALID,
Table: PO_LINES_ALL 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_ALL, object_name:PO_LINES_ALL, status:VALID, product: PO - Purchasing , description: Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINES_ALL ,
Table: PO_LINES_ALL 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_LINES_ALL, object_name:PO_LINES_ALL, status:VALID, product: PO - Purchasing , description: Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_LINES_ALL ,
Table: PO_HEADERS_ALL 12.2.2
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_HEADERS_ALL, object_name:PO_HEADERS_ALL, status:VALID, product: PO - Purchasing , description: Document headers (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_HEADERS_ALL ,
12.1.1 FND Design Data 12.1.1
Table: PO_HEADERS_ALL 12.1.1
owner:PO, object_type:TABLE, fnd_design_data:PO.PO_HEADERS_ALL, object_name:PO_HEADERS_ALL, status:VALID, product: PO - Purchasing , description: Document headers (for purchase orders, purchase agreements, quotations, RFQs) , implementation_dba_data: PO.PO_HEADERS_ALL ,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 FND Design Data 12.2.2
APPS.JAI_PO_HOOK_PKG SQL Statements 12.1.1
APPS.JAI_PO_HOOK_PKG SQL Statements 12.2.2
VIEW: APPS.JAI_PO_RCV_TAXES_V 12.2.2
View: JAI_PO_RCV_TAXES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:JA.JAI_PO_RCV_TAXES_V, object_name:JAI_PO_RCV_TAXES_V, status:VALID, product: JA - Asia/Pacific Localizations , description: View for PO RCV taxes , implementation_dba_data: APPS.JAI_PO_RCV_TAXES_V ,
APPS.JAI_RCV_RT_TRIGGER_PKG SQL Statements 12.2.2
APPS.JAI_RCV_TAX_PKG dependencies on JAI_CMN_LINES 12.2.2
APPS.JAI_RCV_RT_TRIGGER_PKG dependencies on JAI_CMN_LINES 12.2.2
APPS.JAI_AP_MATCH_TAX_PKG dependencies on JAI_CMN_LINES 12.1.1
APPS.JAI_RCV_TAX_PKG dependencies on JAI_CMN_LINES 12.1.1
APPS.JAI_PO_HOOK_PKG dependencies on JAI_CMN_LINES 12.1.1
APPS.JAI_AP_MATCH_TAX_PKG dependencies on JAI_CMN_LINES 12.2.2
APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on JAI_CMN_LINES 12.2.2
APPS.JAI_PO_HOOK_PKG dependencies on JAI_CMN_LINES 12.2.2
APPS.JAI_RCV_TAX_PKG SQL Statements 12.2.2
PACKAGE BODY: APPS.JAI_PO_HOOK_PKG 12.2.2
PACKAGE BODY: APPS.JAI_PO_HOOK_PKG 12.1.1