Search Results ams_user_statuses_b




Overview
Explore in AI Chat

Overview

The AMS_USER_STATUSES_B table is a core master data table within the Oracle E-Business Suite Marketing (AMS) module. It functions as the primary repository for user-defined status codes, providing a centralized, flexible mechanism for tracking the lifecycle state of various marketing and related business objects. Its role is pivotal in enabling workflow, approval processes, and status-driven reporting across the marketing application. The table stores the base, non-translatable attributes of each status, while its corresponding translation table, AMS_USER_STATUSES_TL, supports multilingual implementations.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the structure of such a status table in Oracle EBS typically includes several key fields. The primary identifier, USER_STATUS_ID, is the unique surrogate key for each status record. A STATUS_CODE column usually holds a short, internal identifier, and a STATUS_TYPE column is critical for categorizing the status's applicability (e.g., 'CAMP_CAMPAIGN', 'CAMP_SCHEDULE', 'DELIVERABLE'). Other common columns include ENABLED_FLAG (to activate or deactivate the status), DISPLAY_ORDER (for UI presentation), and the standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY). The table's primary key constraint is named AMS_USER_STATUSES_B_PK on the USER_STATUS_ID column.

Common Use Cases and Queries

This table is central to querying and reporting on the state of marketing entities. A common use case involves joining AMS_USER_STATUSES_B to transactional tables to generate status-based dashboards or to enforce business rules in custom logic. For instance, to list all active campaigns with their user-defined status, a query would join AMS_CAMPAIGNS_ALL_B to this table. Administrators may query the table to audit or configure the available statuses for a specific object type. A typical pattern for retrieving enabled statuses for campaigns would be: SELECT status_code, meaning FROM ams_user_statuses_b bus, ams_user_statuses_tl tl WHERE bus.user_status_id = tl.user_status_id AND tl.language = USERENV('LANG') AND status_type = 'CAMP_CAMPAIGN' AND enabled_flag = 'Y' ORDER BY display_order; This table is also integral to the setup of approval workflows, where status transitions are governed by predefined rules.

Related Objects

As evidenced by the extensive foreign key relationships, AMS_USER_STATUSES_B is a fundamental reference table for numerous entities across the AMS and related modules. Key dependent transactional tables include:

The primary related object is the translation table, AMS_USER_STATUSES_TL, which holds the language-specific names (MEANING, DESCRIPTION) for each USER_STATUS_ID. This relationship is enforced via a foreign key from the TL table back to the base table.

  • Table: AMS_USER_STATUSES_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_USER_STATUSES_B,  object_name:AMS_USER_STATUSES_B,  status:VALID,  product: AMS - Marketing ,  description: Stores User status information ,  implementation_dba_data: AMS.AMS_USER_STATUSES_B , 

  • Table: AMS_USER_STATUSES_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_USER_STATUSES_B,  object_name:AMS_USER_STATUSES_B,  status:VALID,  product: AMS - Marketing ,  description: Stores User status information ,  implementation_dba_data: AMS.AMS_USER_STATUSES_B , 

  • Table: AMS_EVENT_REGISTRATIONS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_REGISTRATIONS,  object_name:AMS_EVENT_REGISTRATIONS,  status:VALID,  product: AMS - Marketing ,  description: Stores all enrollment information for an event, who got registered, who will be attending and their status. ,  implementation_dba_data: AMS.AMS_EVENT_REGISTRATIONS , 

  • Table: AMS_EVENT_HEADERS_ALL_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_HEADERS_ALL_B,  object_name:AMS_EVENT_HEADERS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Stores the definition of a Marketing Event. (Master Event or Event Template) ,  implementation_dba_data: AMS.AMS_EVENT_HEADERS_ALL_B , 

  • Table: AMS_EVENT_OFFERS_ALL_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_OFFERS_ALL_B,  object_name:AMS_EVENT_OFFERS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the Event Offerings. ,  implementation_dba_data: AMS.AMS_EVENT_OFFERS_ALL_B , 

  • Table: AMS_EVENT_REGISTRATIONS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_REGISTRATIONS,  object_name:AMS_EVENT_REGISTRATIONS,  status:VALID,  product: AMS - Marketing ,  description: Stores all enrollment information for an event, who got registered, who will be attending and their status. ,  implementation_dba_data: AMS.AMS_EVENT_REGISTRATIONS , 

  • Table: AMS_EVENT_HEADERS_ALL_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_HEADERS_ALL_B,  object_name:AMS_EVENT_HEADERS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Stores the definition of a Marketing Event. (Master Event or Event Template) ,  implementation_dba_data: AMS.AMS_EVENT_HEADERS_ALL_B , 

  • Table: AMS_EVENT_OFFERS_ALL_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_OFFERS_ALL_B,  object_name:AMS_EVENT_OFFERS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the Event Offerings. ,  implementation_dba_data: AMS.AMS_EVENT_OFFERS_ALL_B , 

  • Table: AMS_ACT_RESOURCES 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_RESOURCES,  object_name:AMS_ACT_RESOURCES,  status:VALID,  product: AMS - Marketing ,  description: Stores business parties for a specific activity such as an event. ,  implementation_dba_data: AMS.AMS_ACT_RESOURCES , 

  • Table: AMS_USER_STATUSES_TL 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_USER_STATUSES_TL,  object_name:AMS_USER_STATUSES_TL,  status:VALID,  product: AMS - Marketing ,  description: Translation columns for User Statuses ,  implementation_dba_data: AMS.AMS_USER_STATUSES_TL , 

  • Table: AMS_DIALOGS_ALL_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DIALOGS_ALL_B,  object_name:AMS_DIALOGS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: This stores the dialog object ,  implementation_dba_data: AMS.AMS_DIALOGS_ALL_B , 

  • Table: AMS_DM_MODELS_ALL_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_MODELS_ALL_B,  object_name:AMS_DM_MODELS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Container for the model definition in the model building process. ,  implementation_dba_data: AMS.AMS_DM_MODELS_ALL_B , 

  • Table: AMS_ACT_RESOURCES 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_RESOURCES,  object_name:AMS_ACT_RESOURCES,  status:VALID,  product: AMS - Marketing ,  description: Stores business parties for a specific activity such as an event. ,  implementation_dba_data: AMS.AMS_ACT_RESOURCES , 

  • Table: AMS_CAMPAIGN_SCHEDULES 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_CAMPAIGN_SCHEDULES,  object_name:AMS_CAMPAIGN_SCHEDULES,  status:VALID,  product: AMS - Marketing ,  description: This table is obsoleted and no longer in use. ,  implementation_dba_data: AMS.AMS_CAMPAIGN_SCHEDULES , 

  • Table: AMS_USER_STATUSES_TL 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_USER_STATUSES_TL,  object_name:AMS_USER_STATUSES_TL,  status:VALID,  product: AMS - Marketing ,  description: Translation columns for User Statuses ,  implementation_dba_data: AMS.AMS_USER_STATUSES_TL , 

  • View: AMS_USER_STATUSES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:AMS.AMS_USER_STATUSES_VL,  object_name:AMS_USER_STATUSES_VL,  status:VALID,  product: AMS - Marketing ,  description: This view returns information on User statuses defined for System Statuses for Marketing Objects(Event,Registration,Campaign etc..) ,  implementation_dba_data: APPS.AMS_USER_STATUSES_VL , 

  • Table: AMS_DM_MODELS_ALL_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_MODELS_ALL_B,  object_name:AMS_DM_MODELS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Container for the model definition in the model building process. ,  implementation_dba_data: AMS.AMS_DM_MODELS_ALL_B , 

  • Table: AMS_DIALOGS_ALL_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DIALOGS_ALL_B,  object_name:AMS_DIALOGS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: This stores the dialog object ,  implementation_dba_data: AMS.AMS_DIALOGS_ALL_B , 

  • Table: AMS_DM_SCORES_ALL_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_SCORES_ALL_B,  object_name:AMS_DM_SCORES_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Container for capturing statistics of a scoring instance. ,  implementation_dba_data: AMS.AMS_DM_SCORES_ALL_B , 

  • Table: AMS_ACT_WF_REQUESTS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_WF_REQUESTS,  object_name:AMS_ACT_WF_REQUESTS,  status:VALID,  product: AMS - Marketing ,  description: Stores all requests that have been submitted to Oracle Workflow inside Oracle Marketing for the apprkoval Process. ,  implementation_dba_data: AMS.AMS_ACT_WF_REQUESTS , 

  • Table: AMS_ACT_WF_REQUESTS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_WF_REQUESTS,  object_name:AMS_ACT_WF_REQUESTS,  status:VALID,  product: AMS - Marketing ,  description: Stores all requests that have been submitted to Oracle Workflow inside Oracle Marketing for the apprkoval Process. ,  implementation_dba_data: AMS.AMS_ACT_WF_REQUESTS , 

  • Table: AMS_CAMPAIGN_SCHEDULES 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_CAMPAIGN_SCHEDULES,  object_name:AMS_CAMPAIGN_SCHEDULES,  status:VALID,  product: AMS - Marketing ,  description: This table is obsoleted and no longer in use. ,  implementation_dba_data: AMS.AMS_CAMPAIGN_SCHEDULES , 

  • Table: AMS_CAMPAIGN_SCHEDULES_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_CAMPAIGN_SCHEDULES_B,  object_name:AMS_CAMPAIGN_SCHEDULES_B,  status:VALID,  product: AMS - Marketing ,  description: Stores all Campaign Schedules ,  implementation_dba_data: AMS.AMS_CAMPAIGN_SCHEDULES_B , 

  • Table: AMS_DM_SCORES_ALL_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DM_SCORES_ALL_B,  object_name:AMS_DM_SCORES_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Container for capturing statistics of a scoring instance. ,  implementation_dba_data: AMS.AMS_DM_SCORES_ALL_B , 

  • View: AMS_USER_STATUSES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:AMS.AMS_USER_STATUSES_VL,  object_name:AMS_USER_STATUSES_VL,  status:VALID,  product: AMS - Marketing ,  description: This view returns information on User statuses defined for System Statuses for Marketing Objects(Event,Registration,Campaign etc..) ,  implementation_dba_data: APPS.AMS_USER_STATUSES_VL , 

  • Table: AMS_OFFERS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_OFFERS,  object_name:AMS_OFFERS,  status:VALID,  product: AMS - Marketing ,  description: This is a surrogate table to QP_LIST_HEADERS_B for Offers related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, peformance dates and lumpsum related offer types. ,  implementation_dba_data: AMS.AMS_OFFERS , 

  • Table: AMS_PRICE_LIST_ATTRIBUTES 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_PRICE_LIST_ATTRIBUTES,  object_name:AMS_PRICE_LIST_ATTRIBUTES,  status:VALID,  product: AMS - Marketing ,  description: This is a surrogate table to QP_LIST_HEADERS_B for Price List related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, owner and other attributes specifice to Marketing Online Requir ,  implementation_dba_data: AMS.AMS_PRICE_LIST_ATTRIBUTES , 

  • Table: AMS_CAMPAIGN_SCHEDULES_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_CAMPAIGN_SCHEDULES_B,  object_name:AMS_CAMPAIGN_SCHEDULES_B,  status:VALID,  product: AMS - Marketing ,  description: Stores all Campaign Schedules ,  implementation_dba_data: AMS.AMS_CAMPAIGN_SCHEDULES_B , 

  • Table: AMS_OFFERS 12.2.2

    product: AMS - Marketing ,  description: This is a surrogate table to QP_LIST_HEADERS_B for Offers related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, peformance dates and lumpsum related offer types. ,  implementation_dba_data: Not implemented in this database , 

  • Table: AMS_PRICE_LIST_ATTRIBUTES 12.2.2

    product: AMS - Marketing ,  description: This is a surrogate table to QP_LIST_HEADERS_B for Price List related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, owner and other attributes specifice to Marketing Online Requir ,  implementation_dba_data: Not implemented in this database , 

  • Table: AMS_DELIVERABLES_ALL_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DELIVERABLES_ALL_B,  object_name:AMS_DELIVERABLES_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: This table stores the details about marketing deliverables/collaterals, collaterals are uniquely identified by deliverable name, language and version. ,  implementation_dba_data: AMS.AMS_DELIVERABLES_ALL_B , 

  • Table: AMS_IMP_LIST_HEADERS_ALL 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_IMP_LIST_HEADERS_ALL,  object_name:AMS_IMP_LIST_HEADERS_ALL,  status:VALID,  product: AMS - Marketing ,  description: This table stores the user entered name and other details about lists imported into Oracle Marketing from external sources. ,  implementation_dba_data: AMS.AMS_IMP_LIST_HEADERS_ALL , 

  • Table: AMS_IMP_LIST_HEADERS_ALL 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_IMP_LIST_HEADERS_ALL,  object_name:AMS_IMP_LIST_HEADERS_ALL,  status:VALID,  product: AMS - Marketing ,  description: This table stores the user entered name and other details about lists imported into Oracle Marketing from external sources. ,  implementation_dba_data: AMS.AMS_IMP_LIST_HEADERS_ALL , 

  • Table: AMS_DELIVERABLES_ALL_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_DELIVERABLES_ALL_B,  object_name:AMS_DELIVERABLES_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: This table stores the details about marketing deliverables/collaterals, collaterals are uniquely identified by deliverable name, language and version. ,  implementation_dba_data: AMS.AMS_DELIVERABLES_ALL_B , 

  • Table: AMS_CAMPAIGNS_ALL_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_CAMPAIGNS_ALL_B,  object_name:AMS_CAMPAIGNS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Base table to store the details of a campaign. ,  implementation_dba_data: AMS.AMS_CAMPAIGNS_ALL_B , 

  • Table: AMS_CAMPAIGNS_ALL_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_CAMPAIGNS_ALL_B,  object_name:AMS_CAMPAIGNS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Base table to store the details of a campaign. ,  implementation_dba_data: AMS.AMS_CAMPAIGNS_ALL_B ,