Search Results csc_plan_headers_b




Overview
Explore in AI Chat

Overview

The CSC_PLAN_HEADERS_B table is a core data object within the Oracle E-Business Suite Customer Care (CSC) module, applicable to versions 12.1.1 and 12.2.2. It serves as the foundational repository for all plan templates and customized plan templates. These plans are central to the Customer Care functionality, providing structured frameworks for service and support activities. The table's role is to define the master blueprint for service plans, which can be standardized templates or specific customizations derived from those templates. Its design, featuring a self-referential foreign key, supports hierarchical relationships between original templates and their customized versions, enabling a flexible and reusable plan management system.

Key Information Stored

The table's primary key is the PLAN_ID, a unique identifier for each plan record. Based on the documented foreign key relationships, other critical columns include ORIGINAL_PLAN_ID and PROFILE_CHECK_ID. The ORIGINAL_PLAN_ID column is pivotal, as it references the PLAN_ID of a parent template within the same table (CSC_PLAN_HEADERS_B), establishing the lineage between a base template and its customized derivatives. The PROFILE_CHECK_ID column links the plan to a profile check definition in the CSC_PROF_CHECKS_B table, likely associating the plan with specific customer eligibility or validation criteria. While the full column list is not detailed in the provided metadata, the structure implies the storage of plan attributes such as status, effective dates, creation information, and plan type indicators to distinguish between templates and custom plans.

Common Use Cases and Queries

A primary use case is retrieving all customized plans derived from a specific master template for audit or analysis purposes. This is essential for understanding the usage and modification of standard service offerings. Another common scenario involves querying the plan hierarchy to trace the origin of a customized plan. For reporting, analysts often join this table with its associated Translation table (CSC_PLAN_HEADERS_TL) to fetch plan names and descriptions in the user's session language. Sample SQL to find all custom plans based on a template with PLAN_ID=100 would be:

  • SELECT cust_plan.PLAN_ID FROM csc_plan_headers_b cust_plan WHERE cust_plan.ORIGINAL_PLAN_ID = 100;

To obtain a full hierarchical view of plans and their source templates, a self-join is used:

  • SELECT template.PLAN_ID AS TEMPLATE_ID, custom.PLAN_ID AS CUSTOM_PLAN_ID FROM csc_plan_headers_b template RIGHT JOIN csc_plan_headers_b custom ON template.PLAN_ID = custom.ORIGINAL_PLAN_ID;

Related Objects

The CSC_PLAN_HEADERS_B table is central to the Customer Care data model, with extensive relationships to other key entities. The documented foreign key constraints define the following specific dependencies:

  • Referenced by this table (Outgoing Foreign Keys):
    • CSC_PLAN_HEADERS_B.ORIGINAL_PLAN_ID references CSC_PLAN_HEADERS_B.PLAN_ID (Self-reference for plan hierarchy).
    • CSC_PLAN_HEADERS_B.PROFILE_CHECK_ID references CSC_PROF_CHECKS_B (Links to profile check definitions).
  • Referencing this table (Incoming Foreign Keys):

This network of relationships underscores the table's role as the master source for plan definitions, which are then detailed in lines, applied to customers, audited, and referenced in transactional data.

  • Table: CSC_PLAN_HEADERS_B 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PLAN_HEADERS_B,  object_name:CSC_PLAN_HEADERS_B,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PLAN_HEADERS_B table stores all the plan templates and customized plan templates. ,  implementation_dba_data: CSC.CSC_PLAN_HEADERS_B , 

  • Table: CSC_PLAN_HEADERS_B 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PLAN_HEADERS_B,  object_name:CSC_PLAN_HEADERS_B,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PLAN_HEADERS_B table stores all the plan templates and customized plan templates. ,  implementation_dba_data: CSC.CSC_PLAN_HEADERS_B , 

  • Table: CSC_PLAN_LINES 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PLAN_LINES,  object_name:CSC_PLAN_LINES,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PLAN_LINES stores the plan details of plan templates stored in CSC_PLAN_HEADERS_B ,  implementation_dba_data: CSC.CSC_PLAN_LINES , 

  • Table: CSC_PLAN_LINES 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PLAN_LINES,  object_name:CSC_PLAN_LINES,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PLAN_LINES stores the plan details of plan templates stored in CSC_PLAN_HEADERS_B ,  implementation_dba_data: CSC.CSC_PLAN_LINES , 

  • Table: CSC_PLAN_HEADERS_TL 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PLAN_HEADERS_TL,  object_name:CSC_PLAN_HEADERS_TL,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PLAN_HEADERS_TL table stores the translated name, description of the plan templates stored in CSC_PLAN_HEADERS_B table. ,  implementation_dba_data: CSC.CSC_PLAN_HEADERS_TL , 

  • Table: CSC_PLAN_HEADERS_TL 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PLAN_HEADERS_TL,  object_name:CSC_PLAN_HEADERS_TL,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PLAN_HEADERS_TL table stores the translated name, description of the plan templates stored in CSC_PLAN_HEADERS_B table. ,  implementation_dba_data: CSC.CSC_PLAN_HEADERS_TL , 

  • View: CSC_PLAN_HEADERS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CSC.CSC_PLAN_HEADERS_VL,  object_name:CSC_PLAN_HEADERS_VL,  status:VALID,  product: CSC - Customer Care ,  description: This view is the MLSed view based on CSC_PLAN_HEADERS_B and CSC_PLAN_HEADERS_TL used in lock row event of server side API's ,  implementation_dba_data: APPS.CSC_PLAN_HEADERS_VL , 

  • View: CSC_PLAN_HEADERS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CSC.CSC_PLAN_HEADERS_VL,  object_name:CSC_PLAN_HEADERS_VL,  status:VALID,  product: CSC - Customer Care ,  description: This view is the MLSed view based on CSC_PLAN_HEADERS_B and CSC_PLAN_HEADERS_TL used in lock row event of server side API's ,  implementation_dba_data: APPS.CSC_PLAN_HEADERS_VL , 

  • Table: CSC_CUST_PLANS 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_CUST_PLANS,  object_name:CSC_CUST_PLANS,  status:VALID,  product: CSC - Customer Care ,  description: CSC_CUST_PLANS stores the customer, plan association ,  implementation_dba_data: CSC.CSC_CUST_PLANS , 

  • Table: CSC_CUST_PLANS_AUDIT 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_CUST_PLANS_AUDIT,  object_name:CSC_CUST_PLANS_AUDIT,  status:VALID,  product: CSC - Customer Care ,  description: CSC_CUST_PLANS_AUDIT stores the history of all customer, plan association ,  implementation_dba_data: CSC.CSC_CUST_PLANS_AUDIT , 

  • Table: CSC_CUSTOMIZED_PLANS 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_CUSTOMIZED_PLANS,  object_name:CSC_CUSTOMIZED_PLANS,  status:VALID,  product: CSC - Customer Care ,  description: CSC_CUSTOMIZED_PLANS stores the customer information of a customized plan ,  implementation_dba_data: CSC.CSC_CUSTOMIZED_PLANS , 

  • Table: CSC_CUST_PLANS 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_CUST_PLANS,  object_name:CSC_CUST_PLANS,  status:VALID,  product: CSC - Customer Care ,  description: CSC_CUST_PLANS stores the customer, plan association ,  implementation_dba_data: CSC.CSC_CUST_PLANS , 

  • Table: CSC_CUSTOMIZED_PLANS 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_CUSTOMIZED_PLANS,  object_name:CSC_CUSTOMIZED_PLANS,  status:VALID,  product: CSC - Customer Care ,  description: CSC_CUSTOMIZED_PLANS stores the customer information of a customized plan ,  implementation_dba_data: CSC.CSC_CUSTOMIZED_PLANS , 

  • Table: CSC_CUST_PLANS_AUDIT 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_CUST_PLANS_AUDIT,  object_name:CSC_CUST_PLANS_AUDIT,  status:VALID,  product: CSC - Customer Care ,  description: CSC_CUST_PLANS_AUDIT stores the history of all customer, plan association ,  implementation_dba_data: CSC.CSC_CUST_PLANS_AUDIT , 

  • Table: CSC_PROF_CHECKS_B 12.2.2

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECKS_B,  object_name:CSC_PROF_CHECKS_B,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_CHECKS_B stores the profile check information ,  implementation_dba_data: CSC.CSC_PROF_CHECKS_B , 

  • Table: CSC_PROF_CHECKS_B 12.1.1

    owner:CSC,  object_type:TABLE,  fnd_design_data:CSC.CSC_PROF_CHECKS_B,  object_name:CSC_PROF_CHECKS_B,  status:VALID,  product: CSC - Customer Care ,  description: CSC_PROF_CHECKS_B stores the profile check information ,  implementation_dba_data: CSC.CSC_PROF_CHECKS_B , 

  • View: CSC_PLAN_HEADERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:CSC.CSC_PLAN_HEADERS_V,  object_name:CSC_PLAN_HEADERS_V,  status:VALID,  product: CSC - Customer Care ,  description: This view is based on CSC_PLAN_HEADRES_B & CSC_PLAN_HEADRES_TL used in the client code ,  implementation_dba_data: APPS.CSC_PLAN_HEADERS_V , 

  • View: CSC_PLAN_HEADERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:CSC.CSC_PLAN_HEADERS_V,  object_name:CSC_PLAN_HEADERS_V,  status:VALID,  product: CSC - Customer Care ,  description: This view is based on CSC_PLAN_HEADRES_B & CSC_PLAN_HEADRES_TL used in the client code ,  implementation_dba_data: APPS.CSC_PLAN_HEADERS_V ,