CSC — Customer Care
27 documented tables · 79 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
CSC_PROF_BLOCKS_B |
CSC_PROF_BLOCKS_B stores the profile check variable information | hub |
CSC_PROF_CHECKS_B |
CSC_PROF_CHECKS_B stores the profile check information | hub |
CSC_PLAN_HEADERS_B |
CSC_PLAN_HEADERS_B table stores all the plan templates and customized plan templates. | hub |
CSC_PROF_GROUPS_B |
Base Table to Store profile Group information | hub-leaning |
CSC_PROF_CHECK_RULES_B |
CSC_PROF_CHECK_RULES_B stores the conditions used by the profile check | satellite-leaning |
CSC_CUSTOMERS |
CSC_CUSTOMERS stores parties that criticallity is being overridden | hub-leaning |
CSC_COLOR_CODES |
CSC_COLOR_CODES stores information about color and rating association | hub-leaning |
CSC_PROF_BLOCK_RESULTS |
CSC_PROF_BLOCK_RESULTS stores the value of the profile check variables per party and account | satellite-leaning |
CSC_PROF_DRILLDOWN |
CSC_PROF_DRILLDOWN is used to drilldown | standalone |
CSC_PLAN_HEADERS_TL |
CSC_PLAN_HEADERS_TL table stores the translated name, description of the plan templates stored in CSC_PLAN_HEA | satellite-leaning |
CSC_CUSTOMERS_AUDIT_HIST |
CSC_CUSTOMERS_AUDIT_HIST is used to store changes in customers criticallity | satellite-leaning |
CSC_PLAN_ENABLE_SETUP |
CSC_PLAN_ENABLE_SETUP table stores the names of the form functions integrated with Relationship Plans module. | satellite-leaning |
CSC_PLAN_LINES |
CSC_PLAN_LINES stores the plan details of plan templates stored in CSC_PLAN_HEADERS_B | link |
CSC_PROF_GROUPS_TL |
Translation Table to Store profile Group information | satellite-leaning |
CSC_PROF_BLOCKS_TL |
CSC_PROF_BLOCKS_TL table stores the translated columns of profile check variables stored in CSC_PROF_BLOCKS_B | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
CSC_PROF_GROUP_CAT_PUB |
PUB | 5 | 0 packages |
CSC_CUST_PLANS_PUB |
PUB | 7 | 0 packages |
CSC_GROUP_CHECKS_PUB |
PUB | 5 | 0 packages |
CSC_PROF_COLOR_CODE_PUB |
PUB | 4 | 0 packages |
CSC_PROFILE_CHECK_RULES_PUB |
PUB | 5 | 0 packages |
CSC_CHECK_RATINGS_PUB |
PUB | 5 | 0 packages |
CSC_RELATIONSHIP_PLANS_PUB |
PUB | 5 | 0 packages |
CSC_PROFILE_GROUPS_PUB |
PUB | 5 | 0 packages |
CSC_PLAN_LINES_PUB |
PUB | 5 | 0 packages |
CSC_PROFILE_CHECK_PUB |
PUB | 5 | 0 packages |