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_PRTNR_SALES_TEAM_V

Object Details

Object Name:	PV_PRTNR_SALES_TEAM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PV.PV_PRTNR_SALES_TEAM_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
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
CONTACT_PARTY_ID	NUMBER	(15)		Party identifier
TEAM_LEADER_FLAG	VARCHAR2	(1)	Yes	Indicates whether the contact is a team lead or not
FREEZE_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether the record is frozen
CITY	VARCHAR2	(60)		City
POSTAL_CODE	VARCHAR2	(60)		Postal code
STATE	VARCHAR2	(60)		State
PROVINCE	VARCHAR2	(60)		Province
COUNTY	VARCHAR2	(60)		County
COUNTRY	VARCHAR2	(60)		Country
ADDRESS1	VARCHAR2	(240)		First line of Address
ADDRESS2	VARCHAR2	(240)		Second line of Address
ADDRESS3	VARCHAR2	(240)		Third line of Address
ADDRESS4	VARCHAR2	(240)		Fourth line of Address
ADDRESS_ID	NUMBER			Address identifier
CUSTOMER_ID	NUMBER		Yes	Customer/prospect identifier
SALESFORCE_ID	NUMBER		Yes	Salesforce identifier
PHONE_LINE_TYPE	VARCHAR2	(30)		Type of Phone, ex: Cell, Work or Home
PHONE_AREA_CODE	VARCHAR2	(10)		Area code
PHONE_COUNTRY_CODE	VARCHAR2	(10)		Country code
PHONE_NUMBER	VARCHAR2	(40)		Phone number
PHONE_EXTENSION	VARCHAR2	(20)		Phone extension
ACCESS_ID	NUMBER		Yes	Access identifier
SALES_GROUP_NAME	VARCHAR2	(60)		Sales group name
PERSON_LAST_NAME	VARCHAR2	(150)
PERSON_MIDDLE_NAME	VARCHAR2	(60)
PERSON_FIRST_NAME	VARCHAR2	(150)
EMAIL_ADDRESS	VARCHAR2	(240)		Email address
JOB_TITLE	VARCHAR2	(100)		Job Title
SALES_GROUP_ID	NUMBER			Sales group identifier
LEAD_ID	NUMBER			Lead identifier
SALES_LEAD_ID	NUMBER
SALESFORCE_ROLE_CODE	VARCHAR2	(30)		The role the salesforce plays in the team
SALESFORCE_RELATIONSHIP_CODE	VARCHAR2	(30)		Sales and Marketing lookup code for 'RELATIONSHIP' ,Prospect or Customer
CONTACT_PARTY_NAME	VARCHAR2	(360)	Yes	Party name
PARTNER_ORG_PARTY_ID	NUMBER	(15)	Yes	Party identifier
PARTNER_ORG_NAME	VARCHAR2	(360)	Yes
JOB_TITLE_CODE	VARCHAR2	(30)		Job Title code
PERSON_PARTY_ID	NUMBER	(15)	Yes	Person identifier

Query Text

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


SELECT LAST_UPDATE_DATE
,      CONTACT_PARTY_ID
,      TEAM_LEADER_FLAG
,      FREEZE_FLAG
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      ADDRESS_ID
,      CUSTOMER_ID
,      SALESFORCE_ID
,      PHONE_LINE_TYPE
,      PHONE_AREA_CODE
,      PHONE_COUNTRY_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      ACCESS_ID
,      SALES_GROUP_NAME
,      PERSON_LAST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_FIRST_NAME
,      EMAIL_ADDRESS
,      JOB_TITLE
,      SALES_GROUP_ID
,      LEAD_ID
,      SALES_LEAD_ID
,      SALESFORCE_ROLE_CODE
,      SALESFORCE_RELATIONSHIP_CODE
,      CONTACT_PARTY_NAME
,      PARTNER_ORG_PARTY_ID
,      PARTNER_ORG_NAME
,      JOB_TITLE_CODE
,      PERSON_PARTY_ID
FROM APPS.PV_PRTNR_SALES_TEAM_V;

Dependencies

[top of page]

APPS.PV_PRTNR_SALES_TEAM_V references the following:

APPS: AS_ACCESSES_ALL; FND_USER; HZ_CONTACT_POINTS; HZ_LOCATIONS; HZ_ORG_CONTACTS; HZ_PARTIES; HZ_PARTY_SITES; HZ_RELATIONSHIPS; JTF_RS_GROUPS_VL; JTF_RS_RESOURCE_EXTNS

APPS.PV_PRTNR_SALES_TEAM_V is not referenced by any database object