Search Results pa_budget_res_all_v




Overview
Explore in AI Chat

Overview

PA_BUDGET_RES_ALL_V is a documented Oracle E-Business Suite view owned by the APPS schema and classified under the PA (Projects) product family. It is supplied in EBS releases 12.1.1 and 12.2.2. The view returns all enabled resource list members, including unclassified resource list members, for a given resource list. It therefore serves as a reporting and integration access point for the membership of budget and resource lists without requiring callers to reimplement the enabled-flag and display-flag logic that governs which members are visible. Because the view normalizes membership into a hierarchical structure, it is suitable for budget entry, resource list maintenance reports, and downstream interfaces that need a flattened but indented representation of the resource hierarchy.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the view is defined over two referenced objects: the table (exposed via a synonym) PA_RESOURCE_LIST_MEMBERS, and the package PA_RESOURCES_PKG. The body of the view is a hierarchical query against PA_RESOURCE_LIST_MEMBERS, filtered by ENABLED_FLAG = 'Y' and by a DECODE on RESOURCE_TYPE_CODE that admits 'UNCLASSIFIED' rows unconditionally while admitting other rows only when DISPLAY_FLAG = 'Y'. Rows with a MIGRATION_CODE of 'N' are excluded. The CONNECT BY clause (PRIOR RESOURCE_LIST_MEMBER_ID = PARENT_MEMBER_ID) and the START WITH PARENT_MEMBER_ID IS NULL clause build the tree from the root members downward. The scalar function PA_RESOURCES_PKG.GET_RESOURCE_NAME is invoked for each row to resolve the display name of the resource, truncated to 30 characters.

Key Columns

  • ALIAS — the resource alias, prefixed with indentation computed from the hierarchy level (LPAD(' ', 2*(LEVEL-1))), so that report output mirrors the tree structure.
  • ALIAS2 — the same alias value without indentation, available for joins, sorting, or key matching.
  • RESOURCE_LIST_ID — identifier of the resource list to which the member belongs.
  • RESOURCE_LIST_MEMBER_ID — unique identifier of the membership row; the parent-child linkage key.
  • RESOURCE_ID — identifier of the underlying resource being referenced.
  • TRACK_AS_LABOR_FLAG — indicates whether the member is tracked as labor, which affects how budget and cost amounts are treated.
  • PARENT_MEMBER_ID — identifier of the parent membership row, exposed through NVL(PARENT_MEMBER_ID, 0) so root members surface as zero.
  • RESOURCE_NAME — the resolved resource name from PA_RESOURCES_PKG.GET_RESOURCE_NAME, limited to 30 characters.
  • MIGRATION_CODE — migration control code carried from the base table.

Common Use Cases and Queries

Typical uses include listing the enabled membership of a resource list for a given budget, validating that expected resources are present before budget upload, and feeding integrations that require an indented hierarchy. The following query returns the enabled membership of a specific resource list:

  • SELECT alias2, resource_list_member_id, parent_member_id, resource_id, resource_name, track_as_labor_flag FROM pa_budget_res_all_v WHERE resource_list_id = :p_resource_list_id ORDER BY alias2;
  • SELECT resource_list_id, COUNT(*) member_count FROM pa_budget_res_all_v GROUP BY resource_list_id; — counts enabled members per list.
  • SELECT resource_name, track_as_labor_flag FROM pa_budget_res_all_v WHERE resource_list_id = :p_resource_list_id AND track_as_labor_flag = 'Y'; — isolates labor-tracked members, useful when preparing labor budgets.

Because the view applies the enabled, display, and migration-code filters internally, querying it avoids duplicating that logic and keeps results consistent with standard Projects functionality. Callers should supply RESOURCE_LIST_ID predicates to limit the hierarchical scan, and should be aware that the resource name is truncated to 30 characters.