Results for “last_accept_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ITG_PO_LINE_LOC_ARCH_V is a reporting view owned by the APPS schema within the ITG – Internet Procurement Enterprise Connector product. Its documented purpose is XML mapping at the line location level, meaning it exposes archived purchasing document shipment and distribution attributes in a flattened, integration-friendly form suitable for outbound message generation, archival reconciliation, and cross-system data exchange. In Oracle EBS 12.1.1 and 12.2.2 the view is defined over the archived purchasing tables rather than the live transactional tables, so it reflects the state of purchase order lines and shipments as captured at archive time.

The view carries a VALID status in the ETRM repository and is referenced in the context of the search term "price_override," because PRICE_OVERRIDE is one of the columns projected directly from PO_LINE_LOCATIONS_ARCHIVE_ALL.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects: FINANCIALS_SYSTEM_PARAMS_ALL (synonym), HR_API (package), HR_GENERAL (package), HR_ORGANIZATION_UNITS_V (view), HR_SECURITY (package), MTL_UNITS_OF_MEASURE_TL (synonym), PO_HEADERS_ALL (synonym), PO_LINES_ALL (synonym), and PO_LINE_LOCATIONS_ARCHIVE_ALL (synonym). The HR packages and HR_ORGANIZATION_UNITS_V are present because the view resolves the ship-to organization name through HR security, and MTL_UNITS_OF_MEASURE_TL supplies the translated unit of measure code based on the session language.

The principal driving table is PO_LINE_LOCATIONS_ARCHIVE_ALL (aliased PLLA), joined to PO_LINES_ALL (PLA) on PO_LINE_ID and PO_HEADER_ID, to PO_HEADERS_ALL (PHA) on PO_HEADER_ID, and to FINANCIALS_SYSTEM_PARAMS_ALL (FSPA) on ORG_ID to obtain the buying organization's payment currency. The unit of measure is resolved with a DECODE that prefers the shipment-level UNIT_MEAS_LOOKUP_CODE and falls back to the line-level value. The join to HR_ORGANIZATION_UNITS_V is outer, and the predicate on PHA.TYPE_LOOKUP_CODE restricts rows to either standard orders without releases or non-standard documents with releases.

Key Columns

• PO_HEADER_ID, PO_RELEASE_ID, PO_LINE_ID, LINE_LOCATION_ID – the primary linkage keys; PO_RELEASE_ID is coalesced to -9999 when null.
• LINE_NUM, SHIPMENT_NUM – human-readable line and shipment identifiers.
• ORDERED_QUANTITY – derived as QUANTITY minus QUANTITY_CANCELLED.
• UOM – translated unit of measure code.
• NEED_BY_DATE, PROMISED_DATE, LAST_ACCEPT_DATE – scheduling and acceptance dates.
• PRICE_OVERRIDE – the shipment-level price override flag, central to the "price_override" search context.
• TAXABLE_FLAG, TAX_CODE_ID, CONSIGNED_FLAG, DROP_SHIP_FLAG – tax and sourcing attributes.
• SHIPTO_ORG_NAME, SHIPTO_ORG_OTF, SHIPTO_ORG_PARTNER_TYPE, SHIP_TO_LOC_ID, PARTNER_ID – ship-to and partner identification used in XML payloads.
• BUYING_ORG_CURRENCY, AMOUNT_SERVICES – currency and service amount for financial mapping.
• PSCLNSTATUS – derived from PLA.CANCEL_FLAG as CANCELLED or OPEN.

Common Use Cases and Queries

Typical usage includes extracting archived shipments for XML mapping into the Internet Procurement Enterprise Connector, auditing price override activity, and reconciling ordered versus cancelled quantities.

Sample query – price override audit:

• SELECT PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID, SHIPMENT_NUM, PRICE_OVERRIDE
• FROM APPS.ITG_PO_LINE_LOC_ARCH_V
• WHERE PRICE_OVERRIDE IS NOT NULL;

Sample query – open shipments by need-by date:

• SELECT PO_HEADER_ID, LINE_NUM, SHIPMENT_NUM, ORDERED_QUANTITY, UOM, NEED_BY_DATE
• FROM APPS.ITG_PO_LINE_LOC_ARCH_V
• WHERE PSCLNSTATUS = 'OPEN' AND ORDERED_QUANTITY > 0;

Because the view restricts rows to non-negative remaining quantities and applies header type rules, it is best suited to reporting over committed, archive-consistent purchasing data.