Search Results task_billable_flag

Overview

The APPS.PA_XLA_TASK_REF_V view is a Projects (PA) module reference object delivered in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes a denormalized, reporting-friendly projection of project task data combined with carrying-out organization details and top-task hierarchy information. Its name and structure indicate that it serves as a task reference source for Oracle Subledger Accounting (XLA) and Projects-related reporting, where task-level identifiers, descriptive attributes, and descriptive flexfield values must be presented in a single queryable structure without joins performed by the consuming report or integration.

The view is documented in ETRM as a VALID view owned by APPS. It is particularly relevant to users searching for "task_attribute_category," because it exposes the PA_TASKS.ATTRIBUTE_CATEGORY column as TASK_ATTRIBUTE_CATEGORY alongside the ten corresponding descriptive flexfield segments (TASK_ATTRIBUTE1 through TASK_ATTRIBUTE10). This makes the view a convenient access point for task-level DFF data in reporting and interface contexts.

Underlying Base Objects

The view text is defined over three objects:

• PA_TASKS T — the primary source, supplying the task identifier, number, name, carrying-out organization, service type, top task reference, billable and retirement flags, and the attribute category and segments 1–10.
• PA_TASKS TT — a self-join on PA_TASKS used to resolve the parent (top) task number and name via TT.TASK_ID = T.TOP_TASK_ID.
• HR_ORGANIZATION_INFORMATION I1 — an outer-joined source supplying organization information for the carrying-out organization. The join is restricted to ORG_INFORMATION_CONTEXT = 'COMPANY COST CENTER', and the (+) outer-join syntax allows tasks without a matching organization information row to be returned with null organization values.

In ETRM 12.2.2, the referenced base objects are documented as HR_ORGANIZATION_INFORMATION (SYNONYM) and PA_TASKS (SYNONYM), consistent with the APPS synonym layer used by the view definition.

Key Columns

• TASK_ID, TASK_NUMBER, TASK_NAME — the unique task identifier and its descriptive identifiers.
• TASK_ORGANIZATION_ID, TASK_ORG_COMPANY, TASK_ORG_COST_CENTER — the carrying-out organization and its company and cost center classifications, derived from ORG_INFORMATION3 and ORG_INFORMATION5 respectively.
• TASK_SERVICE_TYPE_CODE — the service type associated with the task.
• TOP_TASK_ID, TOP_TASK_NUMBER, TOP_TASK_NAME — the parent task hierarchy, resolved through the PA_TASKS self-join.
• TASK_BILLABLE_FLAG, TASK_RETIREMENT_FLAG — billable and retirement cost indicators.
• TASK_ATTRIBUTE_CATEGORY — the descriptive flexfield context for the task, sourced from PA_TASKS.ATTRIBUTE_CATEGORY.
• TASK_ATTRIBUTE1 … TASK_ATTRIBUTE10 — the ten DFF segments corresponding to the active attribute category.

Common Use Cases and Queries

Typical uses include task-level reporting, XLA reference lookups, and extraction of task descriptive flexfield values. A common query retrieves tasks associated with a given attribute category along with their parent task context:

• SELECT task_id, task_number, task_name, top_task_number, task_attribute_category, task_attribute1, task_attribute2 FROM pa_xla_task_ref_v WHERE task_attribute_category = :category;
• SELECT task_number, task_name, task_org_company, task_org_cost_center FROM pa_xla_task_ref_v WHERE task_billable_flag = 'Y';
• SELECT t.task_id, t.task_number, t.top_task_name, t.task_attribute_category FROM pa_xla_task_ref_v t WHERE t.task_attribute_category IS NOT NULL;

Because the view embeds the top-task and organization joins, it eliminates the need for consumers to reconstruct the parent hierarchy or organization context, making it suitable for direct reporting against Projects task data.