[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AMS_TRIGGERS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  AMS.AMS_TRIGGERS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row id | |
| TRIGGER_ID | NUMBER | Yes | Unique Identifier. | |
| TRIGGER_CHECK_ID | NUMBER | Indicates the Check associated with the Trigger. | ||
| TRIGGER_ACTION_ID | VARCHAR2 | (0) | Indicates the Action associated with the Trigger. | |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes. | |
| PROCESS_ID | NUMBER | Item Key of last Workflow process ran for this Trigger | ||
| TRIGGER_CREATED_FOR_ID | NUMBER | Yes | Indicates the Id of the Activity for which this Trigger is created. For example Campaign Id. | |
| ARC_TRIGGER_CREATED_FOR | VARCHAR2 | (30) | Yes | Indicates wether the Trigger was created for Campaigns or Events. |
| TIMEZONE_ID | NUMBER | (15) | Yes | Timezone Id of the User |
| TIMEZONE_NAME | VARCHAR2 | (50) | Yes | Timezone name of the User |
| TRIGGERING_TYPE | VARCHAR2 | (30) | Yes | Indicates whether the Trigger is date Trigger or if there is check attached to it. For example, Metric to Metric, Metric to Value. |
| TRIGGERING_TYPE_NAME | VARCHAR2 | (4000) | Indicates the the meaning for the lookup Triggering type. | |
| TRIGGER_NAME | VARCHAR2 | (120) | Yes | Indicates the name of the Trigger. |
| VIEW_APPLICATION_ID | NUMBER | Yes | Indicates which Application has created this Trigger. | |
| USER_START_DATE_TIME | DATE | User Start Date and Time of the Trigger execution. | ||
| USER_LAST_RUN_DATE_TIME | DATE | Indicates User Date and time when Trigger was executed last time. | ||
| USER_NEXT_RUN_DATE_TIME | DATE | Indicates the User Date and time when Trigger will execute again. | ||
| USER_REPEAT_DAILY_START_TIME | DATE | Indiates the User Start time of the period of the day during which Trigger can execute or repeat. | ||
| USER_REPEAT_DAILY_END_TIME | DATE | Indiates the User End time of the period of the day during which Trigger can execute or repeat. | ||
| REPEAT_FREQUENCY_TYPE | VARCHAR2 | (30) | Indicates whether the Trigger will repeat Daily,Monthly. | |
| REPEAT_EVERY_X_FREQUENCY | NUMBER | (15) | Indicates the number of Repeat Frequency Type. like, 1 Day, 2 Days | |
| USER_REPEAT_STOP_DATE_TIME | DATE | Indicates the User Expiry date of the Trigger. | ||
| METRICS_REFRESH_TYPE | VARCHAR2 | (30) | Indicates if all Metrics has to be refreshed or only particular metric. If a single Metric has to be refreshed , the ARC_TRIGGER_CREATED_FOR and TRIGGER_CREATED_FOR_ID will store the details of that Activity Metric. | |
| DESCRIPTION | VARCHAR2 | (4000) | Description of the Trigger. | |
| CHK_OBJ_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes. It's the object version number of the Check. | |
| CHK1_TYPE | VARCHAR2 | (30) | Type of Right Hand Side of the Check For example Metric | |
| CHK1_ARC_SOURCE_CODE_FROM | VARCHAR2 | (30) | Indicates Whether the Left hand side Metric is attached to Campaign or Collateral. | |
| CHK1_ACT_OBJECT_ID | NUMBER | Identifier of the object on Left hand side of check. | ||
| CHK1_SOURCE_CODE | VARCHAR2 | (30) | Source code of the Activity to which the Left hand side Metric is attached. For example Source code of the Campaign if the CHK1_ARC_SOURCE_CODE_FROM is CAMP | |
| CHK1_SOURCE_CODE_METRIC_ID | NUMBER | Indicates the Metric id of the Left hand side of the Check. | ||
| CHK1_SOURCE_CODE_METRIC_TYPE | VARCHAR2 | (30) | Indicates the Metric Type of the left hand side of the check. For example Forecasted,Actual. | |
| CHK1_TO_CHK2_OPERATOR_TYPE | VARCHAR2 | (30) | Indicates the Operator of the check. For example =,<,>. | |
| CHK2_TYPE | VARCHAR2 | (30) | Indicates the Type of the Right hand side of the check. For example Metric,Workbook,Static Value. | |
| CHK2_VALUE | NUMBER | (15) | Indicates the Value for Right hand side of the Check if the Right hand side of the Check is Static Value. | |
| CHK2_LOW_VALUE | NUMBER | (15) | Indicates the low value of the range of the right hand side of the check if it is Static Value Range. | |
| CHK2_HIGH_VALUE | NUMBER | (15) | Indicates the High value of the range of the right hand side of the check if it is Static Value Range. | |
| CHK2_SOURCE_CODE | VARCHAR2 | (30) | Source code of the Activity to which the Right hand side Metric is attached. For example Source code of the Campaign if the CHK2_ARC_SOURCE_CODE_FROM is CAMP | |
| CHK2_ARC_SOURCE_CODE_FROM | VARCHAR2 | (30) | Indicates Whether the Right hand side Metric is attached to Campaign or Collateral. | |
| CHK2_ACT_OBJECT_ID | NUMBER | Identifier of the object on Left hand side of check. | ||
| CHK2_SOURCE_CODE_METRIC_ID | NUMBER | Indicates the Metric id of the Right hand side of the Check. | ||
| CHK2_SOURCE_CODE_METRIC_TYPE | VARCHAR2 | (30) | Indicates the Metric Type of the Right hand side of the check. For example Forecasted,Actual. | |
| CHK2_WORKBOOK_NAME | VARCHAR2 | (254) | Indicates the name of the workbook if the Right hand side of the check is Workbook. | |
| CHK2_WORKBOOK_OWNER | VARCHAR2 | (100) | Indicates the name of the workbook Owner if the Right hand side of the check is Workbook. | |
| CHK2_UOM_CODE | VARCHAR2 | (3) | Indicates the uom of the Static Values. | |
| CHK2_CURRENCY_CODE | VARCHAR2 | (15) | Indicates the Currency of the Static value. | |
| CHK2_WORKSHEET_NAME | VARCHAR2 | (254) | Indicates the name of the worksheet of the workbook if the Right hand side of the check is Workbook. | |
| ACT_OBJ_VER_NUM | VARCHAR2 | (0) | This column is used for locking purposes. It's the object version number of the Trigger Action. | |
| NOTIFY_FLAG | VARCHAR2 | (0) | Indicates whether Notifications has to be sent when the Trigger fires. | |
| GENERATE_LIST_FLAG | VARCHAR2 | (0) | Indicates whether List has to be generated when the Trigger fires. | |
| ACTION_NEED_APPROVAL_FLAG | VARCHAR2 | (0) | Indicates whether the generated List needs approval. | |
| ACTION_APPROVER_USER_ID | VARCHAR2 | (0) | Indicates the approver of the List, usually Campaign Owner. | |
| APPROVER_NAME | VARCHAR2 | (0) | Name of the approver. | |
| EXECUTE_ACTION_TYPE | VARCHAR2 | (0) | Actions Performed when the Trigger was fired, Used by workflow process. | |
| LIST_HEADER_ID | VARCHAR2 | (0) | Indicates the List to be generated. | |
| LIST_CONNECTED_TO_ID | VARCHAR2 | (0) | Indicates the id of the Activity the List is connected to. | |
| ARC_LIST_CONNECTED_TO | VARCHAR2 | (0) | Indicates whether the List is connected to Schedule. | |
| DELIVERABLE_ID | VARCHAR2 | (0) | Indicates the Collateral to be fulfilled. | |
| ACTIVITY_OFFER_ID | VARCHAR2 | (0) | Indicates the Activity Offer to be attached to the Schedule. | |
| DSCRIPT_NAME | VARCHAR2 | (0) | Indicates deployed Script name. | |
| COVER_LETTER_ID | VARCHAR2 | (0) | Identifier of the Cover letter being sent | |
| MAIL_SUBJECT | VARCHAR2 | (0) | Subject of the mail | |
| MAIL_SENDER_NAME | VARCHAR2 | (0) | Name of the mail sender | |
| FROM_FAX_NO | VARCHAR2 | (0) | The incoming fax number |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TRIGGER_ID
, TRIGGER_CHECK_ID
, TRIGGER_ACTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, PROCESS_ID
, TRIGGER_CREATED_FOR_ID
, ARC_TRIGGER_CREATED_FOR
, TIMEZONE_ID
, TIMEZONE_NAME
, TRIGGERING_TYPE
, TRIGGERING_TYPE_NAME
, TRIGGER_NAME
, VIEW_APPLICATION_ID
, USER_START_DATE_TIME
, USER_LAST_RUN_DATE_TIME
, USER_NEXT_RUN_DATE_TIME
, USER_REPEAT_DAILY_START_TIME
, USER_REPEAT_DAILY_END_TIME
, REPEAT_FREQUENCY_TYPE
, REPEAT_EVERY_X_FREQUENCY
, USER_REPEAT_STOP_DATE_TIME
, METRICS_REFRESH_TYPE
, DESCRIPTION
, CHK_OBJ_VERSION_NUMBER
, CHK1_TYPE
, CHK1_ARC_SOURCE_CODE_FROM
, CHK1_ACT_OBJECT_ID
, CHK1_SOURCE_CODE
, CHK1_SOURCE_CODE_METRIC_ID
, CHK1_SOURCE_CODE_METRIC_TYPE
, CHK1_TO_CHK2_OPERATOR_TYPE
, CHK2_TYPE
, CHK2_VALUE
, CHK2_LOW_VALUE
, CHK2_HIGH_VALUE
, CHK2_SOURCE_CODE
, CHK2_ARC_SOURCE_CODE_FROM
, CHK2_ACT_OBJECT_ID
, CHK2_SOURCE_CODE_METRIC_ID
, CHK2_SOURCE_CODE_METRIC_TYPE
, CHK2_WORKBOOK_NAME
, CHK2_WORKBOOK_OWNER
, CHK2_UOM_CODE
, CHK2_CURRENCY_CODE
, CHK2_WORKSHEET_NAME
, ACT_OBJ_VER_NUM
, NOTIFY_FLAG
, GENERATE_LIST_FLAG
, ACTION_NEED_APPROVAL_FLAG
, ACTION_APPROVER_USER_ID
, APPROVER_NAME
, EXECUTE_ACTION_TYPE
, LIST_HEADER_ID
, LIST_CONNECTED_TO_ID
, ARC_LIST_CONNECTED_TO
, DELIVERABLE_ID
, ACTIVITY_OFFER_ID
, DSCRIPT_NAME
, COVER_LETTER_ID
, MAIL_SUBJECT
, MAIL_SENDER_NAME
, FROM_FAX_NO
FROM APPS.AMS_TRIGGERS_V;
APPS
AMS_TRIGGERS_VL
AMS_TRIGGER_CHECKS
AMS_UTILITY_PVT
- show dependent code
HZ_TIMEZONES
APPS.AMS_TRIGGERS_V is not referenced by any database object
|
|
|
|