Search Results igs_rc_i_a_lines_pk

Overview

The IGS_RC_I_A_LINES table is a junction table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the now-obsolete IGS (Student System) module. Its primary role is to establish and manage the many-to-many relationship between student inquiry or application records and sales lead lines generated from the Oracle CRM (Customer Relationship Management) system. By linking a person's application identifier (PERSON_ID, ENQUIRY_APPL_NUMBER) with a specific SALES_LEAD_LINE_ID, it enables the tracking of marketing and sales activities associated with prospective student leads throughout the recruitment lifecycle. This integration was designed to bridge student administration functions with front-office sales processes.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of three critical columns. These columns store the essential identifiers needed to create the junction relationship.

• PERSON_ID: References a unique party identifier from the HZ_PARTIES table, representing the prospective student or contact.
• ENQUIRY_APPL_NUMBER: An identifier for the specific student inquiry or application record within the IGS module, used in conjunction with PERSON_ID.
• SALES_LEAD_LINE_ID: A foreign key referencing the AS_SALES_LEAD_LINES table. This links the student record to a specific line item of a sales lead, which could represent a product of interest (e.g., a specific academic program).

Common Use Cases and Queries

This table is central to reporting and operational queries that analyze the pipeline from marketing lead to student application. A common use case is generating a report to show all sales lead lines associated with a particular set of student applications, or conversely, identifying which applications originated from a specific marketing campaign tracked via sales leads. A typical query would join this junction table to both the student system and CRM tables to retrieve a unified view.

Sample Query Pattern:
SELECT ia.person_id, ia.enquiry_appl_number, sl.lead_id, sll.product_id
FROM igs_rc_i_a_lines ia,
    as_sales_lead_lines sll,
    as_sales_leads sl
WHERE ia.sales_lead_line_id = sll.sales_lead_line_id
AND sll.lead_id = sl.lead_id
AND ia.person_id = :p_person_id;

Related Objects

The IGS_RC_I_A_LINES table sits at the intersection of two major EBS functional areas, as evidenced by its foreign key relationships.

• HZ_PARTIES: The foundational table for all parties (people, organizations) in Oracle Trading Community Architecture (TCA). The foreign key on PERSON_ID ties the student applicant to a universal party record.
• AS_SALES_LEAD_LINES: A core CRM table storing individual line items within a sales lead. The foreign key on SALES_LEAD_LINE_ID connects to the specific product or interest captured by the sales team.
• Primary Key Constraint: The IGS_RC_I_A_LINES_PK enforces the unique combination of the three key columns, ensuring a single, unambiguous link between an application and a lead line.

Important Note: The provided ETRM metadata explicitly states this table is "Not implemented in this database," indicating it may be a reference object or its usage was deprecated in specific instances. Implementations should be verified against the actual application database.