Results for “pa_proj_req_distributions”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_PROJ_REQ_DISTRIBUTIONS is an APPS-owned reporting view in Oracle E-Business Suite that exposes project-related purchase requisition distributions originating in Oracle Purchasing. As documented in the ETRM metadata, the view "displays project-related distributions in Oracle Purchasing that have not yet been purchased as a purchase order." It therefore serves as a demand-side pipeline view: it identifies committed project expenditure that has been requisitioned but not yet converted into a purchase order commitment. This makes it valuable for project cost controllers, procurement analysts, and buyers who need visibility over outstanding requisitioned demand charged to projects and tasks. The view is valid in both EBS 12.1.1 and 12.2.2 and is defined in the APPS schema.
Underlying Base Objects
The view is constructed over a join of Purchasing, Projects, and HR/GL objects. The requisition side draws from PO_REQUISITION_HEADERS_ALL and PO_REQUISITION_LINES_ALL, while distribution-level detail comes from PO_REQ_DISTRIBUTIONS_ALL. Project context is supplied by PA_PROJECTS_ALL, PA_TASKS, and PA_TASKS_EXPEND_V, with expenditure classification from PA_EXPENDITURE_TYPES. Organizations are resolved through HR_ORGANIZATION_UNITS, and the requisitioning person through PER_ALL_PEOPLE_F. Document and line type descriptions come from PO_DOCUMENT_TYPES_ALL_TL and PO_LINE_TYPES. Currency and functional amounts are handled via the GL_LEDGERS synonym and the PA_MULTI_CURRENCY package, while security and utility logic is provided by PA_TASK_UTILS, PA_UTILS4, HR_SECURITY, HR_GENERAL, and FND_PROFILE. This combination reflects that the view is a cross-product construct joining procurement transactions to project accounting attributes.
Key Columns
The view exposes a broad set of columns derived from its base objects:
- SEGMENT1, LINE_NUM – Requisition number and line number from the requisition header/line.
- TYPE_NAME – The document/line type description from PO_LINE_TYPES.
- AUTHORIZATION_STATUS – Decoded to a simple Y/N approval indicator based on whether the requisition is APPROVED.
- ITEM_DESCRIPTION, NEED_BY_DATE, CREATION_DATE – Requisition line detail, including required-by and creation dates.
- SUGGESTED_VENDOR_NAME, VENDOR_ID – Suggested supplier information on the requisition line.
- PERSON_ID, FULL_NAME – Requesting person from PER_ALL_PEOPLE_F.
- CURRENCY_CODE, RATE_DATE, RATE_TYPE, RATE – Currency and exchange rate attributes, with nulls applied when the line currency matches the functional ledger currency.
- REQ_LINE_QUANTITY, UNIT_PRICE, UNIT_MEAS_LOOKUP_CODE – Quantity-based attributes, suppressed for amount-based lines.
- REQ_LINE_AMOUNT, NONRECOVERABLE_TAX – Amount-based requisition values, including non-recoverable tax.
- SEGMENT1, NAME, TASK_NUMBER, TASK_NAME – Project number/name and task identifiers.
- EXPENDITURE_TYPE, EXPENDITURE_CATEGORY, REVENUE_CATEGORY_CODE, EXPENDITURE_ITEM_DATE – Project accounting classification and date attributes.
- REQUISITION_HEADER_ID, REQUISITION_LINE_ID, DISTRIBUTION_ID – Transactional keys linking back to Purchasing records.
Common Use Cases and Queries
Typical usage centres on identifying uncommitted requisitioned project spend. A buyer might list approved requisition lines awaiting a purchase order, while a project accountant reconciles project cost pipelines.
- Outstanding approved requisitions by project:
SELECT p.segment1, p.name, t.task_number, r.segment1, r.line_num, r.currency_code, r.req_line_amount FROM apps.pa_proj_req_distributions r, apps.pa_projects_all p, apps.pa_tasks t WHERE r.project_id = p.project_id AND r.task_id = t.task_id AND r.authorization_status = 'Y'; - Pipeline by expenditure category: aggregate req_line_amount grouped by expenditure_category to forecast project spend not yet committed.
- Currency exposure reporting: filter on currency_code and rate where the requisition currency differs from the functional ledger currency.
The view is read-only, so queries should always qualify records by project, task, or approval status to keep result sets meaningful.
-
View that displays project-related distributions in Oracle Purchasing that have not yet been purchased as a purchase order.
APPS.PA_PROJ_REQ_DISTRIBUTIONS·↳ FND_PROFILE·↳ GL_LEDGERS·↳ HR_GENERAL·Explore PA module →
-
View that displays project-related distributions in Oracle Purchasing that have not yet been purchased as a purchase order.
APPS.PA_PROJ_REQ_DISTRIBUTIONS·↳ GL_LEDGERS·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·Explore PA module →
-
Shows project related unapproved, unpurchased requisition distributions
APPS.PA_PROJ_PEND_REQ_DISTRIBUTIONS·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_MULTI_CURRENCY·Explore PA module →
-
Shows project related unapproved, unpurchased requisition distributions
APPS.PA_PROJ_PEND_REQ_DISTRIBUTIONS·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_SECURITY·Explore PA module →
-
Shows all approved and unpurchased requisition distributions, which are project related.
APPS.PA_PROJ_APPR_REQ_DISTRIBUTIONS·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_MULTI_CURRENCY·Explore PA module →
-
Shows all approved and unpurchased requisition distributions, which are project related.
APPS.PA_PROJ_APPR_REQ_DISTRIBUTIONS·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_SECURITY·Explore PA module →
-
APPS.GMS_COMMITMENTS_OVERRIDE_V·↳ AP_INVOICES_PKG·↳ CST_PROJMFG_CMT_VIEW·↳ FND_PROFILE·Explore GMS module →
-
APPS.GMS_COMMITMENTS_OVERRIDE_V·↳ AP_INVOICES_PKG·↳ CST_PROJMFG_CMT_VIEW·↳ GMS_COST_PLUS_EXTN·Explore GMS module →
-
View: PA_COMMITMENT_TXNS_V 12.2.2
A view of all oustanding project-related commitment costs.
APPS.PA_COMMITMENT_TXNS_V·↳ AP_INVOICES_PKG·↳ CST_PROJMFG_CMT_VIEW·↳ FND_PROFILE·Explore PA module →
-
View: PA_COMMITMENT_TXNS_V 12.2.2
APPS.PA_COMMITMENT_TXNS_V·↳ AP_INVOICES_PKG·↳ CST_PROJMFG_CMT_VIEW·↳ FND_PROFILE·Explore JA module →
-
View: PA_COMMITMENT_TXNS_V 12.1.1
APPS.PA_COMMITMENT_TXNS_V·↳ AP_INVOICES_PKG·↳ CST_PROJMFG_CMT_VIEW·↳ HR_GENERAL·Explore JA module →
-
View: PA_COMMITMENT_TXNS_V 12.1.1
A view of all oustanding project-related commitment costs.
APPS.PA_COMMITMENT_TXNS_V·↳ AP_INVOICES_PKG·↳ CST_PROJMFG_CMT_VIEW·↳ HR_GENERAL·Explore PA module →
-
SYNONYM: APPS.PO_LINE_TYPES 12.2.2
-
SYNONYM: APPS.PO_LINE_TYPES 12.1.1
-
VIEW: APPS.PA_TASKS_EXPEND_V 12.2.2
-
VIEW: APPS.PA_COMMITMENTS_V 12.1.1
-
VIEW: APPS.PA_COMMITMENTS_V 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2