Search Results lead_pss_line_id

Overview

The table PV_LEAD_PSS_LINES is a core data object within the Oracle E-Business Suite Partner Management (PV) module, specifically for releases 12.1.1 and 12.2.2. It functions as a transactional detail table designed to capture and manage partner services and solutions (PSS) information associated with sales leads. This table establishes a critical link between the lead management process and partner capabilities, enabling the tracking of which specific partner-provided services or solutions are proposed or relevant for a given sales opportunity. Its role is to support partner-led sales cycles by detailing the partner's proposed value-add beyond the core product.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented foreign key relationships and primary key define its essential structure. The central identifier is the LEAD_PSS_LINE_ID, which serves as the primary key for each unique record. Each record is fundamentally tied to a sales lead via the LEAD_ID column, linking to the standard lead tables in Oracle CRM. The PARTNER_ID column stores a reference to the specific partner (from HZ_PARTIES) associated with the service line. Furthermore, the ATTR_CODE_ID column is crucial, as it links to PV_ATTRIBUTE_CODES_B to categorize and define the type of service or solution being offered (e.g., implementation, consulting, managed service). Additional columns likely store descriptive information, quantities, statuses, and dates pertinent to the partner service line.

Common Use Cases and Queries

This table is primarily used in reporting and operational processes related to partner-involved sales pipelines. Common use cases include generating reports on partner contribution to leads, analyzing which services are most frequently attached to successful opportunities, and validating partner compensation or accreditation based on attached services. A typical analytical query would join this table to lead and partner information.

• Reporting on Leads with Partner Services: SELECT l.lead_number, p.party_name, ac.meaning AS service_type FROM pv_lead_pss_lines pll JOIN as_sales_leads l ON pll.lead_id = l.lead_id JOIN hz_parties p ON pll.partner_id = p.party_id JOIN pv_attribute_codes_b ac ON pll.attr_code_id = ac.attr_code_id;
• Counting Partner Service Lines per Lead: SELECT lead_id, COUNT(*) AS number_of_pss_lines FROM pv_lead_pss_lines GROUP BY lead_id;

Related Objects

The integrity and utility of PV_LEAD_PSS_LINES are defined by its relationships with other key EBS tables, as documented in its foreign keys.

• PV_ATTRIBUTE_CODES_B (via ATTR_CODE_ID): This is the master reference for the type of partner service or solution recorded on each line.
• AS_LEADS_ALL and AS_SALES_LEADS (via LEAD_ID): These tables provide the core sales lead information to which the partner services are attached. The dual reference suggests compatibility with different lead entity models within the application.
• HZ_PARTIES (via PARTNER_ID): This is the Trading Community Architecture (TCA) registry for parties, identifying the specific partner organization responsible for the service line.