Results for “pa_project_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_SELECT_TEMPLATE_V is a reporting view owned by the APPS schema in Oracle Projects (PA). Its documented purpose is to expose all valid project templates that have been created in Oracle Projects. A project template in EBS serves as a reusable model from which new projects can be created, carrying forward standard attributes such as carrying-out organization, distribution rules, and default resource list assignments.
Because it is a view rather than a table, PA_SELECT_TEMPLATE_V does not store data; it dynamically assembles template information from the underlying project, resource list, and operating unit objects. It returns one row per valid template with its associated default resource list, which makes it particularly well suited for value-set style lookups, template selection lists, and lightweight reporting rather than transactional processing. The view is marked VALID and is available in both EBS 12.1.1 and 12.2.2.
The user search term "pa_project_name" maps to the PA_PROJECT_NAME column exposed by this view, indicating the view is frequently queried to retrieve template names by project or operating unit context.
Underlying Base Objects
The view text joins four documented base objects: PA_PROJECTS (synonym) alias PAP, PA_RESOURCE_LIST_ASSIGNMENTS (synonym) alias RLA, PA_RESOURCE_LIST_USES (synonym) alias RLU, and PA_OPERATING_UNITS_V (view) alias POU. The documented base object list also references MO_GLOBAL (package), which is used in the 12.2.2 multi-org context handling.
- PA_PROJECTS — supplies the template master record including ORG_ID, PROJECT_ID, SEGMENT1 (project/template number), NAME, TEMPLATE_FLAG, CREATED_FROM_PROJECT_ID, CARRYING_OUT_ORGANIZATION_ID, DISTRIBUTION_RULE, and the active date range columns.
- PA_RESOURCE_LIST_ASSIGNMENTS — links a template project to an assigned resource list via RESOURCE_LIST_ID and RESOURCE_LIST_ASSIGNMENT_ID.
- PA_RESOURCE_LIST_USES — determines which resource list assignment is the default (DEFAULT_FLAG = 'Y').
- PA_OPERATING_UNITS_V — resolves the operating unit name from the ORG_ID.
The join conditions are: PAP.PROJECT_ID = RLA.PROJECT_ID, RLU.RESOURCE_LIST_ASSIGNMENT_ID = RLA.RESOURCE_LIST_ASSIGNMENT_ID with RLU.DEFAULT_FLAG = 'Y', and PAP.ORG_ID = POU.ORG_ID.
Key Columns
- ORG_ID — the operating unit identifier, enforcing multi-org security.
- PA_SOURCE_TEMPLATE_ID — the template's source identifier (mapped from PAP.PROJECT_ID).
- PA_PROJECT_NUMBER — the template project number (SEGMENT1).
- PA_PROJECT_NAME — the template name (PAP.NAME), the column associated with the user search.
- TEMPLATE_FLAG — indicates template status.
- CREATED_FROM_PROJECT_ID — the project from which the template was copied, if any.
- CARRYING_OUT_ORGANIZATION_ID — the organization responsible for carrying out work.
- DISTRIBUTION_RULE — the default distribution rule for the template.
- TEMPLATE_START_DATE_ACTIVE / TEMPLATE_END_DATE_ACTIVE — the effective date range of the template.
- DEFAULT_RESOURCE_LIST_ID — the default resource list associated with the template.
- OPERATING_UNIT_NAME — the name of the operating unit.
Common Use Cases and Queries
The view is commonly used to populate template selection lists, validate template eligibility, and report on the default resource lists assigned to templates. A representative query to retrieve template names for the current operating unit is:
SELECT pa_project_number, pa_project_name, operating_unit_name, default_resource_list_id FROM apps.pa_select_template_v WHERE org_id = :p_org_id AND template_flag = 'Y' ORDER BY pa_project_name;SELECT pa_source_template_id, pa_project_name FROM apps.pa_select_template_v WHERE pa_project_name LIKE :search_term;SELECT t.pa_project_name, t.distribution_rule, t.template_start_date_active, t.template_end_date_active FROM apps.pa_select_template_v t WHERE TRUNC(SYSDATE) BETWEEN NVL(t.template_start_date_active, SYSDATE) AND NVL(t.template_end_date_active, SYSDATE);
Because the view joins PA_RESOURCE_LIST_USES with DEFAULT_FLAG = 'Y', any template lacking a default resource list assignment will not appear in the result set. Queries against this view should always include the ORG_ID predicate to comply with multi-org access rules.
-
View: PA_SELECT_TEMPLATE_V 12.2.2
All the valid project templates that have been created in Oracle Projects
APPS.PA_SELECT_TEMPLATE_V·↳ MO_GLOBAL·↳ PA_OPERATING_UNITS_V·↳ PA_PROJECTS·Explore PA module →
-
View: PA_SELECT_TEMPLATE_V 12.1.1
All the valid project templates that have been created in Oracle Projects
APPS.PA_SELECT_TEMPLATE_V·↳ MO_GLOBAL·↳ PA_OPERATING_UNITS_V·↳ PA_PROJECTS·Explore PA module →
-
View: XLA_PA_EI_AEL_GL_V 12.1.1
APPS.XLA_PA_EI_AEL_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_DR_AEL_SL_V 12.2.2
APPS.XLA_PA_DR_AEL_SL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_EI_AEL_SL_MRC_V 12.2.2
APPS.XLA_PA_EI_AEL_SL_MRC_V·↳ MO_GLOBAL·↳ PA_AEL_SL_EI_MRC_V·↳ PA_SECURITY·Explore XLA module →
-
View: XLA_PA_DR_AEL_GL_V 12.2.2
APPS.XLA_PA_DR_AEL_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_EI_AEL_GL_V 12.2.2
APPS.XLA_PA_EI_AEL_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_DR_AEL_GL_V 12.1.1
APPS.XLA_PA_DR_AEL_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_WIP_AEL_SL_PAC_V 12.1.1
APPS.XLA_WIP_AEL_SL_PAC_V·↳ CST_PAC_AEL_SL_WIP_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_AR_ADJ_AEL_GL_V 12.1.1
APPS.XLA_AR_ADJ_AEL_GL_V·↳ AR_AEL_GL_ADJ_V·Explore XLA module →
-
View: XLA_FA_AEL_GL_V 12.2.2
-
APPS.XLA_PSA_REQ_ENC_BC_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: OKL_AEL_GL_CTR_V 12.2.2
This view contains all the contract related transactions which have been transferred to GL. This view is used to enable OKL GL Drilldown functionality. This view displays the Lease transactions which fall under Booking, Rebook, Renewal, Rel
APPS.OKL_AEL_GL_CTR_V·↳ ARP_ADDR_LABEL_PKG·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore OKL module →
-
APPS.JAI_PO_OSP_DISP_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSP_DISP_AEL_V·Explore JA module →
-
View: JAI_AP_STDIST_AEL_SL_V 12.2.2
APPS.JAI_AP_STDIST_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_AP_STDIST_AEL_V·Explore JA module →
-
APPS.JAI_PO_REC_MTL_AEL_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ JAI_PO_REC_MTL_AEL_V·Explore JA module →
-
View: JAI_PO_OSPM_AEL_GL_V 12.2.2
APPS.JAI_PO_OSPM_AEL_GL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSPM_AEL_V·Explore JA module →
-
View: JAI_AP_MANUAL_AEL_GL_V 12.2.2
APPS.JAI_AP_MANUAL_AEL_GL_V·↳ FND_GLOBAL·↳ JAI_AP_MANUAL_AEL_V·Explore JA module →
-
View: JAI_INV_RG23_AEL_GL_V 12.2.2
APPS.JAI_INV_RG23_AEL_GL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_INV_RG23_AEL_V·Explore JA module →
-
View: XLA_FV_PYA_GL_V 12.2.2
APPS.XLA_FV_PYA_GL_V·↳ FND_GLOBAL·↳ FV_PYA_GL_V·Explore XLA module →
-
APPS.JAI_PO_REC_CENVAT_AEL_SL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ JAI_PO_REC_CENVAT_AEL_V·Explore JA module →
-
View: XLA_FV_TC_GL_V 12.1.1
-
View: XLA_REQ_ENC_AEL_GL_V 12.1.1
APPS.XLA_REQ_ENC_AEL_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_FV_PYA_GL_V 12.1.1
APPS.XLA_FV_PYA_GL_V·↳ FND_GLOBAL·↳ FV_PYA_GL_V·Explore XLA module →
-
View: XLA_OKL_AEL_GL_TRX_V 12.2.2
APPS.XLA_OKL_AEL_GL_TRX_V·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AEL_GL_TRX_V·Explore XLA module →
-
View: PA_AEL_GL_EI_V 12.2.2
APPS.PA_AEL_GL_EI_V·↳ FND_LOOKUP_VALUES·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore PA module →
-
View: XLA_AR_REC_AEL_GL_V 12.2.2
APPS.XLA_AR_REC_AEL_GL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_GL_REC_ALL_V·↳ FND_ACCESS_CONTROL_UTIL·Explore XLA module →
-
View: XLA_PA_DR_AEL_SL_MRC_V 12.2.2
APPS.XLA_PA_DR_AEL_SL_MRC_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_INV_AEL_GL_V 12.1.1
APPS.XLA_INV_AEL_GL_V·↳ CST_AEL_GL_INV_V·Explore XLA module →
-
View: XLA_PO_AEL_SL_PAC_V 12.1.1
APPS.XLA_PO_AEL_SL_PAC_V·↳ CST_PAC_AEL_SL_RCV_V·↳ FND_GLOBAL·↳ HR_GENERAL·Explore XLA module →
-
View: XLA_PO_AEL_SL_MRC_V 12.1.1
APPS.XLA_PO_AEL_SL_MRC_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_JL_FA_AEL_SL_V 12.1.1
APPS.XLA_JL_FA_AEL_SL_V·↳ JL_CO_FA_AEL_SL_V·Explore XLA module →
-
View: XLA_WIP_AEL_SL_V 12.1.1
APPS.XLA_WIP_AEL_SL_V·↳ CST_AEL_SL_WIP_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_FA_AEL_SL_MRC_V 12.2.2
APPS.XLA_FA_AEL_SL_MRC_V·↳ FA_AEL_SL_MRC_V·Explore XLA module →
-
View: XLA_WIP_AEL_SL_PAC_V 12.2.2
APPS.XLA_WIP_AEL_SL_PAC_V·↳ CST_PAC_AEL_SL_WIP_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PSA_PO_ENC_BC_GL_V 12.2.2
APPS.XLA_PSA_PO_ENC_BC_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_INV_AEL_GL_V 12.2.2
APPS.XLA_INV_AEL_GL_V·↳ CST_AEL_GL_INV_V·Explore XLA module →
-
View: XLA_AR_REC_AEL_SL_V 12.2.2
APPS.XLA_AR_REC_AEL_SL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_SL_REC_V·↳ FND_ACCESS_CONTROL_UTIL·Explore XLA module →
-
View: XLA_PO_AEL_GL_V 12.2.2
APPS.XLA_PO_AEL_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_OZF_UTL_AEL_SL_V 12.1.1
APPS.XLA_OZF_UTL_AEL_SL_V·↳ OZF_AEL_SL_UTL_V·Explore XLA module →
-
APPS.XLA_AR_REC_AEL_SL_MRC_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_SL_REC_MRC_V·↳ FND_ACCESS_CONTROL_UTIL·Explore XLA module →
-
View: XLA_PA_EI_AEL_SL_V 12.1.1
APPS.XLA_PA_EI_AEL_SL_V·↳ PA_AEL_SL_EI_V·↳ PA_SECURITY·↳ XLA_UTIL·Explore XLA module →
-
View: XLA_PA_AEL_DR_MRC_GL_V 12.2.2
APPS.XLA_PA_AEL_DR_MRC_GL_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_PA_EI_AEL_SL_V 12.2.2
APPS.XLA_PA_EI_AEL_SL_V·↳ PA_AEL_SL_EI_V·↳ PA_EXPENDITURE_INQUIRY·↳ PA_SECURITY·Explore XLA module →
-
View: XLA_PA_AEL_EI_MRC_GL_V 12.1.1
APPS.XLA_PA_AEL_EI_MRC_GL_V·↳ HR_SECURITY·↳ PA_AEL_GL_EI_MRC_V·↳ PA_SECURITY·Explore XLA module →
-
View: XLA_PA_DR_AEL_SL_MRC_V 12.1.1
APPS.XLA_PA_DR_AEL_SL_MRC_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_OKL_AEL_GL_CTR_V 12.1.1
APPS.XLA_OKL_AEL_GL_CTR_V·↳ ARP_ADDR_LABEL_PKG·↳ FND_GLOBAL·↳ OKC_UTIL·Explore XLA module →
-
View: XLA_OKL_AEL_GL_AST_V 12.2.2
APPS.XLA_OKL_AEL_GL_AST_V·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AEL_GL_AST_V·Explore XLA module →
-
View: XLA_OKL_AEL_GL_CTR_V 12.2.2
APPS.XLA_OKL_AEL_GL_CTR_V·↳ ARP_ADDR_LABEL_PKG·↳ OKC_UTIL·↳ OKL_ACCOUNTING_UTIL·Explore XLA module →
-
View: OKL_AEL_GL_TRX_V 12.1.1
This view contains the transactions which have been transferred to GL. This view is used to enable OKL GL Drilldown functionality. This view displays the Lease transactions which fall under Loss Provision, Accrual, Miscellaneous and Adjust
APPS.OKL_AEL_GL_TRX_V·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·↳ GL_JE_CATEGORIES_VL·Explore OKL module →