Search Results pa_projects_all




Overview
Explore in AI Chat

Overview

The PA_PROJECTS_ALL table is the fundamental master data table for the Oracle Projects module within Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as the central repository for the highest-level unit of work, the project, which is the primary entity for planning, tracking, costing, billing, and revenue recognition. As an "ALL" table, it is multi-organization enabled, storing data partitioned by the operating unit (ORG_ID). This design is critical for installations with multiple business units, ensuring data isolation and security. The table's extensive foreign key relationships underscore its role as the nexus for integrating project definitions with other core EBS functionalities, including Human Resources, General Ledger, and Projects-specific setups.

Key Information Stored

The table's primary key is PROJECT_ID, a unique system-generated identifier for each project record. Beyond this, the table stores a comprehensive set of attributes that define a project's operational and financial characteristics. Key columns, as indicated by the foreign key relationships, include: PROJECT_TYPE, linking to PA_PROJECT_TYPES_ALL; CARRYING_OUT_ORGANIZATION_ID, linking to HR_ALL_ORGANIZATION_UNITS to define the executing department; and PROJECT_STATUS_CODE, linking to PA_PROJECT_STATUSES. Critical financial and control columns include COST_IND_RATE_SCH_ID, REV_IND_RATE_SCH_ID, and INV_IND_RATE_SCH_ID (and their override counterparts) for linking to indirect cost schedules (PA_IND_RATE_SCHEDULES_ALL_BG). Other significant fields are ROLE_LIST_ID for project team roles, WORK_TYPE_ID, LOCATION_ID, BILLING_CYCLE_ID, and job group IDs for billing and cost accounting (BILL_JOB_GROUP_ID, COST_JOB_GROUP_ID). The ORG_ID column is essential for multi-org data partitioning.

Common Use Cases and Queries

This table is central to virtually all project reporting, data extracts, and integration points. Common use cases include generating project master lists, building data warehouses for project analytics, and serving as the starting point for detailed transaction inquiries. A foundational query retrieves active project details for a specific operating unit, often joined to its related descriptive flexfields (DFF) and reference tables for meaningful reporting.

Sample Query Pattern:

  • SELECT proj.PROJECT_ID, proj.SEGMENT1 AS Project_Number, proj.NAME, proj.DESCRIPTION, proj.PROJECT_STATUS_CODE, org.NAME AS Carrying_Out_Org FROM PA.PA_PROJECTS_ALL proj, HR.HR_ALL_ORGANIZATION_UNITS org WHERE proj.CARRYING_OUT_ORGANIZATION_ID = org.ORGANIZATION_ID AND proj.ORG_ID = 123 AND proj.PROJECT_STATUS_CODE = 'APPROVED';

Technical consultants frequently query this table to validate project setup, troubleshoot issues with rate schedules or organization assignments, and create custom integrations that require project master data.

Related Objects

PA_PROJECTS_ALL has a vast network of dependencies. It is the parent table for numerous key transactional and setup tables, including PA_TASKS, PA_EXPENDITURES_ALL, and PA_DRAFT_INVOICES_ALL. The provided metadata highlights critical foreign key relationships to reference tables: PA_PROJECT_TYPES_ALL, PA_PROJECT_STATUSES, HR_ALL_ORGANIZATION_UNITS, PA_IND_RATE_SCHEDULES_ALL_BG, PA_CC_TP_SCHEDULES_BG, PA_BILLING_CYCLES, PA_WORK_TYPES_B, PA_LOCATIONS, PA_ROLE_LISTS, and PER_JOB_GROUPS. For application development, the primary API for creating and maintaining records in this table is the PA_PROJECT_PUB package. The PA_PROJECTS view provides a public synonym and is often the preferred object for read-only access within custom code.

  • 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 , 

  • 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_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_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_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_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 , 

  • 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_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_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_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_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 , 

  • 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_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 , 

  • 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.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_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_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_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_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 ,