DBA Data[Home] [Help] [Dependency Information]

TABLE: AMS.AMS_TCOP_FR_RULES_SETUP

Object Details
Object Name: AMS_TCOP_FR_RULES_SETUP
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_TCOP_FR_RULES_SETUP
Subobject Name:
Status: VALID


This table stores the definition of Fatigue Rules to be used by the Rules Engine.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes Unique Identifier for a Rule
RULE_TYPE VARCHAR2 (30)
The type of Fatigue Rule
MAX_CONTACT_ALLOWED NUMBER

Maximum contact allowed for this Rule
PERIOD_ID NUMBER
Yes Period associated with this rule.
CHANNEL_ID NUMBER

Channel Id of the channel if the Rule Type is Channel Based
ENABLED_FLAG VARCHAR2 (1)
Flag to denote if the rule is Enabled.
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER (9)
Column used for locking purposes
SECURITY_GROUP_ID NUMBER

Security Group ID
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RULE_ID
,      RULE_TYPE
,      MAX_CONTACT_ALLOWED
,      PERIOD_ID
,      CHANNEL_ID
,      ENABLED_FLAG
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
FROM AMS.AMS_TCOP_FR_RULES_SETUP;

Dependencies

[top of page]

AMS.AMS_TCOP_FR_RULES_SETUP does not reference any database object

AMS.AMS_TCOP_FR_RULES_SETUP is referenced by following:

SchemaAPPS
SynonymAMS_TCOP_FR_RULES_SETUP