Results for “partner_city”

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

Overview

ASFV_SALES_CREDITS is a read-only view in the Oracle E-Business Suite Sales Foundation (AS) module. It consolidates sales credit, quota credit, and revenue attribution data recorded against leads and sales groups, enriched with descriptive attributes drawn from sales force, customer, address, and human resources tables. The view is designed primarily for reporting and integration scenarios where users need a denormalized perspective on how credit for a lead is distributed across sales representatives, sales groups, and partner organizations.

The "F" suffix and the WITH READ ONLY clause confirm that this object is a reporting-only construct. It cannot be used for DML operations, and any application logic depending on it must treat the result set as immutable.

Underlying Base Objects

The view is defined over seven base objects joined with outer joins, preserving credit records even when descriptive data is missing:

• AS_SALES_CREDITS CRED — the primary fact table holding revenue and quota credit amounts and percentages, along with foreign keys to lead, salesforce, sales group, partner customer, and partner address.
• AS_LEADS_ALL LEAD — supplies LEAD_NUMBER and DESCRIPTION for the associated lead.
• AS_SALES_GROUPS GRP — supplies the sales group NAME.
• AS_SALESFORCE SF — resolves the sales representative's employee person identifier.
• PER_ALL_PEOPLE_F PER — provides FIRST_NAME and LAST_NAME, joined with an effective-date predicate using TRUNC(SYSDATE) between EFFECTIVE_START_DATE and NVL(EFFECTIVE_END_DATE, SYSDATE).
• RA_CUSTOMERS CUST — provides CUSTOMER_NAME for the partner.
• RA_ADDRESSES_ALL ADDR — provides partner CITY and COUNTRY.

A pseudocolumn literal '_DF:AS:AS_SALES_CREDITS:CRED' is exposed under the column alias "_DF", functioning as a foreign-key resolver marker for the AS_SALES_CREDITS base row.

Key Columns

• REVENUE_AMOUNT / REVENUE_PERCENT — the credited revenue value and its percentage share.
• QUOTA_CREDIT_AMOUNT / QUOTA_CREDIT_PERCENT — the quota credit value and its percentage share.
• SALES_REP_FIRST_NAME / SALES_REP_LAST_NAME — the sales representative's name, sourced through AS_SALESFORCE to PER_ALL_PEOPLE_F. This is the column most commonly searched when identifying credit ownership.
• SALES_GROUP_NAME — the name of the sales group receiving credit.
• LEAD_NUMBER / LEAD_DESCRIPTION — identifying and descriptive attributes of the associated lead.
• PARTNER_CUSTOMER_NAME, PARTNER_CITY, PARTNER_COUNTRY — partner organization and location attributes.
• SALES_CREDIT_ID, LEAD_ID, LEAD_LINE_ID, SALESFORCE_ID, SALESGROUP_ID, PARTNER_CUSTOMER_ID, PARTNER_ADDRESS_ID — foreign keys to the underlying entities.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard WHO audit columns.

Common Use Cases and Queries

The view supports revenue attribution reporting, quota credit analysis, and lead-to-representative traceability. A typical query locating credits by representative name:

SELECT lead_number, sales_rep_first_name, sales_rep_last_name,
       sales_group_name, revenue_amount, revenue_percent
FROM   asfv_sales_credits
WHERE  sales_rep_first_name = :rep_first_name;

Aggregating quota credit by sales group:

SELECT sales_group_name, SUM(quota_credit_amount) total_quota
FROM   asfv_sales_credits
GROUP  BY sales_group_name;

Partner revenue analysis by country:

SELECT partner_country, SUM(revenue_amount) revenue
FROM   asfv_sales_credits
GROUP  BY partner_country;

Because outer joins populate descriptive columns conditionally, reports should anticipate nulls in representative, customer, and address attributes where the corresponding base record is absent.