[Home] [Help] [Dependency Information]
Object Name: | IBU_MULTI_PARTIES |
---|---|
Object Type: | TABLE |
Owner: | IBU |
Subobject Name: | |
Status: | VALID |
Stores information about multiple parties the iSupport users has access to. Each row includes the user id party id combination and it gives us the current party context the iSupport user is working on.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBU_MULTI_PARTIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
USER_ID
PARTY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_ID | NUMBER | (15) | Yes | The identifier of Application user |
PARTY_ID | NUMBER | (15) | Yes | The identifier of Party |
ENABLE_FLAG | VARCHAR2 | (1) | Flag indicates whether party access to the user is enabled or disabled | |
CURRENT_PARTY | VARCHAR2 | (1) | To identify which is the current party context | |
END_DATE | DATE | Furture Use | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT USER_ID
, PARTY_ID
, ENABLE_FLAG
, CURRENT_PARTY
, END_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IBU.IBU_MULTI_PARTIES;
IBU.IBU_MULTI_PARTIES does not reference any database object
IBU.IBU_MULTI_PARTIES is referenced by following:
|
|
|