CSC Tables (27)

CSC - Customer Care — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
CSC_COLOR_CODES 9 CSC_COLOR_CODES stores information about color and rating association
CSC_CUSTOMERS 32 CSC_CUSTOMERS stores parties that criticallity is being overridden
CSC_CUSTOMERS_AUDIT_HIST 36 CSC_CUSTOMERS_AUDIT_HIST is used to store changes in customers criticallity
CSC_CUSTOMIZED_PLANS 11 CSC_CUSTOMIZED_PLANS stores the customer information of a customized plan
CSC_CUST_PLANS 38 CSC_CUST_PLANS stores the customer, plan association
CSC_CUST_PLANS_AUDIT 33 CSC_CUST_PLANS_AUDIT stores the history of all customer, plan association
CSC_PLAN_ENABLE_SETUP 31 CSC_PLAN_ENABLE_SETUP table stores the names of the form functions integrated with Relationship Plans module.
CSC_PLAN_HEADERS_B 38 CSC_PLAN_HEADERS_B table stores all the plan templates and customized plan templates.
CSC_PLAN_HEADERS_TL 14 CSC_PLAN_HEADERS_TL table stores the translated name, description of the plan templates stored in CSC_PLAN_HEADERS_B table.
CSC_PLAN_LINES 29 CSC_PLAN_LINES stores the plan details of plan templates stored in CSC_PLAN_HEADERS_B
CSC_PROF_BLOCKS_B 30 CSC_PROF_BLOCKS_B stores the profile check variable information
CSC_PROF_BLOCKS_TL 12 CSC_PROF_BLOCKS_TL table stores the translated columns of profile check variables stored in CSC_PROF_BLOCKS_B table
CSC_PROF_BLOCK_RESULTS 14 CSC_PROF_BLOCK_RESULTS stores the value of the profile check variables per party and account
CSC_PROF_CHECKS_B 28 CSC_PROF_CHECKS_B stores the profile check information
CSC_PROF_CHECKS_TL 12 CSC_PROF_CHECKS_TL table stores the translated columns of profile checks stored in CSC_PROF_CHECKS_B table
CSC_PROF_CHECK_RATINGS 20 CSC_PROF_CHECK_RATINGS stores the rating and color information
CSC_PROF_CHECK_RESULTS 18 CSC_PROF_BLOCK_RESULTS stores the value of the profile checks per party and account
CSC_PROF_CHECK_RULES_B 22 CSC_PROF_CHECK_RULES_B stores the conditions used by the profile check
CSC_PROF_CHECK_RULES_TL 12 CSC_PROF_CHECK_RULES_B stores the conditions used by the profile check
CSC_PROF_DRILLDOWN 21 CSC_PROF_DRILLDOWN is used to drilldown
CSC_PROF_GROUPS_B 21 Base Table to Store profile Group information
CSC_PROF_GROUPS_TL 12 Translation Table to Store profile Group information
CSC_PROF_GROUP_CATEGORIES 12 Store the categories that are present in a profile group . Categories are needed only for Dashboard Groups
CSC_PROF_GROUP_CHECKS 22 Store the relation between profile groups and profile checks. This table stores the Profile checks that are present in a profile group
CSC_PROF_MODULE_GROUPS 19 Relation between a form function and Profile groups. This specifies the profile group , to be displayed in the profile window when it is dis
CSC_PROF_TABLE_COLUMNS_B 16 Base table to Store Drilldown details for a profile variable. This stores the column and table names for the drilldown form. Also stores the
CSC_PROF_TABLE_COLUMNS_TL 11 Translation table to Store Drilldown details for a profile variable. This stores the column and table names for the drilldown form. Also sto