Results for “project_organization”

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

Overview

The PA_CAPITAL_PROJECTS_BASE_V view (owner: APPS, status: VALID) is a Projects (PA) module object that presents summary capital amounts for a project. Its documented description reads: "R10SC Only - Base view that shows summary capital amounts for a project." It consolidates, at the project level, the capitalizable and total costs accumulated against capital projects alongside the asset-interface attributes defined on the project type. The view is a base view: it supplies the denormalized, join-ready result set that other capital-project reporting views and capital asset interface processes build upon, rather than exposing granular transactions itself.

Because capital project reporting must reconcile two distinct sources of capital amounts — accumulated cost transactions and already-capitalized asset amounts — the view is defined as a UNION ALL of two queries. The first returns projects with cost accumulation data; the second returns projects with capitalized asset records. This makes it the canonical starting point for queries that need a single, unified picture of capital-project financial position.

Underlying Base Objects

The view is defined over the following documented base objects:

• PA_PROJECTS_ALL — the project definition, supplying name, segment, status, type, asset allocation method, capital event processing, and carrying-out organization.
• PA_PROJECT_TYPES_ALL — the project type, supplying INTERFACE_COMPLETE_ASSET_FLAG, INTERFACE_ASSET_COST_CODE, CAPITAL_COST_TYPE_CODE, BURDEN_AMT_DISPLAY_METHOD, and TOTAL_BURDEN_FLAG.
• PA_PROJECT_ACCUM_HEADERS / PA_PROJECT_ACCUM_ACTUALS — project-level accumulation buckets providing RAW_COST_ITD, BILLABLE_RAW_COST_ITD, BURDENED_COST_ITD, and BILLABLE_BURDENED_COST_ITD. The join constrains TASK_ID = 0 and RESOURCE_ID = 0, i.e., project-level totals only.
• PA_PROJECT_ASSETS — already-capitalized amounts (CAPITALIZED_COST) returned by the second branch of the union.
• HR_ORGANIZATION_UNITS — resolves the carrying-out organization name; secured via HR_SECURITY and HR_GENERAL.
• PA_TXN_ACCUM and PJI_FP_XBS_ACCUM_F — additional accumulation objects referenced in the dependency metadata.

Filtering ensures only non-template projects (TEMPLATE_FLAG <> 'Y') with project type class CAPITAL are selected, and excludes projects where PJI_SOURCE_FLAG is not null.

Key Columns

• PROJECT_ID / NAME / SEGMENT1 — project identifier, name, and number.
• PROJECT_STATUS_CODE / PROJECT_TYPE — lifecycle status and type.
• INTERFACE_COMPLETE_ASSET_FLAG / INTERFACE_ASSET_COST_CODE — control whether costs interface to Fixed Assets and which cost code is used.
• ORG_NAME — name of the carrying-out organization.
• CAPITALIZABLE_COST — derived via DECODE on CAPITAL_COST_TYPE_CODE: billable raw or billable burdened cost ITD.
• TOTAL_COST — derived via DECODE: raw or burdened cost ITD.
• CAPITALIZED_COST — capitalized amount from PA_PROJECT_ASSETS (second union branch).
• ASSET_ALLOCATION_METHOD / CAPITAL_EVENT_PROCESSING — defaulted to 'N' when null.
• CAPITAL_COST_TYPE_CODE / BURDEN_AMT_DISPLAY_METHOD / TOTAL_BURDEN_FLAG — cost-type and burden display attributes.

Common Use Cases and Queries

Typical uses include capital-project cost reviews, asset-interface readiness checks, and reconciling accumulated cost against capitalized amounts.

• Capital amounts by project: SELECT project_id, name, segment1, capitalizable_cost, total_cost, capitalized_cost FROM pa_capital_projects_base_v;
• Projects pending asset interface: SELECT segment1, name, interface_complete_asset_flag FROM pa_capital_projects_base_v WHERE interface_complete_asset_flag = 'N';
• Reconcile accumulated vs capitalized: SELECT segment1, total_cost, capitalized_cost FROM pa_capital_projects_base_v WHERE total_cost <> capitalized_cost;

Because the view is documented as "R10SC Only," treat it as a legacy compatibility object; confirm its presence in the target release before relying on it in custom reporting.