[Home] [Help] [Dependency Information]
Object Name: | PV_MATCHED_PARTNERS_GT |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
APPS.PV_MATCHED_PARTNERS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PV_MATCHED_PARTNERS_GT_U1 | NORMAL | UNIQUE | PARTNER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTNER_ID | NUMBER | Yes | ||
DISTANCE | NUMBER | |||
RECYCLED_FLAG | VARCHAR2 | (10) | Yes | |
INCUMBENT_FLAG | VARCHAR2 | (10) | Yes | |
PARTNER_ORDER | NUMBER | |||
INDUSTRY | VARCHAR2 | (1000) | ||
MEMBER_TYPE | VARCHAR2 | (1000) | ||
GEOGRAPHY | VARCHAR2 | (1000) | ||
CAPACITY_RATING | VARCHAR2 | (1000) |
Cut, paste (and edit) the following text to query this object:
SELECT PARTNER_ID
, DISTANCE
, RECYCLED_FLAG
, INCUMBENT_FLAG
, PARTNER_ORDER
, INDUSTRY
, MEMBER_TYPE
, GEOGRAPHY
, CAPACITY_RATING
FROM APPS.PV_MATCHED_PARTNERS_GT;
APPS.PV_MATCHED_PARTNERS_GT does not reference any database object
APPS.PV_MATCHED_PARTNERS_GT is referenced by following:
|
|
|