[Home] [Help] [Dependency Information]
Object Name: | CUG_SR_TYPE_DUP_CHK_INFO |
---|---|
Object Type: | TABLE |
Owner: | CUG |
FND Design Data: | CUG.CUG_SR_TYPE_DUP_CHK_INFO |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CUG_SR_TYPE_DUP_CHK_INFO_U1 | NORMAL | UNIQUE | APPS_TS_SEED | SR_TYPE_DUP_CHK_INFO_ID |
CUG_SR_TYPE_DUP_CHK_INFO_U2 | NORMAL | UNIQUE | APPS_TS_SEED | INCIDENT_TYPE_ID |
CUG_SR_TYPE_DUP_CHK_INFO_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | RESOURCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_TYPE_DUP_CHK_INFO_ID | NUMBER | (15) | Yes | Primary Key for the Table |
OBJECT_VERSION_NUMBER | NUMBER | (15) | used for 'stateless' HTML applications | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
INCIDENT_TYPE_ID | NUMBER | (15) | Yes | 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) | Yes | Specifies whether the Incident address of the Service Request should be mandatory for a Service Request Type |
VALIDATE_ADDRESS_FLAG | VARCHAR2 | (1) | Yes | 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) | Yes | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT SR_TYPE_DUP_CHK_INFO_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, INCIDENT_TYPE_ID
, RESOURCE_ID
, MANDATORY_ADDRESS_FLAG
, VALIDATE_ADDRESS_FLAG
, COPY_ADDRESS_FLAG
, SR_DUP_CHECK_FLAG
, DUPLICATE_OFFSET
, DUPLICATE_UOM
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, SECURITY_GROUP_ID
, DUP_CHK_INCIDENT_ADDR_FLAG
FROM CUG.CUG_SR_TYPE_DUP_CHK_INFO;
CUG.CUG_SR_TYPE_DUP_CHK_INFO does not reference any database object
CUG.CUG_SR_TYPE_DUP_CHK_INFO is referenced by following:
|
|
|