Results for “requisition_line_number”
44 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PO_DISTRIBUTIONS_PRINT is an APPS-owned reporting view in the Oracle Purchasing (PO) module, catalogued in ETRM with the description marker "- Retrofitted." It is a denormalized, print-oriented projection of the distribution-level records held in PO_DISTRIBUTIONS, enriched with the delivering person's full name resolved from the HR person tables. Its primary role is to supply the data set consumed by Oracle Purchasing distribution printing and related distribution reports, where a human-readable requestor or deliver-to name is required alongside the accounting, requisition, and destination attributes of each distribution.
The view is significant in the context of Oracle EBS 12.1.1 and 12.2.2 because its definition embeds a truncation of SYSDATE against the PER_PEOPLE_F date-tracked effective range and a subquery against FINANCIALS_SYSTEM_PARAMETERS. This makes the view date-sensitive and business-group-sensitive, and it is a frequent subject of retrofitting or client-extension copy during upgrades and multi-org deployments.
Underlying Base Objects
The documented base objects for the view are:
- PO_DISTRIBUTIONS (SYNONYM) — the driving distribution table, supplying quantity, requisition, destination, DFF attribute, and key identifier columns.
- PER_PEOPLE_F (VIEW) — the HR date-tracked person view, supplying FULL_NAME.
- FINANCIALS_SYSTEM_PARAMETERS (SYNONYM) — used in a MAX(BUSINESS_GROUP_ID) subquery to scope the effective person record.
- HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY (PACKAGES) — HR infrastructure referenced by the person name and security logic.
PO_DISTRIBUTIONS and PER_PEOPLE_F are outer-joined: the predicate POD.DELIVER_TO_PERSON_ID = PPF.PERSON_ID (+) ensures distributions without a resolvable deliver-to person are still returned. The person row is accepted only when its BUSINESS_GROUP_ID matches the maximum configured in FINANCIALS_SYSTEM_PARAMETERS and the current truncation of SYSDATE falls between its effective start and end dates; otherwise the PPF.PERSON_ID IS NULL branch preserves the distribution row with a null name.
Key Columns
- REQUESTOR_NAME — the column the user searched for; it is populated from PPF.FULL_NAME and represents the deliver-to person's formatted name.
- REQUESTOR_ID / DELIVER_TO_PERSON_ID — the person identifier underlying REQUESTOR_NAME, exposed separately for joins.
- CHARGE_ACCOUNT_ID (CODE_COMBINATION_ID) — the accounting flexfield combination charged by the distribution.
- QUANTITY_ORDERED / QUANTITY_CANCELLED — ordered and cancelled distribution quantities.
- REQUISITION_NUMBER / REQUISITION_LINE_NUMBER — sourced from REQ_HEADER_REFERENCE_NUM and REQ_LINE_REFERENCE_NUM.
- DESTINATION_TYPE / DESTINATION_SUBINVENTORY — the inventory or expense destination and subinventory.
- PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID, PO_RELEASE_ID, PO_DISTRIBUTION_ID, WIP_ENTITY_ID — the full document and distribution key chain.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the distribution descriptive flexfield segments.
- LOCATION_ID — the deliver-to location.
- ORG_ID — the operating unit for multi-org security.
Common Use Cases and Queries
The view is typically used in distribution print programs, charge-account reconciliations, and custom reports requiring requestor names. A basic query follows:
SELECT requestor_name, requisition_number, charge_account_id, quantity_ordered
FROM apps.po_distributions_print
WHERE po_header_id = :p_header_id;
A requestor-oriented lookup, matching the original search, might read:
SELECT DISTINCT requestor_id, requestor_name
FROM apps.po_distributions_print
WHERE org_id = :p_org_id
ORDER BY requestor_name;
Because REQUESTOR_NAME resolves via SYSDATE and FINANCIALS_SYSTEM_PARAMETERS, results depend on the reporting date and the set of books configuration; queries intended for historical reporting should account for this behavior. In 12.1.1 and 12.2.2 the object remains an APPS view over the same base tables, with 12.2.x Online Patching considerations applying to any custom objects layered on top of it.
-
View: PO_DISTRIBUTIONS_PRINT 12.2.2
- Retrofitted
APPS.PO_DISTRIBUTIONS_PRINT·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PO module →
-
View: JAI_RCV_ACCT_DIST_V 12.2.2
APPS.JAI_RCV_ACCT_DIST_V·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS·↳ HR_GENERAL·Explore JA module →
-
View: JAI_RCV_ACCT_DIST_V 12.1.1
APPS.JAI_RCV_ACCT_DIST_V·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS·↳ HR_GENERAL·Explore JA module →
-
10SC ONLY - Retrofitted - Retrofitted
APPS.RCV_RECEIVING_ACCT_DISTR_V·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS·↳ HR_GENERAL·Explore PO module →
-
10SC ONLY - Retrofitted - Retrofitted
APPS.RCV_RECEIVING_ACCT_DISTR_V·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS·↳ HR_GENERAL·Explore PO module →
-
View: PO_DISTRIBUTIONS_PRINT 12.1.1
- Retrofitted
APPS.PO_DISTRIBUTIONS_PRINT·↳ FINANCIALS_SYSTEM_PARAMETERS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PO module →
-
- Retrofitted
APPS.INVFV_INVENTORY_SUPPLIES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_ITEM_LOCATIONS·↳ MTL_PARAMETERS·Explore INV module →
-
APPS.RCV_REC_ACCT_DISTR_MRC_V·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS·↳ HR_GENERAL·Explore PO module →
-
APPS.RCV_REC_ACCT_DISTR_MRC_V·↳ FND_GLOBAL·↳ GL_CODE_COMBINATIONS·↳ HR_GENERAL·Explore PO module →
-
- Retrofitted
APPS.POFV_INBOUND_SHIPMENT_LINES·↳ GL_CODE_COMBINATIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
- Retrofitted
APPS.POFV_RECEIVING_TRANSACTIONS·↳ AP_INVOICES_ALL·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·Explore PO module →
-
- Retrofitted
APPS.INVFV_INVENTORY_SUPPLIES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_ITEM_LOCATIONS·↳ MTL_PARAMETERS·Explore INV module →
-
- Retrofitted
APPS.POFV_RECEIVING_TRANSACTIONS·↳ AP_INVOICES_ALL·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·Explore PO module →
-
- Retrofitted
APPS.POFV_INBOUND_SHIPMENT_LINES·↳ GL_CODE_COMBINATIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
View: OEFV_SALES_ORDER_LINES 12.1.1
- Retrofitted
Not implemented in this database·Explore OE module →
-
View: OEFV_SALES_ORDER_LINES 12.2.2
- Retrofitted
Not implemented in this database·Explore OE module →
-
- Retrofitted
Not implemented in this database·Explore INV module →
-
- Retrofitted
Not implemented in this database·Explore INV module →
-
eTRM - PO Tables and Views 12.1.1
Temporary table for tracking a receiving upgrade from Release 9 to Release 10
-
eTRM - PO Tables and Views 12.2.2
Temporary table for tracking a receiving upgrade from Release 9 to Release 10
-
eTRM - JA Tables and Views 12.1.1
The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table.
-
eTRM - JA Tables and Views 12.2.2
The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines.
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2