EGO_AFF_OBJ_PROPAGATION
Table used to store affected object propagation details.
Details
-
Schema: FUSION
-
Object owner: EGO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
EGO_AFF_OBJ_PROPAGATION_PK |
PROPAGATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROPAGATION_ID | NUMBER | 18 | Yes | Primary key identifier for the affected object propagation 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. | |
| CHANGE_ID | NUMBER | 18 | Change Id of the CO whose affected objects need to be propagated. | ||
| SRC_CHANGE_LINE_ID | NUMBER | 18 | ChangeLineId of the source affected object which needs to be propagated. | ||
| SRC_ORG_ID | NUMBER | 18 | Organization Id of the source affected object which needs to be propagated. | ||
| TARGET_ORG_ID | NUMBER | 18 | Organization Id where the propagation is to be done. | ||
| TARGET_SCHEDULED_DATE | TIMESTAMP | Scheduled effective date of the target affected object. | |||
| PROPAGATION_STATUS | VARCHAR2 | 30 | Current status of affected object propagation. | ||
| COMPONENT_REDLINES | VARCHAR2 | 1 | Flag to denote whether component redlines need to be propagated or not. | ||
| PROPAGATION_LEVEL | VARCHAR2 | 20 | Denotes the entry has resulted from line level or header level propagation setup. Possible values are LINE or HEADER. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGO_AFF_OBJ_PROPAGATION_N1 | Non Unique | Default | CHANGE_ID, SRC_CHANGE_LINE_ID |
| EGO_AFF_OBJ_PROPAGATION_U1 | Unique | Default | PROPAGATION_ID |