CUG — Citizen Interaction Center

13 documented tables · 8 views — Oracle EBS ETRM 12.2.2

Most-referenced tables

TableDescriptionData 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

PackageClassProceduresUsed by
CUG_VALIDATE_ADDRESS_PUB PUB 2 3 packages

✨ Ask AI about CUG objects