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 |