RCS_QS_ORG_COPIES

Table to store the information for the copy of an inventory organization. Users specify the code, name and location for each new copied organization.

Details

  • Schema: FUSION

  • Object owner: RCS

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

rcs_qs_org_copies_PK

QS_ORG_COPY_ID

Columns

Name Datatype Length Precision Not-null Comments
QS_ORG_COPY_ID NUMBER 18 Yes Primary key and unique indicator for the copy organization request.
STATUS VARCHAR2 30 Tracks the possible error points by storing the point of the last success when making the copy of each organization. So if the copy of the organization and parameters succeeds, but the Subinventory copy fails, a re-running of the job on the same data will pick up from this point and retry the Subinventory copy again, followed by all downstream requested additional data to duplicate requests. A value of SUCCESS indicates all additional data to duplicate was successfully created.
QS_ORG_COPY_SRC_ID NUMBER 18 Yes Foreign key to parent table, to indicate which set of dependent set up data to apply
NEW_ORG_CODE VARCHAR2 18 Yes Code to use on the copied inventory organization.
NEW_ORG_NAME VARCHAR2 240 Yes Name to use for the copied inventory organization.
NEW_ORG_LOC_ID NUMBER 18 Yes Warehouse location to use for the copied inventory organization.
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.

Indexes

Index Uniqueness Tablespace Columns
rcs_qs_org_copies_U1 Unique FUSION_TS_TX_IDX QS_ORG_COPY_ID