MOW_ASGN_ACCOUNT_HIERARCHY_GT
MOW_ASGN_ACCOUNT_HIERARCHY_GT is a Global Temp Table to store the account hierarchy on translation phase
Details
-
Schema: FUSION
-
Object owner: MOW
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SEQ_ID | NUMBER | 18 | Yes | SEQ_ID = Considering this as a primary key | |
| PARTY_ID | NUMBER | 18 | Yes | PARTY_ID = To store the part id | |
| ANCESTOR_PK1_VALUE | VARCHAR2 | 100 | ANCESTOR_PK1_VALUE = To Store the value of column ANCESTOR_PK1_VALUE of table FND_TREE_NODE_RF | ||
| DISTANCE | NUMBER | 18 | Yes | DISTANCE = To store the column DISTANCE value of table FND_TREE_NODE_RF |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| MOW_ASGN_ACCOUNT_HIERARCHY_U1 | Unique | SEQ_ID |