RCS_QS_ORG_COPY_SRC
Table to store the information and settings for making a copy of an inventory organization. Users may tailor which dependent set up data from the source inventory organization is to be copied into the new inventory organization.
Details
-
Schema: FUSION
-
Object owner: RCS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
RCS_QS_ORG_COPY_SRC_PK |
QS_ORG_COPY_SRC_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| QS_ORG_COPY_SRC_ID | NUMBER | 18 | Yes | Primary key and unique indicator for the copy organization request. | |
| SOURCE_ORG_ID | NUMBER | 18 | Yes | Source inventory organization being copied. | |
| ESS_REQUEST_ID | NUMBER | 18 | Identifier of the program job called to copy organizations. | ||
| STATUS | VARCHAR2 | 30 | Status of ESS request to copy inventory organization program. Valid values are FAIL, SUCCESS, SUBMITTED, and null. The default value is null. It means no background program has been submitted to copy inventory organizations. | ||
| 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. | |
| COPY_DATA_SECURITY | VARCHAR2 | 1 | If true, the data security assignments to the source organization will be duplicated for each new copy. | ||
| COPY_SUBINVENTORY | VARCHAR2 | 1 | If true, all subinventories in the source organization will be duplicated in each new copy. | ||
| COPY_LOCATORS | VARCHAR2 | 1 | If true, all locators in the source inventory organizations will be duplicated in each new copy. | ||
| COPY_PLANT_PARAMS | VARCHAR2 | 1 | If true, the manufacturing and maintenance plant parameters for the source organization will be duplicated for each new copy. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RCS_QS_ORG_COPY_SRC_U1 | Unique | FUSION_TS_TX_IDX | QS_ORG_COPY_SRC_ID |