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_ALL_V

Object Details

Object Name:	PV_PARTNERS_ALL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PV.PV_PARTNERS_ALL_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	Partner identifier
PARTNER_PARTY_NAME	VARCHAR2	(360)	Yes	Partner Party name
INTERNAL_FLAG	VARCHAR2	(1)		Indicates if this is an internal organization. Y for internal, N for external.
PARTNER_RELATIONSHIP_ID	NUMBER	(15)	Yes	Partner ralationship identifier
RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	Lookup: party_relationship_type.
PARTNER_PROFILE_ID	NUMBER			Partner profile identifier
PRF_LAST_UPDATE_DATE	DATE			Standard Who column
PRF_CREATION_DATE	DATE			Standard Who column
PRF_OBJECT_VERSION_NUMBER	NUMBER			Object version number
PARTNER_ID	NUMBER	(15)		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)		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_RESOURCE_ID	NUMBER			Partner resource identifier
PARTNER_GROUP_ID	NUMBER			Partner group identifier
PARTNER_RESOURCE_NUMBER	VARCHAR2	(30)		Partner resource number
PARTNER_GROUP_NUMBER	VARCHAR2	(30)		Partner group number
PARTNER_ORG_ID	NUMBER

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_RESOURCE_ID
,      PARTNER_GROUP_ID
,      PARTNER_RESOURCE_NUMBER
,      PARTNER_GROUP_NUMBER
,      PARTNER_ORG_ID
FROM APPS.PV_PARTNERS_ALL_V;

Dependencies

[top of page]

APPS.PV_PARTNERS_ALL_V references the following:

APPS: HZ_ORGANIZATION_PROFILES; HZ_PARTIES; HZ_RELATIONSHIPS; PV_PARTNER_PROFILES

APPS.PV_PARTNERS_ALL_V is not referenced by any database object