[Home] [Help] [Dependency Information]
Object Name: | IGP_US_REG_VIEWERS |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGP_US_REG_VIEWERS |
Subobject Name: | |
Status: | VALID |
Stores the registered viewers who have portfolio assignments.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGP_US_REG_VIEWERS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | REG_VIEWER_ID |
IGP_US_REG_VIEWERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PORTFOLIO_ID
PARTY_ID ORG_PARTY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REG_VIEWER_ID | NUMBER | Yes | Sequence generated primary key | |
PORTFOLIO_ID | NUMBER | Portfolio id for which the viewer is given access | ||
PARTY_ID | NUMBER | (15) | Party id of the person to whom the access is given | |
ORG_PARTY_ID | NUMBER | (15) | Organization Party Id, if the person is a contact of any organization and access was given in respect to that organization | |
START_DATE | DATE | Yes | Start Date from when the access should be granted. Presently we are not taking any user input for this column. However, we are defaulting it to the sysdate.This is done just to absorb the future impact incase we plan to control start date also. | |
END_DATE | DATE | End Date till when the access should be valid. | ||
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) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT REG_VIEWER_ID
, PORTFOLIO_ID
, PARTY_ID
, ORG_PARTY_ID
, START_DATE
, END_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM IGS.IGP_US_REG_VIEWERS;
IGS.IGP_US_REG_VIEWERS does not reference any database object
IGS.IGP_US_REG_VIEWERS is referenced by following:
|
|
|