FND Design Data [Home] [Help]

Table: AMS_STATUS_ORDER_RULES

Product: AMS - Marketing
Description: Stores the next available status(es) the user can select.
Implementation/DBA Data: TableAMS.AMS_STATUS_ORDER_RULES
Primary Key: AMS_STATUS_ORDER_RULES_PK
  1. ColumnSTATUS_ORDER_RULE_ID
Primary Key: AMS_STATUS_ORDER_RULES_UK1
  1. ColumnSYSTEM_STATUS_TYPE
  2. ColumnCURRENT_STATUS_CODE
  3. ColumnNEXT_STATUS_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
TableAMS_ACT_QA_CHECKS FK Joins to AMS_STATUS_ORDER_RULES AMS_ACT_QA_CHECKS.ACTIVITY_QA_CHECK_FOR_ID