POR_CA_GEN_SESSION_GT
This global temporary table is used to store the distribution ids and hash code for requisition before calling TAB api.
Details
-
Schema: FUSION
-
Object owner: POR
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
POR_CA_GEN_SESSION_GT_PK |
DISTRIBUTION_ID |
Columns
| Name | Datatype | Not-null | Comments |
|---|---|---|---|
| DISTRIBUTION_ID | NUMBER | Yes | DISTRIBUTION_ID |
| HASH_CODE | NUMBER | HASH_CODE |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| POR_CA_GEN_SESSION_GT_N1 | Non Unique | HASH_CODE |
| POR_CA_GEN_SESSION_GT_U1 | Unique | DISTRIBUTION_ID |