Results for “rev_rate_type”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_MC_BUDGET_LINES is a Projects (PA) module table that stores project budget lines converted into the reporting currencies of every reporting set of books associated with a primary set of books. In Oracle EBS multi-currency and multi-organization reporting scenarios, transactional data is maintained in the functional (primary) currency, and this table provides the equivalent raw cost, burdened cost, and revenue amounts expressed in each reporting currency. Its native key is composite: the budget line identifier combined with the set of books identifier, which allows the same source budget line to exist once per reporting set of books. The table is populated and maintained by concurrent processes, evidenced by the REQUEST_ID column, which links generated rows back to a specific concurrent request.
From a Data Vault modeling perspective, the documented foreign key structure suggests this object is best characterized as a link table. It resolves the many-to-many relationship between budget lines (PA_BUDGET_LINES) and reporting sets of books (GL_SETS_OF_BOOKS_11I), while carrying descriptive currency-conversion attributes. The conversion-oriented columns (rate types, conversion dates, exchange rates, converted amounts) are satellite-style attributes attached to that link, but the composite key behavior places the object firmly in the link classification.
Key Information Stored
The most significant columns are:
- BUDGET_LINE_ID — Identifier of the source budget line; also the business-key candidate when combined with SET_OF_BOOKS_ID.
- SET_OF_BOOKS_ID — The reporting set of books for which the converted amounts are held.
- REPORTING_CURRENCY_CODE — Currency of the converted amounts; foreign key to FND_CURRENCIES.
- RAW_COST — Raw cost amount expressed in the reporting currency.
- BURDENED_COST — Burdened cost amount expressed in the reporting currency.
- REVENUE — Revenue amount expressed in the reporting currency.
- COST_RATE_TYPE / COST_RATE_DATE_TYPE — Daily conversion rate type and rate date basis used for cost conversion.
- COST_CONVERSION_DATE / COST_EXCHANGE_RATE — Date and rate applied to convert cost.
- REV_RATE_TYPE / REV_RATE_DATE_TYPE — Rate type and rate date basis used for revenue conversion.
- REV_CONVERSION_DATE / REV_EXCHANGE_RATE — Date and rate applied to convert revenue.
- PROJECT_ID — Project to which the budget line belongs; foreign key to PA_PROJECTS_ALL.
- REQUEST_ID — Concurrent request that created or refreshed the row.
- Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.
The surrogate unique index PA_MC_BUDGET_LINES_U1 is defined on (BUDGET_LINE_ID, SET_OF_BOOKS_ID), and the primary key constraint PA_MC_BUDGET_LINES_PK uses the same columns.
Common Use Cases and Queries
A frequent requirement is retrieving converted budget amounts for a specific reporting set of books, which is where the budget_line_id search term typically surfaces.
- Reporting converted budget cost and revenue by project and reporting currency.
- Reconciling reporting-currency budgets against the primary-set-of-books values in PA_BUDGET_LINES.
- Auditing conversion rate usage across budget versions during period-close reviews.
SELECT mc.budget_line_id,
mc.set_of_books_id,
mc.reporting_currency_code,
mc.raw_cost,
mc.burdened_cost,
mc.revenue
FROM pa_mc_budget_lines mc
WHERE mc.budget_line_id = :budget_line_id
AND mc.set_of_books_id = :set_of_books_id;
Joining to the source budget line and project aids traceability:
SELECT p.project_number,
mc.reporting_currency_code,
SUM(mc.burdened_cost) AS burdened_cost,
SUM(mc.revenue) AS revenue
FROM pa_mc_budget_lines mc,
pa_projects_all p
WHERE mc.project_id = p.project_id
AND mc.set_of_books_id = :set_of_books_id
GROUP BY p.project_number, mc.reporting_currency_code;
Related Objects
- PA_BUDGET_LINES — Source budget lines; joined on BUDGET_LINE_ID.
- PA_BUDGET_VERSIONS — Budget version context; joined via BUDGET_LINE_ID / BUDGET_VERSION_ID.
- PA_PROJECTS_ALL — Project master; joined on PROJECT_ID.
- GL_SETS_OF_BOOKS_11I — Reporting set of books definition; joined on SET_OF_BOOKS_ID.
- FND_CURRENCIES — Currency validation; joined on REPORTING_CURRENCY_CODE.
- GL_DAILY_CONVERSION_TYPES — Rate type validation for both COST_RATE_TYPE and REV_RATE_TYPE.
- FND_CONCURRENT_REQUESTS — Request traceability via REQUEST_ID.
-
This table stores budget lines for all the reporting set of books associated with primary set of books. The raw cost, burdened cost and revenue amounts are converted to the respective reporting currencies
-
This table stores budget lines for all the reporting set of books associated with primary set of books. The raw cost, burdened cost and revenue amounts are converted to the respective reporting currencies
-
VIEW: PA.PA_MC_BUDGET_LINES# 12.2.2
-
VIEW: PA.PA_MC_BUDGET_LINES# 12.2.2
-
TABLE: PA.PA_MC_BUDGET_LINES 12.2.2
-
TABLE: PA.PA_MC_BUDGET_LINES 12.1.1
-
eTRM - PA Tables and Views 12.1.1
-
eTRM - PA Tables and Views 12.2.2