Results for “probability_member_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_FCST_PROJECT_LIST_V is an Oracle E-Business Suite Projects (PA) module view owned by the APPS schema. Its documented purpose is to present the list of projects available for forecasting, exposing a project-oriented record set that combines project master data, customer information, project manager or party details, probability information, and implementation context. The view is used by the Project Forecasting and budgeting functionality where users must select a project before forecasting periods may be maintained. In the Oracle EBS 12.1.1 and 12.2.2 releases, this object typically appears as a supporting view for Forecast (PA_FCST) forms and related concurrent programs, and is commonly referenced in troubleshooting and extension work where developers search for "pa_fcst_project_list_v" to understand which project rows are eligible for forecasting.
Underlying Base Objects
The view text joins several documented base objects. The principal project source is PA_PROJECTS_ALL, aliased PPA, supplying project identifiers, number, name, currency, organization, type, status, and date information. Customer names are derived through the PA_PROJECTS_MAINT_UTILS package function GET_PRIMARY_CUSTOMER_NAME, restricted to the first 45 characters. Probability percentage and probability member information comes from PA_PROBABILITY_MEMBERS. Party and person associations are drawn from PA_PROJECT_PARTIES and PER_ALL_PEOPLE_F, while security and menu-related filtering references FND_GRANTS, FND_OBJECTS, FND_MENUS, WF_ROLES, and FND_GLOBAL. Implementation and ledger context are supplied by PA_IMPLEMENTATIONS_ALL and GL_SETS_OF_BOOKS. Additional inline subqueries call the PA_FCST_GLOBAL package, using functions such as ISCROSSPROJECTVIEWUSER, GETPROJECTNUMBER, GETPROJECTNAME, GETPROJTYPE, GETPROJECTORGID, GETPROJECTSTARTDATE, GETPROJECTCOMPDATE, GETPROJECTMANGERNAME, and GETPERIODSETNAME. FND_GLOBAL, PA_UTILS, PA_PROJECT_PLAYERS, and DUAL are also documented as referenced objects.
Key Columns
- PROJECT_ID — Primary project identifier from PA_PROJECTS_ALL.
- PROJECT_NAME / PROJECT_NUMBER — Project name and segment1 project number.
- CUSTOMER_NAME — Primary customer name, truncated to 45 characters.
- PERSON_ID / PERSON_NAME — Party resource source identifier and full name of the associated person.
- PROJECT_CURRENCY_CODE — Functional or project currency code.
- PROBABILITY_PERCENTAGE / PROBABILITY_MEMBER_ID — Probability data used in revenue or forecast calculations.
- CARRYING_OUT_ORGANIZATION_ID / ORG_ID — Carrying-out organization and operating unit identifiers.
- PROJECT_TYPE / PROJECT_STATUS_CODE — Project classification and current status.
- START_DATE / COMPLETION_DATE — Project start and completion dates.
- PERIOD_SET_NAME — Accounting period set derived through PA_FCST_GLOBAL.
Common Use Cases and Queries
This view is most often queried to list projects that a given user may forecast, or to restrict forecasting selections to a specific project number, customer, or status. A typical inquiry is:
SELECT project_id, project_number, project_name, customer_name, project_status_code FROM pa_fcst_project_list_v WHERE project_number = :project_number;
Another common pattern filters by status and person to populate a selection list:
SELECT project_id, project_name, person_name FROM pa_fcst_project_list_v WHERE project_status_code = 'APPROVED' AND person_id = :person_id ORDER BY project_number;
Because the view embeds calls to PA_FCST_GLOBAL and PA_PROJECTS_MAINT_UTILS, performance depends on package execution and security filtering. When extending or diagnosing the Forecast project list, the view should be treated as a read-only, security-aware source rather than a base table.
-
View: PA_FCST_PROJECT_LIST_V 12.1.1
PA_FCST_PROJECT_LIST_V is a view that shows forecasting periods
APPS.PA_FCST_PROJECT_LIST_V·↳ FND_GLOBAL·↳ FND_GRANTS·↳ FND_MENUS·Explore PA module →
-
View: PA_PROJECTS_CUST_360_V 12.1.1
APPS.PA_PROJECTS_CUST_360_V·↳ FND_GLOBAL·↳ FND_GRANTS·↳ FND_OBJECTS·Explore PA module →
-
APPS.PA_PROJECTS_PROBABILITY_V·↳ PA_PROBABILITY_MEMBERS·↳ PA_PROJECT_TYPES·Explore PA module →
-
This table stores information about the members that make up the probability list.
-
This table stores information about the members that make up the probability list.
-
APPS.PA_PROJECTS_PROBABILITY_V·↳ PA_PROBABILITY_MEMBERS·↳ PA_PROJECT_TYPES·Explore PA module →
-
View: PA_PROBABILITIES_V 12.1.1
APPS.PA_PROBABILITIES_V·↳ PA_PROBABILITY_LISTS·↳ PA_PROBABILITY_MEMBERS·Explore PA module →
-
View: PA_PROBABILITIES_V 12.2.2
APPS.PA_PROBABILITIES_V·↳ PA_PROBABILITY_LISTS·↳ PA_PROBABILITY_MEMBERS·Explore PA module →
-
View: PA_PROJECT_LISTS_V 12.2.2
APPS.PA_PROJECT_LISTS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_TERRITORIES_VL·Explore PA module →
-
View: PA_FCST_PROJECT_LIST_V 12.2.2
PA_FCST_PROJECT_LIST_V is a view that shows forecasting periods
APPS.PA_FCST_PROJECT_LIST_V·↳ FND_GLOBAL·↳ FND_GRANTS·↳ FND_MENUS·Explore PA module →
-
View: PA_PROJECTS_AMG_V 12.2.2
Internal
APPS.PA_PROJECTS_AMG_V·↳ PA_PROJECTS·↳ PA_PROJECT_STRUCTURE_UTILS·↳ PA_PROJ_ELEMENTS_UTILS·Explore PA module →
-
APPS.PA_PROJECT_LISTS_PORTLET_V·↳ FND_GLOBAL·↳ PA_LOOKUPS·↳ PA_PROJECTS_MAINT_UTILS·Explore PA module →
-
View: AMW_PROJECTS_V 12.1.1
This view returns information about Audit Project.
APPS.AMW_PROJECTS_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ PA_PROJECTS_MAINT_UTILS·Explore AMW module →
-
View: PA_PROJECTS_CUST_360_V 12.2.2
APPS.PA_PROJECTS_CUST_360_V·↳ FND_GLOBAL·↳ FND_GRANTS·↳ FND_OBJECTS·Explore PA module →
-
View: PA_PROJECTS_AMG_V 12.1.1
Internal
APPS.PA_PROJECTS_AMG_V·↳ PA_PROJECTS·↳ PA_PROJECT_STRUCTURE_UTILS·↳ PA_PROJ_ELEMENTS_UTILS·Explore PA module →
-
View: PA_PROJECT_LISTS_V 12.1.1
APPS.PA_PROJECT_LISTS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_TERRITORIES_VL·Explore PA module →
-
APPS.PA_PROJECT_LISTS_USER_V·↳ FND_GLOBAL·↳ FND_GRANTS·↳ FND_LOOKUPS·Explore PA module →
-
APPS.PA_PROJECT_LISTS_PORTLET_V·↳ FND_GLOBAL·↳ PA_LOOKUPS·↳ PA_PROJECTS_MAINT_UTILS·Explore PA module →
-
View: PA_PROJECTS_V 12.2.2
APPS.PA_PROJECTS_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
View: PA_PROJECTS_PRM_V 12.2.2
Single-Org
APPS.PA_PROJECTS_PRM_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_TERRITORIES_VL·Explore PA module →
-
View: PA_PROJECTS_V 12.1.1
APPS.PA_PROJECTS_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
View: PA_PROJECTS_PRM_V 12.1.1
Single-Org
APPS.PA_PROJECTS_PRM_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_TERRITORIES_VL·Explore PA module →
-
APPS.PA_PROJECT_LISTS_USER_V·↳ FND_GLOBAL·↳ FND_GRANTS·↳ FND_LOOKUPS·Explore PA module →
-
PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects.
-
PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects.
-
View: PA_FCST_PROJ_INFO_V 12.1.1
PA_FCST_PROJ_INFO_V is a view that shows project information
APPS.PA_FCST_PROJ_INFO_V·↳ PA_PROBABILITY_MEMBERS·↳ PA_PROJECTS_ALL·Explore PA module →
-
View: PA_FCST_PROJ_INFO_V 12.2.2
PA_FCST_PROJ_INFO_V is a view that shows project information
APPS.PA_FCST_PROJ_INFO_V·↳ PA_PROBABILITY_MEMBERS·↳ PA_PROJECTS_ALL·Explore PA module →
-
View: PA_PROJECTS_O 12.2.2
Single-Org
Not implemented in this database·Explore PA module →
-
View: PA_PROJECTS_O 12.1.1
Single-Org
Not implemented in this database·Explore PA module →