Results for “pa_tsk_bgt_lines_it_all”
32 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_TSK_BGT_LINES_IT_ALL is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores task-level budget lines for the Oracle Project Analysis Collection Pack. It is an interface/collection staging table (indicated by the _IT_ALL suffix), designed to hold budget data at the intersection of project task, budget period, budget type, resource list member, expenditure type, and service type so that this information can be collected and consumed by the Analysis Collection Pack business intelligence and reporting infrastructure.
Under the heuristic Data Vault classification mined from its foreign key structure, this table is modeled as a link entity. That classification is a modeling suggestion rather than a physical implementation: the table serves as an intersection resolving many-to-many relationships between tasks, periods, resources, budget types, expenditure types, service types, and operating units, and it carries descriptive measures (cost, revenue, quantity) that a pure link would normally delegate to a satellite.
The table is owned by the PA schema, is documented as VALID, and contains 35 columns with a single documented unique index, PA_TSK_BGT_LINES_IT_ALL_U1, on TASK_BUDGET_LINE_KEY.
Key Information Stored
The surrogate primary key is TASK_BUDGET_LINE_KEY, enforced by PA_TSK_BGT_LINES_IT_ALL_PK and also carried by the unique index PA_TSK_BGT_LINES_IT_ALL_U1, making it the primary business-key candidate as well. The most significant columns and their roles are:
TASK_BUDGET_LINE_KEY— surrogate primary key uniquely identifying each task budget line.TASK_ID— the project task to which the budget line belongs; referencesPA_TOP_TASKS_IT.PA_PERIOD_KEY— the budget period for the line; referencesPA_PERIODS_IT.BUDGET_TYPE_CODE— the budget type (for example, approved, baseline, or forecast); referencesPA_BGT_TYPES_IT.RESOURCE_LIST_MEMBER_ID— the resource list member defining the bud
-
Task level budgets for Oracle Project Analysis Collection Pack
-
Task level budgets for Oracle Project Analysis Collection Pack
-
View: PA_TSK_BGT_LINES_IT 12.2.2
Single-Org
Not implemented in this database·Explore PA module →
-
View: PA_TSK_BGT_LINES_IT 12.1.1
Single-Org
Not implemented in this database·Explore PA module →
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
PACKAGE BODY: APPS.AD_MORG 12.1.1
-
PACKAGE BODY: APPS.AD_MORG 12.2.2
-
eTRM - PA Tables and Views 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - PA Tables and Views 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - PA Tables and Views 12.2.2
-
eTRM - PA Tables and Views 12.1.1