Results for “igi_cis_pmt_vch_v”

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

Overview

IGI_CIS_PMT_VCH_V is an APPS-owned database view in Oracle E-Business Suite Release 12.1.1 and 12.2.2, delivered as part of the IGI – Public Sector Financials International product. Its documented purpose is to display Construction Industry Scheme (CIS) payment voucher details by vendor site. The view presents a deduplicated, reporting-oriented projection of CIS payment voucher information, exposing the vendor, ledger, vendor site, voucher number, amount, receipt date, and description attributes that are relevant to CIS payment voucher processing and reconciliation.

Because the view is defined over another CIS view rather than over base transaction tables directly, it functions as a simplified presentation layer for downstream reporting, extracts, and integrations. In EBS 12.1.1 and 12.2.2 the object remains VALID in the APPS schema, and consumers should treat it as a read-only reporting artifact rather than a table that may be written to.

Underlying Base Objects

The documented base objects referenced by IGI_CIS_PMT_VCH_V are:

• IGI_CIS_CERT_INV_PMT_VCH_V (VIEW) – the source view from which all columns are selected.
• FND_GLOBAL (PACKAGE) – the standard EBS package supplying runtime context such as organization, user, and application identifiers.
• IGI_CIS_GET_PROFILE (PACKAGE) – the CIS profile option access package used to resolve CIS-related system profile values at runtime.

The view text is a straightforward projection: SELECT DISTINCT VENDOR_ID, SET_OF_BOOKS_ID, VENDOR_SITE_ID, PMT_VCH_NUMBER, PMT_VCH_AMOUNT, PMT_VCH_RECEIVED_DATE, PMT_VCH_DESCRIPTION FROM IGI_CIS_CERT_INV_PMT_VCH_V WHERE PMT_VCH_NUMBER IS NOT NULL. The DISTINCT operator collapses duplicate rows that may arise in the underlying certification, invoice, and payment voucher join, and the predicate on PMT_VCH_NUMBER excludes records that have not yet been associated with a payment voucher number. The references to FND_GLOBAL and IGI_CIS_GET_PROFILE indicate that the source view applies EBS session and profile context, which propagates to this view when queried.

Key Columns

• VENDOR_ID – identifier of the supplier against whom the CIS payment voucher is recorded.
• SET_OF_BOOKS_ID – the ledger identifier under which the voucher amount is accounted.
• VENDOR_SITE_ID – the supplier site for which the voucher detail is reported, consistent with the view's by-vendor-site description.
• PMT_VCH_NUMBER – the CIS payment voucher number; rows with a null value are filtered out.
• PMT_VCH_AMOUNT – the monetary amount associated with the payment voucher.
• PMT_VCH_RECEIVED_DATE – the date the payment voucher was received.
• PMT_VCH_DESCRIPTION – free-text description of the payment voucher.

Common Use Cases and Queries

Typical usage includes CIS payment voucher listings per supplier site, ledger-level reconciliation of voucher amounts, and feeds into custom extracts or reports. A representative query joining to supplier and ledger reference objects follows:

• SELECT v.PMT_VCH_NUMBER, v.VENDOR_ID, v.VENDOR_SITE_ID, v.SET_OF_BOOKS_ID, v.PMT_VCH_AMOUNT, v.PMT_VCH_RECEIVED_DATE, v.PMT_VCH_DESCRIPTION FROM APPS.IGI_CIS_PMT_VCH_V v WHERE v.VENDOR_SITE_ID = :p_vendor_site_id ORDER BY v.PMT_VCH_RECEIVED_DATE;
• SELECT VENDOR_SITE_ID, SET_OF_BOOKS_ID, SUM(PMT_VCH_AMOUNT) TOTAL_AMOUNT FROM APPS.IGI_CIS_PMT_VCH_V GROUP BY VENDOR_SITE_ID, SET_OF_BOOKS_ID;
• SELECT * FROM APPS.IGI_CIS_PMT_VCH_V WHERE PMT_VCH_RECEIVED_DATE BETWEEN :p_from_date AND :p_to_date;

Because the view depends on runtime profile and session context through FND_GLOBAL and IGI_CIS_GET_PROFILE, results can vary with the querying responsibility and profile configuration. Access should be granted through standard APPS synonym and grant conventions, and any extensions should avoid duplicating the DISTINCT logic that this view already applies.