Search Results ship_to_org_code

Overview

PO_LINE_LOCATIONS_RFQQT_V is an APPS-owned view in the Oracle E-Business Suite Purchasing (PO) module. The ETRM metadata flags this object with the description "10SC ONLY - Retrofitted," indicating that it originated as a customer- or release-specific customization and was retrofitted into the standard 11i/12.x code line. It is not a seeded, generally documented Oracle view; it exists to expose request-for-quotation (RFQ) and quotation shipment lines in a denormalized, reporting-friendly form.

Functionally, the view joins PO_LINE_LOCATIONS (the shipment or "line location" detail of a purchasing document) to PO_HEADERS_ALL, and restricts the result set to documents whose TYPE_LOOKUP_CODE is either 'RFQ' or 'QUOTATION'. It therefore presents the shipment-level scheduling attributes of RFQs and quotations alongside descriptive lookups — organization codes, location codes, payment terms, and tax codes. Because the header filter is embedded in the view definition, any query against it returns only RFQ/quotation shipments, making it a targeted reporting and integration surface rather than a general-purpose purchasing line view.

Underlying Base Objects

Per the ETRM 12.2.2 object list, the view resolves to the following referenced objects: PO_LINE_LOCATIONS (SYNONYM), PO_HEADERS_ALL (SYNONYM), ORG_ORGANIZATION_DEFINITIONS (VIEW), HR_LOCATIONS_ALL_TL (SYNONYM), AP_TERMS (SYNONYM), AP_TAX_CODES_ALL (SYNONYM), plus the HR_GENERAL and HR_SECURITY packages used for language handling and security resolution.

• PO_LINE_LOCATIONS — the driving table; supplies shipment number, dates, quantity, price, receipt/inspection flags, and all descriptive attributes.
• PO_HEADERS_ALL — joined on PO_HEADER_ID; provides QUOTE_TYPE_LOOKUP_CODE and supplies the RFQ/QUOTATION filter.
• ORG_ORGANIZATION_DEFINITIONS — outer-joined on SHIP_TO_ORGANIZATION_ID to resolve ORGANIZATION_CODE and ORGANIZATION_NAME.
• HR_LOCATIONS_ALL_TL — outer-joined on SHIP_TO_LOCATION_ID and restricted by USERENV('LANG') to return LOCATION_CODE in the session language.
• AP_TERMS and AP_TAX_CODES_ALL — outer-joined lookups for payment term name and tax code name.

Key Columns

The view exposes the full PO_LINE_LOCATIONS column set plus six joined descriptive columns. Notable items include SHIP_TO_ORGANIZATION_ID together with OOD.ORGANIZATION_CODE — the column users search for as "ship_to_org_code" — and OOD.ORGANIZATION_NAME. SHIP_TO_LOCATION_ID is accompanied by HRL.LOCATION_CODE. Scheduling and control columns include QUANTITY, UNIT_MEAS_LOOKUP_CODE, PRICE_OVERRIDE, PRICE_DISCOUNT, NEED_BY_DATE, LAST_ACCEPT_DATE, START_DATE, END_DATE, LEAD_TIME, LEAD_TIME_UNIT, FIRM_STATUS_LOOKUP_CODE, RECEIPT_REQUIRED_FLAG, INSPECTION_REQUIRED_FLAG, RECEIVE_CLOSE_TOLERANCE, and QTY_RCV_EXCEPTION_CODE. Commercial attributes include TERMS_ID with APT.NAME, FREIGHT_TERMS_LOOKUP_CODE, FOB_LOOKUP_CODE, SHIP_VIA_LOOKUP_CODE with ATC.NAME, TAXABLE_FLAG, and TAX_CODE_ID.

Common Use Cases and Queries

Typical uses are reporting on RFQ shipment destinations, validating ship-to organization codes, and feeding downstream quoting or sourcing integrations. A representative query joining the view to the organization definition follows:

• Listing all RFQ/quotation shipments by ship-to organization code.
• Extracting need-by dates and quantities for sourcing analysis.
• Auditing receipt-required and inspection-required flags on quoted lines.

SELECT pll.po_header_id, pll.po_line_id, pll.line_location_id, pll.ship_to_organization_id, pll.organization_code, pll.organization_name, pll.need_by_date, pll.quantity, pll.unit_meas_lookup_code FROM apps.po_line_locations_rfqqt_v pll WHERE pll.organization_code = :ship_to_org_code; Because the view already filters on RFQ and QUOTATION header types, no additional header-type predicate is required.