Results for “invoice_adjustment_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The PO_AP_RETROACTIVE_DIST_V view is a Purchasing (PO) module database object owned by the APPS schema and defined with VALID status in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to capture the purchase order distributions that are candidates for retroactive invoice adjustment. In other words, it surfaces the distribution lines for which Purchasing has flagged an intent to re-price already-invoiced receipts or commitments, typically following a supplier price change that must flow back through Payables.
Within the EBS reporting and integration layer, this view functions as a pre-built, business-filtered projection over core Purchasing entities. It eliminates the multi-table join logic a developer would otherwise assemble manually and exposes a stable, named interface for concurrent programs, custom reports, Oracle Discoverer workbooks, and third-party integrations that require a list of distributions eligible for invoice adjustment. Because it is a view rather than a table, it carries no storage of its own and always reflects the current transactional state of the underlying Purchasing tables.
Underlying Base Objects
According to the documented ETRM 12.2.2 metadata, the view is defined over the following referenced base objects, all accessed through APPS synonyms:
- PO_DISTRIBUTIONS_ALL — the distribution lines that carry the INVOICE_ADJUSTMENT_FLAG and ORG_ID.
- PO_HEADERS_ALL — the purchasing document header, source of VENDOR_ID.
- PO_LINES_ALL — the document line, source of UNIT_PRICE and FROM_HEADER_ID.
- PO_LINE_LOCATIONS_ALL — the shipment or schedule line, source of PRICE_OVERRIDE, RETROACTIVE_DATE, and SHIPMENT_TYPE.
- PO_RELEASES_ALL — referenced in metadata, associated with blanket-release handling.
The view text joins PO_HEADERS_ALL to PO_LINES_ALL on PO_HEADER_ID, PO_LINES_ALL to PO_LINE_LOCATIONS_ALL on PO_LINE_ID, and PO_LINE_LOCATIONS_ALL to PO_DISTRIBUTIONS_ALL on LINE_LOCATION_ID. The effective PO_HEADER_ID is derived using a DECODE on SHIPMENT_TYPE: for BLANKET shipments the header comes directly from the distribution, otherwise the line's FROM_HEADER_ID is used when present, falling back to the distribution header. Only distributions whose INVOICE_ADJUSTMENT_FLAG is 'R' (retroactive price change pending) or 'E' (adjustment in error/exception state) are returned.
Key Columns
- PO_HEADER_ID — effective purchasing document header, resolved for blanket and standard agreements.
- PO_LINE_ID, LINE_LOCATION_ID, PO_DISTRIBUTION_ID — the line, shipment/schedule, and distribution identifiers that uniquely key the record.
- VENDOR_ID — supplier associated with the document, sourced from PO_HEADERS_ALL.
- INVOICE_ADJUSTMENT_FLAG — the decisive filter column; 'R' and 'E' denote adjustment-eligible distributions.
- UNIT_PRICE — the line unit price that drives the retroactive re-pricing calculation.
- PRICE_OVERRIDE — indicates whether a shipment-level price override applies.
- RETROACTIVE_DATE — the date from which the retroactive price adjustment takes effect; this is the column most often cited when users search for "retroactive_date".
- ORG_ID — operating unit identifier supporting multi-org security and filtering.
Common Use Cases and Queries
Typical usage includes reconciliation of retroactive price adjustments against Payables invoices, identifying distributions that require invoice re-pricing, and building exception reports for adjustments flagged 'E'. A representative query restricted to a single operating unit and a retroactive date window is:
- SELECT po_header_id, po_line_id, line_location_id, po_distribution_id, vendor_id, invoice_adjustment_flag, unit_price, price_override, retroactive_date, org_id FROM apps.po_ap_retroactive_dist_v WHERE org_id = :p_org_id AND retroactive_date >= :p_from_date AND retroactive_date < :p_to_date ORDER BY retroactive_date;
Because RETROACTIVE_DATE originates in PO_LINE_LOCATIONS_ALL, the view is the preferred access path for reporting on retroactive pricing by shipment or schedule. All references should be schema-qualified as APPS and accessed under the appropriate operating unit context.
-
PO_AP_RETROACTIVE_DIST_V view captures the distributions to be invoice adjusted..
APPS.PO_AP_RETROACTIVE_DIST_V·↳ PO_DISTRIBUTIONS_ALL·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
View: PO_DISTRIBUTION_XML 12.1.1
APPS.PO_DISTRIBUTION_XML·↳ GL_CODE_COMBINATIONS_KFV·↳ PER_ALL_PEOPLE_F·↳ PO_COMMUNICATION_GT·Explore PO module →
-
View: PO_DISTRIBUTIONS_V 12.1.1
10SC ONLY
APPS.PO_DISTRIBUTIONS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PO_DISTRIBUTIONS·↳ PO_DISTRIBUTIONS_ALL·Explore PO module →
-
PO_AP_RETROACTIVE_DIST_V view captures the distributions to be invoice adjusted..
APPS.PO_AP_RETROACTIVE_DIST_V·↳ PO_DISTRIBUTIONS_ALL·↳ PO_HEADERS_ALL·↳ PO_LINES_ALL·Explore PO module →
-
View: PO_DISTRIBUTIONS_V 12.2.2
10SC ONLY
APPS.PO_DISTRIBUTIONS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PO_DISTRIBUTIONS·↳ PO_DISTRIBUTIONS_ALL·Explore PO module →
-
APPS.PO_DISTRIBUTION_ARCHIVE_XML·↳ GL_CODE_COMBINATIONS_KFV·↳ PER_ALL_PEOPLE_F·↳ PO_COMMUNICATION_GT·Explore PO module →
-
APPS.PO_DISTRIBUTION_ARCHIVE_XML·↳ GL_CODE_COMBINATIONS_KFV·↳ HR_API·↳ HR_LOOKUPS·Explore PO module →
-
Archived distributions
-
View: PO_DISTRIBUTIONS_INQ_V 12.2.2
- Retrofitted
APPS.PO_DISTRIBUTIONS_INQ_V·↳ PO_DISTRIBUTIONS_ALL·↳ PO_DOCUMENT_TYPES_ALL_B·↳ PO_DOCUMENT_TYPES_ALL_TL·Explore PO module →
-
Archived distributions
-
Purchase order distributions draft
-
View: PO_DISTRIBUTION_XML 12.2.2
APPS.PO_DISTRIBUTION_XML·↳ GL_CODE_COMBINATIONS_KFV·↳ HR_API·↳ HR_LOOKUPS·Explore PO module →
-
The merged view using PO_DISTRIBUTIONS_ALL table and PO_DISTRIBUTIONS_DRAFT_ALL tables.
APPS.PO_DISTRIBUTIONS_MERGE_V·↳ PO_DISTRIBUTIONS_ALL·↳ PO_DISTRIBUTIONS_DRAFT_ALL·↳ PO_DRAFTS·Explore PO module →
-
Interface table for purchase order distributions
-
View: PO_DISTRIBUTIONS_AP_V 12.2.2
Purchase order distributions
APPS.PO_DISTRIBUTIONS_AP_V·↳ PO_DISTRIBUTIONS·Explore PO module →
-
View: PO_DISTRIBUTIONS_AP_V 12.1.1
Purchase order distributions
APPS.PO_DISTRIBUTIONS_AP_V·↳ PO_DISTRIBUTIONS·Explore PO module →
-
View: PO_DISTRIBUTIONS_TRX_V 12.2.2
Requisition Distribution View.
APPS.PO_DISTRIBUTIONS_TRX_V·↳ PO_CLM_INTG_GRP·↳ PO_DISTRIBUTIONS·↳ PO_LINES_TRX_V·Explore PO module →
-
View: PO_DISTRIBUTIONS_INQ_V 12.1.1
- Retrofitted
APPS.PO_DISTRIBUTIONS_INQ_V·↳ PO_DISTRIBUTIONS_ALL·↳ PO_DOCUMENT_TYPES_ALL_B·↳ PO_DOCUMENT_TYPES_ALL_TL·Explore PO module →
-
The merged view using PO_DISTRIBUTIONS_ALL table and PO_DISTRIBUTIONS_DRAFT_ALL tables.
APPS.PO_DISTRIBUTIONS_MERGE_V·↳ PO_DISTRIBUTIONS_ALL·↳ PO_DISTRIBUTIONS_DRAFT_ALL·↳ PO_DRAFTS·Explore PO module →
-
Purchase order distributions
-
Purchase order distributions
-
Interface table for purchase order distributions
-
- Retrofitted
Not implemented in this database·Explore PO module →
-
View: PO_DISTRIBUTIONS_MRC_V 12.1.1
- Retrofitted
Not implemented in this database·Explore PO module →
-
- Retrofitted
Not implemented in this database·Explore PO module →
-
View: PO_DISTRIBUTIONS_MRC_V 12.2.2
- Retrofitted
Not implemented in this database·Explore PO module →