MSC_ATP_AVAILABLE_SUPPLIES
Table is used to store input payload of quick availability and supply availability
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_ATP_AVAILABLE_SUPPLIE_PK |
UNIQUE_ORDER_NUMBER |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| UNIQUE_ORDER_NUMBER | VARCHAR2 | 32 | Yes | Header level attribute that indicates the unique order identifier for the request. |
| CALLING_MODULE | VARCHAR2 | 32 | A string that indicates the identifier of the module from which the order promising service request originated. | |
| CALLING_INSTANCE | VARCHAR2 | 32 | A string that indicates the unique identifier of the source system from which the order promising service request originated. | |
| QUERY_ID | VARCHAR2 | 32 | Attribute to determine the query id for supply availability report | |
| START_DATE | DATE | Attribute to determine the start date of supply availability report | ||
| END_DATE | DATE | Attribute to determine the end date of supply availability report | ||
| REQUEST_CREATION_DATE | DATE | Date and time when the check availability request was created for the fulfillment line. | ||
| PROMISING_SYSTEM | VARCHAR2 | 32 | A string identifier for the order promising system that performed the availability check. | |
| PROMISING_DATE | DATE | Date attribute to determine the date of promise for quick availability | ||
| ERROR_CODE | VARCHAR2 | 10 | A string that indicates the error code returned by Oracle Fusion Global Order Promising for the fulfillment line availability request. | |
| OPERATION_NAME | VARCHAR2 | 255 | A string that indicates the type of request that needs to be performed for the fulfillment line. | |
| 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. | |
| ENGINE_NAME | VARCHAR2 | 6 | This column will be used to capture the system by which request is promised |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_ATP_AVAILABLE_SUPPLIES_U1 | Unique | Default | UNIQUE_ORDER_NUMBER |