1. Tables and Views for Procurement
  2. POR_AMX_CONDITIONS

POR_AMX_CONDITIONS

This table contains individual conditions for approval rules. Each row contains one condition.

Details

  • Schema: FUSION

  • Object owner: POR

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

POR_AMX_CONDITIONS_PK

CONDITION_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CONDITION_ID NUMBER Yes Unique ID of the condition. Active
RULE_ID NUMBER Yes ID of the rule that this condition is part of. Active
TASK_ID NUMBER Yes ID of the task that this condition's rule is part of. Active
ATTRIBUTE_ID NUMBER ID of the AMX attribute on the left side of the condition. Active
ATTRIBUTE_KEY VARCHAR2 150 Backend key of the AMX attribute on the left side of the condition. Active
DIMENSION_KEY VARCHAR2 150 Backend key of the left-side attribute's dimension. Active
OPERATOR VARCHAR2 30 Operator of the condition. Active
DISPLAY_DATA_TYPE VARCHAR2 30 The data type of the attribute, as displayed on the UI. Active
RULE_DATA_TYPE VARCHAR2 30 The data type of the attribute in the backend. Active
DISPLAY_TYPE VARCHAR2 30 Input mode for the right side of the condition. Active
ATTRIBUTE_VALUE_INPUT_TEXT VARCHAR2 150 Value for the right side of the condition, used if the user uses an InputText to input a string value. Active
ATTRIBUTE_VALUE_INPUT_TEXT2 VARCHAR2 150 Value for the second input string in "between" conditions.
ATTRIBUTE_VALUE_NUMBER NUMBER Value for the right side of the condition, used if the user uses an InputText to input a numeric value. Active
ATTRIBUTE_VALUE_NUMBER2 NUMBER Value for the second number in "between" conditions. Active
STORED_ATTRIBUTE_VALUE VARCHAR2 150 Value for the right side of a condition, used if the user selects the value from an LOV choicelist. Active
VALID_CONDITION_FLAG VARCHAR2 1 Flag that determines whether this condition is valid. Active
NESTED_CONDITION_FLAG VARCHAR2 1 Flag that determines whether this condition has children. Active
PARENT_CONDITION_ID NUMBER ID of the parent condition of this condition. Active
NESTED_CONNECTIVE VARCHAR2 30 The operator used to connect its children if this condition is nested. Active
CONDITION_TYPE_CODE VARCHAR2 30 Backend code for the condition's attribute type. Active
CONDITION_STRING VARCHAR2 1000 String describing the condition in a readable format. Active
CONDITION_NUMBER NUMBER Sequence number of the condition in its rule. Active
CUSTOM_RULE_DATA_TYPE VARCHAR2 30 Data type of the user-defined attribute in the backend, if one is used. Active
USER_DEFINED_ATTRIBUTE_TYPE VARCHAR2 30 Type of user-defined attribute being used. Active
COMPARISON_TYPE_CODE VARCHAR2 30 Comparison type of the condition. Active
RIGHT_ATTRIBUTE_ID NUMBER ID of the AMX attribute on the right side of the condition. Active
RIGHT_ATTRIBUTE_KEY VARCHAR2 150 Backend key of the AMX attribute on the right side of the condition. Active
RIGHT_DIMENSION_KEY VARCHAR2 150 Backend key of the right-side attribute's dimension. Active
ROLLSUP_FLAG VARCHAR2 1 Flag that determines whether a rollup attribute is in use. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
SANDBOX_FLAG VARCHAR2 1 Flag that determines whether or not this condition is part of a sandbox rule.

Indexes

Index Uniqueness Tablespace Columns Status
POR_AMX_CONDITIONS_N1 Non Unique FUSION_TS_TX_DATA RULE_ID
POR_AMX_CONDITIONS_U1 Unique FUSION_TS_TX_IDX CONDITION_ID Active