Results for “other_cenvat_claimed_amt”

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

Overview

JAI_MTL_CVAT_V is a reporting view owned by the APPS schema and shipped as part of the JA – Asia/Pacific Localizations product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to consolidate excise, CENVAT (Central Value Added Tax), and VAT recovery information associated with inventory receiving transactions so that Indian localization tax reporting and downstream integration can present a single, unified result set. In the ETRM reference repository the object is recorded with status VALID and is catalogued under object type VIEW.

The view is particularly relevant to users who search for cenvat_claimed_ptg, since that column appears directly in the view definition and reflects the percentage of CENVAT claimed against a receipt line. By joining receiving transactions to their CENVAT claim and RGM (recoverable amount) records, the view exposes both CENVAT and VAT recovery percentages side by side, which is essential for reconciliation and statutory reporting.

Underlying Base Objects

The ETRM 12.2.2 metadata documents three referenced base objects, all exposed through synonyms in the APPS schema:

• JAI_RCV_TRANSACTIONS — the receiving transaction source, supplying RECEIPT_NUM, QUANTITY, ORGANIZATION_ID, INVENTORY_ITEM_ID, SHIPMENT_LINE_ID, TRANSACTION_ID, excise invoice attributes, and item classification.
• JAI_RCV_CENVAT_CLAIMS — the CENVAT claim source, providing CENVAT_CLAIMED_PTG, QUANTITY_FOR_2ND_CLAIM, CENVAT_AMT_FOR_2ND_CLAIM, claimed and other CENVAT amounts, and CENVAT_AMOUNT.
• JAI_RCV_RGM_LINES — the recoverable-amount source, providing RECOVERED_AMOUNT, RECOVERABLE_AMOUNT, receive and RTV quantities, and INVOICE_NO.

The view text is a three-branch UNION. Each branch filters on ITEM_CLASS IN ('CGIN','CGEX') and TRANSACTION_TYPE='RECEIVE', and uses mutually exclusive NOT EXISTS predicates so that a shipment line is reported once: CENVAT lines without an RGM match, RGM lines without a CENVAT match, and lines where both exist. The third branch combines both recovery streams.

Key Columns

• RECEIPT_NUM, QUANTITY, ORGANIZATION_ID, INVENTORY_ITEM_ID — identify the receipt and item.
• CENVAT_CLAIMED_PTG — the percentage of CENVAT claimed on the line; central to the user's search.
• VAT_CLAIMED_PTG — computed as ROUND((RECOVERED_AMOUNT/RECOVERABLE_AMOUNT)*100,2).
• CENVAT_QTY_AVAILABLE and VAT_QTY — quantities eligible for a subsequent claim.
• CENVAT_CLAIMED_AMT, OTHER_CENVAT_CLAIMED_AMT, CENVAT_AMOUNT, OTHER_CENVAT_AMT — monetary recovery figures.
• SHIPMENT_LINE_ID and TRANSACTION_ID — join keys to receiving and inventory transactions.
• EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE, VAT_INVOICE_NO — statutory invoice references.

Common Use Cases and Queries

Typical scenarios include reconciling CENVAT percentages against receipts, reporting VAT recovery where no CENVAT claim exists, and extracting invoice-level tax detail for localization returns.

SELECT receipt_num, quantity, cenvat_claimed_ptg, cenvat_claimed_amt
FROM   apps.jai_mtl_cvat_v
WHERE  cenvat_claimed_ptg <> 0;

SELECT receipt_num, vat_claimed_ptg, vat_qty, vat_invoice_no
FROM   apps.jai_mtl_cvat_v
WHERE  vat_claimed_ptg IS NOT NULL;

The view is read-only and should be queried rather than modified; performance depends on the joins across the three underlying JA receiving tables.