Search Results duty_amount




Overview
Explore in AI Chat

Overview

AP_EXPENSE_FEED_LINES_V is a Payables (AP) view owned by the APPS schema that exposes the individual expense feed lines generated during corporate card and procurement card transaction processing in Oracle E-Business Suite. The view presents denormalized, reporting-friendly access to card transaction detail — merchant information, tax and freight components, currency amounts, employee references, and a full set of DFF attributes — without requiring consumers to join the underlying staging and reference tables directly.

The view is closely related to the Oracle Payments (IBY) card instrument model and the AP employee expense feed process. The columns MERCHANT_CITY, MERCHANT_NAME, MERCHANT_NUMBER, and the merchant address columns make this view a primary source for merchant-level spend analysis, audit reporting, and reconciliation of card feeds. Because it joins out to HR_EMPLOYEES_CURRENT_V and IBY payer instruments, the view also serves employee and corporate card context alongside transaction detail.

Underlying Base Objects

The documented view metadata identifies the following referenced base objects:

Note that HR_SECURITY participation means the view is subject to HR security profiles, so results are filtered by the querying user's authorized organization and employee access.

Key Columns

Common Use Cases and Queries

Typical use cases include corporate card spend analysis, merchant aggregation, tax reconciliation, and identifying rejected or unreleased feed lines before expense report creation.

Merchant spend by city:

SELECT merchant_city,
       merchant_name,
       SUM(amount) total_amount,
       COUNT(*) line_count
  FROM apps.ap_expense_feed_lines_v
 WHERE org_id = :p_org_id
   AND transaction_date BETWEEN :p_start AND :p_end
 GROUP BY merchant_city, merchant_name
 ORDER BY total_amount DESC;

Rejected feeds for review:

SELECT feed_line_id, employee_id, card_number,
       merchant_name, merchant_city, amount, reject_code
  FROM apps.ap_expense_feed_lines_v
 WHERE reject_code IS NOT NULL
   AND org_id = :p_org_id;

Tax and freight detail by merchant country:

SELECT merchant_country, merchant_city,
       SUM(tax_amount) tax, SUM(freight_amount) freight,
       SUM(duty_amount) duty
  FROM apps.ap_expense_feed_lines_v
 WHERE tax_paid_flag = 'Y'
 GROUP BY merchant_country, merchant_city;

Because the view invokes HR_SECURITY, restricted users may see reduced row sets; query as a user with appropriate HR security, and always constrain by ORG_ID in a multi-org environment.