Search Results ship_to_full_address

Overview

OKL_AM_ASSET_SALE_UV is a read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL - Lease and Finance Management product. Its name follows the standard Oracle naming convention: the _UV suffix designates a user-facing validation or inquiry view, while AM and ASSET_SALE identify the asset management and asset disposition business area. The view is reported VALID in the ETRM metadata, confirming the definition compiles cleanly against its dependent objects in both Oracle EBS 12.1.1 and 12.2.2.

The view consolidates asset sale transactions that originate in Oracle Order Management and flow into Lease and Finance Management asset return processing. It joins order header, order line, item, customer, ship-to address, contract, asset return, and remarketing data into a single denormalized row set. Its principal role is to support reporting and integration requirements where lease assets are sold to customers, providing a joined, presentation-ready projection rather than requiring report authors to reconstruct the OE/OKL relationships manually.

Underlying Base Objects

The view is defined over a fixed multi-table join. The following documented base objects are referenced:

• OE_ORDER_HEADERS_ALL (synonym) — order header source, aliased H.
• OE_ORDER_LINES_ALL (synonym) — order line source, aliased L.
• MTL_SYSTEM_ITEMS_B_KFV (view) — key flexfield item description, aliased I.
• OKL_ASSET_RETURNS_ALL_B (synonym) — asset return base table, aliased AR.
• OKL_K_LINES_FULL_V (view) — asset line details, aliased AL.
• OKC_K_HEADERS_B (synonym) — contract header, aliased KH.
• HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTY_SITES, HZ_LOCATIONS (synonyms) — Trading Community Architecture customer and address entities.
• JTF_RS_TEAMS_TL (synonym) — remarketing team translation, aliased T.
• ARP_ADDR_LABEL_PKG (package) — invoked via FORMAT_ADDRESS to build a formatted ship-to address string.

The join links order headers to lines on HEADER_ID, links inventory items through the key flexfield view, resolves customer identity through the HZ tables, and connects asset return and contract records through the OKL identifiers.

Key Columns

Columns returned by the view include:

• ART_ID and KLE_ID — asset return and asset line identifiers from OKL_ASSET_RETURNS_ALL_B.
• ORDER_NUMBER, ORDERED_DATE, and ORDER_STATUS (FLOW_STATUS_CODE) — order header attributes.
• LINE_NUMBER, HEADER_ID, INVENTORY_ITEM_ID — order line identifiers.
• ITEM_NAME (CONCATENATED_SEGMENTS) and ITEM_DESCRIPTION — item identification from the KFV view.
• CUSTOMER_ID, CUSTOMER_NAME, CUSTOMER_NUMBER — sold-to customer details from HZ.
• UNIT_SELLING_PRICE, UNIT_LIST_PRICE, TAX_VALUE, ORDERED_QUANTITY, ACTUAL_SHIPMENT_DATE — pricing, tax, quantity, and fulfillment attributes from the order line.
• BOOKED_FLAG — the order line booked indicator copied from OE_ORDER_LINES_ALL, the column most commonly searched by users validating whether a sale line has been booked.
• SHIP_SITE_ID, SHIP_TO_CONTACT_ID, and the SHIP_TO_ADDRESS, CITY, STATE, PROVINCE, COUNTY, COUNTRY, and POSTAL_CODE columns, plus SHIP_TO_FULL_ADDRESS, which is produced by ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS and truncated to 80 characters.
• ASSET_NUMBER, ASSET_DESCRIPTION, STATUS (STS_CODE), and FA_COST — asset disposition details.
• CONTRACT_NUMBER, RMR_ID, REMARKETER_NAME, and ORG_ID — contract linkage, remarketing, and multi-org context.

Common Use Cases and Queries

Typical usage includes asset sale reporting, booked versus unbooked line reconciliation, and lease-to-order integration extracts. Because BOOKED_FLAG is exposed directly, a frequent query filters unbooked sale lines:

• SELECT order_number, line_number, customer_name, item_name, booked_flag FROM apps.okl_am_asset_sale_uv WHERE booked_flag = 'N';
• SELECT contract_number, asset_number, unit_selling_price, ship_to_full_address FROM apps.okl_am_asset_sale_uv WHERE org_id = :p_org_id;

Note the BOOKED_FLAG value semantics follow OE_ORDER_LINES_ALL. The view is read-only and should be queried directly rather than modified.