MOW_DISPOSITION_TBA_GT
This Global Temp Table is used to store the data temporarily on our package.
Details
-
Schema: FUSION
-
Object owner: MOW
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OBJECT_TYPE | VARCHAR2 | 30 | Yes | OBJECT_TYPE = To determine which object type this row belongs to. | |
| ESS_REQUEST_ID | NUMBER | 18 | Yes | ESS_REQUEST_ID = To store the current ESS_REQUEST_ID | |
| WORK_OBJECT_PKA1 | NUMBER | 18 | WORK_OBJECT_PKA1 = Primary Key Attribute 1 of the work object is stored | ||
| WORK_OBJECT_PKA2 | NUMBER | 18 | WORK_OBJECT_PKA2 = Primary Key Attribute 2 of the work object is stored | ||
| WORK_OBJECT_PKA3 | NUMBER | 18 | WORK_OBJECT_PKA3 = Primary Key Attribute 3 of the work object is stored | ||
| CANDIDATE_OBJECT_PKA1 | NUMBER | 18 | CANDIDATE_OBJECT_PKA1 = Primary Key Attribute 1 of the candidate object is stored | ||
| CANDIDATE_OBJECT_PKA2 | NUMBER | 18 | CANDIDATE_OBJECT_PKA2 = Primary Key Attribute 2 of the candidate object is stored | ||
| CANDIDATE_OBJECT_PKA3 | NUMBER | 18 | CANDIDATE_OBJECT_PKA3 = Primary Key Attribute 3 of the candidate object is stored | ||
| ERROR_MESSAGE | VARCHAR2 | 256 | ERROR_MESSAGE = To store the error message if exists |