ZCA_EXP_PROCESSING_GT
Global Temp table to hold parent Primary Key of an object to process the child record.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZCA_EXP_PROCESSING_GT_PK |
PROCESSING_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROCESSING_ID | NUMBER | 18 | Yes | Primary Key | |
| ASSOC_ATTR_VALUE1 | NUMBER | 18 | Stores Parent's second Composite Key | ||
| ASSOC_ATTR_VALUE2 | NUMBER | 18 | Stores Parent's third Composite Key | ||
| ALTERNATE_KEY_VALUES | VARCHAR2 | 2000 | Stores Parent Object AlernateKey Column Values | ||
| ASSOC_ATTR_VALUE | NUMBER | 18 | Yes | To hold the Primary Key value of the View Object. | |
| VIEW_NAME | VARCHAR2 | 32 | Yes | To hold export view name. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ZCA_EXP_PROCESSING_GT_U1 | Unique | PROCESSING_ID |