Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - CUG Tables and Views

TABLE - CUG.CUG_INCIDNT_ATTR_VALS_B
TABLE - CUG.CUG_INCIDNT_ATTR_VALS_TL
TABLE - CUG.CUG_SR_TASK_ATTR_VALS_B
TABLE - CUG.CUG_SR_TASK_ATTR_VALS_TL
TABLE - CUG.CUG_SR_TASK_TYPE_DETS_B
TABLE - CUG.CUG_SR_TASK_TYPE_DETS_TL
TABLE - CUG.CUG_SR_TYPE_ATTR_MAPS_B
TABLE - CUG.CUG_SR_TYPE_ATTR_MAPS_TL
TABLE - CUG.CUG_SR_TYPE_DUP_CHK_INFO
TABLE - CUG.CUG_TSK_TYP_ATTR_DEPS_B
TABLE - CUG.CUG_TSK_TYP_ATTR_DEPS_TL
TABLE - CUG.CUG_TSK_TYP_ATTR_MAPS_B
TABLE - CUG.CUG_TSK_TYP_ATTR_MAPS_TL
VIEW - APPS.CUG_INCIDNT_ATTR_VALS_V
VIEW - APPS.CUG_INCIDNT_ATTR_VALS_VL
VIEW - APPS.CUG_SR_TASK_ATTR_VALS_VL
VIEW - APPS.CUG_SR_TASK_TYPE_DETS_VL
VIEW - APPS.CUG_SR_TYPE_ATTR_MAPS_VL
VIEW - APPS.CUG_SR_TYPE_DUP_CHK_INFO_V
VIEW - APPS.CUG_TSK_TYP_ATTR_DEPS_VL
VIEW - APPS.CUG_TSK_TYP_ATTR_MAPS_VL

Table: CUG_INCIDNT_ATTR_VALS_B

Description: This Table contains the runtime values of the Service Request Attributes configured for a Service Request Type
Primary Key: CUG_INCIDNT_ATTR_VALS_B_PK
  1. INCIDNT_ATTR_VAL_ID
Primary Key: INCIDNT_ATTR_VALS_B_UK1
  1. SR_ATTRIBUTE_CODE
  2. INCIDENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_INCIDNT_ATTR_VALS_B.INCIDENT_ID CS_INCIDENTS_ALL_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CUG_INCIDNT_ATTR_VALS_TL.INCIDNT_ATTR_VAL_ID CUG_INCIDNT_ATTR_VALS_B
Comments

The CUG_INCIDNT_ATTR_VALS_B Table contains the runtime values of the Service Request Attributes configured for a Service Request Type. The OVERWRITE_ADDRESS_VALID_FLAG column is used to overwrite the default configuration to validate the Incident Address for a Service Request Type. This is required so that a supervisor can create a Service Request even if the Incident Address validation fails for that Service Request Type.

Indexes
Index Type Tablespace Column
CUG_INCIDNT_ATTR_VALS_B_U1 UNIQUE APPS_TS_TX_IDX INCIDNT_ATTR_VAL_ID
CUG_INCIDNT_ATTR_VALS_B_U2 UNIQUE APPS_TS_TX_IDX INCIDENT_ID
SR_ATTRIBUTE_CODE
Columns
Name Datatype Length Mandatory Comments
INCIDNT_ATTR_VAL_ID NUMBER (15) Y Primary key of the Table
OBJECT_VERSION_NUMBER NUMBER

Used for 'Stateless' HTML Application
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
INCIDENT_ID NUMBER (15) Y Foreign key to the CS_INCIDENTS_ALL_B Table
SR_ATTRIBUTE_CODE VARCHAR2 (30) Y Foreign Key to the FND_LOOKUP_VALUES Table
OVERRIDE_ADDR_VALID_FLAG VARCHAR2 (1)
used to overwrite the incident address validation for a Service Request Type at runtime
ATTRIBUTE1 VARCHAR2 (150)
Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Flexfield column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Flexfield column
SECURITY_GROUP_ID NUMBER (15)
Security column for Hosting

[top of page]

CUG.CUG_INCIDNT_ATTR_VALS_B does not reference any database object

CUG.CUG_INCIDNT_ATTR_VALS_B is referenced by following:

APPS
SYNONYM - CUG_INCIDNT_ATTR_VALS_B

[top of page]

Table: CUG_INCIDNT_ATTR_VALS_TL

Description: This Table contains the Translation information for the CUG_INCIDENT_ATTR_VALS_B Table.
Primary Key: CUG_INCIDNT_ATTR_VALS_TL_PK
  1. INCIDNT_ATTR_VAL_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_INCIDNT_ATTR_VALS_TL.INCIDNT_ATTR_VAL_ID CUG_INCIDNT_ATTR_VALS_B
Comments

The CUG_INCIDNT_ATTR_VALS_TL table contains the Translation information for the CUG_INCIDNT_ATTR_VALS_B Table. The DESCRIPTION column contains the translated values of the Service Request Type Attribute Values.

Indexes
Index Type Tablespace Column
CUG_INCIDNT_ATTR_VALS_TL_U1 UNIQUE APPS_TS_TX_IDX INCIDNT_ATTR_VAL_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INCIDNT_ATTR_VAL_ID NUMBER (15) Y Foreign Key column to the CUG_INCIDNT_ATTR_VALS_B Table
LANGUAGE VARCHAR2 (4) Y Language of translated text
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SOURCE_LANG VARCHAR2 (4) Y Language of translated text
SR_ATTRIBUTE_VALUE VARCHAR2 (1997)
Translated Value of the Service Request Attribute entered at Runtime
SECURITY_GROUP_ID NUMBER (15)
Used by hosted applications

[top of page]

CUG.CUG_INCIDNT_ATTR_VALS_TL does not reference any database object

CUG.CUG_INCIDNT_ATTR_VALS_TL is referenced by following:

APPS
SYNONYM - CUG_INCIDNT_ATTR_VALS_TL

[top of page]

Table: CUG_SR_TASK_ATTR_VALS_B

Description: This Table stores the values of Task Type Attributes for a Service Request Type.
Primary Key: CUG_SR_TASK_ATTR_VALS_B_PK
  1. SR_TASK_ATTR_VAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_SR_TASK_ATTR_VALS_B.TSK_TYP_ATTR_DEPEND_ID CUG_TSK_TYP_ATTR_DEPS_B
CUG_SR_TASK_ATTR_VALS_B.TASK_TYPE_ATTR_MAP_ID CUG_TSK_TYP_ATTR_MAPS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CUG_SR_TASK_ATTR_VALS_TL.SR_TASK_ATTR_VAL_ID CUG_SR_TASK_ATTR_VALS_B
Comments

The CUG_SR_TASK_ATTR_VALS_B Table stores the values of the Task Type Attributes for a Service Request Type. The Task Attribute values may change depending on the Service Request Type, However, the Task Attributes are set for a Task Type independent of the Service Request Type.
The SEQUENCE column stores the order in which the Tasks are created for a Service Request Type

Indexes
Index Type Tablespace Column
CUG_SR_TASK_ATTR_VALS_B_U1 UNIQUE APPS_TS_SEED SR_TASK_ATTR_VAL_ID
CUG_SR_TASK_ATTR_VALS_B_U2 UNIQUE APPS_TS_SEED TSK_TYP_ATTR_DEPEND_ID
TASK_TYPE_ATTR_MAP_ID
CUG_SR_TASK_ATTR_VALS_B_N2 NONUNIQUE APPS_TS_SEED TASK_TYPE_ATTR_MAP_ID
Columns
Name Datatype Length Mandatory Comments
SR_TASK_ATTR_VAL_ID NUMBER (15) Y Primary Key of the Table
OBJECT_VERSION_NUMBER NUMBER (15)
used for 'stateless' HTML applications
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
TSK_TYP_ATTR_DEPEND_ID NUMBER (15) Y Foreign key to the CUG_TSK_TYP_ATTR_DEPENDS Table
TASK_TYPE_ATTR_MAP_ID NUMBER (15) Y Foreign key to the CUG_TASK_TYPE_ATTR_MAPS Table
SECURITY_GROUP_ID NUMBER (15)
Used for Hosted applications

[top of page]

CUG.CUG_SR_TASK_ATTR_VALS_B does not reference any database object

CUG.CUG_SR_TASK_ATTR_VALS_B is referenced by following:

APPS
SYNONYM - CUG_SR_TASK_ATTR_VALS_B

[top of page]

Table: CUG_SR_TASK_ATTR_VALS_TL

Description: This is the Translation Table for the CUG_SR_TASK_ATTR_VALS_B Table
Primary Key: CUG_SR_TASK_ATTR_VALS_TL_PK
  1. SR_TASK_ATTR_VAL_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_SR_TASK_ATTR_VALS_TL.SR_TASK_ATTR_VAL_ID CUG_SR_TASK_ATTR_VALS_B
Comments

This is the Translation Table for the CUG_SR_TASK_ATTR_VALS_B Table

Indexes
Index Type Tablespace Column
CUG_SR_TASK_ATTR_VALS_TL_U1 NONUNIQUE APPS_TS_SEED SR_TASK_ATTR_VAL_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SR_TASK_ATTR_VAL_ID NUMBER (15) Y Foreign key to the CUG_SR_TASK_ATTR_VALS_B Table
LANGUAGE VARCHAR2 (4) Y Language of Translation
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
SOURCE_LANG VARCHAR2 (4) Y Language of the Translated text
TASK_TYPE_ATTR_VALUE VARCHAR2 (1997)
Holds the translated value of the Task Type Attribute for the Service Request Type
SECURITY_GROUP_ID NUMBER (15)
Used by Hosted Applications

[top of page]

CUG.CUG_SR_TASK_ATTR_VALS_TL does not reference any database object

CUG.CUG_SR_TASK_ATTR_VALS_TL is referenced by following:

APPS
SYNONYM - CUG_SR_TASK_ATTR_VALS_TL

[top of page]

Table: CUG_SR_TASK_TYPE_DETS_B

Description: This table is used to hold additional details about the Task Type for a Service Request Type
Primary Key: CUG_SR_TASK_TYPE_DETS_B_PK
  1. SR_TASK_TYPE_DET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_SR_TASK_TYPE_DETS_B.TSK_TYP_ATTR_DEP_ID CUG_TSK_TYP_ATTR_DEPS_B
CUG_SR_TASK_TYPE_DETS_B.TASK_STATUS_ID JTF_TASK_STATUSES_B
CUG_SR_TASK_TYPE_DETS_B.OWNER_ID JTF_RS_GROUPS_B
CUG_SR_TASK_TYPE_DETS_B.OWNER_ID JTF_RS_RESOURCE_EXTNS
CUG_SR_TASK_TYPE_DETS_B.TASK_PRIORITY_ID JTF_TASK_PRIORITIES_B
CUG_SR_TASK_TYPE_DETS_B.OWNER_ID JTF_RS_TEAMS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CUG_SR_TASK_TYPE_DETS_TL.SR_TASK_TYPE_DET_ID CUG_SR_TASK_TYPE_DETS_B
Comments

The CUG_SR_TASK_TYPE_DETS_B table is used to hold additional details about the Task Type for a Service Request Type. The additonal details are required to be entered at configuration time to be used while creating the Tasks of the Task Type attached to the Service Request Type.

Indexes
Index Type Tablespace Column
CUG_SR_TASK_TYPE_DETS_B_N1 NONUNIQUE APPS_TS_SEED TSK_TYP_ATTR_DEP_ID
CUG_SR_TASK_TYPE_DETS_B_N3 NONUNIQUE APPS_TS_SEED TASK_STATUS_ID
CUG_SR_TASK_TYPE_DETS_B_N4 NONUNIQUE APPS_TS_SEED OWNER_ID
CUG_SR_TASK_TYPE_DETS_B_N5 NONUNIQUE APPS_TS_SEED TASK_PRIORITY_ID
CUG_SR_TASK_TYPE_DETS_B_U1 NONUNIQUE APPS_TS_SEED SR_TASK_TYPE_DET_ID
Columns
Name Datatype Length Mandatory Comments
SR_TASK_TYPE_DET_ID NUMBER (15) Y Primary Key of the Table
OBJECT_VERSION_NUMBER NUMBER (15)
Used for HTML Applications
CREATED_BY NUMBER (15) Y Standard who column
CREATION_DATE DATE
Y Standard who column
LAST_UPDATED_BY NUMBER (15) Y Standard who column
LAST_UPDATE_DATE DATE
Y Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TSK_TYP_ATTR_DEP_ID NUMBER (15) Y Foreign key to the CUG_TSK_TYP_ATTR_DEPS_B Table
TASK_STATUS_ID NUMBER (15) Y Foreign key to the JTF_TASK_STATUSES_B Table
OWNER_ID NUMBER
Y Unique identifier of the Task Owner
OWNER_TYPE_CODE VARCHAR2 (30) Y Unique identifier of the Type of the Task Owner
ASSIGNED_BY_ID NUMBER

Unique identifier of the user who assigned the task to current owner
ASSIGNEE_TYPE_CODE VARCHAR2 (30)
Unique identifier of the type of person who assigned the task to the owner
TASK_PRIORITY_ID NUMBER

Foreign key to JTF_TASK_PRIORITIES_B
PLANNED_START_OFFSET NUMBER (15)
The time period from the current date that marks the planned start date of the Task. Reserved For Future Use.
PLANNED_END_OFFSET NUMBER (15)
The time period from the current date that marks the planned end date of the Task. Reserved For Future Use.
PLANNED_START_UOM VARCHAR2 (30)
The unit of measure for the time period offset of the Planned Start Date. Reserved For Future Use.
PLANNED_END_UOM VARCHAR2 (30)
The unit of measure for the time period offset of the Planned End Date. Reserved For Future Use.
SCHEDULED_START_OFFSET NUMBER (15)
The time period from the current date that marks the scheduled start date of the Task. Reserved For Future Use.
SCHEDULED_END_OFFSET NUMBER (15)
The time period from the current date that marks the scheduled start date of the Task. Reserved For Future Use.
SCHEDULED_START_UOM VARCHAR2 (30)
The unit of measure for the time period offset of the Scheduled Start Date. Reserved For Future Use.
SCHEDULED_END_UOM VARCHAR2 (30)
The unit of measure for the time period offset of the Planned End Date. Reserved For Future Use.
PRIVATE_FLAG VARCHAR2 (1)
Indicates whether the task is private or public
PUBLISH_FLAG VARCHAR2 (1)
Indicates whether the task should be published.
ATTRIBUTE1 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flexfield column
SECURITY_GROUP_ID NUMBER (15)
Security column for hosted applications

[top of page]

CUG.CUG_SR_TASK_TYPE_DETS_B does not reference any database object

CUG.CUG_SR_TASK_TYPE_DETS_B is referenced by following:

APPS
SYNONYM - CUG_SR_TASK_TYPE_DETS_B

[top of page]

Table: CUG_SR_TASK_TYPE_DETS_TL

Description: This Table holds the translated values for the CUG_SR_TASK_TYPE_DETS_B Table
Primary Key: CUG_SR_TASK_TYPE_DETS_TL_PK
  1. SR_TASK_TYPE_DET_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_SR_TASK_TYPE_DETS_TL.SR_TASK_TYPE_DET_ID CUG_SR_TASK_TYPE_DETS_B
Comments

This CUG_SR_TASK_TYPE_DETS_TLTable holds the translated values for the CUG_SR_TASK_TYPE_DETS_B Table

Indexes
Index Type Tablespace Column
CUG_SR_TASK_TYPE_DETS_TL_U1 NONUNIQUE APPS_TS_SEED SR_TASK_TYPE_DET_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SR_TASK_TYPE_DET_ID NUMBER (15) Y Foreign Key to the Base Table
LANGUAGE VARCHAR2 (4) Y Holds the Language of translation
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
TASK_NAME VARCHAR2 (80) Y Translated value of the Task Name
DESCRIPTION VARCHAR2 (4000)
Translated value of the Task description
SOURCE_LANG VARCHAR2 (4) Y Language of translation
SECURITY_GROUP_ID NUMBER (15)
Security column for hosted applications

[top of page]

CUG.CUG_SR_TASK_TYPE_DETS_TL does not reference any database object

CUG.CUG_SR_TASK_TYPE_DETS_TL is referenced by following:

APPS
SYNONYM - CUG_SR_TASK_TYPE_DETS_TL

[top of page]

Table: CUG_SR_TYPE_ATTR_MAPS_B

Description: This Table stores the mapping between Service Request Types and Service Request Attributes
Primary Key: CUG_SR_TYPE_ATTR_MAPS_B_PK
  1. SR_TYPE_ATTR_MAP_ID
Primary Key: CUG_SR_TYPE_ATTR_MAP_B_UK1
  1. INCIDENT_TYPE_ID
  2. SR_ATTRIBUTE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_SR_TYPE_ATTR_MAPS_B.INCIDENT_TYPE_ID CS_INCIDENT_TYPES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CUG_SR_TYPE_ATTR_MAPS_TL.SR_TYPE_ATTR_MAP_ID CUG_SR_TYPE_ATTR_MAPS_B
Comments

The CUG_SR_TYPE_ATTR_MAPS_B Table stores the mapping between the Service Request Types and Service Request Attributes.
A set of questions need to be answered for a Service Request Type while creating a Service Request for a citizen. What questions should be asked for a Service Request Type are configured by a Business Analyst at the time of Configuring the CIC application.
The Call center agent sees all the preconfigured questions at the time of creating a Request of a certain Type.
This Table stores the questions configured by the Business Analysts for the Service Request Type.
The Service Request Attributes can be deactivated for a Service Request Type using the START_DATE_ACTIVE and END_DATE_ACTIVE columns of the Table.

Indexes
Index Type Tablespace Column
CUG_SR_TYPE_ATTR_MAPS_B_U1 UNIQUE APPS_TS_SEED SR_TYPE_ATTR_MAP_ID
CUG_SR_TYPE_ATTR_MAPS_B_U2 UNIQUE APPS_TS_SEED SR_ATTRIBUTE_CODE
INCIDENT_TYPE_ID
TEMPLATE_ID
CUG_SR_TYPE_ATTR_MAPS_B_N1 NONUNIQUE APPS_TS_SEED INCIDENT_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
SR_TYPE_ATTR_MAP_ID NUMBER (15) Y Primary key for the Table
OBJECT_VERSION_NUMBER NUMBER (15)
For 'stateless' HTML applications
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
INCIDENT_TYPE_ID NUMBER (15)
Foreign key to the CS_INCIDENT_TYPES_B Table
SR_ATTRIBUTE_CODE VARCHAR2 (30) Y Name of the Service Request Attribute. Foreign key to the FND_LOOKUP_VALUES Table
SR_ATTR_MANDATORY_FLAG VARCHAR2 (1) Y Specifies if the Service Request Attribute is required at runtime
SR_ATTR_DISPLAYED_FLAG VARCHAR2 (1) Y Specifies whether the Service Request Attribute is displayed at runtime
SR_ATTR_DUP_CHECK_FLAG VARCHAR2 (1) Y Specifies whether the Service RequestAttribute should be used to check for duplicate Service Requests
SR_ATTRIBUTE_LIST_NAME VARCHAR2 (30)
Name of the List of values to be attached with the Service Request Attribute. Foreign key to the FND_LOOKUP_TYPES Table
ATTRIBUTE1 VARCHAR2 (150)
Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Flexfield Column
START_DATE_ACTIVE DATE

Start Date of the time period for which Service Request Attribute is valid
END_DATE_ACTIVE DATE

End Date of the time period for which Service Request Attribute is valid
SECURITY_GROUP_ID NUMBER (15)
Security column for Hosted Applications
TEMPLATE_ID NUMBER (15)
Template Id
REQD_FOR_CLOSE_FLAG VARCHAR2 (1)
Required for the Close of Service Request
SHOW_ON_UPDATE_FLAG VARCHAR2 (1)
The attribute is shown on Update Page if set to 'Y'
UPDATE_ALLOWED_FLAG VARCHAR2 (1)
Indicates if upate is allowed for the attributes
SR_TYPE_ATTR_SEQ_NUM NUMBER (10)
SR Attribute Sequence

[top of page]

CUG.CUG_SR_TYPE_ATTR_MAPS_B does not reference any database object

CUG.CUG_SR_TYPE_ATTR_MAPS_B is referenced by following:

APPS
SYNONYM - CUG_SR_TYPE_ATTR_MAPS_B

[top of page]

Table: CUG_SR_TYPE_ATTR_MAPS_TL

Description: This Table holds the translated values of the CUG_SR_TYPE_ATTR_MAPS_B Table
Primary Key: CUG_SR_TYPE_ATTR_MAPS_TL_PK
  1. SR_TYPE_ATTR_MAP_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_SR_TYPE_ATTR_MAPS_TL.SR_TYPE_ATTR_MAP_ID CUG_SR_TYPE_ATTR_MAPS_B
Comments

This Table holds the translated values of the CUG_SR_TYPE_ATTR_MAPS_B Table

Indexes
Index Type Tablespace Column
CUG_SR_TYPE_ATTR_MAPS_TL_U1 NONUNIQUE APPS_TS_SEED SR_TYPE_ATTR_MAP_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SR_TYPE_ATTR_MAP_ID NUMBER (15) Y Foreign key to the Base Table
LANGUAGE VARCHAR2 (4) Y Holds the Language of Translation
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
SR_ATTR_DEFAULT_VALUE VARCHAR2 (1997)
Default value of the Service Request attribute
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
SOURCE_LANG VARCHAR2 (4) Y Language of Translated Text
SECURITY_GROUP_ID NUMBER (15)
Used by hosted applications

[top of page]

CUG.CUG_SR_TYPE_ATTR_MAPS_TL does not reference any database object

CUG.CUG_SR_TYPE_ATTR_MAPS_TL is referenced by following:

APPS
SYNONYM - CUG_SR_TYPE_ATTR_MAPS_TL

[top of page]

Table: CUG_SR_TYPE_DUP_CHK_INFO

Description: This Table stores the Business Rules to identify a Service Request Type as a Duplicate.
Primary Key: CUG_SR_TYPE_DUP_CHK_INFO_PK
  1. SR_TYPE_DUP_CHK_INFO_ID
Primary Key: CUG_SR_TYPE_DUP_CHK_INFO_UK1
  1. INCIDENT_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_SR_TYPE_DUP_CHK_INFO.INCIDENT_TYPE_ID CS_INCIDENT_TYPES_B
CUG_SR_TYPE_DUP_CHK_INFO.RESOURCE_ID JTF_RS_RESOURCE_EXTNS
Comments

The CUG_SR_TYPE_DUP_CHK_INFO Table stores the Business Rules that identify a Service Request Type as a Duplicate.
The DUPLICATE_CHECK_FLAG column is used to specify whether a Service Request Type should be checked for Duplicates. The DUPLICATE_OFFSET and DUPLICATE_UOM columns are used to store the time period and unit of measure for the time period during which occurrence of an identical Service Request would be considered a Duplicate for a Service Request Type. The DEFAULT_OWNER_ID column contains the userid of the default owner of the Service Request Type.
The Table also contains few Flag columns that are used to configure various checks for a Service Request Types like should the Incident Address be validated, is the incident Address mandatory for the Service Request Type and whether the Primary valid address of the customer should be copied over to the Runtime Service Request Attribute Capture Form.
The Table also contains a set of Flexfield Attribute Columns that can be used to hold additional information for the Service Request Type per the Customer requirements.

Indexes
Index Type Tablespace Column
CUG_SR_TYPE_DUP_CHK_INFO_U1 UNIQUE APPS_TS_SEED SR_TYPE_DUP_CHK_INFO_ID
CUG_SR_TYPE_DUP_CHK_INFO_U2 UNIQUE APPS_TS_SEED INCIDENT_TYPE_ID
CUG_SR_TYPE_DUP_CHK_INFO_N2 NONUNIQUE APPS_TS_SEED RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
SR_TYPE_DUP_CHK_INFO_ID NUMBER (15) Y Primary Key for the Table
OBJECT_VERSION_NUMBER NUMBER (15)
used for 'stateless' HTML applications
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
INCIDENT_TYPE_ID NUMBER (15) Y Foreign Key to the CS_INCIDENT_TYPES_B Table
RESOURCE_ID NUMBER (15)
Unique Identifier of the default Service Request Owner.
MANDATORY_ADDRESS_FLAG VARCHAR2 (1) Y Specifies whether the Incident address of the Service Request should be mandatory for a Service Request Type
VALIDATE_ADDRESS_FLAG VARCHAR2 (1) Y Specifies whether the Incident Address for a Service Request Type should be validated at runtime for a Service Request Type
COPY_ADDRESS_FLAG VARCHAR2 (1)
specifies whether the Primary valid address of the customer should be copied into the Runtime Service Request Attribute capture form for a Service Request Type.
SR_DUP_CHECK_FLAG VARCHAR2 (1) Y specifies whether the Service Request Type should be checked for duplicates
DUPLICATE_OFFSET NUMBER (5)
The time period during which a Service Request would be checked for duplicates
DUPLICATE_UOM VARCHAR2 (30)
The Unit of measure of the Duplicate time period
ATTRIBUTE1 VARCHAR2 (150)
Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Flexfield Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Flexfield Column
SECURITY_GROUP_ID NUMBER (15)
Security column for hosted applications
DUP_CHK_INCIDENT_ADDR_FLAG VARCHAR2 (1)
Flag if dulicate check should include Incident Address

[top of page]

CUG.CUG_SR_TYPE_DUP_CHK_INFO does not reference any database object

CUG.CUG_SR_TYPE_DUP_CHK_INFO is referenced by following:

APPS
SYNONYM - CUG_SR_TYPE_DUP_CHK_INFO

[top of page]

Table: CUG_TSK_TYP_ATTR_DEPS_B

Description: This Table stores the dependencies between Task Type and Service Request Attributes for a Service Request Type
Primary Key: CUG_TSK_TYP_ATTR_DEPS_B_PK
  1. TSK_TYP_ATTR_DEP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_TSK_TYP_ATTR_DEPS_B.TASK_TYPE_ID JTF_TASK_TYPES_B
CUG_TSK_TYP_ATTR_DEPS_B.INCIDENT_TYPE_ID CS_INCIDENT_TYPES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CUG_SR_TASK_ATTR_VALS_B.TSK_TYP_ATTR_DEPEND_ID CUG_TSK_TYP_ATTR_DEPS_B
CUG_SR_TASK_TYPE_DETS_B.TSK_TYP_ATTR_DEP_ID CUG_TSK_TYP_ATTR_DEPS_B
CUG_TSK_TYP_ATTR_DEPS_TL.TSK_TYP_ATTR_DEP_ID CUG_TSK_TYP_ATTR_DEPS_B
Comments

The CUG_TSK_TYP_ATTR_DEPS_B Table stores the dependencies between Task Type and Service Request Attributes for a Service Request Type.
The Task Types are associated with the Service Request Types either conditionally or unconditionally. The unconditional association will create the Task Type for the Service Request Type regardless. The conditional association will depend upon the values of Service Request Attributes to be created for a Service Request type when the call center agent creates a Service Request of that Type.
This Table stores the associations between Service Request Type, Task Type, Service Request Attribute Name, Service Request Attribute Value. A Null value of the Service Request Attribute indicates unconditional Task Type.

Indexes
Index Type Tablespace Column
CUG_TSK_TYP_ATTR_DEPS_B_U1 UNIQUE APPS_TS_SEED TSK_TYP_ATTR_DEP_ID
CUG_TSK_TYP_ATTR_DEPS_B_N1 NONUNIQUE APPS_TS_SEED TASK_TYPE_ID
CUG_TSK_TYP_ATTR_DEPS_B_N2 NONUNIQUE APPS_TS_SEED INCIDENT_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
TSK_TYP_ATTR_DEP_ID NUMBER (15) Y Primary Key of the Table
OBJECT_VERSION_NUMBER NUMBER (15)
Used for 'stateless' HTML Applications
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
INCIDENT_TYPE_ID NUMBER (15) Y Foreign Key to the CS_INCIDENT_TYPES_B Table
TASK_TYPE_ID NUMBER (15) Y Foreign Key to the JTF_TASK_TYPES_B Table
SR_ATTRIBUTE_CODE VARCHAR2 (30)
Foreign key to the FND_LOOKUP_values Table
SR_ATTRIBUTE_OPERATOR VARCHAR2 (30)
Specifies the relationship between SR_ATTRIBUTE_CODE and SR_ATTRIBUTE_VALUE
START_DATE_ACTIVE DATE

Start Date of the time period for which the Task Type is active for the specified Service Request Type
END_DATE_ACTIVE DATE

End Date of the time period for which the Task Type is active for the specified Service Request Type
ATTRIBUTE1 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flexfield column
SECURITY_GROUP_ID NUMBER (15)
Security column used by hosted Applications

[top of page]

CUG.CUG_TSK_TYP_ATTR_DEPS_B does not reference any database object

CUG.CUG_TSK_TYP_ATTR_DEPS_B is referenced by following:

APPS
SYNONYM - CUG_TSK_TYP_ATTR_DEPS_B

[top of page]

Table: CUG_TSK_TYP_ATTR_DEPS_TL

Description: This is the Translation table for CUG_TSK_TYP_ATTR_DEPS_B Table
Primary Key: CUG_TSK_TYP_ATTR_DEPS_TL_PK
  1. TSK_TYP_ATTR_DEP_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_TSK_TYP_ATTR_DEPS_TL.TSK_TYP_ATTR_DEP_ID CUG_TSK_TYP_ATTR_DEPS_B
Comments

This is the Translation table for CUG_TSK_TYP_ATTR_DEPS_B Table

Indexes
Index Type Tablespace Column
CUG_TSK_TYP_ATTR_DEPS_TL_U1 NONUNIQUE APPS_TS_SEED TSK_TYP_ATTR_DEP_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TSK_TYP_ATTR_DEP_ID NUMBER (15) Y Foreign key to the CUG_TSK_TYP_ATTR_DEPS_B table
LANGUAGE VARCHAR2 (4) Y Language of Translation
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
SR_ATTRIBUTE_VALUE VARCHAR2 (1997)
Value of the Service Request Attribute that triggers a Task Type
SOURCE_LANG VARCHAR2 (4) Y Language of Translated Text
SECURITY_GROUP_ID NUMBER (15)
Used by Hosted Applications

[top of page]

CUG.CUG_TSK_TYP_ATTR_DEPS_TL does not reference any database object

CUG.CUG_TSK_TYP_ATTR_DEPS_TL is referenced by following:

APPS
SYNONYM - CUG_TSK_TYP_ATTR_DEPS_TL

[top of page]

Table: CUG_TSK_TYP_ATTR_MAPS_B

Description: This Table stores the Task Attributes associated with a Task Type
Primary Key: CUG_TSK_TYP_ATTR_MAPS_B_PK
  1. TSK_TYP_ATTR_MAP_ID
Primary Key: CUG_TSK_TYP_ATTR_MAPS_B_UK1
  1. TASK_TYPE_ATTRIBUTE_CODE
  2. TASK_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_TSK_TYP_ATTR_MAPS_B.TASK_TYPE_ID JTF_TASK_TYPES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CUG_SR_TASK_ATTR_VALS_B.TASK_TYPE_ATTR_MAP_ID CUG_TSK_TYP_ATTR_MAPS_B
CUG_TSK_TYP_ATTR_MAPS_TL.TSK_TYP_ATTR_MAP_ID CUG_TSK_TYP_ATTR_MAPS_B
Comments

The CUG_TSK_TYP_ATTR_MAPS_B Table stores the Task Type Attributes associated with a Task Type. The Task Type Attributes are associated with the Task Type by the Business Analyst at time of configuring the CIC Application. This association is independant of the Service Request Type. The Table also contains columns to specify the Task Type Attribute as Mandatory and to hold the default values of the Task Type Attributes. The Task Type Attributes can be inactivated for a Task Type using the START_DATE_ACTIVE and END_DATE_ACTIVE Columns of the Table.

Indexes
Index Type Tablespace Column
CUG_TSK_TYP_ATTR_MAPS_B_U1 UNIQUE APPS_TS_SEED TSK_TYP_ATTR_MAP_ID
CUG_TSK_TYP_ATTR_MAPS_B_U2 UNIQUE APPS_TS_SEED TASK_TYPE_ATTRIBUTE_CODE
TASK_TYPE_ID
CUG_TSK_TYP_ATTR_MAPS_B_N1 NONUNIQUE APPS_TS_SEED TASK_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
TSK_TYP_ATTR_MAP_ID NUMBER (15) Y Primary key for the Table
OBJECT_VERSION_NUMBER NUMBER (15)
used by 'stateless' HTML applications
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
TASK_TYPE_ATTRIBUTE_CODE VARCHAR2 (30) Y Task Type Attribute Name. Foreign Key to the FND_LOOKUP_VALUES Table
TASK_TYPE_ID NUMBER (15) Y Uniquely identifies the Task Type. Foreign key to the JTF_TASK_TYPES Table
TASK_ATTR_DEFAULT_VALUE VARCHAR2 (1997)
Holds the default value of the Task Attribute
TASK_ATTR_MANDATORY_FLAG VARCHAR2 (1)
Specifies whether the Task type Attribute is mandatory for a Task Type
TASK_ATTR_DISPLAYED_FLAG VARCHAR2 (1)
Specifies whether the Task Type Attribute is displayed or not
TASK_ATTRIBUTE_LIST_NAME VARCHAR2 (30)
Holds the name of the List of Values for the Task Type Attribute
START_DATE_ACTIVE DATE

Start Date of the time period for which Task Type Attribute is valid
END_DATE_ACTIVE DATE

End Date of the time period for which Task Type Attribute is valid
ATTRIBUTE1 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flexfield column
SECURITY_GROUP_ID NUMBER (15)
security column for hosted applications

[top of page]

CUG.CUG_TSK_TYP_ATTR_MAPS_B does not reference any database object

CUG.CUG_TSK_TYP_ATTR_MAPS_B is referenced by following:

APPS
SYNONYM - CUG_TSK_TYP_ATTR_MAPS_B

[top of page]

Table: CUG_TSK_TYP_ATTR_MAPS_TL

Description: This is the Translation Table for the CUG_TSK_TYP_ATTR_MAPS_B Table
Primary Key: CUG_TSK_TYP_ATTR_MAPS_TL_PK
  1. TSK_TYP_ATTR_MAP_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
CUG_TSK_TYP_ATTR_MAPS_TL.TSK_TYP_ATTR_MAP_ID CUG_TSK_TYP_ATTR_MAPS_B
Comments

The CUG_TSK_TYP_ATTR_MAPS_TL Table is the Translation Table for the CUG_TSK_TYP_ATTR_MAPS_B Table

Indexes
Index Type Tablespace Column
CUG_TSK_TYP_ATTR_MAPS_TL_U1 NONUNIQUE APPS_TS_SEED TSK_TYP_ATTR_MAP_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
SOURCE_LANG VARCHAR2 (4) Y Language of the translated text
TASK_ATTR_DEFAULT_VALUE VARCHAR2 (1997)
Holds the default value of the Task Attribute
TSK_TYP_ATTR_MAP_ID NUMBER (15) Y Foreign key to teh CUG_TSK_TYP_ATTR_MAPS_B Table
LANGUAGE VARCHAR2 (4) Y Language of Translation
SECURITY_GROUP_ID NUMBER (15)
Used by hosted applications

[top of page]

CUG.CUG_TSK_TYP_ATTR_MAPS_TL does not reference any database object

CUG.CUG_TSK_TYP_ATTR_MAPS_TL is referenced by following:

APPS
SYNONYM - CUG_TSK_TYP_ATTR_MAPS_TL

[top of page]

View: CUG_INCIDNT_ATTR_VALS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
SR_TYPE_ATTR_MAP_ID NUMBER (15) Y Primary key of the underlying base Table cug_sr_type_attr_maps_vl
SR_ATTRIBUTE_CODE VARCHAR2 (30) Y Foreign Key to the FND_LOOKUP_VALUES Table
INCIDENT_TYPE_ID NUMBER (15)
Foreign key to the CS_INCIDENTS_ALL_B Table
SR_ATTR_MANDATORY_FLAG VARCHAR2 (1) Y Specifies if the Service Request Attribute is required at runtime
SR_ATTR_DISPLAYED_FLAG VARCHAR2 (1) Y Specifies whether the Service Request Attribute is displayed at runtime
SR_ATTR_DUP_CHECK_FLAG VARCHAR2 (1) Y Specifies whether the Service RequestAttribute should be used to check for duplicate Service Requests
SR_ATTRIBUTE_LIST_NAME VARCHAR2 (30)
Name of the List of values to be attached with the Service Request Attribute. Foreign key to the FND_LOOKUP_TYPES Table
SR_ATTR_DEFAULT_VALUE VARCHAR2 (1997)
Default Value of the Service Request Attribute entered at Runtime
START_DATE_ACTIVE DATE

Effective Start Date
END_DATE_ACTIVE DATE

Effective End Date
ROW_ID ROWID (10)
RowId
INCIDNT_ATTR_VAL_ID NUMBER (15)
Primary key of the underlying base Table cug_incidnt_attr_vals_vl
OBJECT_VERSION_NUMBER NUMBER

Used for 'Stateless' HTML Application
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
INCIDENT_ID NUMBER (15)
Foreign key to the CS_INCIDENTS_ALL_B Table
OVERRIDE_ADDR_VALID_FLAG VARCHAR2 (1)
used to overwrite the incident address validation for a Service Request Type at runtime
ATTRIBUTE1 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flexfield column
SR_ATTRIBUTE_VALUE VARCHAR2 (1997)
Translated Value of the Service Request Attribute entered at Runtime
SR_TYPE_ATTR_SEQ_NUM NUMBER (10)
SR Attribute Sequence Number
DESCRIPTION VARCHAR2 (240)
Description for Attribute question from fnd_lookups
SR_ATTR_LKUP_START_DATE DATE

Start date from fnd_lookups table for attribute code
SR_ATTR_LKUP_END_DATE DATE

End date from fnd_lookups table for attribute code

[top of page]

APPS.CUG_INCIDNT_ATTR_VALS_V references the following:

APPS
VIEW - CUG_INCIDNT_ATTR_VALS_VL
VIEW - CUG_SR_TYPE_ATTR_MAPS_VL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS

APPS.CUG_INCIDNT_ATTR_VALS_V is not referenced by any database object

[top of page]

View: CUG_INCIDNT_ATTR_VALS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

This view captures run time values for the SR Attributes.. The details captured include SR Attribute Code, SR Attribute Value and , Over ride Address Flag.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
INCIDNT_ATTR_VAL_ID NUMBER (15) Y Primary key of the Underlying Base Table
OBJECT_VERSION_NUMBER NUMBER

used by 'stateless' HTML applications
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
INCIDENT_ID NUMBER (15) Y Foreign key to the CS_INCIDENTS_ALL_B Table
SR_ATTRIBUTE_CODE VARCHAR2 (30) Y Foreign Key to the FND_LOOKUP_VALUES Table
OVERRIDE_ADDR_VALID_FLAG VARCHAR2 (1)
used to overwrite the incident address validation for a Service Request Type at runtime
ATTRIBUTE1 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flexfield column
SR_ATTRIBUTE_VALUE VARCHAR2 (1997)
Translated Value of the Service Request Attribute entered at Runtime

[top of page]

APPS.CUG_INCIDNT_ATTR_VALS_VL references the following:

APPS
SYNONYM - CUG_INCIDNT_ATTR_VALS_B
SYNONYM - CUG_INCIDNT_ATTR_VALS_TL
APPS.CUG_INCIDNT_ATTR_VALS_VL is referenced by following:

APPS
PACKAGE BODY - CS_EA_AUTOGEN_TASKS_PVT
PACKAGE BODY - CS_SR_DUP_CHK_PVT
PACKAGE BODY - CS_SR_WF_DUP_CHK_PVT
PACKAGE BODY - CUG_GENERIC_WF_PKG
VIEW - CUG_INCIDNT_ATTR_VALS_V
PACKAGE BODY - CUG_PREVENT_SR_UPDATE_PKG
PACKAGE BODY - CUG_WF_EMAIL_UTIL

[top of page]

View: CUG_SR_TASK_ATTR_VALS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

This view captures the Task Type Attribute and the Value for a given combination of SR Type and Task Type. The Task Type Attribute is obtained based on the various attributes associated with the task type.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
SR_TASK_ATTR_VAL_ID NUMBER (15) Y Primary Key of the Underlying Base Table
OBJECT_VERSION_NUMBER NUMBER (15)
used by 'stateless' HTML applications
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
TSK_TYP_ATTR_DEPEND_ID NUMBER (15) Y Foreign key to the CUG_TSK_TYP_ATTR_DEPENDS Table
TASK_TYPE_ATTR_MAP_ID NUMBER (15) Y Foreign key to the CUG_TASK_TYPE_ATTR_MAPS Table
TASK_TYPE_ATTR_VALUE VARCHAR2 (1997)
Holds the translated value of the Task Type Attribute for the Service Request Type

[top of page]

APPS.CUG_SR_TASK_ATTR_VALS_VL references the following:

APPS
SYNONYM - CUG_SR_TASK_ATTR_VALS_B
SYNONYM - CUG_SR_TASK_ATTR_VALS_TL
APPS.CUG_SR_TASK_ATTR_VALS_VL is referenced by following:

APPS
PACKAGE BODY - CUG_WF_EMAIL_UTIL

[top of page]

View: CUG_SR_TASK_TYPE_DETS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

This view is used by the SR Type - Task Type Attribute Capture form to capture the Mandatory Attributes during configuration. These attributes are used as the default values by the Create Task API when tasks are created for an SR .

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
ASSIGNED_BY_ID NUMBER

Unique identifier of the user who assigned the task to current owner
ASSIGNEE_TYPE_CODE VARCHAR2 (30)
Unique identifier of the type of person who assigned the task to the owner
TASK_PRIORITY_ID NUMBER

Foreign key to JTF_TASK_PRIORITIES_B
PLANNED_START_OFFSET NUMBER (15)
Reserved For Future Use
PLANNED_END_OFFSET NUMBER (15)
Reserved For Future Use
SR_TASK_TYPE_DET_ID NUMBER (15) Y Primary Key of the Underlying Base Table
OBJECT_VERSION_NUMBER NUMBER (15)
used by 'stateless' HTML applications
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
ATTRIBUTE6 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Standard Flexfield column
OWNER_TYPE_CODE VARCHAR2 (30) Y Unique identifier of the Type of the Task Owner
PLANNED_START_UOM VARCHAR2 (30)
Reserved For Future Use
PLANNED_END_UOM VARCHAR2 (30)
Reserved For Future Use
SCHEDULED_START_OFFSET NUMBER (15)
Reserved For Future Use
TSK_TYP_ATTR_DEP_ID NUMBER (15) Y Foreign key to the CUG_TSK_TYP_ATTR_DEPS_B Table
TASK_STATUS_ID NUMBER (15) Y Foreign key to the JTF_TASK_STATUSES_B Table
ATTRIBUTE3 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Standard Flexfield column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OWNER_ID NUMBER
Y Unique identifier of the Task Owner
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
SCHEDULED_END_OFFSET NUMBER (15)
Reserved For Future Use
SCHEDULED_START_UOM VARCHAR2 (30)
Reserved For Future Use
SCHEDULED_END_UOM VARCHAR2 (30)
Reserved For Future Use
PRIVATE_FLAG VARCHAR2 (1)
Indicates whether the task is private or public
PUBLISH_FLAG VARCHAR2 (1)
Indicates whether the task should be published.
ATTRIBUTE1 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Standard Flexfield column
TASK_NAME VARCHAR2 (80) Y Default Task Name used when a Task is Created
DESCRIPTION VARCHAR2 (4000)
Default Task Description used when a Task is Created

[top of page]

APPS.CUG_SR_TASK_TYPE_DETS_VL references the following:

APPS
SYNONYM - CUG_SR_TASK_TYPE_DETS_B
SYNONYM - CUG_SR_TASK_TYPE_DETS_TL
APPS.CUG_SR_TASK_TYPE_DETS_VL is referenced by following:

APPS
PACKAGE BODY - CS_EA_AUTOGEN_TASKS_PVT
PACKAGE BODY - CUG_GENERIC_WF_PKG

[top of page]

View: CUG_SR_TYPE_ATTR_MAPS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

This view is used to configure various Service Request Attributes to a Service Request. The service request attributes are defined in FND_LOOKUPS under the lookup type "CUG_SR_TYPE_ATTRIBUTES"

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
SR_TYPE_ATTR_MAP_ID NUMBER (15) Y Primary key for the Underlying Base Table
OBJECT_VERSION_NUMBER NUMBER (15)
used by 'stateless' HTML applications
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
INCIDENT_TYPE_ID NUMBER (15)
Foreign key to the CS_INCIDENT_TYPES_B Table
SR_ATTRIBUTE_CODE VARCHAR2 (30) Y Name of the Service Request Attribute. Foreign key to the FND_LOOKUP_VALUES Table
SR_ATTR_MANDATORY_FLAG VARCHAR2 (1) Y Specifies if the Service Request Attribute is required at runtime
SR_ATTR_DISPLAYED_FLAG VARCHAR2 (1) Y Specifies whether the Service Request Attribute is displayed at runtime
SR_ATTR_DUP_CHECK_FLAG VARCHAR2 (1) Y Specifies whether the Service RequestAttribute should be used to check for duplicate Service Requests
SR_ATTRIBUTE_LIST_NAME VARCHAR2 (30)
Name of the List of values to be attached with the Service Request Attribute. Foreign key to the FND_LOOKUP_TYPES Table
SR_TYPE_ATTR_SEQ_NUM NUMBER (10)
SR Attribute Sequence Number
ATTRIBUTE1 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flexfield column
START_DATE_ACTIVE DATE

Effective Start Date
END_DATE_ACTIVE DATE

Effective End Date
SR_ATTR_DEFAULT_VALUE VARCHAR2 (1997)
Default value of the Service Request attribute
TEMPLATE_ID NUMBER (15)
Template Id
REQD_FOR_CLOSE_FLAG VARCHAR2 (1)
Required for Close of Service Request
SHOW_ON_UPDATE_FLAG VARCHAR2 (1)
Sho w On Update Page
UPDATE_ALLOWED_FLAG VARCHAR2 (1)
Where the attribute can be updated

[top of page]

APPS.CUG_SR_TYPE_ATTR_MAPS_VL references the following:

APPS
SYNONYM - CUG_SR_TYPE_ATTR_MAPS_B
SYNONYM - CUG_SR_TYPE_ATTR_MAPS_TL
APPS.CUG_SR_TYPE_ATTR_MAPS_VL is referenced by following:

APPS
PACKAGE BODY - CS_SR_DUP_CHK_PVT
PACKAGE BODY - CUG_GENERIC_WF_PKG
VIEW - CUG_INCIDNT_ATTR_VALS_V
PACKAGE BODY - CUG_SR_ATTRIBUTE_INTF
PACKAGE BODY - CUG_WF_EMAIL_UTIL

[top of page]

View: CUG_SR_TYPE_DUP_CHK_INFO_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
SR_TYPE_DUP_CHK_INFO_ID NUMBER (15) Y Primary Key for the Underlying Base Table
OBJECT_VERSION_NUMBER NUMBER (15)
used by 'stateless' HTML applications
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
INCIDENT_TYPE_ID NUMBER (15) Y Foreign Key to the CS_INCIDENT_TYPES_B Table
RESOURCE_ID NUMBER (15)
Unique Identifier of the default Service Request Owner.
MANDATORY_ADDRESS_FLAG VARCHAR2 (1) Y Specifies whether the Incident address of the Service Request should be mandatory for a Service Request Type
VALIDATE_ADDRESS_FLAG VARCHAR2 (1) Y Specifies whether the Incident Address for a Service Request Type should be validated at runtime for a Service Request Type
COPY_ADDRESS_FLAG VARCHAR2 (1)
specifies whether the Primary valid address of the customer should be copied into the Runtime Service Request Attribute capture form for a Service Request Type.
SR_DUP_CHECK_FLAG VARCHAR2 (1) Y specifies whether the Service Request Type should be checked for duplicates
DUPLICATE_OFFSET NUMBER (5)
The time period during which a Service Request would be checked for duplicates
DUPLICATE_UOM VARCHAR2 (30)
The Unit of measure of the Duplicate time period
DUP_CHK_INCIDENT_ADDR_FLAG VARCHAR2 (1)
Flag if duplicate check needs to be done on Incident Address
ATTRIBUTE1 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flexfield column

[top of page]

APPS.CUG_SR_TYPE_DUP_CHK_INFO_V references the following:

APPS
SYNONYM - CUG_SR_TYPE_DUP_CHK_INFO
APPS.CUG_SR_TYPE_DUP_CHK_INFO_V is referenced by following:

APPS
PACKAGE BODY - CUG_VALIDATE_ADDRESS_TYPE

[top of page]

View: CUG_TSK_TYP_ATTR_DEPS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

This view is used by the SR Type - Task Type Attribute Capture form for creating the association of the Task Type to SR Type. A value for the SR Attribute Code and the value which drives the run time form are also captured.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
TSK_TYP_ATTR_DEP_ID NUMBER (15) Y Primary Key of the Underlying Base Table
OBJECT_VERSION_NUMBER NUMBER (15)
used by 'stateless' HTML applications
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
INCIDENT_TYPE_ID NUMBER (15) Y Foreign Key to the CS_INCIDENT_TYPES_B Table
TASK_TYPE_ID NUMBER (15) Y Foreign Key to the JTF_TASK_TYPES_B Table
SR_ATTRIBUTE_CODE VARCHAR2 (30)
Foreign key to the FND_LOOKUP_values Table
SR_ATTRIBUTE_OPERATOR VARCHAR2 (30)
Specifies the relationship between SR_ATTRIBUTE_CODE and SR_ATTRIBUTE_VALUE. This is defaulted to Equals and is non-updataeble.
START_DATE_ACTIVE DATE

Effective Start Date
END_DATE_ACTIVE DATE

Effective End Date
ATTRIBUTE1 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flexfield column
SR_ATTRIBUTE_VALUE VARCHAR2 (1997)
Value of the Service Request Attribute that triggers a Task Type

[top of page]

APPS.CUG_TSK_TYP_ATTR_DEPS_VL references the following:

APPS
SYNONYM - CUG_TSK_TYP_ATTR_DEPS_B
SYNONYM - CUG_TSK_TYP_ATTR_DEPS_TL
APPS.CUG_TSK_TYP_ATTR_DEPS_VL is referenced by following:

APPS
PACKAGE BODY - CS_EA_AUTOGEN_TASKS_PVT
PACKAGE BODY - CUG_GENERIC_WF_PKG
PACKAGE BODY - CUG_WF_EMAIL_UTIL

[top of page]

View: CUG_TSK_TYP_ATTR_MAPS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

This view is used to configure variousTask Type Attributes to a Task Type. The Task Type attributes are defined in FND_LOOKUPS under the lookup type "CUG_TASK_TYPE_ATTRIBUTES"

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
END_DATE_ACTIVE DATE

Effective End Date
TSK_TYP_ATTR_MAP_ID NUMBER (15) Y Primary key for the BaseTable
OBJECT_VERSION_NUMBER NUMBER (15)
used by 'stateless' HTML applications
CREATED_BY NUMBER (15) Y Standard Who Column
CREATION_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
START_DATE_ACTIVE DATE

Effective Start Date
LAST_UPDATE_DATE DATE
Y Standard Who Column
TASK_TYPE_ATTRIBUTE_CODE VARCHAR2 (30) Y Task Type Attribute Name. Foreign Key to the FND_LOOKUP_VALUES Table
TASK_TYPE_ID NUMBER (15) Y Uniquely identifies the Task Type. Foreign key to the JTF_TASK_TYPES Table
TASK_ATTR_MANDATORY_FLAG VARCHAR2 (1)
Specifies whether the Task type Attribute is mandatory for a Task Type
TASK_ATTR_DISPLAYED_FLAG VARCHAR2 (1)
Specifies whether the Task Type Attribute is displayed or not
TASK_ATTRIBUTE_LIST_NAME VARCHAR2 (30)
Holds the name of the List of Values for the Task Type Attribute
ATTRIBUTE1 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Standard Flexfield column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Flexfield column
TASK_ATTR_DEFAULT_VALUE VARCHAR2 (1997)
Holds the default value of the Task Attribute

[top of page]

APPS.CUG_TSK_TYP_ATTR_MAPS_VL references the following:

APPS
SYNONYM - CUG_TSK_TYP_ATTR_MAPS_B
SYNONYM - CUG_TSK_TYP_ATTR_MAPS_TL
APPS.CUG_TSK_TYP_ATTR_MAPS_VL is referenced by following:

APPS
PACKAGE BODY - CUG_WF_EMAIL_UTIL

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract