[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PV_REFERRALS_B |
|---|---|
| Object Type: | TABLE |
| Owner: | PV |
| FND Design Data: |  PV.PV_REFERRALS_B
|
| Subobject Name: | |
| Status: | VALID |
This table stores referral information for a partner.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PV_REFERRALS_B_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 REFERRAL_CODE
|
| PV_REFERRALS_B_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CLAIM_ID
|
| PV_REFERRALS_B_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORDER_ID
|
| PV_REFERRALS_B_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_PARTY_ID
|
| PV_REFERRALS_B_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_CONTACT_PARTY_ID
|
| PV_REFERRALS_B_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_ORG_CONTACT_ID
|
| PV_REFERRALS_B_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_PARTY_SITE_ID
|
| PV_REFERRALS_B_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARTNER_ID
|
| PV_REFERRALS_B_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARTNER_CUST_ACCOUNT_ID
|
| PV_REFERRALS_B_U1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REFERRAL_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| 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 | |
| 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 field #1 | |
| CUSTOMER_ADDRESS2 | VARCHAR2 | (240) | Customer address field #2 | |
| CUSTOMER_ADDRESS3 | VARCHAR2 | (240) | Customer address field #3 | |
| CUSTOMER_ADDRESS4 | VARCHAR2 | (240) | Customer address field #4 | |
| 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 ID of the order tied to this referral | ||
| CLAIM_ID | NUMBER | Claim ID 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 | |
| ACTUAL_COMPENSATION_AMT | NUMBER | Actual compensation amount as reflected in the claim | ||
| ACTUAL_CURRENCY_CODE | VARCHAR2 | (10) | The currency code in the claim | |
| BENEFIT_TYPE_CODE | VARCHAR2 | (30) | Yes | BEnefit Type Code |
| STATUS_CHANGE_DATE | DATE | Yes | Status Change Date | |
| DUPLICATE_CUSTOMER_FLAG | VARCHAR2 | (1) | Duplicate customer flag | |
| ORG_ID | NUMBER | Organization identifer | ||
| 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) | This column stores the pronounciation for Referral Customer Name. All the values in this column must be in the same language. There is however no validation around this. | |
| RETURN_REASON_CODE | VARCHAR2 | (30) | This column stores the latest value of the Return Reason code. | |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT REFERRAL_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, 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 PV.PV_REFERRALS_B;
PV.PV_REFERRALS_B does not reference any database object
PV.PV_REFERRALS_B is referenced by following:
PV
PV_REFERRALS_B#
|
|
|
|