Search Results pji_currency_types_v

Overview

PJI_CURRENCY_TYPES_V is a database view owned by the APPS schema in Oracle E-Business Suite and is delivered as part of the PJI (Project Intelligence) product family. Per the ETRM metadata, the object is classified as a VALID view whose stated purpose is to serve as an "internal summarization view." It does not represent a transactional entity in its own right; rather, it consolidates currency information sourced from Project Accounting implementations, the General Ledger set of books, and the FII currency listing so that Project Intelligence reporting can resolve a single, normalized currency value for a given operating unit context.

Functionally, the view flattens two logically distinct currency sources — the set-of-books currency attached to each PA implementation, and the internal global currency designation (FII_GLOBAL1) — into a uniform three-column projection of ORG_ID, ID, and VALUE. A user searching for fii_currencies_v is typically attempting to locate where currency values used by Project Intelligence originate; PJI_CURRENCY_TYPES_V is the downstream summarization layer that references FII_CURRENCIES_V rather than the base currency view itself.

Underlying Base Objects

The view is defined over three referenced objects, all accessed through the APPS schema (the ETRM metadata records no separately documented base tables, but the embedded view text identifies them explicitly):

• FII_CURRENCIES_V — the FII currency listing view, which supplies the VALUE column and the identifying token FII_GLOBAL1 for the global branch of the union.
• PA_IMPLEMENTATIONS_ALL — the Project Accounting implementations table, which supplies ORG_ID and links each operating unit to its set of books through SET_OF_BOOKS_ID.
• GL_SETS_OF_BOOKS — the General Ledger set of books table, joined to PA_IMPLEMENTATIONS_ALL on SET_OF_BOOKS_ID to obtain CURRENCY_CODE, which is matched against FII_CURRENCIES_V.ID.

The body is a two-branch UNION. The first branch returns operating-unit-specific rows keyed by ORG_ID with a literal indicator of 'F', joining PA_IMPLEMENTATIONS_ALL to GL_SETS_OF_BOOKS. The second branch returns a single global row with a NULL ORG_ID and a literal indicator of 'G', selecting the value where FII_CURRENCIES_V.ID = 'FII_GLOBAL1'. This union structure allows consumers to distinguish per-organization currency settings from the system-wide default.

Key Columns

• ORG_ID — the operating unit identifier for the organization-scoped branch. It is populated from PA_IMPLEMENTATIONS_ALL.ORG_ID and is NULL for the global branch, so null checking is a reliable way to separate the two row classes.
• ID — a literal character flag indicating row type: 'F' denotes a currency derived from the implementation's set of books, and 'G' denotes the global FII currency entry.
• VALUE — the actual currency value string sourced from FII_CURRENCIES_V.VALUE. In the organization branch it corresponds to the set-of-books currency code; in the global branch it corresponds to the FII_GLOBAL1 entry.

Common Use Cases and Queries

The view is principally consumed by Project Intelligence concurrent programs, BI Publisher data templates, and custom project reporting that requires a currency context per operating unit without directly joining Project Accounting and General Ledger tables. A representative query retrieving all organizational currency assignments is:

SELECT ORG_ID, ID, VALUE FROM APPS.PJI_CURRENCY_TYPES_V WHERE ID = 'F';

To retrieve the global fallback currency, filter on the alternate literal:

SELECT VALUE FROM APPS.PJI_CURRENCY_TYPES_V WHERE ID = 'G';

Because the underlying joins traverse PA_IMPLEMENTATIONS_ALL and GL_SETS_OF_BOOKS, the view respects the set-of-books configuration for each operating unit and will return only those organizations with a valid implementation record. Reports that must render a currency for every operating unit should therefore left-join this view to the organization list and fall back to the ID = 'G' row when no ORG_ID match exists.