Search Results taskfunc_cost_rate_date




Overview
Explore in AI Chat

Overview

PA_WBS_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The ETRM metadata identifies it as a 10SC-only retrofitted object, meaning it originated from a 10 Smart Client customization or interim release and was subsequently carried forward into the EBS schema rather than being a standard, universally shipped view. Its status is VALID, confirming it is compiled and queryable in the documented environments.

The view exposes Work Breakdown Structure (WBS) task information drawn primarily from the PA_TASKS table. It presents a flattened, display-oriented projection of project tasks, including both raw WBS attributes and derived presentation columns such as tree sort ordering and an expand/collapse indicator. Because it carries a ROW_ID based on the PA_TASKS rowid, it can support both reporting and certain form-level or integration lookups that require a row identifier.

Underlying Base Objects

The ETRM metadata documents three referenced objects:

  • PA_TASKS (referenced as a SYNONYM) — the primary base table supplying virtually all columns, including task identity, hierarchy, billing, scheduling, and descriptive attributes.
  • PA_TASK_UTILS (PACKAGE) — invoked for the derived columns, specifically SORT_ORDER_TREE for hierarchical ordering and CHECK_CHILD_EXISTS for the expand indicator.
  • PA_WBS_PKG (PACKAGE) — a supporting WBS package associated with the view, providing WBS-specific logic.

Key Columns

Identity and hierarchy columns include TASK_NUMBER, TASK_ID, PROJECT_ID, TASK_NAME, LONG_TASK_NAME, PARENT_TASK_ID, TOP_TASK_ID, and WBS_LEVEL. Two derived columns are prominent: the SORT_ORDER_TREE output, which orders tasks in tree-walk sequence, and a DECODE on CHECK_CHILD_EXISTS returning '+' when children exist and a space otherwise — a classic expand/collapse marker.

Billing and control columns include READY_TO_BILL_FLAG, READY_TO_DISTRIBUTE_FLAG, CHARGEABLE_FLAG, BILLABLE_FLAG, LIMIT_TO_TXN_CONTROLS_FLAG, ALLOW_CROSS_CHARGE_FLAG, CC_PROCESS_LABOR_FLAG, and CC_PROCESS_NL_FLAG. Rate and schedule columns include LABOR_BILL_RATE_ORG_ID, NON_LABOR_BILL_RATE_ORG_ID, LABOR_STD_BILL_RATE_SCHDL, NON_LABOR_STD_BILL_RATE_SCHDL, fixed-date and discount fields, COST_IND_RATE_SCH_ID, REV_IND_RATE_SCH_ID, INV_IND_RATE_SCH_ID, and the corresponding schedule fixed dates and types. Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN), request/program audit columns, and ATTRIBUTE1–10 with ATTRIBUTE_CATEGORY are also exposed.

Common Use Cases and Queries

Typical uses include project WBS reporting, hierarchical task listings for forms or BI Publisher reports, and integration extracts requiring billable or chargeable task sets. A basic listing ordered by the tree walk:

  • SELECT TASK_NUMBER, TASK_NAME, WBS_LEVEL, PROJECT_ID FROM APPS.PA_WBS_V WHERE PROJECT_ID = :p_project_id ORDER BY PROJECT_ID, SORT_ORDER_TREE;
  • SELECT TASK_ID, TASK_NUMBER, CHARGEABLE_FLAG, BILLABLE_FLAG FROM APPS.PA_WBS_V WHERE CHARGEABLE_FLAG = 'Y' AND READY_TO_BILL_FLAG = 'Y';

Developers should treat PA_WBS_V as a legacy 10SC retrofitted object, verify its continued presence in each target instance, and prefer supported PA_TASKS-based APIs where direct view querying is not required.