1. Tables and Views for Sales and Fusion Service
  2. MOP_IMP_PROMOTIONS

MOP_IMP_PROMOTIONS

This is the interface table for migrating promotions from an external data source into fusion. This interface table is also used to store multi-lingual attributes. This is a single interface table that will be used to migrate data into the following promotion base tables in fusion - MOP_PROMOTIONS_B and MOP_PROMOTIONS_TL. The WHO columns in this table, just reflects when the data was loaded into the interface table or when it was processed. These columns are for information purpose only and will not be used during actual import into Fusion.

Details

  • Schema: FUSION

  • Object owner: MOP

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

MOP_IMP_PROMOTIONS_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments Status
BATCH_ID NUMBER 18 Yes Primary Key. Batch Identifier. Identifier that groups data into a batch. Active
INTERFACE_ROW_ID NUMBER 18 Yes Primary Key. Interface Row Id. Will be used to link this row with rows in the error table. Active
IMPORT_STATUS_CODE VARCHAR2 30 Indicates the status of the row to be processed. Active
ACTION_CODE VARCHAR2 30 Indicates the operation to be performed on a row such as Insert, Update etc. Active
INTERNAL_ACTION_CODE VARCHAR2 30 For internal use. Used to evaluate the operation to be performed on a row such as Insert, Update etc.
PROMOTION_ID NUMBER 18 Used for internal processing. Promotion Identifier in fusion. Active
PROMOTION_STATUS_CODE VARCHAR2 30 Indicates the status of the Promotion. It can be in one of the following: Active, Inactive or InProgress. Active
PROMOTION_NUM VARCHAR2 100 Unique Promotion Number Active
START_DATE TIMESTAMP Start Date of the promotion. Date from which the promotion is effective. Active
END_DATE TIMESTAMP End Date of the promotion. Date from which the promotion is not effective. Active
LANGUAGE VARCHAR2 4 Indicates the code of the language into which the contents of the translatable columns are translated. Active
SOURCE_LANG_FLAG VARCHAR2 1 Flag to indicate whether the specified language is also the source language. Active
PROMOTION_NAME VARCHAR2 255 Translated Name of the Promotion Active
PROMOTION_DESC VARCHAR2 1000 Translated Promotion Description Active
FILE_RECORD_NUM NUMBER Used by the file import wizard to relate a row in the interface table to the actual data file that was uploaded.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 255 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
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. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active

Indexes

Index Uniqueness Tablespace Columns Status
MOP_IMP_PROMOTIONS_N1 Non Unique FUSION_TS_INTERFACE BATCH_ID, PROMOTION_NUM Active
MOP_IMP_PROMOTIONS_N2 Non Unique Default BATCH_ID, INTERNAL_ACTION_CODE, IMPORT_STATUS_CODE
MOP_IMP_PROMOTIONS_N3 Non Unique Default BATCH_ID, ACTION_CODE, IMPORT_STATUS_CODE
MOP_IMP_PROMOTIONS_PK Unique FUSION_TS_INTERFACE BATCH_ID, INTERFACE_ROW_ID Active