Search Results pa_projects_all

Overview

PA_PROJECTS_ALL is the master table in the Oracle Projects (PA) module of Oracle E-Business Suite, holding the highest units of work defined in Oracle Projects. Each row represents a single project — a container for tasks, budgets, expenditures, billing events, and revenue — and serves as the integration point between Project Management, Project Costing, Project Billing, and numerous external applications such as Payables, Assets, Purchasing, Grants, and Property Manager. The table resides in the PA schema and is the principal reference point for all project-related foreign keys across the EBS database.

In ETRM 12.2.2 the table is documented with 201 columns, and in a Data Vault modeling heuristic — mined from its foreign-key structure — PA_PROJECTS_ALL classifies as a hub, since it is the central anchor whose surrogate key is referenced by a very large number of dependent links and satellites across EBS.

Key Information Stored

The primary key is PA_PROJECTS_PK, defined on the PROJECT_ID surrogate column. Five unique indexes identify the business-key candidates: PA_PROJECTS_U1 (PROJECT_ID, SEGMENT1), PA_PROJECTS_U2 (SEGMENT1), PA_PROJECTS_U3 (NAME), PA_PROJECTS_U4 (PM_PROJECT_REFERENCE, PM_PRODUCT_CODE), and PA_PROJECTS_U5 (LONG_NAME).

The most significant columns include:

PROJECT_ID — surrogate primary key and the value copied into all dependent tables.
SEGMENT1 — the user-visible project number, the primary business key.
NAME and LONG_NAME — the project's short and descriptive names.
PROJECT_TYPE — foreign key to PA_PROJECT_TYPES_ALL, controlling project classification and associated behavior.
PROJECT_STATUS_CODE — foreign key to PA_PROJECT_STATUSES, governing lifecycle state (e.g., approved, closed).
CARRYING_OUT_ORGANIZATION_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, identifying the executing organization.
START_DATE, COMPLETION_DATE, CLOSED_DATE — core lifecycle dates.
ORG_ID — the multi-org operating unit discriminator.
TEMPLATE_FLAG and CREATED_FROM_PROJECT_ID — designate templates and the source project for copies.
COST_IND_RATE_SCH_ID, REV_IND_RATE_SCH_ID, INV_IND_RATE_SCH_ID — foreign keys to PA_IND_RATE_SCHEDULES_ALL_BG for indirect rate schedules.
BILLING_CYCLE_ID and BILLING_CYCLE — billing cycle reference (foreign key to PA_BILLING_CYCLES).
PUBLIC_SECTOR_FLAG, SECURITY_LEVEL, and REVENUE_ACCRUAL_METHOD — functional attributes governing accounting and access.
LAST_UPDATE_DATE, CREATION_DATE, LAST_UPDATED_BY — standard audit columns.

Common Use Cases and Queries

PA_PROJECTS_ALL is queried in virtually every Projects report and is a frequent starting point for joins into cost, billing, and task data.

Locating a project by number or name:
SELECT project_id, name, segment1, project_status_code FROM pa_projects_all WHERE segment1 = :project_number;
List active projects for an operating unit:
SELECT p.project_id, p.segment1, p.name, s.project_status_name FROM pa_projects_all p, pa_project_statuses s WHERE p.project_status_code = s.project_status_code AND p.org_id = :org_id;
Join to PA_TASKS to enumerate the work breakdown structure for a project.
Exclude templates when reporting:
WHERE NVL(template_flag,'N') = 'N'
Feed downstream reporting on billing setup (billing cycle, invoice formats, indirect rate schedules).

Related Objects

The table participates in an extensive relationship graph. The most significant dependents and referenced objects include:

PA_TASKS — links on PROJECT_ID; the second-highest unit of work and the most common child of a project.
PA_EXPENDITURE_ITEMS_ALL — links on PROJECT_ID; stores raw cost transactions charged to the project.
PA_BUDGETS and PA_BUDGET_VERSIONS — link on PROJECT_ID; hold project budget data.
PA_DRAFT_INVOICES_ALL and PA_DRAFT_REVENUES_ALL — link on PROJECT_ID; billing and revenue generation output.
PA_PROJECT_ASSIGNMENTS and PA_PROJECT_PLAYERS — link on PROJECT_ID; hold team and role assignments.
AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL — link on PROJECT_ID; Payables transactions referencing projects.
FA_MASS_ADDITIONS and FA_ASSET_INVOICES — link on PROJECT_ID for capital projects feeding Assets.
PO_REQ_DISTRIBUTIONS_ALL — links on PROJECT_ID for Purchasing distributions.
PA_PROJECTS_ERP_EXT_B — the extension table for project attributes, joined on PROJECT_ID.
HR_ALL_ORGANIZATION_UNITS, PA_PROJECT_TYPES_ALL, and PA_PROJECT_STATUSES — referenced by PA_PROJECTS_ALL via its own foreign keys.

Because of this breadth of referencing relationships, care should be taken before purging or reorganizing project rows, as hundreds of EBS tables depend on the PROJECT_ID values defined here.

Table: PA_PROJECTS_ALL 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PROJECTS_ALL, object_name:PA_PROJECTS_ALL, status:VALID, product: PA - Projects , description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. , implementation_dba_data: PA.PA_PROJECTS_ALL ,
Table: PA_PROJECTS_ALL 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PROJECTS_ALL, object_name:PA_PROJECTS_ALL, status:VALID, product: PA - Projects , description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. , implementation_dba_data: PA.PA_PROJECTS_ALL ,
Table: PA_IND_RATE_SCHEDULES_ALL_BG 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_IND_RATE_SCHEDULES_ALL_BG, object_name:PA_IND_RATE_SCHEDULES_ALL_BG, status:VALID, product: PA - Projects , description: Implementation-defined burden schedules , implementation_dba_data: PA.PA_IND_RATE_SCHEDULES_ALL_BG ,
Table: PA_IND_RATE_SCHEDULES_ALL_BG 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_IND_RATE_SCHEDULES_ALL_BG, object_name:PA_IND_RATE_SCHEDULES_ALL_BG, status:VALID, product: PA - Projects , description: Implementation-defined burden schedules , implementation_dba_data: PA.PA_IND_RATE_SCHEDULES_ALL_BG ,
Table: PA_ROLE_LISTS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_ROLE_LISTS, object_name:PA_ROLE_LISTS, status:VALID, product: PA - Projects , description: PA_ROLE_LISTS stores lists of roles defined with the system. , implementation_dba_data: PA.PA_ROLE_LISTS ,
Table: PA_ROLE_LISTS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_ROLE_LISTS, object_name:PA_ROLE_LISTS, status:VALID, product: PA - Projects , description: PA_ROLE_LISTS stores lists of roles defined with the system. , implementation_dba_data: PA.PA_ROLE_LISTS ,
Table: PA_PERF_TRANSACTIONS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PERF_TRANSACTIONS, object_name:PA_PERF_TRANSACTIONS, status:VALID, product: PA - Projects , description: This table records performance transaction data. , implementation_dba_data: PA.PA_PERF_TRANSACTIONS ,
Table: PA_PERF_TRANSACTIONS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PERF_TRANSACTIONS, object_name:PA_PERF_TRANSACTIONS, status:VALID, product: PA - Projects , description: This table records performance transaction data. , implementation_dba_data: PA.PA_PERF_TRANSACTIONS ,
Table: PA_INVOICE_FORMATS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_INVOICE_FORMATS, object_name:PA_INVOICE_FORMATS, status:VALID, product: PA - Projects , description: Implementation-defined configurations of columns, text, and layout of invoice lines , implementation_dba_data: PA.PA_INVOICE_FORMATS ,
Table: PA_INVOICE_FORMATS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_INVOICE_FORMATS, object_name:PA_INVOICE_FORMATS, status:VALID, product: PA - Projects , description: Implementation-defined configurations of columns, text, and layout of invoice lines , implementation_dba_data: PA.PA_INVOICE_FORMATS ,
View: PA_PROJECT_DRIVERS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_PROJECT_DRIVERS_V, object_name:PA_PROJECT_DRIVERS_V, status:VALID, product: PA - Projects , implementation_dba_data: APPS.PA_PROJECT_DRIVERS_V ,
View: PA_PROJECT_DRIVERS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_PROJECT_DRIVERS_V, object_name:PA_PROJECT_DRIVERS_V, status:VALID, product: PA - Projects , implementation_dba_data: APPS.PA_PROJECT_DRIVERS_V ,
View: PA_PROJ_PAGE_REGIONS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_PROJ_PAGE_REGIONS_V, object_name:PA_PROJ_PAGE_REGIONS_V, status:VALID, product: PA - Projects , implementation_dba_data: APPS.PA_PROJ_PAGE_REGIONS_V ,
View: PA_PROJ_PAGE_REGIONS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_PROJ_PAGE_REGIONS_V, object_name:PA_PROJ_PAGE_REGIONS_V, status:VALID, product: PA - Projects , implementation_dba_data: APPS.PA_PROJ_PAGE_REGIONS_V ,
View: PA_CP_GENERATE_ASSET_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_CP_GENERATE_ASSET_V, object_name:PA_CP_GENERATE_ASSET_V, status:VALID, product: PA - Projects , description: 10SC Only , implementation_dba_data: APPS.PA_CP_GENERATE_ASSET_V ,
Table: PA_BUDGETARY_CONTROL_OPTIONS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BUDGETARY_CONTROL_OPTIONS, object_name:PA_BUDGETARY_CONTROL_OPTIONS, status:VALID, product: PA - Projects , description: pa_budgetary_control_options stores all the default budgetary control levels and time intervals , implementation_dba_data: PA.PA_BUDGETARY_CONTROL_OPTIONS ,
Table: PA_BUDGETARY_CONTROL_OPTIONS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BUDGETARY_CONTROL_OPTIONS, object_name:PA_BUDGETARY_CONTROL_OPTIONS, status:VALID, product: PA - Projects , description: pa_budgetary_control_options stores all the default budgetary control levels and time intervals , implementation_dba_data: PA.PA_BUDGETARY_CONTROL_OPTIONS ,
View: PA_RETIREMENT_COSTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RETIREMENT_COSTS_V, object_name:PA_RETIREMENT_COSTS_V, status:VALID, product: PA - Projects , implementation_dba_data: APPS.PA_RETIREMENT_COSTS_V ,
Table: PA_PROJECT_SET_LINES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PROJECT_SET_LINES, object_name:PA_PROJECT_SET_LINES, status:VALID, product: PA - Projects , description: This is an intersection table between PA_PROJECTS_ALL and PA_PROJECT_SETS_B. It stores the elements (which will be projects) of the project set. , implementation_dba_data: PA.PA_PROJECT_SET_LINES ,
View: PA_CP_GENERATE_ASSET_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_CP_GENERATE_ASSET_V, object_name:PA_CP_GENERATE_ASSET_V, status:VALID, product: PA - Projects , description: 10SC Only , implementation_dba_data: APPS.PA_CP_GENERATE_ASSET_V ,
Table: PA_PERF_KPA_SUMMARY 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PERF_KPA_SUMMARY, object_name:PA_PERF_KPA_SUMMARY, status:VALID, product: PA - Projects , description: This table records the exception summary for a given object across all KPAs. , implementation_dba_data: PA.PA_PERF_KPA_SUMMARY ,
View: PA_RETIREMENT_COSTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RETIREMENT_COSTS_V, object_name:PA_RETIREMENT_COSTS_V, status:VALID, product: PA - Projects , implementation_dba_data: APPS.PA_RETIREMENT_COSTS_V ,
Table: PA_PERF_KPA_SUMMARY 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PERF_KPA_SUMMARY, object_name:PA_PERF_KPA_SUMMARY, status:VALID, product: PA - Projects , description: This table records the exception summary for a given object across all KPAs. , implementation_dba_data: PA.PA_PERF_KPA_SUMMARY ,
Table: PA_COMP_RULE_OT_DEFAULTS_ALL 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_COMP_RULE_OT_DEFAULTS_ALL, object_name:PA_COMP_RULE_OT_DEFAULTS_ALL, status:VALID, product: PA - Projects , description: This table stores the overtime default project and task details for a Labor costing rule. , implementation_dba_data: PA.PA_COMP_RULE_OT_DEFAULTS_ALL ,
Table: PA_PROJECT_CTX_SEARCH 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PROJECT_CTX_SEARCH, object_name:PA_PROJECT_CTX_SEARCH, status:VALID, product: PA - Projects , description: PA_PROJECT_CTX_SEARCH stores the concatenated attributes for the columns of PA_PROJECTS_ALL that we perform keyword search on, including Name, Long Name, Segment1 and Description , implementation_dba_data: PA.PA_PROJECT_CTX_SEARCH ,
Table: PA_PROJECT_CTX_SEARCH 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PROJECT_CTX_SEARCH, object_name:PA_PROJECT_CTX_SEARCH, status:VALID, product: PA - Projects , description: PA_PROJECT_CTX_SEARCH stores the concatenated attributes for the columns of PA_PROJECTS_ALL that we perform keyword search on, including Name, Long Name, Segment1 and Description , implementation_dba_data: PA.PA_PROJECT_CTX_SEARCH ,
Table: PA_PERF_OBJECT_RULES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PERF_OBJECT_RULES, object_name:PA_PERF_OBJECT_RULES, status:VALID, product: PA - Projects , description: This table stores the association between Exception Rule and the actual object. , implementation_dba_data: PA.PA_PERF_OBJECT_RULES ,
Table: PA_PERF_OBJECT_RULES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PERF_OBJECT_RULES, object_name:PA_PERF_OBJECT_RULES, status:VALID, product: PA - Projects , description: This table stores the association between Exception Rule and the actual object. , implementation_dba_data: PA.PA_PERF_OBJECT_RULES ,
Table: PA_RES_FORMATS_B 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_RES_FORMATS_B, object_name:PA_RES_FORMATS_B, status:VALID, product: PA - Projects , description: Stores all valid resource formats for planning resources. , implementation_dba_data: PA.PA_RES_FORMATS_B ,
Table: PA_RES_FORMATS_B 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_RES_FORMATS_B, object_name:PA_RES_FORMATS_B, status:VALID, product: PA - Projects , description: Stores all valid resource formats for planning resources. , implementation_dba_data: PA.PA_RES_FORMATS_B ,
Table: PA_BUDGETARY_CONTROLS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BUDGETARY_CONTROLS, object_name:PA_BUDGETARY_CONTROLS, status:VALID, product: PA - Projects , description: PA_BUDGETARY_CONTROLS are used to store the controls levels that are used to regulate how the funds are reserved for transactions , implementation_dba_data: PA.PA_BUDGETARY_CONTROLS ,
Table: PA_PROJECT_SET_LINES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_PROJECT_SET_LINES, object_name:PA_PROJECT_SET_LINES, status:VALID, product: PA - Projects , description: This is an intersection table between PA_PROJECTS_ALL and PA_PROJECT_SETS_B. It stores the elements (which will be projects) of the project set. , implementation_dba_data: PA.PA_PROJECT_SET_LINES ,
Table: PA_COMP_RULE_OT_DEFAULTS_ALL 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_COMP_RULE_OT_DEFAULTS_ALL, object_name:PA_COMP_RULE_OT_DEFAULTS_ALL, status:VALID, product: PA - Projects , description: This table stores the overtime default project and task details for a Labor costing rule. , implementation_dba_data: PA.PA_COMP_RULE_OT_DEFAULTS_ALL ,
Table: PA_BUDGETARY_CONTROLS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BUDGETARY_CONTROLS, object_name:PA_BUDGETARY_CONTROLS, status:VALID, product: PA - Projects , description: PA_BUDGETARY_CONTROLS are used to store the controls levels that are used to regulate how the funds are reserved for transactions , implementation_dba_data: PA.PA_BUDGETARY_CONTROLS ,
View: PA_PROJECT_OPTIONS_SS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_PROJECT_OPTIONS_SS_V, object_name:PA_PROJECT_OPTIONS_SS_V, status:VALID, product: PA - Projects , implementation_dba_data: APPS.PA_PROJECT_OPTIONS_SS_V ,
Table: PA_ORG_FCST_ELEMENTS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_ORG_FCST_ELEMENTS, object_name:PA_ORG_FCST_ELEMENTS, status:VALID, product: PA - Projects , description: This table stores denormalized header information for Organization Forecasts. , implementation_dba_data: PA.PA_ORG_FCST_ELEMENTS ,
Table: PA_CC_TP_SCHEDULES_BG 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_CC_TP_SCHEDULES_BG, object_name:PA_CC_TP_SCHEDULES_BG, status:VALID, product: PA - Projects , description: Transfer price schedules which define how transfer price is calculated between the provider and receiver organizations for cross charged labor and non-labor transactions. , implementation_dba_data: PA.PA_CC_TP_SCHEDULES_BG ,
Table: PA_ORG_FCST_ELEMENTS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_ORG_FCST_ELEMENTS, object_name:PA_ORG_FCST_ELEMENTS, status:VALID, product: PA - Projects , description: This table stores denormalized header information for Organization Forecasts. , implementation_dba_data: PA.PA_ORG_FCST_ELEMENTS ,
Table: PA_CC_TP_SCHEDULES_BG 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_CC_TP_SCHEDULES_BG, object_name:PA_CC_TP_SCHEDULES_BG, status:VALID, product: PA - Projects , description: Transfer price schedules which define how transfer price is calculated between the provider and receiver organizations for cross charged labor and non-labor transactions. , implementation_dba_data: PA.PA_CC_TP_SCHEDULES_BG ,
Table: PA_BC_BALANCES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BC_BALANCES, object_name:PA_BC_BALANCES, status:VALID, product: PA - Projects , description: PA_BC_BALANCES stores actual, budget and encumbrance balance per project, task, period, budget version and resource. Budget balances are created during the budget baselining process. Actuals and encumbrances accounting entries are creat , implementation_dba_data: PA.PA_BC_BALANCES ,
View: PA_PROJECT_OPTIONS_SS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_PROJECT_OPTIONS_SS_V, object_name:PA_PROJECT_OPTIONS_SS_V, status:VALID, product: PA - Projects , implementation_dba_data: APPS.PA_PROJECT_OPTIONS_SS_V ,
Table: PA_STD_BILL_RATE_SCHEDULES_ALL 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_STD_BILL_RATE_SCHEDULES_ALL, object_name:PA_STD_BILL_RATE_SCHEDULES_ALL, status:VALID, product: PA - Projects , description: Sets of standard bill rates that can be assigned as groups to projects and tasks , implementation_dba_data: PA.PA_STD_BILL_RATE_SCHEDULES_ALL ,
Table: PA_STD_BILL_RATE_SCHEDULES_ALL 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_STD_BILL_RATE_SCHEDULES_ALL, object_name:PA_STD_BILL_RATE_SCHEDULES_ALL, status:VALID, product: PA - Projects , description: Sets of standard bill rates that can be assigned as groups to projects and tasks , implementation_dba_data: PA.PA_STD_BILL_RATE_SCHEDULES_ALL ,
Table: PA_BC_BALANCES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_BC_BALANCES, object_name:PA_BC_BALANCES, status:VALID, product: PA - Projects , description: PA_BC_BALANCES stores actual, budget and encumbrance balance per project, task, period, budget version and resource. Budget balances are created during the budget baselining process. Actuals and encumbrances accounting entries are creat , implementation_dba_data: PA.PA_BC_BALANCES ,
Table: PA_WORK_TYPES_B 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_WORK_TYPES_B, object_name:PA_WORK_TYPES_B, status:VALID, product: PA - Projects , description: This table stores implementation-defined types of work being carried out in Projects in the base language. , implementation_dba_data: PA.PA_WORK_TYPES_B ,
Table: PA_WORK_TYPES_B 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_WORK_TYPES_B, object_name:PA_WORK_TYPES_B, status:VALID, product: PA - Projects , description: This table stores implementation-defined types of work being carried out in Projects in the base language. , implementation_dba_data: PA.PA_WORK_TYPES_B ,
Table: PA_LOCATIONS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_LOCATIONS, object_name:PA_LOCATIONS, status:VALID, product: PA - Projects , description: This table is used to store the locations that are used in Projects. A new location is created when a new location is assigned to a project or a team role. There would be no way for user to enter new locations into this table , implementation_dba_data: PA.PA_LOCATIONS ,
Table: PA_DRAFT_INVOICE_DETAILS_ALL 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_DRAFT_INVOICE_DETAILS_ALL, object_name:PA_DRAFT_INVOICE_DETAILS_ALL, status:VALID, product: PA - Projects , description: Intercompany invoice details for cross charged transactions , implementation_dba_data: PA.PA_DRAFT_INVOICE_DETAILS_ALL ,
Table: PA_DRAFT_INVOICE_DETAILS_ALL 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_DRAFT_INVOICE_DETAILS_ALL, object_name:PA_DRAFT_INVOICE_DETAILS_ALL, status:VALID, product: PA - Projects , description: Intercompany invoice details for cross charged transactions , implementation_dba_data: PA.PA_DRAFT_INVOICE_DETAILS_ALL ,
Table: PA_LOCATIONS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_LOCATIONS, object_name:PA_LOCATIONS, status:VALID, product: PA - Projects , description: This table is used to store the locations that are used in Projects. A new location is created when a new location is assigned to a project or a team role. There would be no way for user to enter new locations into this table , implementation_dba_data: PA.PA_LOCATIONS ,