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]

VIEW: APPS.PV_PARTNERS_V

Object Details

Object Name:	PV_PARTNERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PV.PV_PARTNERS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INTERNAL_PARTY_ID	NUMBER	(15)	Yes	Party identifier
INTERNAL_PARTY_NAME	VARCHAR2	(360)	Yes	Name of this party
PARTNER_PARTY_ID	NUMBER	(15)	Yes	Party identifier
PARTNER_PARTY_NAME	VARCHAR2	(360)	Yes	Name of this party
INTERNAL_FLAG	VARCHAR2	(1)		Indicates if this is an internal organization. Y for internal, N for external.
PARTNER_RELATIONSHIP_ID	NUMBER	(15)	Yes	The unique identifier of a relationship
RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	Either a forward or a backward relationship code
PARTNER_PROFILE_ID	NUMBER		Yes	Partner profile identifier
PRF_LAST_UPDATE_DATE	DATE		Yes	Standard Who column
PRF_CREATION_DATE	DATE		Yes	Standard Who column
PRF_OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
PARTNER_ID	NUMBER		Yes	Partner 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
CM_ID	NUMBER			Channel manager identifier
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_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
MAX_USERS	NUMBER
INTERNAL_STATUS	VARCHAR2	(1)	Yes
PARTNER_STATUS	VARCHAR2	(1)	Yes
RELATIONSHIP_STATUS	VARCHAR2	(1)	Yes
RELATIONSHIP_DIRECTION	VARCHAR2	(1)	Yes
PARTNER_INTERNAL_FLAG	VARCHAR2	(1)
PARTNER_ORG_ID	NUMBER
VAD_FLAG	VARCHAR2	(1)

Query Text

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


SELECT INTERNAL_PARTY_ID
,      INTERNAL_PARTY_NAME
,      PARTNER_PARTY_ID
,      PARTNER_PARTY_NAME
,      INTERNAL_FLAG
,      PARTNER_RELATIONSHIP_ID
,      RELATIONSHIP_TYPE
,      PARTNER_PROFILE_ID
,      PRF_LAST_UPDATE_DATE
,      PRF_CREATION_DATE
,      PRF_OBJECT_VERSION_NUMBER
,      PARTNER_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
,      CM_ID
,      PH_SUPPORT_REP
,      LEAD_SHARING_STATUS
,      LEAD_SHARE_APPR_FLAG
,      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
,      INTERNAL_STATUS
,      PARTNER_STATUS
,      RELATIONSHIP_STATUS
,      RELATIONSHIP_DIRECTION
,      PARTNER_INTERNAL_FLAG
,      PARTNER_ORG_ID
,      VAD_FLAG
FROM APPS.PV_PARTNERS_V;

Dependencies

[top of page]

APPS.PV_PARTNERS_V references the following:

APPS: HZ_ORGANIZATION_PROFILES; HZ_PARTIES; HZ_RELATIONSHIPS; JTF_RS_RESOURCE_EXTNS; PV_ENTY_ATTR_VALUES; PV_PARTNER_PROFILES

APPS.PV_PARTNERS_V is referenced by following:

APPS: AMS_ACTPARTNER_PVT - show dependent code; AS_SALES_LEAD_OPP_PVT - show dependent code