CUG — Citizen Interaction Center
13 documented tables · 8 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
CUG_TSK_TYP_ATTR_DEPS_B |
This Table stores the dependencies between Task Type and Service Request Attributes for a Service Request Type | hub-leaning |
CUG_TSK_TYP_ATTR_MAPS_B |
This Table stores the Task Attributes associated with a Task Type | hub-leaning |
CUG_SR_TYPE_ATTR_MAPS_B |
This Table stores the mapping between Service Request Types and Service Request Attributes | satellite-leaning |
CUG_SR_TASK_TYPE_DETS_B |
This table is used to hold additional details about the Task Type for a Service Request Type | satellite-leaning |
CUG_INCIDNT_ATTR_VALS_B |
This Table contains the runtime values of the Service Request Attributes configured for a Service Request Typ | satellite-leaning |
CUG_SR_TASK_ATTR_VALS_B |
This Table stores the values of Task Type Attributes for a Service Request Type. | satellite-leaning |
CUG_SR_TASK_ATTR_VALS_TL |
This is the Translation Table for the CUG_SR_TASK_ATTR_VALS_B Table | satellite-leaning |
CUG_TSK_TYP_ATTR_DEPS_TL |
This is the Translation table for CUG_TSK_TYP_ATTR_DEPS_B Table | satellite-leaning |
CUG_SR_TYPE_DUP_CHK_INFO |
This Table stores the Business Rules to identify a Service Request Type as a Duplicate. | link |
CUG_SR_TYPE_ATTR_MAPS_TL |
This Table holds the translated values of the CUG_SR_TYPE_ATTR_MAPS_B Table | satellite-leaning |
CUG_SR_TASK_TYPE_DETS_TL |
This Table holds the translated values for the CUG_SR_TASK_TYPE_DETS_B Table | satellite-leaning |
CUG_INCIDNT_ATTR_VALS_TL |
This Table contains the Translation information for the CUG_INCIDENT_ATTR_VALS_B Table. | satellite-leaning |
CUG_TSK_TYP_ATTR_MAPS_TL |
This is the Translation Table for the CUG_TSK_TYP_ATTR_MAPS_B Table | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
CUG_VALIDATE_ADDRESS_PUB |
PUB | 2 | 3 packages |