eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PV.PV_PARTNER_PROFILES

Object Details

Object Name:	PV_PARTNER_PROFILES
Object Type:	TABLE
Owner:	PV
FND Design Data:	PV.PV_PARTNER_PROFILES
Subobject Name:
Status:	VALID

PV_PARTNER_PROFILE stores the partner profile information related to a partner-of or VAD-of
relationship of the organization with internal org

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PV_PARTNER_PROFILES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTNER_PROFILE_ID
PV_PARTNER_PROFILES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTNER_RELATIONSHIP_ID
PV_PARTNER_PROFILES_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTNER_ID
PV_PARTNER_PROFILES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CM_ID
PV_PARTNER_PROFILES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PH_SUPPORT_REP
PV_PARTNER_PROFILES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RELATED_PARTNER_ID
PV_PARTNER_PROFILES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTNER_PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PARTNER_PROFILE_ID	NUMBER		Yes	Partner profile identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
PARTNER_ID	NUMBER		Yes	Partner identifier
CM_ID	NUMBER			Channel manager identifier
TARGET_REVENUE_AMT	NUMBER			Partner targetted revenue amount towards the supplier
ACTUAL_REVENUE_AMT	NUMBER			Partner achieved revenue amount towards the supplier
TARGET_REVENUE_PCT	NUMBER			Partner targetted revenue amount in percentage
ACTUAL_REVENUE_PCT	NUMBER			Partner actual revenue amount in percentage
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)		The reference identifier from which the record is imported
ORIG_SYSTEM_TYPE	VARCHAR2	(30)		Type of system from which the record is imported
CAPACITY_SIZE	VARCHAR2	(30)		Number of employees in partner organisation
CAPACITY_AMOUNT	VARCHAR2	(30)		Revenue amount in partner organisation
AUTO_MATCH_ALLOWED_FLAG	VARCHAR2	(1)		Flag indicates whether partner needs to be included in automatch or not
PURCHASE_METHOD	VARCHAR2	(30)		Type of Purchase
SECURITY_GROUP_ID	NUMBER			Id for security of the data for web hosting
PH_SUPPORT_REP	NUMBER			Supplier support contact person by phone for Partners
LEAD_SHARING_STATUS	VARCHAR2	(30)		Lead sharing status for the partner
LEAD_SHARE_APPR_FLAG	VARCHAR2	(1)	Yes	Flag indicating if the partner is approved for lead sharing
PARTNER_RELATIONSHIP_ID	NUMBER		Yes	Denormalized column from hz_party_relationships.party_id. Relationship_id of the forward relationship in hz_relationships.
PARTNER_LEVEL	VARCHAR2	(30)		Partner level code
PREFERRED_VAD_ID	NUMBER			Preferred Vad identifier
PARTNER_GROUP_ID	NUMBER			Partner group identifier
PARTNER_RESOURCE_ID	NUMBER			Partner resource identifier
PARTNER_GROUP_NUMBER	VARCHAR2	(30)		Partner group number
PARTNER_RESOURCE_NUMBER	VARCHAR2	(30)		Partner resource number
SALES_PARTNER_FLAG	VARCHAR2	(1)		Identifies whether the partner is sales partner or not
INDIRECTLY_MANAGED_FLAG	VARCHAR2	(1)		Indicates whether the partner is managed by party or not
CHANNEL_MARKETING_MANAGER	NUMBER			Marketing Channel Manager
OPPTY_LAST_OFFERED_DATE	DATE			Last offered date of opportunity to the partner
RELATED_PARTNER_ID	NUMBER			Identifier for indirectly managed partners. party_id of the indirectly-managed partner relationship.
MAX_USERS	NUMBER			Maximum number of users allowed to register for a partner
PARTNER_PARTY_ID	NUMBER			Partner / VAD Organization Identifier
STATUS	VARCHAR2	(1)		The status of the partner ('A', 'I')

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PARTNER_PROFILE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      PARTNER_ID
,      CM_ID
,      TARGET_REVENUE_AMT
,      ACTUAL_REVENUE_AMT
,      TARGET_REVENUE_PCT
,      ACTUAL_REVENUE_PCT
,      ORIG_SYSTEM_REFERENCE
,      ORIG_SYSTEM_TYPE
,      CAPACITY_SIZE
,      CAPACITY_AMOUNT
,      AUTO_MATCH_ALLOWED_FLAG
,      PURCHASE_METHOD
,      SECURITY_GROUP_ID
,      PH_SUPPORT_REP
,      LEAD_SHARING_STATUS
,      LEAD_SHARE_APPR_FLAG
,      PARTNER_RELATIONSHIP_ID
,      PARTNER_LEVEL
,      PREFERRED_VAD_ID
,      PARTNER_GROUP_ID
,      PARTNER_RESOURCE_ID
,      PARTNER_GROUP_NUMBER
,      PARTNER_RESOURCE_NUMBER
,      SALES_PARTNER_FLAG
,      INDIRECTLY_MANAGED_FLAG
,      CHANNEL_MARKETING_MANAGER
,      OPPTY_LAST_OFFERED_DATE
,      RELATED_PARTNER_ID
,      MAX_USERS
,      PARTNER_PARTY_ID
,      STATUS
FROM PV.PV_PARTNER_PROFILES;

Dependencies

[top of page]

PV.PV_PARTNER_PROFILES does not reference any database object

PV.PV_PARTNER_PROFILES is referenced by following:

PV: PV_PARTNER_PROFILES#