Search Results recovered_amount




Overview
Explore in AI Chat

Overview

APPS.JAI_RCV_RGM_HEADERS_V is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, shipped as part of the Oracle Financials for India (JAI) product family and documented within the ETRM repository. The view presents recoverable and recovered tax amounts associated with receipt transactions at the receipt header level, aggregating detailed line-level records into a single summarized row per receiving shipment. Its purpose is to support reporting and reconciliation of recoverable indirect taxes captured during the receiving process, most notably the taxes tracked against vendor invoices that relate to goods received. Because the recoverable amount is a central element of indirect tax recovery and input tax credit reporting, the view is commonly consumed by tax consolidation programs, reconciliation reports, and custom integrations that require a consolidated header-level picture of recoverable and recovered tax values.

Underlying Base Objects

The view is defined over a single documented base object, the synonym JAI_RCV_RGM_LINES. All columns published by the view are derived from that source by grouped aggregation. The view performs a GROUP BY over organization_id, location_id, receipt_num, and shipment_header_id, which collapses the many line records held in JAI_RCV_RGM_LINES into one row for each unique combination of inventory organization, location, receipt number, and shipment header. Aggregated measures are produced with SUM and NVL to guarantee non-null numeric results, while COUNT DISTINCT and COUNT provide the cardinality metrics that describe the composition of the underlying lines. The dependency on a synonym indicates that the view is intended to be resolved through the APPS schema's synonym layer, which is standard Oracle EBS practice.

Key Columns

  • ORGANIZATION_ID — Inventory organization that owns the receipt; primary grouping key.
  • LOCATION_ID — Location associated with the receipt; secondary grouping key.
  • RECEIPT_NUM — Receiving receipt number identifying the shipment at the transactional level.
  • SHIPMENT_HEADER_ID — Internal identifier of the shipment header, allowing joins to receiving tables.
  • RECOVERABLE_AMOUNT — Sum of recoverable tax amounts on the underlying lines, defaulted to zero via NVL(SUM(...),0).
  • RECOVERED_AMOUNT — Sum of already-recovered amounts on the underlying lines, likewise defaulted to zero.
  • CNT_INVOICE_NO — Count of distinct vendor invoice numbers referenced by the line records.
  • CNT_INVOICE_DATE — Count of distinct invoice dates appearing on the lines.
  • CNT_VENDOR_ID — Count of distinct vendors contributing lines to the shipment header.
  • CNT_VENDOR_SITE_ID — Count of distinct vendor sites contributing lines.
  • TOTAL_LINES — Total number of underlying line records for the grouping.
  • LINES_WO_VAT_DETAILS — Count of lines with no associated invoice number, computed with SUM(DECODE(invoice_no, NULL, 1, 0)); indicates lines lacking VAT detail coverage.

Common Use Cases and Queries

The most typical usage is reconciliation of recoverable tax against recovered tax for received shipments, and identification of lines that are missing VAT details so that data can be corrected before tax reporting. A representative query selecting from the view for a specific organization is shown below:

SELECT receipt_num, shipment_header_id, recoverable_amount, recovered_amount, total_lines, lines_wo_vat_details FROM apps.jai_rcv_rgm_headers_v WHERE organization_id = :org_id AND lines_wo_vat_details > 0 ORDER BY receipt_num;

The view is also frequently used to summarize tax recovery by vendor or location, for example summing recoverable_amount grouped by location_id or by the distinct vendor counts exposed on each row. Integration programs may join the view back to receiving headers and inventory organizations to enrich reports, while tax dashboards use the gap between recoverable_amount and recovered_amount as a key performance indicator of outstanding tax recovery.