[Home] [Help] [Dependency Information]
Object Name: | IBW_GUEST_PARTY |
---|---|
Object Type: | TABLE |
Owner: | IBW |
Subobject Name: | |
Status: | VALID |
Stores the current guest party information for Web Analytics. This table will be populated to make the MV fast refreshable. The following assumption is made this table would store the current guest party information and any change in the definition of the guest party would lead to inconsistent reporting of the anonymous carts made by the previous guest user.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_PARTY_ID | NUMBER | (15) | The identifier of the subject in this relationship | |
CUSTOMER_ID | NUMBER | (15) | Yes | Customer identifier |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Object version number for Locking |
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 PERSON_PARTY_ID
, CUSTOMER_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IBW.IBW_GUEST_PARTY;
IBW.IBW_GUEST_PARTY does not reference any database object
IBW.IBW_GUEST_PARTY is referenced by following:
|
|
|