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

VIEW: APPS.PV_REFERRALS_VL

Object Details
Object Name: PV_REFERRALS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPV.PV_REFERRALS_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


Standard Multi-language View.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Standard column used by OA Framework entity object
REFERRAL_ID NUMBER
Yes Referral 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
REFERRAL_NAME VARCHAR2 (100) Yes Referral name
DESCRIPTION VARCHAR2 (500) Yes Referral description
BENEFIT_ID NUMBER
Yes Benefit identifier
REFERRAL_CODE VARCHAR2 (50) Yes Referral code
REFERRAL_STATUS VARCHAR2 (30) Yes Referral status
PARTNER_ID NUMBER
Yes Partner identifier
PARTNER_CONTACT_RESOURCE_ID NUMBER
Yes Partner contact resource identifier
CUSTOMER_PARTY_ID NUMBER

Customer party identifier
CUSTOMER_ORG_CONTACT_ID NUMBER

Customer organization contact identifier
CUSTOMER_CONTACT_PARTY_ID NUMBER

Customer contact party identifier
CUSTOMER_PARTY_SITE_ID NUMBER

Customer party site identifier
CUSTOMER_NAME VARCHAR2 (240) Yes Customer name
CUSTOMER_ADDRESS_TYPE VARCHAR2 (240)
Customer address type
CUSTOMER_ADDRESS1 VARCHAR2 (240)
Customer address
CUSTOMER_ADDRESS2 VARCHAR2 (240)
Customer address
CUSTOMER_ADDRESS3 VARCHAR2 (240)
Customer address
CUSTOMER_ADDRESS4 VARCHAR2 (240)
Customer address
ADDRESS_LINES_PHONETIC VARCHAR2 (240)
Address line phonetic
CUSTOMER_CITY VARCHAR2 (240)
Customer city
CUSTOMER_STATE VARCHAR2 (240)
Customer state
CUSTOMER_PROVINCE VARCHAR2 (240)
Customer province
CUSTOMER_POSTAL_CODE VARCHAR2 (30)
Customer postal code
CUSTOMER_COUNTY VARCHAR2 (240)
Customer county
CUSTOMER_COUNTRY VARCHAR2 (240) Yes Customer country
CUSTOMER_CONTACT_TITLE VARCHAR2 (30)
Customer contact title
CUSTOMER_CONTACT_FIRST_NAME VARCHAR2 (240)
Customer contact first name
CUSTOMER_CONTACT_LAST_NAME VARCHAR2 (240)
Customer contact last name
CUSTOMER_CONTACT_CNTRY_CODE VARCHAR2 (10)
Customer contact country code
CUSTOMER_CONTACT_AREA_CODE VARCHAR2 (10)
Customer contact area code
CUSTOMER_CONTACT_PHONE_NO VARCHAR2 (240)
Customer contact phone number
CUSTOMER_CONTACT_PHONE_TYPE VARCHAR2 (240)
Customer contact phone type
CUSTOMER_CONTACT_EMAIL_ADDRESS VARCHAR2 (240)
Customer contact email address
CUSTOMER_CONTACT_PHONE_EXT VARCHAR2 (10)
Customer contact phone extension
DECLINE_REASON_CODE VARCHAR2 (30)
Decline reason code
ENTITY_TYPE VARCHAR2 (30)
LEAD, OPPORTUNITY, or REFERRAL
ENTITY_ID_LINKED_TO NUMBER

lead_id (for lead referral and influences) or opportunity_id (for deal registration)
ORDER_ID NUMBER

Order identifier of the order associated with this referral
CLAIM_ID NUMBER

Claim identifier of the claim generated for this referral
CLAIM_NUMBER VARCHAR2 (30)
Claim number of the claim generated for this referral
EST_COMPENSATION_AMT NUMBER

Estimated compensation amount for this referral
CURRENCY_CODE VARCHAR2 (10)
Currency code of the estimated compensation amount
ACTUAL_COMPENSATION_AMT NUMBER

Actual compensation amount for the referral as reflected in the claim
ACTUAL_CURRENCY_CODE VARCHAR2 (10)
Currency code of the actual compensation amount
BENEFIT_TYPE_CODE VARCHAR2 (30) Yes Benefit type code (Referral or Deal Registration)
STATUS_CHANGE_DATE DATE
Yes Referral status change date
DUPLICATE_CUSTOMER_FLAG VARCHAR2 (1)
Indicates whether the customer on this referral has a duplicate in the system
ORG_ID NUMBER

Organization identifier
PARTNER_CUST_ACCOUNT_ID NUMBER (15) Yes Referring partner's customer account identifier
SECURITY_GROUP_ID NUMBER

Security group identifier
CUSTOMER_NAME_PRONOUNCIATION VARCHAR2 (240)
RETURN_REASON_CODE VARCHAR2 (30)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flexfield segment column
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flexfield segment column
Query Text

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


SELECT ROW_ID
,      REFERRAL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      REFERRAL_NAME
,      DESCRIPTION
,      BENEFIT_ID
,      REFERRAL_CODE
,      REFERRAL_STATUS
,      PARTNER_ID
,      PARTNER_CONTACT_RESOURCE_ID
,      CUSTOMER_PARTY_ID
,      CUSTOMER_ORG_CONTACT_ID
,      CUSTOMER_CONTACT_PARTY_ID
,      CUSTOMER_PARTY_SITE_ID
,      CUSTOMER_NAME
,      CUSTOMER_ADDRESS_TYPE
,      CUSTOMER_ADDRESS1
,      CUSTOMER_ADDRESS2
,      CUSTOMER_ADDRESS3
,      CUSTOMER_ADDRESS4
,      ADDRESS_LINES_PHONETIC
,      CUSTOMER_CITY
,      CUSTOMER_STATE
,      CUSTOMER_PROVINCE
,      CUSTOMER_POSTAL_CODE
,      CUSTOMER_COUNTY
,      CUSTOMER_COUNTRY
,      CUSTOMER_CONTACT_TITLE
,      CUSTOMER_CONTACT_FIRST_NAME
,      CUSTOMER_CONTACT_LAST_NAME
,      CUSTOMER_CONTACT_CNTRY_CODE
,      CUSTOMER_CONTACT_AREA_CODE
,      CUSTOMER_CONTACT_PHONE_NO
,      CUSTOMER_CONTACT_PHONE_TYPE
,      CUSTOMER_CONTACT_EMAIL_ADDRESS
,      CUSTOMER_CONTACT_PHONE_EXT
,      DECLINE_REASON_CODE
,      ENTITY_TYPE
,      ENTITY_ID_LINKED_TO
,      ORDER_ID
,      CLAIM_ID
,      CLAIM_NUMBER
,      EST_COMPENSATION_AMT
,      CURRENCY_CODE
,      ACTUAL_COMPENSATION_AMT
,      ACTUAL_CURRENCY_CODE
,      BENEFIT_TYPE_CODE
,      STATUS_CHANGE_DATE
,      DUPLICATE_CUSTOMER_FLAG
,      ORG_ID
,      PARTNER_CUST_ACCOUNT_ID
,      SECURITY_GROUP_ID
,      CUSTOMER_NAME_PRONOUNCIATION
,      RETURN_REASON_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
FROM APPS.PV_REFERRALS_VL;

Dependencies

[top of page]

APPS.PV_REFERRALS_VL references the following:

SchemaAPPS
SynonymPV_REFERRALS_B
SynonymPV_REFERRALS_TL
APPS.PV_REFERRALS_VL is referenced by following:

SchemaAPPS
Package BodyPV_REFERRAL_COMP_PUB - show dependent code
Package BodyPV_REFERRAL_GENERAL_PUB - show dependent code