Search Results exp_organization_name




Overview
Explore in AI Chat

Overview

APPS.PA_XLA_COST_V is a denormalized reporting view in the Oracle E-Business Suite Projects (PA) application, owned by the APPS schema and registered under FND Design Data as PA.PA_XLA_COST_V. The object is a VIEW of type Internal with status VALID in both EBS 12.1.1 and 12.2.2. Its purpose is to expose project expenditure cost lines in a flattened, human-readable form suitable for Subledger Accounting (XLA) extraction, cost distribution reporting, and downstream warehouse loads. The view consolidates identifying and descriptive attributes for each expenditure item, including concatenated project, task, and award identifiers together with expenditure classification and incurring organization.

The view is flagged by Oracle as Internal Use Only; Oracle Corporation does not support customer access to the underlying applications data through this object except from standard Oracle Applications programs. The view is not referenced by any other database object, so it functions as a terminal reporting surface rather than a dependency of further application logic.

Underlying Base Objects

The view is defined over the following documented base objects, all resolved as APPS synonyms in 12.2.2:

The join of expenditure items to expenditure types, projects, tasks, and organization units produces one row per expenditure item with descriptive context attached.

Key Columns

Common Use Cases and Queries

Typical uses include cost-line extracts for XLA reconciliation, organization-level expenditure analysis, and grant award cost reporting. The recorded query text is:

SELECT EXPENDITURE_ITEM_ID
     , PROJECT_NAME_NUM_CONCAT
     , TASK_NAME_NUM_CONCAT
     , AWARD_NAME_NUM_CONCAT
     , EXPENDITURE_TYPE
     , EXPENDITURE_TYPE_CLASS
     , EXPENDITURE_CATEGORY
     , EXPENDITURE_ITEM_DATE
     , EXP_ORGANIZATION_NAME
     , NON_LABOR_RESOURCE
  FROM APPS.PA_XLA_COST_V;

A filtered variant matching the user's search term retrieves items incurred by a specific organization:

SELECT EXPENDITURE_ITEM_ID
     , PROJECT_NAME_NUM_CONCAT
     , EXPENDITURE_TYPE
     , EXPENDITURE_ITEM_DATE
     , EXP_ORGANIZATION_NAME
  FROM APPS.PA_XLA_COST_V
 WHERE EXP_ORGANIZATION_NAME = :p_org_name
   AND EXPENDITURE_ITEM_DATE BETWEEN :p_start AND :p_end;

Because the view is unsupported for direct customer access, production use should be restricted to read-only reporting, and organizations should consider building supported extracts or custom views over the base PA tables where long-term stability is required.