Results for “por_tax_code_lov_v”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
POR_TAX_CODE_LOV_V is a lightweight database view owned by the Oracle iProcurement module (product code ICX). Its documented purpose is simply to "get tax codes," and it functions as the value-set backing for the tax code list of values presented to users during iProcurement self-service requisition and shopping flows. When a requester enters a requisition line and selects a tax classification, iProcurement must constrain the available choices to tax codes that are active and enabled as of the current date. This view performs that filtering on behalf of the LOV, returning only valid, currently effective tax codes for selection.
Because it is defined with a simple projection over a single Oracle Payables table, the view also serves as a convenient read-only reporting object. Users searching for "ap_tax_codes" typically arrive at this view because the ETRM documentation cross-references the base table AP_TAX_CODES, from which the view derives every column it exposes. It contains no procedural logic, no PL/SQL, and no joins, making it inexpensive to query and safe for ad-hoc extraction of tax code reference data.
Underlying Base Objects
The documented view text is:
SELECT TAX_ID, NAME, TAX_RATE, DESCRIPTION FROM AP_TAX_CODES WHERE SYSDATE BETWEEN CREATION_DATE AND NVL(INACTIVE_DATE, SYSDATE) AND ENABLED_FLAG='Y' ORDER BY NAME
The sole referenced base object is AP_TAX_CODES, the Oracle Payables table that stores the definition of every tax code (name, rate, effective dates, enabled flag, and related accounting configuration). The view applies three filters: the current system date must fall within the code's active window (created on or before today, and not past its inactive date), and the ENABLED_FLAG must equal 'Y'. Rows are returned in ascending order of tax code name. No other tables, synonyms, or database links are documented as underlying objects, and the ETRM metadata records the view as not implemented in the source database and lists no additional referenced base objects beyond this Payables table.
Key Columns
The ETRM metadata documents a column set whose names differ slightly from the raw SELECT list, reflecting the LOV's published interface rather than the column aliases in the view text:
TAX_CODE_ID— maps toTAX_IDin the underlying query; the unique identifier of the tax code and the value normally returned to the calling form or page.TAX_CODE— maps toNAME; the user-visible tax code name, displayed in the LOV and used for ordering.TAX_RATE— the percentage rate associated with the tax code, returned directly fromAP_TAX_CODES.TAX_DESCRIPTION— maps toDESCRIPTION; free-text descriptive information about the tax code.
Collectively these columns provide the identifier, display name, rate, and description required to render and interpret a tax code selection. Because the view filters on effective dates and the enabled flag, every row returned is, by construction, currently usable.
Common Use Cases and Queries
The primary use case is resolving the tax code list of values during iProcurement requisition entry, but the view is equally useful for validation and reporting. A typical extraction query is:
SELECT TAX_CODE_ID, TAX_CODE, TAX_RATE, TAX_DESCRIPTION FROM POR_TAX_CODE_LOV_V;
To confirm that a specific tax code is currently selectable:
SELECT TAX_CODE, TAX_RATE FROM POR_TAX_CODE_LOV_V WHERE TAX_CODE = :p_tax_code;
Because the view pre-filters on CREATION_DATE, INACTIVE_DATE, and ENABLED_FLAG, queries against it never return disabled or expired codes, unlike direct queries on AP_TAX_CODES, which would require the same predicates to be written manually. For audit or historical reporting where inactive codes must be visible, query the base table instead. Note that the ETRM metadata documents this view as "not implemented in this database," so verify its presence in the target instance before relying on it in custom code.
-
View: POR_TAX_CODE_LOV_V 12.2.2
View to get tax codes
Not implemented in this database·Explore ICX module →
-
View: POR_TAX_CODE_LOV_V 12.1.1
View to get tax codes
Not implemented in this database·Explore ICX module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2