Results for “bill_to_customer”

50+ results




Overview
Explore in AI Chat

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

Overview

The view OKL_CS_ASTUPF_TAX_SUM_UV, owned by the APPS schema within the Oracle E-Business Suite Lease and Finance Management (OKL) module, presents an Upfront Tax Summary for a leased asset. It exposes tax lines that have been generated at the transaction line level during the upfront tax calculation process performed by the E-Business Tax engine (ZX). Because the view consolidates customer billing details, line classification, asset location, and tax amounts into a single row per tax line, it is used primarily for reporting and integration purposes in both EBS 12.1.1 and 12.2.2. The BILL_TO_CUSTOMER column, which concatenates the customer account name and account number from HZ_CUST_ACCOUNTS, frequently drives searches such as "bill_to_customer" that seek to reconcile upfront tax charges against the party responsible for payment.

Underlying Base Objects

The view is defined over OKL_TAX_SOURCES, the principal tax extraction source for OKL transactions, joined against contract and stream tables and E-Business Tax classification views. Documented base objects include:

Key Columns

Common Use Cases and Queries

Typical uses include reviewing upfront tax burden by customer, reconciling OKL tax lines with E-Business Tax, and feeding downstream reporting. A representative query filtering on the bill-to customer is:

  • SELECT bill_to_customer, line_type, asset_location, tax_date, tax_amount, total_tax FROM okl_cs_astupf_tax_sum_uv WHERE bill_to_customer LIKE '%ACME%';
  • Aggregate tax by customer: SELECT bill_to_customer, SUM(total_tax) FROM okl_cs_astupf_tax_sum_uv GROUP BY bill_to_customer;
  • Filter by contract identifiers using KLE_ID or KHR_ID, or restrict by ORG_ID and LEGAL_ENTITY_ID for multi-org reporting.

Because all ZX classification joins are outer joins, rows are returned even when classification data is absent, making the view suitable for exception reporting.