Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - PV Tables and Views

TABLE - PV.PV_ACCESS_MIGRATION_LOG
TABLE - PV.PV_ALLOWED_STATUSES
TABLE - APPS.PV_AMS_BIN_MV
TABLE - APPS.PV_AMS_BIN_SUM_MV
TABLE - PV.PV_ASSIGNMENT_LOGS
TABLE - PV.PV_ATTRIBUTES_B
TABLE - PV.PV_ATTRIBUTES_TL
TABLE - PV.PV_ATTRIBUTE_CODES_B
TABLE - PV.PV_ATTRIBUTE_CODES_TL
TABLE - PV.PV_ATTRIBUTE_USAGES
TABLE - PV.PV_ATTRIB_RESP_MAPPINGS
TABLE - PV.PV_BENFT_BUDGETS
TABLE - PV.PV_BENFT_PRODUCTS
TABLE - PV.PV_BENFT_STATUS_MAPS
TABLE - PV.PV_BENFT_THRESHOLDS
TABLE - PV.PV_BENFT_USER_ROLE_MAPS
TABLE - PV.PV_CHANNEL_TYPES
TABLE - APPS.PV_CHN_BIN_MV
TABLE - APPS.PV_CHN_BIN_SUM_MV
TABLE - PV.PV_COUNTRY_RSBLTS
TABLE - PV.PV_COUNTRY_TIMEOUTS
TABLE - PV.PV_ENTITY_ATTRS
TABLE - PV.PV_ENTITY_ATTR_MAPPINGS
TABLE - PV.PV_ENTITY_ATTR_MIRROR
TABLE - PV.PV_ENTITY_ATTR_TRENDS
TABLE - PV.PV_ENTITY_ROUTINGS
TABLE - PV.PV_ENTITY_RULES_APPLIED
TABLE - PV.PV_ENTY_ATTR_TEXTS
TABLE - PV.PV_ENTY_ATTR_VALIDATIONS
TABLE - PV.PV_ENTY_ATTR_VALUES
TABLE - PV.PV_ENTY_SELECT_CRITERIA
TABLE - PV.PV_GE_BENEFITS_B
TABLE - PV.PV_GE_BENEFITS_TL
TABLE - PV.PV_GE_CHKLST_ITEMS_B
TABLE - PV.PV_GE_CHKLST_ITEMS_TL
TABLE - PV.PV_GE_CHKLST_RESPONSES
TABLE - PV.PV_GE_HISTORY_LOG_B
TABLE - PV.PV_GE_HISTORY_LOG_PARAMS
TABLE - PV.PV_GE_HISTORY_LOG_TL
TABLE - PV.PV_GE_NOTIF_RULES_B
TABLE - PV.PV_GE_NOTIF_RULES_TL
TABLE - PV.PV_GE_PARTY_NOTIFICATIONS
TABLE - PV.PV_GE_PTNR_RESPS
TABLE - PV.PV_GE_QSNR_ELEMENTS_B
TABLE - PV.PV_GE_QSNR_ELEMENTS_TL
TABLE - PV.PV_GE_RESP_MAP_RULES
TABLE - PV.PV_GE_TEMP_APPROVERS
TABLE - PV.PV_ITYPE_ATTR_MAPS
TABLE - PV.PV_LEAD_ASSIGNMENTS
TABLE - PV.PV_LEAD_PSS_LINES
TABLE - PV.PV_LEAD_WORKFLOWS
TABLE - PV.PV_MDF_OWNERS
TABLE - PV.PV_NOTIFICATION_SETUPS
TABLE - PV.PV_OPPTY_ROUTING_LOGS
TABLE - PV.PV_PARTNER_ACCESSES
TABLE - PV.PV_PARTNER_PROFILES
TABLE - PV.PV_PARTNER_PROGRAM_B
TABLE - PV.PV_PARTNER_PROGRAM_TL
TABLE - PV.PV_PARTNER_PROGRAM_TYPE_B
TABLE - PV.PV_PARTNER_PROGRAM_TYPE_TL
TABLE - PV.PV_PARTY_NOTIFICATIONS
TABLE - PV.PV_PG_ELIG_PROGRAMS
TABLE - PV.PV_PG_ELIG_PROG_MIRR
TABLE - PV.PV_PG_ENRL_CHANGE_RULES
TABLE - PV.PV_PG_ENRL_REQUESTS
TABLE - PV.PV_PG_ENRQ_INIT_SOURCES
TABLE - PV.PV_PG_INVITE_HEADERS_B
TABLE - PV.PV_PG_INVITE_HEADERS_TL
TABLE - PV.PV_PG_MEMBERSHIPS
TABLE - PV.PV_PG_MMBR_TRANSITIONS
TABLE - APPS.PV_PRD_BIN_MV
TABLE - APPS.PV_PRD_BIN_SUM_MV
TABLE - PV.PV_PROCESS_RULES_B
TABLE - PV.PV_PROCESS_RULES_TL
TABLE - PV.PV_PROGRAM_BENEFITS
TABLE - PV.PV_PROGRAM_CONTRACTS
TABLE - PV.PV_PROGRAM_PARTNER_TYPES
TABLE - PV.PV_PROGRAM_PAYMENT_MODE
TABLE - PV.PV_REFERRALS_B
TABLE - PV.PV_REFERRALS_TL
TABLE - PV.PV_REFERRAL_STATUS_MAPS
TABLE - PV.PV_REFERRED_PRODUCTS
TABLE - PV.PV_RELATIONSHIPS
TABLE - APPS.PV_ROLLUP_MGR_MV
TABLE - PV.PV_SEARCH_ATTR_MIRROR
TABLE - PV.PV_SEARCH_ATTR_VALUES
TABLE - PV.PV_SELECTED_ATTR_VALUES
TABLE - PV.PV_SINGLE_PROD_H_MAPPINGS
TABLE - PV.PV_SINGLE_PROD_H_MAPPINGS2
TABLE - APPS.PV_SLBINAMT_SUM_MV
TABLE - APPS.PV_SL_BIN_MV
TABLE - PV.PV_STATUS_NOTIFICATIONS
TABLE - PV.PV_TAP_ACCESS_TERRS
TABLE - PV.PV_TAP_BATCH_CHG_PARTNERS
TABLE - PV.PV_USER_CUSTOM_ENTRIES
VIEW - APPS.PV_ATTRIBUTES_VL
VIEW - APPS.PV_ATTRIBUTE_CODES_VL
VIEW - APPS.PV_ATTRIBUTE_USAGES_V
VIEW - APPS.PV_ENTITY_ATTRS_V
VIEW - APPS.PV_ENTITY_ATTR_VAL_V
VIEW - APPS.PV_ENTY_ATTR_VALUES_V
VIEW - APPS.PV_GE_BENEFITS_VL
VIEW - APPS.PV_GE_CHKLST_ITEMS_VL
VIEW - APPS.PV_GE_HISTORY_LOG_VL
VIEW - APPS.PV_GE_NOTIF_RULES_VL
VIEW - APPS.PV_GE_QSNR_ELEMENTS_VL
VIEW - APPS.PV_LEAD_PSS_LINES_V
VIEW - APPS.PV_LOOKUPS
VIEW - APPS.PV_PARTNERS_ALL_V
VIEW - APPS.PV_PARTNERS_LOV_V
VIEW - APPS.PV_PARTNERS_V
VIEW - APPS.PV_PARTNER_BUSINESS_USERS_V
VIEW - APPS.PV_PARTNER_CONTACTS_V
VIEW - APPS.PV_PARTNER_LOV_V
VIEW - APPS.PV_PARTNER_PRIMARY_USERS_V
VIEW - APPS.PV_PARTNER_PROGRAM_TYPE_VL
VIEW - APPS.PV_PARTNER_PROGRAM_V
VIEW - APPS.PV_PARTNER_PROGRAM_VL
VIEW - APPS.PV_PARTNER_VENDORS_V
VIEW - APPS.PV_PG_INVITE_HEADERS_VL
VIEW - APPS.PV_PROCESS_RULES_VL
VIEW - APPS.PV_PRTNR_SALES_TEAM_V
VIEW - APPS.PV_REFERRALS_VL
VIEW - APPS.PV_RESOURCE_INFO_V
VIEW - APPS.PV_ROUTING_HISTORY_V

Table: PV_ACCESS_MIGRATION_LOG

Description:
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ACCESS_MIGRATION_LOG.ACCESS_ID AS_ACCESSES_ALL_ALL
Comments

Stores the external sales team migration rows

Columns
Name Datatype Length Mandatory Comments
ACCESS_MIGRATION_LOG_ID NUMBER (30)
Primary Key for this table
ACCESS_ID NUMBER (30) Y Access Id from as_accesses_all table
ACTION VARCHAR2 (240)
Stores the action to be performed on as_accesses_all table
CREATION_DATE DATE

Standard WHO Column
ACCESS_TYPE VARCHAR2 (240)
Access Type in as_accesses_all
FREEZE_FLAG VARCHAR2 (240)
Freeze flag in as_accesses_all
REASSIGN_FLAG VARCHAR2 (240)
reassign flag in as_accesses_all
TEAM_LEADER_FLAG VARCHAR2 (240)
team_leader_flag in as_accesses_all
CUSTOMER_ID NUMBER (30)
customer id in as_accesses_all
ADDRESS_ID NUMBER (30)
Address ID in as_accesses_all
SALESFORCE_ID NUMBER (30)
Sales Force Id in as_accesses_all
PARTNER_CUSTOMER_ID NUMBER

Partner Customer ID in as_accesses_all
PARTNER_ADDRESS_ID NUMBER (30)
Partner Address ID in as_accesses_all
LEAD_ID NUMBER (30)
Opportunity ID from as_accesses_all
SALESFORCE_ROLE_CODE VARCHAR2 (240)
Salesforce Role Code in as_accesses_all
ORG_ID NUMBER (30)
Salesforce Role Code in as_accesses_all
SALES_GROUP_ID NUMBER (30)
Sales Group Id in as_accesses_all
INTERNAL_UPDATE_ACCESS NUMBER (30)
Internal Update Access from as_accesses_all
SALES_LEAD_ID NUMBER (30)
Lead Id from as_accesses_all
PARTNER_CONT_PARTY_ID NUMBER (30)
Partner Contact Party ID
OWNER_FLAG VARCHAR2 (240)
Owner Flag
CREATED_BY_TAP_FLAG VARCHAR2 (240)
Created By TAP Flag
PRM_KEEP_FLAG VARCHAR2 (240)
PRM Keep Flag
OPEN_FLAG VARCHAR2 (240)
Open Flag

[top of page]

PV.PV_ACCESS_MIGRATION_LOG does not reference any database object

PV.PV_ACCESS_MIGRATION_LOG is referenced by following:

APPS
SYNONYM - PV_ACCESS_MIGRATION_LOG

[top of page]

Table: PV_ALLOWED_STATUSES

Description: This table is being obsoleted for 11.5.6
Primary Key: PV_ALLOWED_STATUSES_PK
  1. ALLOWED_STATUS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ALLOWED_STATUSES.TO_STATUS_CODE AS_STATUSES_B
PV_ALLOWED_STATUSES.FROM_STATUS_CODE AS_STATUSES_B
Comments
Indexes
Index Type Tablespace Column
PV_ALLOWED_STATUSES_U1 UNIQUE APPS_TS_ARCHIVE ALLOWED_STATUS_ID
PV_ALLOWED_STATUSES_N1 NONUNIQUE APPS_TS_ARCHIVE TO_STATUS_CODE
PV_ALLOWED_STATUSES_N2 NONUNIQUE APPS_TS_ARCHIVE FROM_STATUS_CODE
Columns
Name Datatype Length Mandatory Comments
ALLOWED_STATUS_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y
STATUS_CATEGORY VARCHAR2 (30)
STATUS_TYPE VARCHAR2 (40)
FROM_STATUS_CODE VARCHAR2 (30) Y
TO_STATUS_CODE VARCHAR2 (30)
SECURITY_GROUP_ID NUMBER (15)
ENABLED_FLAG VARCHAR2 (1) Y
LOV_FLAG VARCHAR2 (1)
TIMEOUT_NOTIFY_FLAG VARCHAR2 (1)
DURATION_VIEW_TYPE_CODE VARCHAR2 (30)
NOTIFY_PT_FLAG VARCHAR2 (1)
NOTIFY_CM_FLAG VARCHAR2 (1)
NOTIFY_LAM_FLAG VARCHAR2 (1)
NOTIFY_SUPPORT_REP_FLAG VARCHAR2 (1)

[top of page]

PV.PV_ALLOWED_STATUSES does not reference any database object

PV.PV_ALLOWED_STATUSES is referenced by following:

APPS
SYNONYM - PV_ALLOWED_STATUSES

[top of page]

Table: PV_AMS_BIN_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PARENT_RESOURCE_ID NUMBER

SOURCE_PROMOTION_ID NUMBER

CNT NUMBER

TOTAL_AMOUNT NUMBER

WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
CURRENCY_CODE VARCHAR2 (15)
PERIOD_TYPE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y
LEAD_ID NUMBER
Y

[top of page]

APPS.PV_AMS_BIN_MV does not reference any database object

APPS.PV_AMS_BIN_MV is not referenced by any database object

[top of page]

Table: PV_AMS_BIN_SUM_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PARENT_RESOURCE_ID NUMBER

SOURCE_PROMOTION_ID NUMBER

LCNT NUMBER

TOTAL_AMOUNT NUMBER

WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
CURRENCY_CODE VARCHAR2 (15)
PERIOD_TYPE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y

[top of page]

APPS.PV_AMS_BIN_SUM_MV does not reference any database object

APPS.PV_AMS_BIN_SUM_MV is not referenced by any database object

[top of page]

Table: PV_ASSIGNMENT_LOGS

Description: Lead assignments log
Primary Key: PV_ASSIGNMENT_LOGS_PK
  1. ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ASSIGNMENT_LOGS.LEAD_ASSIGNMENT_ID PV_LEAD_ASSIGNMENTS
PV_ASSIGNMENT_LOGS.PARTNER_ID HZ_PARTIES
Comments

PV_ASSIGNMENT_LOGS stores history of all the lead assignments

Indexes
Index Type Tablespace Column
PV_ASSIGNMENT_LOGS_U1 UNIQUE APPS_TS_TX_IDX ASSIGNMENT_ID
PV_ASSIGNMENT_LOGS_N1 NONUNIQUE APPS_TS_TX_IDX LEAD_ASSIGNMENT_ID
PV_ASSIGNMENT_LOGS_N2 NONUNIQUE APPS_TS_TX_IDX LEAD_ID
PV_ASSIGNMENT_LOGS_N3 NONUNIQUE APPS_TS_TX_IDX PARTNER_ID
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER
Y Lead assignment identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
LEAD_ASSIGNMENT_ID NUMBER

Lead assignment identifier
PARTNER_ID NUMBER

Partner identifier
ASSIGN_SEQUENCE NUMBER

Sotes the serial order in which lead is to be assigned to the partners in serial mode
CM_ID NUMBER

Supplier employee with a channel manager role identifier
LEAD_ID NUMBER
Y Lead identifier
DURATION NUMBER

Fixed time duration for a lead with Supplier/Partner for an action to be taken
FROM_LEAD_STATUS VARCHAR2 (30)
The lead status changing from
TO_LEAD_STATUS VARCHAR2 (30)
The lead status changed to
STATUS VARCHAR2 (30)
Indicates the stage of the lead with in a lead assignment cycle
STATUS_DATE DATE

Lead assignment status date
WF_ITEM_TYPE VARCHAR2 (30)
Workflow item type, part of workflow unique identifier
WF_ITEM_KEY VARCHAR2 (30)
Workflow unique identifier
WF_PT_USER VARCHAR2 (30)
Partner user name
WF_CM_USER VARCHAR2 (30)
Supplier employee with a role of Channel manager user name
WORKFLOW_ID NUMBER

Workflow identifier
ERROR_TXT VARCHAR2 (255)
To display workflow error messages
TRANS_TYPE NUMBER (15)
Transaction type
STATUS_CHANGE_COMMENTS VARCHAR2 (60)
Reason for the status change if any
SECURITY_GROUP_ID NUMBER

Security group identifier

[top of page]

PV.PV_ASSIGNMENT_LOGS does not reference any database object

PV.PV_ASSIGNMENT_LOGS is referenced by following:

APPS
SYNONYM - PV_ASSIGNMENT_LOGS

[top of page]

Table: PV_ATTRIBUTES_B

Description: Partner attribute identifiers
Primary Key: PV_ATTRIBUTES_B_PK
  1. ATTRIBUTE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_ATTRIBUTE_USAGES.ATTRIBUTE_ID PV_ATTRIBUTES_B
PV_ENTITY_ATTR_TRENDS.ATTRIBUTE_ID PV_ATTRIBUTES_B
PV_ATTRIB_RESP_MAPPINGS.ATTRIBUTE_ID PV_ATTRIBUTES_B
PV_ATTRIBUTES_TL.ATTRIBUTE_ID PV_ATTRIBUTES_B
PV_ATTRIBUTE_CODES_B.ATTRIBUTE_ID PV_ATTRIBUTES_B
PV_ATTRIBUTE_CODES.ATTRIBUTE_ID PV_ATTRIBUTES_B
PV_ENTITY_ATTRS.ATTRIBUTE_ID PV_ATTRIBUTES_B
PV_ENTITY_ATTR_MAPPINGS.SOURCE_ATTR_ID PV_ATTRIBUTES_B
PV_ENTITY_ATTR_MAPPINGS.TARGET_ATTR_ID PV_ATTRIBUTES_B
PV_ENTY_ATTR_VALUES.ATTRIBUTE_ID PV_ATTRIBUTES_B
PV_ENTY_SELECT_CRITERIA.ATTRIBUTE_ID PV_ATTRIBUTES_B
PV_SEARCH_ATTR_VALUES.ATTRIBUTE_ID PV_ATTRIBUTES_B
Comments

PV_ATTRIBUTES_B stores additional lead/partner attribute identifiers

Indexes
Index Type Tablespace Column
PV_ATTRIBUTES_B_U1 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_ID NUMBER (15) Y Attribute identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
SECURITY_GROUP_ID NUMBER (15)
Security group identifier
ENABLED_FLAG VARCHAR2 (1) Y Flag to enable or disable the Attribute
ATTRIBUTE_TYPE VARCHAR2 (30)
Attribute display type, text or lov or dropdown etc.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category, number or date or text type
SEEDED_FLAG VARCHAR2 (1)
Whether the attribute is seeded or not
LOV_FUNCTION_NAME VARCHAR2 (30)
Function name for the List of values, if any
RETURN_TYPE VARCHAR2 (30)
If the attribute is a function attribute, it specifies the return type
MAX_VALUE_FLAG VARCHAR2 (1)
Attribute value is Max or not
DISPLAY_STYLE VARCHAR2 (30)
Attribute Dsplay Style(text,Dropdown etc)
EXPOSE_TO_PARTNER_FLAG VARCHAR2 (1)
Exposed to Partner or Not
CHARACTER_WIDTH NUMBER

Character Width of the attribute
DECIMAL_POINTS NUMBER

Decimal Points for number attribute
NO_OF_LINES NUMBER

Number of Lines
VALUE_EXTN_RETURN_TYPE VARCHAR2 (30)
Value of External Return Type if any
ENABLE_MATCHING_FLAG VARCHAR2 (1)
Matching Flag enabled if Y else, N
PERFORMANCE_FLAG VARCHAR2 (1)
Indicates whether this attribute is a performance attribute.
ADDITIVE_FLAG VARCHAR2 (1)
Indicates whether the attribute value of this attribute can be added across time.
SEQUENCE_NUMBER NUMBER

The column is used to specify ther placement of the attribute on the appropriate UI.

[top of page]

PV.PV_ATTRIBUTES_B does not reference any database object

PV.PV_ATTRIBUTES_B is referenced by following:

APPS
SYNONYM - PV_ATTRIBUTES_B

[top of page]

Table: PV_ATTRIBUTES_TL

Description: Partner attribute name and description
Primary Key: PV_ATTRIBUTES_TL_PK
  1. ATTRIBUTE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ATTRIBUTES_TL.ATTRIBUTE_ID PV_ATTRIBUTES_B
Comments

PV_ATTRIBUTES_TL stores the name and description of the additional lead/partner attributes with a multilingal support.

Indexes
Index Type Tablespace Column
PV_ATTRIBUTES_TL_U1 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
LANGUAGE
PV_ATTRIBUTES_TL_U2 UNIQUE APPS_TS_TX_IDX LANGUAGE
SHORT_NAME
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_ID NUMBER (15) Y Attribute identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
LANGUAGE VARCHAR2 (4) Y Language being translated to
SOURCE_LANG VARCHAR2 (4) Y Source language
NAME VARCHAR2 (60)
Partner attribute name
DESCRIPTION VARCHAR2 (240)
Partner attribute description
SHORT_NAME VARCHAR2 (60)
Partner attribute short name
SECURITY_GROUP_ID NUMBER (15)
Security group identifier

[top of page]

PV.PV_ATTRIBUTES_TL does not reference any database object

PV.PV_ATTRIBUTES_TL is referenced by following:

APPS
SYNONYM - PV_ATTRIBUTES_TL

[top of page]

Table: PV_ATTRIBUTE_CODES_B

Description: Partner attribute identifiers
Primary Key: PV_ATTRIBUTE_CODES_B_PK
  1. ATTR_CODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ATTRIBUTE_CODES_B.ATTRIBUTE_ID PV_ATTRIBUTES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_ATTRIBUTE_CODES_TL.ATTR_CODE_ID PV_ATTRIBUTE_CODES_B
PV_LEAD_PSS_LINES.ATTR_CODE_ID PV_ATTRIBUTE_CODES_B
Comments

PV_ATTRIBUTE_CODES_B stores predefined Attribute Codes which are
mapped to the product interest types of the table AS_INTEREST_TYPES_B.
PV_ATTRIBUTE_CODES associated with the attribute details in PV_ATTRIBUTES_TL

Indexes
Index Type Tablespace Column
PV_ATTRIBUTE_CODES_B_U1 UNIQUE APPS_TS_TX_IDX ATTR_CODE_ID
PV_ATTRIBUTE_CODES_B_U2 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
ATTR_CODE
Columns
Name Datatype Length Mandatory Comments
ATTR_CODE_ID NUMBER (15) Y Attribute code identifier
ATTR_CODE VARCHAR2 (30) Y Partner Attribute Code
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
ATTRIBUTE_ID NUMBER
Y Attribute identifier
ENABLED_FLAG VARCHAR2 (1) Y Attribute enabled flag
START_DATE_ACTIVE DATE

Starting date for an attribute in active state
END_DATE_ACTIVE DATE

Ending date for an attribute in active state
AUTO_ASSIGN_FLAG VARCHAR2 (1)
Flag used for automatic matching or not
SECURITY_GROUP_ID NUMBER (15)
Security group identifier

[top of page]

PV.PV_ATTRIBUTE_CODES_B does not reference any database object

PV.PV_ATTRIBUTE_CODES_B is referenced by following:

APPS
SYNONYM - PV_ATTRIBUTE_CODES_B

[top of page]

Table: PV_ATTRIBUTE_CODES_TL

Description: Partner Attribute Code name and description
Primary Key: PV_ATTRIBUTE_CODES_TL_PK
  1. ATTR_CODE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ATTRIBUTE_CODES_TL.ATTR_CODE_ID PV_ATTRIBUTE_CODES_B
Comments

PV_ATTRIBUTE_CODES_TL stores the name and description of the attributes codes with a multilingal support.

Indexes
Index Type Tablespace Column
PV_ATTRIBUTE_CODES_TL_U1 UNIQUE APPS_TS_TX_IDX ATTR_CODE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
ATTR_CODE_ID NUMBER (15) Y Attribute code indentifier
LANGUAGE VARCHAR2 (4) Y Language being translated to
SOURCE_LANG VARCHAR2 (4) Y Source language
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
DESCRIPTION VARCHAR2 (240) Y Attribute code description
SECURITY_GROUP_ID NUMBER (15)
Security group identifier

[top of page]

PV.PV_ATTRIBUTE_CODES_TL does not reference any database object

PV.PV_ATTRIBUTE_CODES_TL is referenced by following:

APPS
SYNONYM - PV_ATTRIBUTE_CODES_TL

[top of page]

Table: PV_ATTRIBUTE_USAGES

Description: Attribute used for - Opportunity, Partner,Locator
Primary Key: PV_ATTRIBUTE_USAGES_PK
  1. ATTRIBUTE_USAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ATTRIBUTE_USAGES.ATTRIBUTE_ID PV_ATTRIBUTES_B
Comments

PV_ATTRIBUTE_USAGES Stores the attributed id along with the attribute used type.

Indexes
Index Type Tablespace Column
PV_ATTRIBUTE_USAGES_U1 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_USAGE_ID
PV_ATTRIBUTE_USAGES_N1 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_USAGE_ID NUMBER
Y Attribute usage identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last date this record was updated by a concurrent program
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
ATTRIBUTE_USAGE_TYPE VARCHAR2 (30) Y Attribute usage type like Opportunity,partner
ATTRIBUTE_USAGE_CODE VARCHAR2 (30) Y Short code for attribute usage
ATTRIBUTE_ID NUMBER (15) Y Attribute identifier
ENABLED_FLAG VARCHAR2 (1) Y The flag is to indicate if the record is enabled or not
SECURITY_GROUP_ID NUMBER

Security Group Identifier

[top of page]

PV.PV_ATTRIBUTE_USAGES does not reference any database object

PV.PV_ATTRIBUTE_USAGES is referenced by following:

APPS
SYNONYM - PV_ATTRIBUTE_USAGES

[top of page]

Table: PV_ATTRIB_RESP_MAPPINGS

Description:
Primary Key: PV_ATTRIB_RESP_MAPPINGS_PK
  1. ATTRIB_RESP_MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ATTRIB_RESP_MAPPINGS.ATTRIBUTE_ID PV_ATTRIBUTES_B
PV_ATTRIB_RESP_MAPPINGS.REF_ATTRIB_RESP_MAP_ID PV_ATTRIB_RESP_MAPPINGS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_ATTRIB_RESP_MAPPINGS.REF_ATTRIB_RESP_MAP_ID PV_ATTRIB_RESP_MAPPINGS
Comments

This table is used to store the attribute responsibility mappings. Thsi is primarily used to store Manula Matching Responsibility Mappings and the responsibility mappings used to map attributes to the responsibility for sord order feature.

Indexes
Index Type Tablespace Column
PV_ATTRIB_RESP_MAPPINGS_N1 NONUNIQUE APPS_TS_TX_IDX RESPONSIBILITY_ID
ATTRIBUTE_ID
PV_ATTRIB_RESP_MAPPINGS_N2 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
PV_ATTRIB_RESP_MAPPINGS_U1 NONUNIQUE APPS_TS_TX_IDX ATTRIB_RESP_MAP_ID
Columns
Name Datatype Length Mandatory Comments
ATTRIB_RESP_MAP_ID NUMBER
Y Primary Key of the table
CREATION_DATE DATE
Y Standard WHO Column
CREATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_DATE DATE
Y Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER (15) Y Standard WHO Column
SECURITY_GROUP_ID NUMBER (15)
Standard WHO Column
RESPONSIBILITY_ID NUMBER (15) Y The responsibility id of the responsibility to which the attribute is tied to
ENTITY_TYPE VARCHAR2 (30) Y The entity type for which the attribute is tied to along with the responsibility
STATUS VARCHAR2 (30)
Status of the responsibility map.
ATTRIBUTE_ID NUMBER (15)
Attribute Id of the attribute that is tied to responsibility and entity.
ATTRIBUTE_ORDER NUMBER (15)
Order of the attribute that is displayed on User interface
REF_ATTRIB_RESP_MAP_ID NUMBER

this column stores the responsibility id to which thsi attribute belongs to.

[top of page]

PV.PV_ATTRIB_RESP_MAPPINGS does not reference any database object

PV.PV_ATTRIB_RESP_MAPPINGS is referenced by following:

APPS
SYNONYM - PV_ATTRIB_RESP_MAPPINGS

[top of page]

Table: PV_BENFT_BUDGETS

Description: Benefit Budgets
Primary Key: PV_BENFT_BUDGET_PK
  1. BENFT_BUDGET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_BENFT_BUDGETS.BENEFIT_ID PV_GE_BENEFITS_B
Comments

This table stores the budgets used by the benefit.

Indexes
Index Type Tablespace Column
PV_BENFT_BUDGETS_U1 NONUNIQUE APPS_TS_TX_IDX BENFT_BUDGET_ID
Columns
Name Datatype Length Mandatory Comments
BENFT_BUDGET_ID NUMBER
Y Benefit budget identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
BUDGET_ID NUMBER

Budget ID
BENEFIT_ID NUMBER
Y Benefit ID
SECURITY_GROUP_ID NUMBER

Security group identifier
REQUESTED_BUDGET_AMOUNT NUMBER
Y Amount requested of the budget
BUDGET_REQUEST_ID NUMBER

Budget request ID

[top of page]

PV.PV_BENFT_BUDGETS does not reference any database object

PV.PV_BENFT_BUDGETS is referenced by following:

APPS
SYNONYM - PV_BENFT_BUDGETS

[top of page]

Table: PV_BENFT_PRODUCTS

Description: Benefit Products
Primary Key: PV_BENFT_PRODUCTS_PK
  1. BENFT_PRODUCT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_BENFT_PRODUCTS.BENEFIT_ID PV_GE_BENEFITS_B
Comments

This table stores the product categories used by the benefit.

Indexes
Index Type Tablespace Column
PV_BENFT_PRODUCTS_U1 NONUNIQUE APPS_TS_TX_IDX BENFT_PRODUCT_ID
Columns
Name Datatype Length Mandatory Comments
BENFT_PRODUCT_ID NUMBER
Y Benefit product identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
COMPENSATION_PERCENTAGE NUMBER

Compensation percentage
MAXIMUM_COMPENSATION NUMBER

maximum compensation
CURRENCY_CODE VARCHAR2 (240)
currency code
BENEFIT_ID NUMBER
Y Benefit identifier
SECURITY_GROUP_ID NUMBER

Security group identifier
PRODUCT_CATEGORY_ID NUMBER
Y Product category identifier
PRODUCT_CATEGORY_SET_ID NUMBER
Y Product categoryh set identifier

[top of page]

PV.PV_BENFT_PRODUCTS does not reference any database object

PV.PV_BENFT_PRODUCTS is referenced by following:

APPS
SYNONYM - PV_BENFT_PRODUCTS

[top of page]

Table: PV_BENFT_STATUS_MAPS

Description: Benefit status map
Primary Key: PV_BENFT_STATUS_MAPS_PK
  1. BENFT_STATUS_MAP_ID
Comments

This table stores the mapping of vendor view and partner view benefit status codes.

Columns
Name Datatype Length Mandatory Comments
BENFT_STATUS_MAP_ID NUMBER
Y Benefit status map identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
BENEFIT_TYPE VARCHAR2 (30)
Benefit type
VENDOR_STATUS_CODE VARCHAR2 (100)
Status code as seen by vendor
PARTNER_STATUS_CODE VARCHAR2 (100)
Status code as seen by partner
SECURITY_GROUP_ID NUMBER

Security group identifier

[top of page]

PV.PV_BENFT_STATUS_MAPS does not reference any database object

PV.PV_BENFT_STATUS_MAPS is referenced by following:

APPS
SYNONYM - PV_BENFT_STATUS_MAPS

[top of page]

Table: PV_BENFT_THRESHOLDS

Description: Benefit threshold
Primary Key: PV_BENFT_THRESHOLDS_PK
  1. BENFT_THRESHOLD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_BENFT_THRESHOLDS.BENEFIT_ID PV_GE_BENEFITS_B
Comments

This table stores the territories used by the benefit and the threshold defined on each territory.

Indexes
Index Type Tablespace Column
PV_BENFT_THRESHOLDS_N1 NONUNIQUE APPS_TS_TX_IDX BENEFIT_ID
PV_BENFT_THRESHOLDS_U1 NONUNIQUE APPS_TS_TX_IDX BENFT_THRESHOLD_ID
Columns
Name Datatype Length Mandatory Comments
BENFT_THRESHOLD_ID NUMBER
Y Benefit threshold identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
TERRITORY_ID NUMBER
Y Territory identifier
THRESHOLD_AMOUNT NUMBER
Y threshold amount
CURRENCY_CODE VARCHAR2 (240) Y Currency code
ACTION VARCHAR2 (240)
action
EXPIRATION NUMBER

Expiration in number of days
BENEFIT_ID NUMBER
Y Benefit identifier
SECURITY_GROUP_ID NUMBER

Security group identifier

[top of page]

PV.PV_BENFT_THRESHOLDS does not reference any database object

PV.PV_BENFT_THRESHOLDS is referenced by following:

APPS
SYNONYM - PV_BENFT_THRESHOLDS

[top of page]

Table: PV_BENFT_USER_ROLE_MAPS

Description: Benefit user role map
Primary Key: PV_BENFT_USER_ROLE_MAPS_PK
  1. USER_ROLE_MAP_ID
Comments

This table stores the user roles available for a particular benefit type.

Indexes
Index Type Tablespace Column
PV_BENFT_USER_ROLE_MAPS_U1 NONUNIQUE APPS_TS_TX_IDX USER_ROLE_MAP_ID
Columns
Name Datatype Length Mandatory Comments
USER_ROLE_MAP_ID NUMBER
Y User role map identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
BENEFIT_TYPE VARCHAR2 (8)
Benefit type (Referral, Deal Registration, Soft Funds, etc)
USER_ROLE_CODE VARCHAR2 (30)
User role code
EXTERNAL_FLAG VARCHAR2 (1)
Indicates whether the user role is an external (e.g. partner) or an internal (e.g. vendor) user role.
SECURITY_GROUP_ID NUMBER

Security group identifier

[top of page]

PV.PV_BENFT_USER_ROLE_MAPS does not reference any database object

PV.PV_BENFT_USER_ROLE_MAPS is referenced by following:

APPS
SYNONYM - PV_BENFT_USER_ROLE_MAPS

[top of page]

Table: PV_CHANNEL_TYPES

Description: Channel Types (Direct/Indirect)
Primary Key: PV_CHANNEL_TYPES_PK
  1. CHANNEL_TYPE_ID
Comments

PV_CHANNEL_TYPES Stores various Channel types to indicate the whether the channel is direct channel or indirect channel

Indexes
Index Type Tablespace Column
PV_CHANNEL_TYPES_U1 UNIQUE APPS_TS_TX_IDX CHANNEL_TYPE_ID
PV_CHANNEL_TYPES_U2 UNIQUE APPS_TS_TX_IDX CHANNEL_LOOKUP_CODE
CHANNEL_LOOKUP_TYPE
Columns
Name Datatype Length Mandatory Comments
CHANNEL_TYPE_ID NUMBER
Y Channel type identifier
CHANNEL_LOOKUP_TYPE VARCHAR2 (30) Y Channel Type
CHANNEL_LOOKUP_CODE VARCHAR2 (30) Y Channel code
INDIRECT_CHANNEL_FLAG VARCHAR2 (1) Y Flag to identify whether the channel is indirect or direct for an opportunity
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
REQUEST_ID NUMBER (15)
Request identifier
PROGRAM_APPLICATION_ID NUMBER (15)
Program application identifier
PROGRAM_ID NUMBER (15)
Program identifier
PROGRAM_UPDATE_DATE DATE

Program updated date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
SECURITY_GROUP_ID NUMBER (15)
Security group identifier
RANK NUMBER

Rank for the defined channel

[top of page]

PV.PV_CHANNEL_TYPES does not reference any database object

PV.PV_CHANNEL_TYPES is referenced by following:

APPS
SYNONYM - PV_CHANNEL_TYPES

[top of page]

Table: PV_CHN_BIN_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PARENT_RESOURCE_ID NUMBER

CHANNEL_CODE VARCHAR2 (30)
CNT NUMBER

TOTAL_AMOUNT NUMBER

WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
CURRENCY_CODE VARCHAR2 (15)
PERIOD_TYPE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y
LEAD_ID NUMBER
Y

[top of page]

APPS.PV_CHN_BIN_MV does not reference any database object

APPS.PV_CHN_BIN_MV is not referenced by any database object

[top of page]

Table: PV_CHN_BIN_SUM_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PARENT_RESOURCE_ID NUMBER

CHANNEL_CODE VARCHAR2 (30)
LCNT NUMBER

TOTAL_AMOUNT NUMBER

WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
CURRENCY_CODE VARCHAR2 (15)
PERIOD_TYPE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y

[top of page]

APPS.PV_CHN_BIN_SUM_MV does not reference any database object

APPS.PV_CHN_BIN_SUM_MV is not referenced by any database object

[top of page]

Table: PV_COUNTRY_RSBLTS

Description: Supplier employee responsible for a country or regions in the country
Primary Key: PV_COUNTRY_RSBLTS_PK
  1. COUNTRY_RESP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_COUNTRY_RSBLTS.COUNTRY_CODE FND_TERRITORIES
PV_COUNTRY_RSBLTS.RESOURCE_ID JTF_RS_RESOURCE_EXTNS
PV_COUNTRY_RSBLTS.CONTACT_ID HZ_PARTIES
Comments
Indexes
Index Type Tablespace Column
PV_COUNTRY_RSBLTS_U5 UNIQUE APPS_TS_ARCHIVE COUNTRY_RESP_ID
PV_COUNTRY_RSBLTS_N1 NONUNIQUE APPS_TS_ARCHIVE CONTACT_ID
PV_COUNTRY_RSBLTS_N2 NONUNIQUE APPS_TS_ARCHIVE RESOURCE_ID
PV_COUNTRY_RSBLTS_N4 NONUNIQUE APPS_TS_ARCHIVE COUNTRY_CODE
Columns
Name Datatype Length Mandatory Comments
COUNTRY_RESP_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER
Y
POSTAL_FROM VARCHAR2 (30)
POSTAL_TO VARCHAR2 (30)
COUNTRY_CODE VARCHAR2 (15) Y
RESOURCE_TYPE VARCHAR2 (30) Y
RESOURCE_ID NUMBER (15) Y
CONTACT_ID NUMBER

PRIMARY_FLAG VARCHAR2 (1) Y
SECURITY_GROUP_ID NUMBER (15)

[top of page]

PV.PV_COUNTRY_RSBLTS does not reference any database object

PV.PV_COUNTRY_RSBLTS is referenced by following:

APPS
SYNONYM - PV_COUNTRY_RSBLTS

[top of page]

Table: PV_COUNTRY_TIMEOUTS

Description: Timeout periods based on the country
Primary Key: PV_COUNTRY_TIMEOUTS_PK
  1. TIMEOUT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_COUNTRY_TIMEOUTS.COUNTRY_CODE FND_TERRITORIES
Comments

PV_COUNTRY_TIMEOUT stores different timeout period based on the country to provide the same time across all the partners from various geographical areas for an offered lead

Indexes
Index Type Tablespace Column
PV_COUNTRY_TIMEOUTS_U1 UNIQUE APPS_TS_TX_IDX TIMEOUT_ID
PV_COUNTRY_TIMEOUTS_U2 UNIQUE APPS_TS_TX_IDX TIMEOUT_TYPE
COUNTRY_CODE
PV_COUNTRY_TIMEOUTS_N1 NONUNIQUE APPS_TS_TX_IDX COUNTRY_CODE
Columns
Name Datatype Length Mandatory Comments
TIMEOUT_ID NUMBER (15) Y Timeout identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
TIMEOUT_PERIOD NUMBER (30)
Time out period in hours based on the country
TIMEOUT_TYPE VARCHAR2 (30)
Predefined timeout types
COUNTRY_CODE VARCHAR2 (15) Y Country code
SECURITY_GROUP_ID NUMBER (15)
Security group identifier

[top of page]

PV.PV_COUNTRY_TIMEOUTS does not reference any database object

PV.PV_COUNTRY_TIMEOUTS is referenced by following:

APPS
SYNONYM - PV_COUNTRY_TIMEOUTS

[top of page]

Table: PV_ENTITY_ATTRS

Description: Entity attributes
Primary Key: PV_ENTITY_ATTRS_PK
  1. ENTITY_ATTR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ENTITY_ATTRS.ATTRIBUTE_ID PV_ATTRIBUTES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_GE_QSNR_ELEMENTS_B.ENTITY_ATTR_ID PV_ENTITY_ATTRS
Comments

PV_ENTITY_ATTRS stores the information about the entity attribute relationships used for
deciding partner selection based on the rank. The rank is determined based on the partner experties defined in the PV_ATTRIBUTE_CODES

Indexes
Index Type Tablespace Column
PV_ENTITY_ATTRS_U1 UNIQUE APPS_TS_TX_IDX ENTITY_ATTR_ID
PV_ENTITY_ATTRS_U2 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
ENTITY
PV_ENTITY_ATTRS_N2 NONUNIQUE APPS_TS_TX_IDX ENTITY
Columns
Name Datatype Length Mandatory Comments
ENTITY_ATTR_ID NUMBER (15) Y Entity identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
ATTRIBUTE_ID NUMBER (15) Y Attribute identifier
ENTITY VARCHAR2 (30) Y Type of entity (ex: partner,lead)
SRC_TABLE_NAME VARCHAR2 (50)
SRC_PKCOL_NAME VARCHAR2 (100)
SQL_TEXT VARCHAR2 (2000)
Contains a sql text that returns values associated with a lead or partner
ATTR_DATA_TYPE VARCHAR2 (30)
Data source from which the entity is defined
LOV_STRING VARCHAR2 (2000)
Contains a sql text that is used in displaying LOV on mannual matching screens
ENABLED_FLAG VARCHAR2 (1) Y The entity-attributes row is enabled or not
ITEM_STYLE VARCHAR2 (30)
Item style to be used while rendering the attribute
SELECTION_TYPE VARCHAR2 (1)
Based on the value, matching partner screen field can be single select or multi select
DISPLAY_FLAG VARCHAR2 (1) Y Flag to restrict the contents based on the roles
RANK NUMBER (3)
AUTO_ASSIGN_FLAG VARCHAR2 (1)
SECURITY_GROUP_ID NUMBER (15)
Security group identifier
LOCATOR_FLAG VARCHAR2 (1)
Attribute Locator Flag
ENTITY_TYPE VARCHAR2 (30)
Entity type for categarization
REQUIRE_VALIDATION_FLAG VARCHAR2 (1)
Require Validation Flag, if Yes it is Y else it is N
EXTERNAL_UPDATE_TEXT VARCHAR2 (2000)
External Update Text
BATCH_SQL_TEXT VARCHAR2 (2000)
Same as sql_text but the predicate of the SQL is not qualified by an entity_id (e.g. partner_id or lead_id).
REFRESH_FREQUENCY NUMBER

Refresh frequency of the attribute
REFRESH_FREQUENCY_UOM VARCHAR2 (20)
Refresh frequency unit of measure (e.g. DAY, HOUR MONTH)
LAST_REFRESH_DATE DATE

The date the attribute is last refreshed.
DISPLAY_EXTERNAL_VALUE_FLAG VARCHAR2 (1)
For performance and derived attributes of 'PARTNER' entity, if display_external_value_flag is 'Y', then the attribute value is stored in pv_search_attr_values. Otherwise, the attribute value is stored in pv_enty_attr_values.

[top of page]

PV.PV_ENTITY_ATTRS does not reference any database object

PV.PV_ENTITY_ATTRS is referenced by following:

APPS
SYNONYM - PV_ENTITY_ATTRS

[top of page]

Table: PV_ENTITY_ATTR_MAPPINGS

Description: Entity attributes mapping
Primary Key: PV_ENTITY_ATTR_MAPPINGS_PK
  1. MAPPING_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ENTITY_ATTR_MAPPINGS.PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_ENTITY_ATTR_MAPPINGS.SOURCE_ATTR_ID PV_ATTRIBUTES_B
PV_ENTITY_ATTR_MAPPINGS.TARGET_ATTR_ID PV_ATTRIBUTES_B
Comments

PV_ENTITY_ATTR_MAPPINGS Stores the attribute mappings of an entity type (e.g. partner qualification) to another entity type (e.g. opportunity selection).

Indexes
Index Type Tablespace Column
PV_ENTITY_ATTR_MAPPINGS_U1 UNIQUE APPS_TS_TX_IDX MAPPING_ID
PV_ENTITY_ATTR_MAPPINGS_N1 NONUNIQUE APPS_TS_TX_IDX SOURCE_ATTR_ID
PV_ENTITY_ATTR_MAPPINGS_N2 NONUNIQUE APPS_TS_TX_IDX TARGET_ATTR_ID
Columns
Name Datatype Length Mandatory Comments
MAPPING_ID NUMBER
Y Mapping identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER

Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last date this record was updated by a concurrent program
PROCESS_RULE_ID NUMBER
Y Process Rule Identifier, Foreign key to pv_process_rules.process_rule_id
SOURCE_ATTR_TYPE VARCHAR2 (30) Y Source attribute type, ex: lead or partner, lookup type = 'PV_ENTITY_ATTR_TYPE'
SOURCE_ATTR_ID NUMBER
Y Source attribute identifier,Foreign key to pv_attributes_vl.attribute_id.
TARGET_ATTR_TYPE VARCHAR2 (30) Y Target attribute type, ex: lead or partner, lookup type = 'PV_ENTITY_ATTR_TYPE'
TARGET_ATTR_ID NUMBER
Y Target attribute identifier, Foreign key to pv_attributes_vl.attribute_id.
OPERATOR VARCHAR2 (30) Y Operator, If the attribute is of VARCHAR2 type:lookup_type = 'PV_TEXT_OPERATOR',If the attribute is of NUMBER or DATE type:lookup_type = 'PV_NUM_DATE_OPERATOR' .
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield structure definition
SECURITY_GROUP_ID NUMBER

Security Group Identifier

[top of page]

PV.PV_ENTITY_ATTR_MAPPINGS does not reference any database object

PV.PV_ENTITY_ATTR_MAPPINGS is referenced by following:

APPS
SYNONYM - PV_ENTITY_ATTR_MAPPINGS

[top of page]

Table: PV_ENTITY_ATTR_MIRROR

Description: Entity attributes
Primary Key: PV_ENTITY_ATTR_MIRROR_PK
  1. ATTRIBUTE_TREND_ID
Comments

Mirror table for pv_entity_attr_trends table.

Indexes
Index Type Tablespace Column
PV_ENTITY_ATTR_TRENDS_U1_M UNIQUE APPS_TS_TX_IDX ATTRIBUTE_TREND_ID
PV_ENTITY_ATTR_TRENDS_N2_M NONUNIQUE APPS_TS_TX_IDX ENTITY_ID
ATTRIBUTE_ID
TREND_TIMELINE
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_TREND_ID NUMBER (15) Y Entity identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
ATTRIBUTE_ID NUMBER (15) Y Attribute identifier
ENTITY_ID NUMBER (30) Y Depends on entity, this identifier can be partner, lead, or sales lead identifier
ENTITY VARCHAR2 (30) Y Type of entity (ex: partner,lead)
ATTR_VALUE NUMBER
Y Attribute value
TREND_TIMELINE DATE
Y The starting date of this trending period
TIME_UOM VARCHAR2 (30)
Time unit of measure used for trending
CURRENCY_CODE VARCHAR2 (3)
Currency code
CURRENCY_DATE DATE

Currency conversion date
SECURITY_GROUP_ID NUMBER (15)
Security group identifier

[top of page]

PV.PV_ENTITY_ATTR_MIRROR does not reference any database object

PV.PV_ENTITY_ATTR_MIRROR is referenced by following:

APPS
SYNONYM - PV_ENTITY_ATTR_MIRROR

[top of page]

Table: PV_ENTITY_ATTR_TRENDS

Description: Entity attributes
Primary Key: PV_ENTITY_ATTR_TRENDS_PK
  1. ATTRIBUTE_TREND_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ENTITY_ATTR_TRENDS.ATTRIBUTE_ID PV_ATTRIBUTES_B
Comments

PV_ENTITY_ATTR_TRENDS stores the information about the entity attribute relationships used for
deciding partner selection based on the rank. The rank is determined based on the partner experties defined in the PV_ATTRIBUTE_CODES

Indexes
Index Type Tablespace Column
PV_ENTITY_ATTR_TRENDS_U1 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_TREND_ID
PV_ENTITY_ATTR_TRENDS_N2 NONUNIQUE APPS_TS_TX_IDX ENTITY_ID
ATTRIBUTE_ID
TREND_TIMELINE
Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_TREND_ID NUMBER (15) Y Entity identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
ATTRIBUTE_ID NUMBER (15) Y Attribute identifier
ENTITY_ID NUMBER (30) Y Depends on entity, this identifier can be partner, lead, or sales lead identifier
ENTITY VARCHAR2 (30) Y Type of entity (ex: partner,lead)
ATTR_VALUE NUMBER
Y Attribute value
TREND_TIMELINE DATE
Y The starting date of this trending period
TIME_UOM VARCHAR2 (30)
Time unit of measure used for trending
CURRENCY_CODE VARCHAR2 (3)
Currency code
CURRENCY_DATE DATE

Currency conversion date
SECURITY_GROUP_ID NUMBER (15)
Security group identifier

[top of page]

PV.PV_ENTITY_ATTR_TRENDS does not reference any database object

PV.PV_ENTITY_ATTR_TRENDS is referenced by following:

APPS
SYNONYM - PV_ENTITY_ATTR_TRENDS

[top of page]

Table: PV_ENTITY_ROUTINGS

Description: Entity Routings
Primary Key: PV_ENTITY_ROUTINGS_PK1
  1. ENTITY_ROUTING_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ENTITY_ROUTINGS.PROCESS_RULE_ID PV_PROCESS_RULES_B
Comments

PV_ENTITY_ROUTINGS Stores geo proximity and routing information for the entity. Entity is an Opportunity or Partner.

Indexes
Index Type Tablespace Column
PV_ENTITY_ROUTINGS_U1 UNIQUE APPS_TS_TX_IDX ENTITY_ROUTING_ID
PV_ENTITY_ROUTINGS_U2 UNIQUE APPS_TS_TX_IDX PROCESS_RULE_ID
Columns
Name Datatype Length Mandatory Comments
ENTITY_ROUTING_ID NUMBER
Y Entity routing identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER

Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last date this record was updated by a concurrent program
PROCESS_RULE_ID NUMBER
Y Foreign key to pv_process_rules.process_rule_id
DISTANCE_FROM_CUSTOMER NUMBER

Unit of measure for distance_from_customer field.
DISTANCE_UOM_CODE VARCHAR2 (10)
Unit of measure for distance_from_customer field, lookup type = 'PV_DISTANCE_UOM'
MAX_NEAREST_PARTNER NUMBER

Used for Geo Proximity to find out the nearest partners
ROUTING_TYPE VARCHAR2 (30)
Routing type, serial,single or multiple. Lookup type = 'PV_ASSIGNMENT_TYPE'
BYPASS_CM_OK_FLAG VARCHAR2 (1)
Bypass Channel Manager approval. 'Y' to Bypass, Otherwise 'N'.
CM_TIMEOUT NUMBER

Channel manager timeout
CM_TIMEOUT_UOM_CODE VARCHAR2 (10)
The unit of measure applied to cm_timeout. Lookup type = 'PV_TIMEOUT_UOM'
PARTNER_TIMEOUT NUMBER

Partner timeout.
PARTNER_TIMEOUT_UOM_CODE VARCHAR2 (10)
The unit of measure applied to partner_timeout. Lookup type = 'PV_TIMEOUT_UOM'
UNMATCHED_INT_RESOURCE_ID NUMBER

If the opportunity could not find a match, assign this opportunity to an internal resource.
UNMATCHED_CALL_TAP_FLAG VARCHAR2 (5)
If the opportunity could not find a match, call Territory Assignment Program (TAP). 'Y' or 'N'.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
SECURITY_GROUP_ID NUMBER

Security Group Identifier

[top of page]

PV.PV_ENTITY_ROUTINGS does not reference any database object

PV.PV_ENTITY_ROUTINGS is referenced by following:

APPS
SYNONYM - PV_ENTITY_ROUTINGS

[top of page]

Table: PV_ENTITY_RULES_APPLIED

Description: Log table to store the rules applied to select the entity. Entity is an opportunity or partner.
Primary Key: PV_ENTITY_RULES_APPLIED_PK
  1. ENTITY_RULE_APPLIED_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ENTITY_RULES_APPLIED.PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_ENTITY_RULES_APPLIED.PARENT_PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_ENTITY_RULES_APPLIED.PROCESS_RULE_ID %
PV_ENTITY_RULES_APPLIED.PARENT_PROCESS_RULE_ID %
Comments

PV_ENTITY_RULES_APPLIED is used to track the rules that were applied to an entity for reporting purposes

Indexes
Index Type Tablespace Column
PV_ENTITY_RULES_APPLIED_U1 UNIQUE APPS_TS_TX_IDX ENTITY_RULE_APPLIED_ID
PV_ENTITY_RULES_APPLIED_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_PROCESS_RULE_ID
PV_ENTITY_RULES_APPLIED_N2 NONUNIQUE APPS_TS_TX_IDX PROCESS_RULE_ID
PV_ENTITY_RULES_APPLIED_N3 NONUNIQUE APPS_TS_TX_IDX ENTITY_ID
PROCESS_TYPE
CREATION_DATE
Columns
Name Datatype Length Mandatory Comments
ENTITY_RULE_APPLIED_ID NUMBER
Y Entity rule applied identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER

Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last date this record was updated by a concurrent program
ENTITY VARCHAR2 (30) Y Entity type, opportunity or partner. Lookup type = 'PV_RULE_APPLIED_ENTITY_TYPE'
ENTITY_ID NUMBER
Y Entity identifier, lead_id if the entity is 'lead'.
PROCESS_RULE_ID NUMBER

Process Rule Identifier, Foreign key to pv_process_rules.process_rule_id
PARENT_PROCESS_RULE_ID NUMBER

Foreign key to pv_process_rules.parent_process_rule_id
LATEST_FLAG VARCHAR2 (5)
Since this table stores the history information, latest_flag is used to identify whether the current record is the result of the latest run.
ACTION_VALUE VARCHAR2 (15)
This is a denormalized column from pv_process_rules_b.
PROCESS_TYPE VARCHAR2 (30)
This is a denormalized column from pv_process_rules_b, Llookup type = 'PV_PROCESS_TYPE'
WINNING_RULE_FLAG VARCHAR2 (1)
'Y' - to indicate that the current nested rule is the one that won within a parent rule.'N' - otherwise.
PROCESS_STATUS VARCHAR2 (30)
Stores the pass/fail outcome of a process such as lead qualification, lead rating, channel selection for a lead (if fail, process_rule_id will be null). Lookup type = 'PV_RULES_APPLIED_STATUS'
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield structure definition
SECURITY_GROUP_ID NUMBER

Security Group Identifier
ENTITY_DETAIL VARCHAR2 (100)
Entity Details if any

[top of page]

PV.PV_ENTITY_RULES_APPLIED does not reference any database object

PV.PV_ENTITY_RULES_APPLIED is referenced by following:

APPS
SYNONYM - PV_ENTITY_RULES_APPLIED

[top of page]

Table: PV_ENTY_ATTR_TEXTS

Description: Partner attribute information
Primary Key: PV_ENTY_ATTR_TEXTS_PK
  1. PARTY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ENTY_ATTR_TEXTS.PARTY_ID HZ_PARTIES
Comments
Primary Key: PV_ENTY_ATTR_TEXTS_PK
  1. PARTY_ID
Indexes
Index Type Tablespace Column
PV_ENTY_ATTR_TEXTS_U1 UNIQUE APPS_TS_ARCHIVE PARTY_ID
SYS_IL0000108877C00008$$ UNIQUE APPS_TS_ARCHIVE
PV_ENTY_ATTR_TEXTS_U2 NONUNIQUE ATTR_TEXT
Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y
ATTR_TEXT CLOB (4000)
SECURITY_GROUP_ID NUMBER (15)

[top of page]

PV.PV_ENTY_ATTR_TEXTS does not reference any database object

PV.PV_ENTY_ATTR_TEXTS is referenced by following:

APPS
SYNONYM - PV_ENTY_ATTR_TEXTS

[top of page]

Table: PV_ENTY_ATTR_VALIDATIONS

Description: Entity Attributes table column validations
Primary Key: PV_ENTY_ATTR_VALIDATIONS_PK
  1. VALIDATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_ENTY_ATTR_VALUES.VALIDATION_ID PV_ENTY_ATTR_VALIDATIONS
Comments

PV_ENTY_ATTR_VALIDATIONS Stores the validations for PV_ENTY_ATTRS.

Indexes
Index Type Tablespace Column
PV_ENTY_ATTR_VALIDATIONS_U1 UNIQUE APPS_TS_TX_IDX VALIDATION_ID
Columns
Name Datatype Length Mandatory Comments
VALIDATION_ID NUMBER
Y Validation Identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Standard Who column
VALIDATED_BY_RESOURCE_ID NUMBER
Y Resource Identifier Validation
VALIDATION_DOCUMENT_ID NUMBER

Validation document Identifier
VALIDATION_NOTE VARCHAR2 (240)
Note for Validation
VALIDATION_DATE DATE
Y Date of Validation

[top of page]

PV.PV_ENTY_ATTR_VALIDATIONS does not reference any database object

PV.PV_ENTY_ATTR_VALIDATIONS is referenced by following:

APPS
SYNONYM - PV_ENTY_ATTR_VALIDATIONS

[top of page]

Table: PV_ENTY_ATTR_VALUES

Description: Partner attribute values
Primary Key: PV_ENTY_ATTR_VALUES_PK
  1. ENTY_ATTR_VAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ENTY_ATTR_VALUES.ATTRIBUTE_ID PV_ATTRIBUTES_B
PV_ENTY_ATTR_VALUES.ENTITY_ID HZ_PARTIES
PV_ENTY_ATTR_VALUES.ENTITY_ID AS_LEADS_ALL
PV_ENTY_ATTR_VALUES.VALIDATION_ID PV_ENTY_ATTR_VALIDATIONS
Comments

PV_ENTY_ATTR_VALUES stores the transaction level partner lead additional attribute information

Indexes
Index Type Tablespace Column
PV_ENTY_ATTR_VALUES_U1 UNIQUE APPS_TS_TX_IDX ENTY_ATTR_VAL_ID
PV_ENTY_ATTR_VALUES_N1 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
PV_ENTY_ATTR_VALUES_N2 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
PV_ENTY_ATTR_VALUES_N3 NONUNIQUE APPS_TS_TX_IDX ENTITY_ID
ATTRIBUTE_ID
ENTITY
PV_ENTY_ATTR_VALUES_N4 NONUNIQUE APPS_TS_TX_IDX VALIDATION_ID
Columns
Name Datatype Length Mandatory Comments
ENTY_ATTR_VAL_ID NUMBER (15) Y Entity attribute values identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
ENTITY VARCHAR2 (50) Y Entity type
ATTRIBUTE_ID NUMBER (15) Y Attribute identifier
PARTY_ID NUMBER (15)
Party/Partner identifier. Obsolete.
ATTR_VALUE VARCHAR2 (2000)
Partner experties
SCORE VARCHAR2 (30)
Score to measure the partner experties
SECURITY_GROUP_ID NUMBER (15)
Security group identifier
ENABLED_FLAG VARCHAR2 (1) Y Flag indicates whether the partner attribute values are enabled or not
ENTITY_ID NUMBER (15) Y Could be either partner or lead depends on the entity type
VERSION NUMBER

Versions
LATEST_FLAG VARCHAR2 (1)
Y, if the value is Latest
ATTR_VALUE_EXTN VARCHAR2 (4000)
Attribute Value Extensions if any
VALIDATION_ID NUMBER

Validation Identifier from PV_ENTY_ATTR_VALIDATIONS

[top of page]

PV.PV_ENTY_ATTR_VALUES does not reference any database object

PV.PV_ENTY_ATTR_VALUES is referenced by following:

APPS
SYNONYM - PV_ENTY_ATTR_VALUES

[top of page]

Table: PV_ENTY_SELECT_CRITERIA

Description: Entity selection criteria
Primary Key: PV_ENTY_SELECT_CRITERIA_PK
  1. SELECTION_CRITERIA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ENTY_SELECT_CRITERIA.PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_ENTY_SELECT_CRITERIA.ATTRIBUTE_ID PV_ATTRIBUTES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_SELECTED_ATTR_VALUES.SELECTION_CRITERIA_ID PV_ENTY_SELECT_CRITERIA
Comments

PV_ENTY_SELECT_CRITERIA Stores the attributes (conditions) of a rule or a nested rule. Tie-breaking information for a rule is also stored here.

Indexes
Index Type Tablespace Column
PV_ENTY_SELECT_CRITERIA_U1 UNIQUE APPS_TS_TX_IDX SELECTION_CRITERIA_ID
PV_ENTY_SELECT_CRITERIA_N1 NONUNIQUE APPS_TS_TX_IDX PROCESS_RULE_ID
PV_ENTY_SELECT_CRITERIA_N2 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
Columns
Name Datatype Length Mandatory Comments
SELECTION_CRITERIA_ID NUMBER
Y Selection Criteria Identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER

Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last date this record was updated by a concurrent program
PROCESS_RULE_ID NUMBER
Y Foreign key to pv_process_rules.process_rule_id
ATTRIBUTE_ID NUMBER
Y Attribute Identifier, Foreign key to pv_attributes_vl.attrribute_id
SELECTION_TYPE_CODE VARCHAR2 (30) Y Selection Type, criterian or input filter. Lookup type = 'PV_SELECTION_TYPE_CODE'
OPERATOR VARCHAR2 (30) Y If the attribute is of VARCHAR2 type:lookup type = 'PV_TEXT_OPERATOR ' If the attribute is of NUMBER or DATE type:lookup type = 'PV_NUM_DATE_OPERATOR'. The value are equal, not equal ..
RANK NUMBER

Used by tie breaker. The rank of this attribute when used for tie breaking. A higher ranked attribute will be used first to break a tie.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield structure definition
SECURITY_GROUP_ID NUMBER

Security Group Identifier

[top of page]

PV.PV_ENTY_SELECT_CRITERIA does not reference any database object

PV.PV_ENTY_SELECT_CRITERIA is referenced by following:

APPS
SYNONYM - PV_ENTY_SELECT_CRITERIA

[top of page]

Table: PV_GE_BENEFITS_B

Description: Benfits and its status
Primary Key: PV_GE_BENEFITS_B_PK
  1. BENEFIT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_BENFT_BUDGETS.BENEFIT_ID PV_GE_BENEFITS_B
PV_REFERRALS_B.BENEFIT_ID PV_GE_BENEFITS_B
PV_GE_BENEFITS_TL.BENEFIT_ID PV_GE_BENEFITS_B
PV_PROGRAM_BENEFITS.BENEFIT_ID PV_GE_BENEFITS_B
PV_BENFT_THRESHOLDS.BENEFIT_ID PV_GE_BENEFITS_B
PV_BENFT_PRODUCTS.BENEFIT_ID PV_GE_BENEFITS_B
Comments

PV_GE_BENEFITS_B stores the benefit details that will be available to be assigned to a program

Indexes
Index Type Tablespace Column
PV_GE_BENEFITS_B_U1 UNIQUE APPS_TS_SEED BENEFIT_ID
PV_GE_BENEFITS_B_N1 NONUNIQUE APPS_TS_SEED BENEFIT_TYPE_CODE
PV_GE_BENEFITS_B_N2 NONUNIQUE APPS_TS_SEED ADDITIONAL_INFO_1
Columns
Name Datatype Length Mandatory Comments
BENEFIT_ID NUMBER
Y Benefit Id
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
BENEFIT_TYPE_CODE VARCHAR2 (30) Y Benefit Type Code
BENEFIT_STATUS_CODE VARCHAR2 (30) Y Benefit Status Code
BENEFIT_CODE VARCHAR2 (30)
Benefit Code
DELETE_FLAG VARCHAR2 (1) Y Delete Flag
ADDITIONAL_INFO_1 NUMBER (15)
Additional Information 1
ADDITIONAL_INFO_2 VARCHAR2 (240)
Additional Information 2
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Attribute category
ATTRIBUTE1 VARCHAR2 (240)
Attribute1
ATTRIBUTE2 VARCHAR2 (240)
Attribute2
ATTRIBUTE3 VARCHAR2 (240)
Attribute3
ATTRIBUTE4 VARCHAR2 (240)
Attribute4
ATTRIBUTE5 VARCHAR2 (240)
Attribute5
ATTRIBUTE6 VARCHAR2 (240)
Attribute6
ATTRIBUTE7 VARCHAR2 (240)
Attribute7
ATTRIBUTE8 VARCHAR2 (240)
Attribute8
ATTRIBUTE9 VARCHAR2 (240)
Attribute9
ATTRIBUTE10 VARCHAR2 (240)
Attribute10
ATTRIBUTE11 VARCHAR2 (240)
Attribute11
ATTRIBUTE12 VARCHAR2 (240)
Attribute12
ATTRIBUTE13 VARCHAR2 (240)
Attribute13
ATTRIBUTE14 VARCHAR2 (240)
Attribute14
ATTRIBUTE15 VARCHAR2 (240)
Attribute15

[top of page]

PV.PV_GE_BENEFITS_B does not reference any database object

PV.PV_GE_BENEFITS_B is referenced by following:

APPS
SYNONYM - PV_GE_BENEFITS_B

[top of page]

Table: PV_GE_BENEFITS_TL

Description: Translation table for Benefits
Primary Key: PV_GE_BENEFITS_TL_PK
  1. BENEFIT_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_BENEFITS_TL.BENEFIT_ID PV_GE_BENEFITS_B
Comments

Translation table for PV_GE_BENEFITS_TL

Indexes
Index Type Tablespace Column
PV_GE_BENEFITS_TL_U1 UNIQUE APPS_TS_TX_IDX BENEFIT_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
BENEFIT_ID NUMBER
Y Benefit Id
LANGUAGE VARCHAR2 (4) Y Language being translated to.
BENEFIT_NAME VARCHAR2 (2000)
Benefit Name
DESCRIPTION VARCHAR2 (2000)
Description of the benefit
SOURCE_LANG VARCHAR2 (4) Y Source Language.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_GE_BENEFITS_TL does not reference any database object

PV.PV_GE_BENEFITS_TL is referenced by following:

APPS
SYNONYM - PV_GE_BENEFITS_TL

[top of page]

Table: PV_GE_CHKLST_ITEMS_B

Description: Container for Task Items that needs to be checked.
Primary Key: PV_GE_CHKLST_ITEMS_B_PK
  1. CHECKLIST_ITEM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_CHKLST_ITEMS_B.USED_BY_ENTITY_ID PV_PARTNER_PROGRAM_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_GE_CHKLST_ITEMS_TL.CHECKLIST_ITEM_ID PV_GE_CHKLST_ITEMS_B
PV_GE_CHKLST_RESPONSES.CHECKLIST_ITEM_ID PV_GE_CHKLST_ITEMS_B
Comments

PV_GE_CHKLST_ITEMS_B is PRM's one of the Global Entitiy tables. It stores details of different check list items(tasks) that needs to be checked for an entity before it can be approved.
Programs entity uses this table to capture the details of tasks that need to be checked by an approver before approving the partner's enrollment request into a specific program.
ARC_USED_BY_ENTITY_CODE stores the entity code, and USED_BY_ENTITY_ID stores the entity identifier.

Indexes
Index Type Tablespace Column
PV_GE_CHKLST_ITEMS_B_U1 UNIQUE APPS_TS_TX_IDX CHECKLIST_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
CHECKLIST_ITEM_ID NUMBER
Y Unique Identifier
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
ARC_USED_BY_ENTITY_CODE VARCHAR2 (30) Y Entity code for which cheklists needs to be checked - Lookup
USED_BY_ENTITY_ID NUMBER
Y Entity Id for which checklist items need to be checked - Foreign key.
SEQUENCE_NUM NUMBER
Y Checklist Item sequence number
IS_REQUIRED_FLAG VARCHAR2 (1) Y Is this checklist item mandatory for processing
ENABLED_FLAG VARCHAR2 (1) Y Whether checklist item is enabled or not
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Attribute category
ATTRIBUTE1 VARCHAR2 (240)
Attribute1
ATTRIBUTE2 VARCHAR2 (240)
Attribute2
ATTRIBUTE3 VARCHAR2 (240)
Attribute3
ATTRIBUTE4 VARCHAR2 (240)
Attribute4
ATTRIBUTE5 VARCHAR2 (240)
Attribute5
ATTRIBUTE6 VARCHAR2 (240)
Attribute6
ATTRIBUTE7 VARCHAR2 (240)
Attribute7
ATTRIBUTE8 VARCHAR2 (240)
Attribute8
ATTRIBUTE9 VARCHAR2 (240)
Attribute9
ATTRIBUTE10 VARCHAR2 (240)
Attribute10
ATTRIBUTE11 VARCHAR2 (240)
Attribute11
ATTRIBUTE12 VARCHAR2 (240)
Attribute12
ATTRIBUTE13 VARCHAR2 (240)
Attribute13
ATTRIBUTE14 VARCHAR2 (240)
Attribute14
ATTRIBUTE15 VARCHAR2 (240)
Attribute15

[top of page]

PV.PV_GE_CHKLST_ITEMS_B does not reference any database object

PV.PV_GE_CHKLST_ITEMS_B is referenced by following:

APPS
SYNONYM - PV_GE_CHKLST_ITEMS_B

[top of page]

Table: PV_GE_CHKLST_ITEMS_TL

Description: Captures the translateable data for Check list items.
Primary Key: PV_GE_CHKLST_ITEMS_TL_PK
  1. CHECKLIST_ITEM_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_CHKLST_ITEMS_TL.CHECKLIST_ITEM_ID PV_GE_CHKLST_ITEMS_B
Comments

PV_GE_CHKLST_ITEMS_TL captures the translatable data for checklist items.

Indexes
Index Type Tablespace Column
PV_GE_CHKLST_ITEMS_TL_U1 UNIQUE APPS_TS_TX_IDX CHECKLIST_ITEM_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
CHECKLIST_ITEM_ID NUMBER
Y Foreign key to Checklist Item Id for which translatable data is being collected
LANGUAGE VARCHAR2 (4) Y Language being translated to.
CHECKLIST_ITEM_NAME VARCHAR2 (2000) Y Checklist Item Name that needs to be checked.
SOURCE_LANG VARCHAR2 (4) Y Source Language.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_GE_CHKLST_ITEMS_TL does not reference any database object

PV.PV_GE_CHKLST_ITEMS_TL is referenced by following:

APPS
SYNONYM - PV_GE_CHKLST_ITEMS_TL

[top of page]

Table: PV_GE_CHKLST_RESPONSES

Description: Container for responses to checklist items.
Primary Key: PV_GE_CHKLST_RESPONSES_PK
  1. CHKLST_RESPONSE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_CHKLST_RESPONSES.CHECKLIST_ITEM_ID PV_GE_CHKLST_ITEMS_B
PV_GE_CHKLST_RESPONSES.RESPONSE_FOR_ENTITY_ID PV_PG_ENRL_REQUESTS
Comments

PV_GE_CHKLST_RESPONSES is PRM's one of the Global Entitiy tables. It stores the responses for a given check list item in the context of a given entity.
Enrollment Requests entity uses this table to catpure the responses for different checklist items that needs to be checked bofoer approving the partner's enrollment request.
ARC_USED_BY_ENTITY_CODE stores the entity code for which checklist items are reviewed, and USED_BY_ENTITY_ID stores the entity identifier, and CHECKLIST_ITEM_ID stores the check list for which response is collected.

Indexes
Index Type Tablespace Column
PV_GE_CHKLST_RESPONSES_U1 UNIQUE APPS_TS_TX_IDX CHKLST_RESPONSE_ID
PV_GE_CHKLST_RESPONSES_U2 UNIQUE APPS_TS_TX_IDX ARC_RESPONSE_FOR_ENTITY_CODE
RESPONSE_FOR_ENTITY_ID
CHECKLIST_ITEM_ID
PV_GE_CHKLST_RESPONSES_N1 NONUNIQUE APPS_TS_TX_IDX CHECKLIST_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
CHKLST_RESPONSE_ID NUMBER
Y Unique Identifier
CHECKLIST_ITEM_ID NUMBER
Y Foreign key to Checklist Item Id for which responses are collected
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
ARC_RESPONSE_FOR_ENTITY_CODE VARCHAR2 (30) Y Entity Code in whose context cheklist response are collected - Lookup
RESPONSE_FLAG VARCHAR2 (1) Y Checklist checking response
RESPONSE_FOR_ENTITY_ID NUMBER
Y Entity Id in whcih context checklist responses are collected - Foreign key
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_GE_CHKLST_RESPONSES does not reference any database object

PV.PV_GE_CHKLST_RESPONSES is referenced by following:

APPS
SYNONYM - PV_GE_CHKLST_RESPONSES

[top of page]

Table: PV_GE_HISTORY_LOG_B

Description: Captures the transaction history log for a given entity.
Primary Key: PV_GE_HISTORY_LOG_B_PK
  1. ENTITY_HISTORY_LOG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_HISTORY_LOG_B.HISTORY_FOR_ENTITY_ID PV_PG_ENRL_REQUESTS
PV_GE_HISTORY_LOG_B.HISTORY_FOR_ENTITY_ID PV_PARTNER_PROGRAM_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_GE_HISTORY_LOG_PARAMS.ENTITY_HISTORY_LOG_ID PV_GE_HISTORY_LOG_B
PV_GE_HISTORY_LOG_TL.ENTITY_HISTORY_LOG_ID PV_GE_HISTORY_LOG_B
Comments

PV_GE_HISTORY_LOG_B is PRM's one of the Global Entitiy tables. It stores transaction history log details of an entity when that entity progresses.
Enrollment Request entity uses this table to log history of various transactions that happened with the enrollment request.
In order to have language translatability, MESSAGE_CODE is captured, which has the detailed log message for the transaction in FND message related table.
ARC_HISTORY_FOR_ENTITY_CODE stores the entity code, and HISTORY_FOR_ENTITY_ID stores the entity identifier.
HISTORY_CATEGORY_CODE categorizes the different type of history transactions.

Indexes
Index Type Tablespace Column
PV_GE_HISTORY_LOG_B_U1 UNIQUE APPS_TS_TX_IDX ENTITY_HISTORY_LOG_ID
PV_GE_HISTORY_LOG_B_N1 NONUNIQUE APPS_TS_TX_IDX PARTNER_ID
ARC_HISTORY_FOR_ENTITY_CODE
HISTORY_FOR_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
ENTITY_HISTORY_LOG_ID NUMBER
Y Unique Identifier
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
ARC_HISTORY_FOR_ENTITY_CODE VARCHAR2 (30) Y Entity Code for which history transaction is being logged - Lookup
HISTORY_FOR_ENTITY_ID NUMBER
Y Entity Id for which history transaction is being logged - Foreign key
MESSAGE_CODE VARCHAR2 (30) Y Foreign key to MESSAGE_CODE, which details the transaction history log
HISTORY_CATEGORY_CODE VARCHAR2 (30)
History Category Code to categorize the different types of log messages - Lookup
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
PARTNER_ID NUMBER
Y Partner ID for which history transaction is being logged - Foreign key
ACCESS_LEVEL_FLAG VARCHAR2 (1) Y The level of who has the access to see the corresponding log.
INTERACTION_LEVEL NUMBER
Y The level to distinguish the importance of a log.

[top of page]

PV.PV_GE_HISTORY_LOG_B does not reference any database object

PV.PV_GE_HISTORY_LOG_B is referenced by following:

APPS
SYNONYM - PV_GE_HISTORY_LOG_B

[top of page]

Table: PV_GE_HISTORY_LOG_PARAMS

Description: Container for token parameters of history log transaction.
Primary Key: PV_GE_HISTORY_LOG_PARAMS_PK
  1. HISTORY_LOG_PARAM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_HISTORY_LOG_PARAMS.ENTITY_HISTORY_LOG_ID PV_GE_HISTORY_LOG_B
Comments

PV_GE_HISTORY_LOG_PARAMS is PRM's one of the Global Entitiy tables. It stores values for token parameters that are required for some message_codes in PV_GE_HISTORY_LOG.

Indexes
Index Type Tablespace Column
PV_GE_HISTORY_LOG_PARAMS_U1 UNIQUE APPS_TS_TX_IDX HISTORY_LOG_PARAM_ID
PV_GE_HISTORY_LOG_PARAMS_U2 UNIQUE APPS_TS_TX_IDX ENTITY_HISTORY_LOG_ID
PARAM_NAME
Columns
Name Datatype Length Mandatory Comments
HISTORY_LOG_PARAM_ID NUMBER
Y Unique Identifier
ENTITY_HISTORY_LOG_ID NUMBER
Y Foreign key to History Log Id for which token parameters are recorded.
PARAM_NAME VARCHAR2 (30) Y Token parameter name in the message of history log id
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
PARAM_VALUE VARCHAR2 (2000)
Token parameter value in the message of history log id
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
LOOKUP_TYPE VARCHAR2 (30)
If Param_type column is LOOKUP, This column stores the LOOKUP_TYPE
PARAM_TYPE VARCHAR2 (30)
Stores the type of the message parameter.

[top of page]

PV.PV_GE_HISTORY_LOG_PARAMS does not reference any database object

PV.PV_GE_HISTORY_LOG_PARAMS is referenced by following:

APPS
SYNONYM - PV_GE_HISTORY_LOG_PARAMS

[top of page]

Table: PV_GE_HISTORY_LOG_TL

Description: Captures the translateable comments information for history log.
Primary Key: PV_GE_HISTORY_LOG_TL_PK
  1. ENTITY_HISTORY_LOG_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_HISTORY_LOG_TL.ENTITY_HISTORY_LOG_ID PV_GE_HISTORY_LOG_B
Comments

PV_GE_HISTORY_LOG_TL captures the translatable data for history log transactions.

Indexes
Index Type Tablespace Column
PV_GE_HISTORY_LOG_TL_U1 UNIQUE APPS_TS_TX_IDX ENTITY_HISTORY_LOG_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
ENTITY_HISTORY_LOG_ID NUMBER
Y Foreign key to Entity History Log Id for which translated data is being collected.
LANGUAGE VARCHAR2 (4) Y Language being translated to
COMMENTS VARCHAR2 (2000)
Comments that are entered by user
SOURCE_LANG VARCHAR2 (4) Y Source Language
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_GE_HISTORY_LOG_TL does not reference any database object

PV.PV_GE_HISTORY_LOG_TL is referenced by following:

APPS
SYNONYM - PV_GE_HISTORY_LOG_TL

[top of page]

Table: PV_GE_NOTIF_RULES_B

Description: Captures the notification rules for a given entity.
Primary Key: PV_GE_NOTIF_RULES_PK
  1. NOTIF_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_NOTIF_RULES_B.NOTIF_FOR_ENTITY_ID PV_PARTNER_PROGRAM_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_GE_NOTIF_RULES_TL.NOTIF_RULE_ID PV_GE_NOTIF_RULES_B
Comments

PV_GE_NOTIF_RULES_B is PRM's one of the Global Entitiy tables. It stores details of rules for sending different types of notifications for a given entity.
Programs entity uses this table to capture the details of rules for sending notifications for a given program in the enrollment process, viz.
Thank you Notification after submitting the enrollment application,
Welcome/Rejection Notification after partner's enrollment request is approved/rejcted,
Membership expiry Notification when the membership is due for renewal,
Contract not recieved Notification when the contract is yet to be received by partner for a given enrollment application.

NOTIF_FOR_ENTITY_CODE stores the entity code, and NOTIF_FOR_ENTITY_ID stores the entity identifier.
NOTIF_TYPE_CODE identifies the type of notification, like Welcome, Thank You, etc. WF_ITEM_TYPE_CODE identifies the workflow item type that will be activated for that notification.

Indexes
Index Type Tablespace Column
PV_GE_NOTIF_RULES_B_N1 NONUNIQUE APPS_TS_TX_IDX NOTIF_FOR_ENTITY_ID
ARC_NOTIF_FOR_ENTITY_CODE
PV_GE_NOTIF_RULES_B_N2 NONUNIQUE APPS_TS_TX_IDX WF_ITEM_TYPE_CODE
PV_GE_NOTIF_RULES_B_U1 NONUNIQUE APPS_TS_TX_IDX NOTIF_RULE_ID
Columns
Name Datatype Length Mandatory Comments
NOTIF_RULE_ID NUMBER
Y Unique Identifier
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
ARC_NOTIF_FOR_ENTITY_CODE VARCHAR2 (30) Y Entity Code for which notification rules are being created - lookup
NOTIF_FOR_ENTITY_ID NUMBER
Y Entity Id for which notification rules are being created - Foreign key
WF_ITEM_TYPE_CODE VARCHAR2 (30)
Workflow Item Type Code
NOTIF_TYPE_CODE VARCHAR2 (30) Y Notification Type Code - Welcome/ThankYou/Contract Not Received/Expiry
ACTIVE_FLAG VARCHAR2 (1) Y Whether rule is active
REPEAT_FREQ_UNIT VARCHAR2 (30)
Repeat Frequency Unit that will be used with Repeat Frequency Value to determine at which frequency notifications will be sent repeatively - Days/Months/Years - Lookup
REPEAT_FREQ_VALUE NUMBER

Repeat Frequency Value that will be used with Repeat Frequency Unit to determine at which frequency notifications will be sent repeatively
SEND_NOTIF_BEFORE_UNIT VARCHAR2 (30)
Send Notif Before Unit will be used along with Send Notif Before Value to determine how much before of an event, sending notifications will be started - Days/Months/Year - Lookup
REPEAT_UNTIL_VALUE NUMBER

Repeat Until Value will be used along with Repeat Until Unit to determine until how long the notifications will be repeated
SEND_NOTIF_AFTER_UNIT VARCHAR2 (30)
Send Notif After Unit will be used along with Send Notif After Value to determine how much after of an event, sending notifications will be started - Days/Months/Year - Lookup
SEND_NOTIF_AFTER_VALUE NUMBER

Send Notif After Value will be used along with Send Notif After Unit to determine how much after of an event, sending notifications will be started
REPEAT_UNTIL_UNIT VARCHAR2 (30)
Repeat Until Unit will be used along with Repeat Until Value to determine until how long the notifications will be repeated - Days/Months/Year - Lookup
SEND_NOTIF_BEFORE_VALUE NUMBER

Send Notif Before Value will be used along with Send Notif Before Unit to determine how much before of an event, sending notifications will be started
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_GE_NOTIF_RULES_B does not reference any database object

PV.PV_GE_NOTIF_RULES_B is referenced by following:

APPS
SYNONYM - PV_GE_NOTIF_RULES_B

[top of page]

Table: PV_GE_NOTIF_RULES_TL

Description: Captures the translateable information for notification rules.
Primary Key: PV_GE_NOTIF_RULES_TL_PK
  1. NOTIF_RULE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_NOTIF_RULES_TL.NOTIF_RULE_ID PV_GE_NOTIF_RULES_B
Comments

PV_GE_NOTIF_RULES_TL captures the translatable data for notification rules.

Indexes
Index Type Tablespace Column
PV_GE_NOTIF_RULES_TL_N1 NONUNIQUE APPS_TS_TX_IDX NOTIF_NAME
PV_GE_NOTIF_RULES_TL_U1 NONUNIQUE APPS_TS_TX_IDX NOTIF_RULE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
NOTIF_RULE_ID NUMBER
Y Foreign key to Notification Rule Id, for which translatation data is being collected
LANGUAGE VARCHAR2 (4) Y Language translated to
NOTIF_NAME VARCHAR2 (240) Y Notification Rule Name
NOTIF_CONTENT VARCHAR2 (2000) Y Notification Content
NOTIF_DESC VARCHAR2 (2000)
Description for Notification
SOURCE_LANG VARCHAR2 (4) Y Source Language.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_GE_NOTIF_RULES_TL does not reference any database object

PV.PV_GE_NOTIF_RULES_TL is referenced by following:

APPS
SYNONYM - PV_GE_NOTIF_RULES_TL

[top of page]

Table: PV_GE_PARTY_NOTIFICATIONS

Description: Container for notification details sent to a given partner.
Primary Key: PV_GE_PARTY_NOTIFICATIONS_PK
  1. PARTY_NOTIFICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_PARTY_NOTIFICATIONS.NOTIF_FOR_ENTITY_ID PV_PG_INVITE_HEADERS_B
PV_GE_PARTY_NOTIFICATIONS.NOTIF_FOR_ENTITY_ID PV_PG_ENRL_REQUESTS
PV_GE_PARTY_NOTIFICATIONS.RECIPIENT_USER_ID FND_USER
PV_GE_PARTY_NOTIFICATIONS.PARTNER_ID HZ_PARTIES
PV_GE_PARTY_NOTIFICATIONS.NOTIF_FOR_ENTITY_ID PV_PG_MEMBERSHIPS
PV_GE_PARTY_NOTIFICATIONS.NOTIF_FOR_ENTITY_ID %
Comments

PV_GE_PARTY_NOTIFICATIONS is PRM's one of the Global Entitiy tables. It stores details of notifications that are sent to a given partner in the context of a given entity.
Programs entity uses this table to capture the details of various notifications sent to a given partner in the program enrollment process.
ARC_NOTIF_FOR_ENTITY_CODE stores the entity code, and NOTIF_FOR_ENTITY_ID stores the entity identifier.
NOTIF_TYPE_CODE identifies the type of notification, like Welcome, Thank You, etc.

Indexes
Index Type Tablespace Column
PV_GE_PARTY_NOTIFICATIONS_U2 UNIQUE APPS_TS_TX_IDX NOTIFICATION_ID
RECIPIENT_USER_ID
PV_GE_PARTY_NOTFICATIONS_N1 NONUNIQUE APPS_TS_TX_IDX PARTNER_ID
PV_GE_PARTY_NOTIFICATIONS_N2 NONUNIQUE APPS_TS_TX_IDX ARC_NOTIF_FOR_ENTITY_CODE
NOTIF_FOR_ENTITY_ID
PV_GE_PARTY_NOTIFICATIONS_U1 NONUNIQUE APPS_TS_TX_IDX PARTY_NOTIFICATION_ID
Columns
Name Datatype Length Mandatory Comments
PARTY_NOTIFICATION_ID NUMBER
Y Unique Identifier
NOTIFICATION_ID NUMBER
Y Foreign key to worklfow notification id
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
PARTNER_ID NUMBER

Foreign to Partner Relationship Organization Id to which notification is sent
RECIPIENT_USER_ID NUMBER
Y User Id who received the notfication
NOTIF_FOR_ENTITY_ID NUMBER
Y Entity Code in whose context notification is being sent - Lookup
ARC_NOTIF_FOR_ENTITY_CODE VARCHAR2 (30)
Entify id in whose context notification is being sent - Foreign key
NOTIF_TYPE_CODE VARCHAR2 (30)
Notification Type - Lookup
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_GE_PARTY_NOTIFICATIONS does not reference any database object

PV.PV_GE_PARTY_NOTIFICATIONS is referenced by following:

APPS
SYNONYM - PV_GE_PARTY_NOTIFICATIONS

[top of page]

Table: PV_GE_PTNR_RESPS

Description: This table is used for storing partner responsibility mappings.
Primary Key: PV_GE_PTNR_RESPS_PK
  1. PTNR_RESP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_PTNR_RESPS.SOURCE_RESP_MAP_RULE_ID PV_GE_RESP_MAP_RULES
PV_GE_PTNR_RESPS.SOURCE_RESP_MAP_RULE_ID PV_PROGRAM_BENEFITS
PV_GE_PTNR_RESPS.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_GE_PTNR_RESPS.PARTNER_ID HZ_PARTIES
PV_GE_PTNR_RESPS.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_GE_PTNR_RESPS.SOURCE_RESP_MAP_RULE_ID PV_GE_RESP_MAP_RULES
Comments

PV_GE_PTNR_RESPS is PRM's one of the Global Entitiy tables. It stores partner responsibility mappings.
This table is like a cache table. It will maintain all the program and iStore responsibilities that we are assigning to any partner.

Indexes
Index Type Tablespace Column
PV_GE_PTNR_RESPS_U1 UNIQUE APPS_TS_TX_IDX PTNR_RESP_ID
PV_GE_PTNR_RESPS_U2 UNIQUE APPS_TS_TX_IDX RESP_TYPE_CODE
PARTNER_ID
PROGRAM_ID
USER_ROLE_CODE
RESPONSIBILITY_ID
SOURCE_RESP_MAP_RULE_ID
PV_GE_PTNR_RESPS_N1 NONUNIQUE APPS_TS_TX_IDX PARTNER_ID
USER_ROLE_CODE
PV_GE_PTNR_RESPS_N2 NONUNIQUE APPS_TS_TX_IDX SOURCE_RESP_MAP_RULE_ID
RESP_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
PTNR_RESP_ID NUMBER
Y Unique Identifier
OBJECT_VERSION_NUMBER NUMBER (9) Y object version number
PARTNER_ID NUMBER
Y partner id
USER_ROLE_CODE VARCHAR2 (30) Y The user role code. Either PRIMARY or BUSINESS.
PROGRAM_ID NUMBER

Program ID
RESPONSIBILITY_ID NUMBER
Y Responsibility ID.
SOURCE_RESP_MAP_RULE_ID NUMBER
Y Source Responsibility Map Rule ID. Forien key of PV_GE_RESP_MAP_RULES
RESP_TYPE_CODE VARCHAR2 (30) Y Responsibility type code. Either PROGRAMS or STORES.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_GE_PTNR_RESPS does not reference any database object

PV.PV_GE_PTNR_RESPS is referenced by following:

APPS
SYNONYM - PV_GE_PTNR_RESPS

[top of page]

Table: PV_GE_QSNR_ELEMENTS_B

Description: Container for questionnaire element details.
Primary Key: PV_GE_QSNR_ELEMENTS_B_PK
  1. QSNR_ELEMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_QSNR_ELEMENTS_B.USED_BY_ENTITY_ID PV_REFERRALS_B
PV_GE_QSNR_ELEMENTS_B.ENTITY_ATTR_ID PV_ENTITY_ATTRS
PV_GE_QSNR_ELEMENTS_B.USED_BY_ENTITY_ID PV_PARTNER_PROGRAM_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_GE_QSNR_ELEMENTS_TL.QSNR_ELEMENT_ID PV_GE_QSNR_ELEMENTS_B
Comments

PV_GE_QSNR_ELEMENTS_B is PRM's one of the Global Entitiy tables. It stores details of questionnaire information that needs to be collected for a given enitity's processing.
Programs entity uses this table to capture the questionnaire information that needs to be answered by partner user while submitting the enrollment application into a given program.
ARC_USED_BY_ENTITY_CODE stores the entity code, and USED_BY_ENTITY_ID stores the entity identifier.
It also captures the information about UI display of the question - in which section, in which page, and in which sequence question needs to be shown to the user.

Indexes
Index Type Tablespace Column
PV_GE_QSNR_ELEMENTS_B_U1 UNIQUE APPS_TS_TX_IDX QSNR_ELEMENT_ID
PV_GE_QSNR_ELEMENTS_B_N1 NONUNIQUE APPS_TS_TX_IDX ARC_USED_BY_ENTITY_CODE
USED_BY_ENTITY_ID
PV_GE_QSNR_ELEMENTS_N2 NONUNIQUE APPS_TS_TX_IDX QSNR_ELMT_TYPE
QSNR_ELMT_SEQ_NUM
Columns
Name Datatype Length Mandatory Comments
QSNR_ELEMENT_ID NUMBER
Y Unique identifier for the Questionnaire Element
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
ARC_USED_BY_ENTITY_CODE VARCHAR2 (30) Y The entity associates with this questionnaire element
USED_BY_ENTITY_ID NUMBER
Y The entity id associates with this questionnaire element
QSNR_ELMT_SEQ_NUM NUMBER (9) Y Questionnaire element sequence number
QSNR_ELMT_TYPE VARCHAR2 (30) Y Questionnaire element type (PAGEBREAK, SECTION, or QUESTION)
ENTITY_ATTR_ID NUMBER

Entity attribute id of this questionnaire element
QSNR_ELMT_PAGE_NUM NUMBER (9) Y Indicate this element is located in which page
IS_REQUIRED_FLAG VARCHAR2 (1) Y Hold information about whether the answer of this question is required or not
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_GE_QSNR_ELEMENTS_B does not reference any database object

PV.PV_GE_QSNR_ELEMENTS_B is referenced by following:

APPS
SYNONYM - PV_GE_QSNR_ELEMENTS_B

[top of page]

Table: PV_GE_QSNR_ELEMENTS_TL

Description: Captures the translateable information for questionnaire elements.
Primary Key: PV_GE_QSNR_ELEMENTS_TL_PK
  1. QSNR_ELEMENT_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_QSNR_ELEMENTS_TL.QSNR_ELEMENT_ID PV_GE_QSNR_ELEMENTS_B
Comments

PV_GE_QSNR_ELEMENTS_TL captures the translatable data for questionnaire elements.

Indexes
Index Type Tablespace Column
PV_GE_QSNR_ELEMENTS_TL_U1 UNIQUE APPS_TS_TX_IDX LANGUAGE
QSNR_ELEMENT_ID
Columns
Name Datatype Length Mandatory Comments
QSNR_ELEMENT_ID NUMBER
Y Unique identifier for the Questionnaire Element
LANGUAGE VARCHAR2 (4) Y Language of the translated record.The language the text columns will mirror to. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
ELMT_CONTENT VARCHAR2 (2000)
The content of questions or sections. For example, "What was your company's total gross revenue?"
SOURCE_LANG VARCHAR2 (4) Y The source language of the record.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_GE_QSNR_ELEMENTS_TL does not reference any database object

PV.PV_GE_QSNR_ELEMENTS_TL is referenced by following:

APPS
SYNONYM - PV_GE_QSNR_ELEMENTS_TL

[top of page]

Table: PV_GE_RESP_MAP_RULES

Description: Table for responsibility mapping rules
Primary Key: PV_GE_RESP_MAP_RULES_PK
  1. RESP_MAP_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_RESP_MAP_RULES.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_GE_RESP_MAP_RULES.PROGRAM_ID PV_PARTNER_PROGRAM_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_GE_PTNR_RESPS.SOURCE_RESP_MAP_RULE_ID PV_GE_RESP_MAP_RULES
PV_GE_PTNR_RESPS.SOURCE_RESP_MAP_RULE_ID PV_GE_RESP_MAP_RULES
Comments

Table for responsibility mapping rules

Indexes
Index Type Tablespace Column
PV_GE_RESP_MAP_RULES_U1 UNIQUE APPS_TS_TX_IDX RESP_MAP_RULE_ID
Columns
Name Datatype Length Mandatory Comments
RESP_MAP_RULE_ID NUMBER
Y Responsibility Mapping Rule Id
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
PROGRAM_ID NUMBER

Program Id
GEO_HIERARCHY_ID NUMBER
Y Geography Hierarchy Id
USER_ROLE_CODE VARCHAR2 (30) Y User Role Code
RESPONSIBILITY_ID NUMBER
Y Responsibility Id
DELETE_FLAG VARCHAR2 (1) Y Delete Flag
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_GE_RESP_MAP_RULES does not reference any database object

PV.PV_GE_RESP_MAP_RULES is referenced by following:

APPS
SYNONYM - PV_GE_RESP_MAP_RULES

[top of page]

Table: PV_GE_TEMP_APPROVERS

Description: Container for approver related information for a given entity.
Primary Key: PV_GE_TEMP_APPROVERS_PK
  1. ENTITY_APPROVER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_GE_TEMP_APPROVERS.APPROVER_ID FND_USER
PV_GE_TEMP_APPROVERS.APPR_FOR_ENTITY_ID PV_PG_ENRL_REQUESTS
Comments

PV_GE_TEMP_APPROVERS is PRM's one of the Global Entitiy tables. It stores details of approver who needs to approve a given entity, when AME product is used for approval processing. It contains TEMP word because it stores the inermediate approver details temporarily, and only the final approver details are persistent.
Enrollment requests entity uses this table to capture the approver details, which are returned from AME after determining as per approval rules.
ARC_APPR_FOR_ENTITY_CODE stores the entity code, and APPR_FOR_ENTITY_ID stores the entity identifier.
Approver can be of different types - Person, User, or Resource. APPROVER_TYPE_CODE determines this, and APPROVER_ID would be person_id, user_id or resource_id respectively.

Indexes
Index Type Tablespace Column
PV_GE_TEMP_APPROVERS_U1 UNIQUE APPS_TS_TX_IDX ENTITY_APPROVER_ID
PV_GE_TEMP_APPROVERS_N1 NONUNIQUE APPS_TS_TX_IDX ARC_APPR_FOR_ENTITY_CODE
APPR_FOR_ENTITY_ID
APPROVER_ID
Columns
Name Datatype Length Mandatory Comments
ENTITY_APPROVER_ID NUMBER
Y Unique Identifier
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
ARC_APPR_FOR_ENTITY_CODE VARCHAR2 (30) Y Entity code which needs approval - lookup
APPR_FOR_ENTITY_ID NUMBER
Y Entity Id that needs approval - Foreign key
APPROVER_ID NUMBER (15)
Approver Id - Person Id, User Id or Resource Id depending on approver type code - Foreign key
APPROVER_TYPE_CODE VARCHAR2 (30)
Approver Type, whether Person, User, or Resource - Lookup
APPROVAL_STATUS_CODE VARCHAR2 (30) Y Approver response - whether approved, rejected, or pending, or default approver pending - Lookup
WORKFLOW_ITEM_KEY VARCHAR2 (240)
Workflow item key
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_GE_TEMP_APPROVERS does not reference any database object

PV.PV_GE_TEMP_APPROVERS is referenced by following:

APPS
SYNONYM - PV_GE_TEMP_APPROVERS

[top of page]

Table: PV_ITYPE_ATTR_MAPS

Description: Interest type with attribute codes mapping
Primary Key: PV_ITYPE_ATTR_MAPS_PK
  1. ITYPE_MAP_ID
Primary Key: PV_ITYPE_ATTR_MAPS_UK1
  1. ATTR_CODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_ITYPE_ATTR_MAPS.INTEREST_TYPE_ID AS_INTEREST_TYPES_B
PV_ITYPE_ATTR_MAPS.ATTR_CODE_ID PV_ATTRIBUTE_CODES
Comments
Indexes
Index Type Tablespace Column
PV_ITYPE_ATTR_MAPS_U1 UNIQUE APPS_TS_TX_IDX ITYPE_MAP_ID
PV_ITYPE_ATTR_MAPS_N1 NONUNIQUE APPS_TS_TX_IDX INTEREST_TYPE_ID
PV_ITYPE_ATTR_MAPS_N2 NONUNIQUE APPS_TS_TX_IDX ATTR_CODE_ID
Columns
Name Datatype Length Mandatory Comments
ITYPE_MAP_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER
Y
INTEREST_TYPE_ID NUMBER (15) Y
ATTR_CODE_ID NUMBER (15) Y
ATTR_TYPE_SNAME VARCHAR2 (30)
SECURITY_GROUP_ID NUMBER (15)

[top of page]

PV.PV_ITYPE_ATTR_MAPS does not reference any database object

PV.PV_ITYPE_ATTR_MAPS is referenced by following:

APPS
SYNONYM - PV_ITYPE_ATTR_MAPS

[top of page]

Table: PV_LEAD_ASSIGNMENTS

Description: Lead assignments
Primary Key: PV_LEAD_ASSIGNMENTS_PK
  1. LEAD_ASSIGNMENT_ID
Primary Key: PV_LEAD_ASSIGNMENTS_UK1
  1. WF_ITEM_KEY
  2. WF_ITEM_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_LEAD_ASSIGNMENTS.PARTNER_ID HZ_PARTIES
PV_LEAD_ASSIGNMENTS.LEAD_ID AS_LEADS_ALL
PV_LEAD_ASSIGNMENTS.CM_ID JTF_RS_RESOURCE_EXTNS
PV_LEAD_ASSIGNMENTS.RELATED_PARTY_ID HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_ASSIGNMENT_LOGS.LEAD_ASSIGNMENT_ID PV_LEAD_ASSIGNMENTS
PV_PARTY_NOTIFICATIONS.LEAD_ASSIGNMENT_ID PV_LEAD_ASSIGNMENTS
Comments

PV_LEAD_ASSIGNMENTS stores the lead assignment details. Three types of lead assignments are
handled, single, serial and parallel. If the lead assignment is of serial, the order is derived based on
the partners experties. If the lead assignment is parallel, the lead is offered to all the partners and
is assigned to the partner with a first come first served basis

Indexes
Index Type Tablespace Column
PV_LEAD_ASSIGNMENTS_U1 UNIQUE APPS_TS_TX_IDX LEAD_ASSIGNMENT_ID
PV_LEAD_ASSIGNMENTS_U2 UNIQUE APPS_TS_TX_IDX LEAD_ID
PARTNER_ID
WF_ITEM_KEY
WF_ITEM_TYPE
PV_LEAD_ASSIGNMENTS_N1 NONUNIQUE APPS_TS_TX_IDX WF_ITEM_TYPE
WF_ITEM_KEY
PARTNER_ID
PV_LEAD_ASSIGNMENTS_N2 NONUNIQUE APPS_TS_TX_IDX PARTNER_ID
PV_LEAD_ASSIGNMENTS_N4 NONUNIQUE APPS_TS_TX_IDX RELATED_PARTY_ID
PV_LEAD_ASSIGNMENTS_N6 NONUNIQUE APPS_TS_TX_IDX WF_ITEM_KEY
Columns
Name Datatype Length Mandatory Comments
LEAD_ASSIGNMENT_ID NUMBER (15) Y Lead assignment identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
PARTNER_ID NUMBER
Y Partner Identifier
ASSIGN_SEQUENCE NUMBER (15)
Sotes the serial order in which lead is to be assigned to the partners in serial mode
CM_ID NUMBER (15)
Supplier employee with a channel manager role identifier
LEAD_ID NUMBER (15) Y Lead identifier
DURATION NUMBER

Fixed time duration for a lead with Supplier/Partner for an action to be taken
STATUS VARCHAR2 (30) Y Lead assignment status
STATUS_DATE DATE

Lead assignment status date
WF_ITEM_TYPE VARCHAR2 (30)
Workflow item type, part of workflow unique identifier
WF_ITEM_KEY VARCHAR2 (30)
Workflow unique identifier
WF_PT_USER VARCHAR2 (80)
Partner user name
WF_CM_USER VARCHAR2 (80)
Supplier employee with a role of Channel manager user name
ERROR_TXT VARCHAR2 (200)
To display workflow error messages
SECURITY_GROUP_ID NUMBER (15)
Security group identifier
REASON_CODE VARCHAR2 (30)
Reasons if any
SOURCE_TYPE VARCHAR2 (30) Y Opportunity source
RELATED_PARTY_ID NUMBER

Identifier for indirectly managed partners
PARTNER_ACCESS_CODE VARCHAR2 (30)
Controls access to the opportunity for the partner
RELATED_PARTY_ACCESS_CODE VARCHAR2 (30)
Controls access to the opportunity for the vad

[top of page]

PV.PV_LEAD_ASSIGNMENTS does not reference any database object

PV.PV_LEAD_ASSIGNMENTS is referenced by following:

APPS
SYNONYM - PV_LEAD_ASSIGNMENTS

[top of page]

Table: PV_LEAD_PSS_LINES

Description: Partner services and solutions
Primary Key: PV_LEAD_PSS_LINES_PK
  1. LEAD_PSS_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_LEAD_PSS_LINES.ATTR_CODE_ID PV_ATTRIBUTE_CODES_B
PV_LEAD_PSS_LINES.LEAD_ID AS_LEADS_ALL
PV_LEAD_PSS_LINES.LEAD_ID AS_SALES_LEADS
PV_LEAD_PSS_LINES.PARTNER_ID HZ_PARTIES
Comments

PV_LEAD_PSS_LINES stores the services and/or solutions offered to the partner

Indexes
Index Type Tablespace Column
PV_LEAD_PSS_LINES_U1 UNIQUE APPS_TS_TX_IDX LEAD_PSS_LINE_ID
PV_LEAD_PSS_LINES_N1 NONUNIQUE APPS_TS_TX_IDX LEAD_ID
PV_LEAD_PSS_LINES_N2 NONUNIQUE APPS_TS_TX_IDX PARTNER_ID
PV_LEAD_PSS_LINES_N3 NONUNIQUE APPS_TS_TX_IDX ATTR_CODE_ID
Columns
Name Datatype Length Mandatory Comments
LEAD_PSS_LINE_ID NUMBER (15) Y Partner solutions or/and services lead identifier
OBJECT_NAME VARCHAR2 (30) Y Identifies whether it is a lead or an opportunity
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
REQUEST_ID NUMBER (15)
Standard Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update record
PROGRAM_ID NUMBER (15)
Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE DATE

Last date concurrent program updated record
ATTR_CODE_ID NUMBER (15) Y Attribute code identifier
LEAD_ID NUMBER (15)
Lead identifier
UOM_CODE VARCHAR2 (3)
Units of measurements
QUANTITY NUMBER

Partner solutions or/and service quantity
AMOUNT NUMBER

Partner solutions or/and service amount
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment column
SECURITY_GROUP_ID NUMBER (15)
Security group identifier
OBJECT_ID NUMBER

Lead/Opportunity identifier
PARTNER_ID NUMBER

Partner identifier

[top of page]

PV.PV_LEAD_PSS_LINES does not reference any database object

PV.PV_LEAD_PSS_LINES is referenced by following:

APPS
SYNONYM - PV_LEAD_PSS_LINES

[top of page]

Table: PV_LEAD_WORKFLOWS

Description: Lead assignment notifications through workflow
Primary Key: PV_LEAD_WORKFLOWS_PK
  1. LEAD_WORKFLOW_ID
Primary Key: PV_LEAD_WORKFLOWS_UK1
  1. WF_ITEM_KEY
  2. WF_ITEM_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_LEAD_WORKFLOWS.LEAD_ID AS_LEADS_ALL
Comments

PV_LEAD_WORKFLOWS stores the lead statuses whether this lead is assigned to the partner or not, if so in what state the lead is. Notifications are sent to the all concerned when ever the lead is assigned to the partner or the lead status is changed.

Indexes
Index Type Tablespace Column
PV_LEAD_WORKFLOWS_U1 UNIQUE APPS_TS_TX_IDX LEAD_WORKFLOW_ID
PV_LEAD_WORKFLOWS_U2 UNIQUE APPS_TS_TX_IDX WF_ITEM_TYPE
WF_ITEM_KEY
PV_LEAD_WORKFLOWS_N1 NONUNIQUE APPS_TS_TX_IDX LEAD_ID
PV_LEAD_WORKFLOWS_N2 NONUNIQUE APPS_TS_TX_IDX ROUTING_STATUS
ROUTING_TYPE
LATEST_ROUTING_FLAG
Columns
Name Datatype Length Mandatory Comments
LEAD_WORKFLOW_ID NUMBER (15) Y Lead Workflow identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
LEAD_ID NUMBER (15) Y Lead identifier
WF_ITEM_TYPE VARCHAR2 (30) Y Workflow item type, part of unique identifier to workflow
WF_ITEM_KEY VARCHAR2 (30) Y Workflow item key, part of unique identifier to workflow
WF_STATUS VARCHAR2 (30)
Workflow status indicates whether the lead is assigned to partner or not
SECURITY_GROUP_ID NUMBER (15)
Security group identifier
MATCHED_DUE_DATE DATE

Due date for matching opportunities to the partners
OFFERED_DUE_DATE DATE

Due date for offered opportunities to the partners
BYPASS_CM_OK_FLAG VARCHAR2 (1)
Flag to bypass cm
LATEST_ROUTING_FLAG VARCHAR2 (1)
Flag to specify whether the current routing is latest or not
ROUTING_STATUS VARCHAR2 (30)
Routing status
ENTITY VARCHAR2 (30) Y Entity - opportunity
FAILURE_CODE VARCHAR2 (30)
Failure Code
FAILURE_MESSAGE VARCHAR2 (500)
Failure Message
ROUTING_TYPE VARCHAR2 (30)
Routing type

[top of page]

PV.PV_LEAD_WORKFLOWS does not reference any database object

PV.PV_LEAD_WORKFLOWS is referenced by following:

APPS
SYNONYM - PV_LEAD_WORKFLOWS

[top of page]

Table: PV_MDF_OWNERS

Description: Region allocation for a Channel Marketing Manager
Primary Key: PV_MDF_OWNERS_PK
  1. MDF_OWNER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_MDF_OWNERS.CMM_RESOURCE_ID JTF_RS_RESOURCE_EXTNS
Comments
Indexes
Index Type Tablespace Column
PV_MDF_OWNERS_U1 UNIQUE APPS_TS_ARCHIVE MDF_OWNER_ID
PV_MDF_OWNERS_N1 NONUNIQUE APPS_TS_ARCHIVE CMM_RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
MDF_OWNER_ID NUMBER
Y
COUNTRY VARCHAR2 (100) Y
FROM_POSTAL_CODE VARCHAR2 (40)
TO_POSTAL_CODE VARCHAR2 (40)
CMM_RESOURCE_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

SECURITY_GROUP_ID NUMBER (15)

[top of page]

PV.PV_MDF_OWNERS does not reference any database object

PV.PV_MDF_OWNERS is referenced by following:

APPS
SYNONYM - PV_MDF_OWNERS

[top of page]

Table: PV_NOTIFICATION_SETUPS

Description: Notification setups
Primary Key: PV_NOTIFICATION_SETUPS_PK
  1. NOTIFICATION_SETUP_ID
Comments

This table stores the notification setup for a benefit.

Indexes
Index Type Tablespace Column
PV_NOTIFICATION_SETUPS_N1 NONUNIQUE APPS_TS_TX_IDX BENEFIT_ID
PV_NOTIFICATION_SETUPS_U1 NONUNIQUE APPS_TS_TX_IDX NOTIFICATION_SETUP_ID
Columns
Name Datatype Length Mandatory Comments
NOTIFICATION_SETUP_ID NUMBER
Y Notification setup identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
ENTITY_STATUS VARCHAR2 (240) Y Entity status
USER_ROLE VARCHAR2 (240) Y User role
WF_MESSAGE_TYPE VARCHAR2 (8) Y Workflow message type
WF_MESSAGE_NAME VARCHAR2 (30)
Workflow message name
BENEFIT_ID NUMBER
Y Benefit identifier
SECURITY_GROUP_ID NUMBER

Security group identifier

[top of page]

PV.PV_NOTIFICATION_SETUPS does not reference any database object

PV.PV_NOTIFICATION_SETUPS is referenced by following:

APPS
SYNONYM - PV_NOTIFICATION_SETUPS

[top of page]

Table: PV_OPPTY_ROUTING_LOGS

Description:
Comments

This table is used to store the opportunity routing history. Thsi is consolidated table where we store the entire opportuniy assignment/routing logging history.

Indexes
Index Type Tablespace Column
PV_OPPTY_ROUTING_LOGS_N1 NONUNIQUE APPS_TS_TX_IDX LEAD_ASSIGNMENT_ID
PV_OPPTY_ROUTING_LOGS_N2 NONUNIQUE APPS_TS_TX_IDX LEAD_ID
PV_OPPTY_ROUTING_LOGS_N3 NONUNIQUE APPS_TS_TX_IDX LEAD_WORKFLOW_ID
PV_OPPTY_ROUTING_LOGS_U1 NONUNIQUE APPS_TS_TX_IDX OPPTY_ROUTING_LOG_ID
Columns
Name Datatype Length Mandatory Comments
OPPTY_ROUTING_LOG_ID NUMBER
Y primary kay of the table
EVENT VARCHAR2 (15) Y The opportunity routing/assignment event
LEAD_ID NUMBER
Y Opportunity Id
LEAD_WORKFLOW_ID NUMBER
Y lead_workflow_id from pv_lead_workflows table
ROUTING_TYPE VARCHAR2 (30)
Type of the routing done for the opportunity
LATEST_ROUTING_FLAG VARCHAR2 (1) Y Latest routing flag which describes if it is latest routing log row or not incase of multiple routings done on opportunity
BYPASS_CM_FLAG VARCHAR2 (1)
This flag describes if the routing is done by-passing Channel Manager or not.
LEAD_ASSIGNMENT_ID NUMBER

Lead Assignment Id from pv_lead_assignments table
EVENT_DATE DATE
Y Routing Event Date
VENDOR_USER_ID NUMBER

User Id of the Vendor who involves in the routing/assignment action
PT_CONTACT_USER_ID NUMBER

User Id of the Partner Contact who involves in the routing action from partner side
USER_RESPONSE VARCHAR2 (30)
User Response of the Partner Contact who involves in the routing action from partner side
REASON_CODE VARCHAR2 (30)
A reason for the partner user Response if the routing action is from partner side
USER_TYPE VARCHAR2 (60)
Type of the user who is responsible for routing/assignment action
VENDOR_BUSINESS_UNIT_ID NUMBER

Vendor Business Unit

[top of page]

PV.PV_OPPTY_ROUTING_LOGS does not reference any database object

PV.PV_OPPTY_ROUTING_LOGS is referenced by following:

APPS
SYNONYM - PV_OPPTY_ROUTING_LOGS

[top of page]

Table: PV_PARTNER_ACCESSES

Description: Holds channel team member information
Primary Key: PV_PARTNER_ACCESS_PK
  1. PARTNER_ACCESS_ID
Comments

PV_PARTNER_ACCESSES stores information that indicates whether an employee
can access a partner information.
.
Each record in PV_PARTNER_ACCESSES includes values that identify an
employee for which the access applies and the partner to which access is
granted.

Indexes
Index Type Tablespace Column
PV_PARTNER_ACCESSES_U1 UNIQUE APPS_TS_TX_IDX PARTNER_ACCESS_ID
PV_PARTNER_ACCESSES_U2 UNIQUE APPS_TS_TX_IDX PARTNER_ID
RESOURCE_ID
PV_PARTNER_ACCESSES_U3 UNIQUE APPS_TS_TX_IDX RESOURCE_ID
PARTNER_ID
PV_PARTNER_ACCESSES_N1 NONUNIQUE APPS_TS_TX_IDX VAD_PARTNER_ID
PARTNER_ID
PV_PARTNER_ACCESSES_N2 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
PARTNER_ACCESS_ID NUMBER
Y Partner Access Id
PARTNER_ID NUMBER
Y Relationship Id between the Partner and the Vendor Org
RESOURCE_ID NUMBER
Y Individual resource Id
KEEP_FLAG VARCHAR2 (1) Y Flag to be 'ON' if the resource is created manually, else it should be 'OFF'.
CREATED_BY_TAP_FLAG VARCHAR2 (1) Y Flag should be 'ON' if the individual resource is attached online during partner creation, else it should be 'OFF'.
ACCESS_TYPE VARCHAR2 (1) Y If it is ON then it means resource has FULL access, otherwise none.
VAD_PARTNER_ID NUMBER

Party Id of the VAD organization.
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER
Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
CREATED_BY NUMBER
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER
Y Standard WHO column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Program Application Id
PROGRAM_ID NUMBER

Program Id
PROGRAM_UPDATE_DATE DATE

Program Update Date
SECURITY_GROUP_ID NUMBER

Security Group Id
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column

[top of page]

PV.PV_PARTNER_ACCESSES does not reference any database object

PV.PV_PARTNER_ACCESSES is referenced by following:

APPS
SYNONYM - PV_PARTNER_ACCESSES

[top of page]

Table: PV_PARTNER_PROFILES

Description: Partner profiles
Primary Key: PV_PARTNER_PROFILES_PK
  1. PARTNER_PROFILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PARTNER_PROFILES.PARTNER_ID HZ_PARTIES
PV_PARTNER_PROFILES.CM_ID JTF_RS_RESOURCE_EXTNS
PV_PARTNER_PROFILES.PH_SUPPORT_REP JTF_RS_RESOURCE_EXTNS
PV_PARTNER_PROFILES.PARTNER_PARTY_ID HZ_PARTIES
PV_PARTNER_PROFILES.RELATED_PARTNER_ID HZ_PARTIES
Comments

PV_PARTNER_PROFILE stores the partner profile information related to a partner-of or VAD-of
relationship of the organization with internal org

Indexes
Index Type Tablespace Column
PV_PARTNER_PROFILES_U1 UNIQUE APPS_TS_TX_IDX PARTNER_PROFILE_ID
PV_PARTNER_PROFILES_U2 UNIQUE APPS_TS_TX_IDX PARTNER_RELATIONSHIP_ID
PV_PARTNER_PROFILES_U3 UNIQUE APPS_TS_TX_IDX PARTNER_ID
PV_PARTNER_PROFILES_N2 NONUNIQUE APPS_TS_TX_IDX CM_ID
PV_PARTNER_PROFILES_N3 NONUNIQUE APPS_TS_TX_IDX PH_SUPPORT_REP
PV_PARTNER_PROFILES_N4 NONUNIQUE APPS_TS_TX_IDX RELATED_PARTNER_ID
PV_PARTNER_PROFILES_N5 NONUNIQUE APPS_TS_TX_IDX PARTNER_PARTY_ID
Columns
Name Datatype Length Mandatory Comments
PARTNER_PROFILE_ID NUMBER
Y Partner profile identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
PARTNER_ID NUMBER
Y Partner identifier
CM_ID NUMBER

Channel manager 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
SECURITY_GROUP_ID NUMBER

Id for security of the data for web hosting
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) Y Flag indicating if the partner is approved for lead sharing
PARTNER_RELATIONSHIP_ID NUMBER
Y Denormalized column from hz_party_relationships.party_id. Relationship_id of the forward relationship in hz_relationships.
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

Identifier for indirectly managed partners. party_id of the indirectly-managed partner relationship.
MAX_USERS NUMBER

Maximum number of users allowed to register for a partner
PARTNER_PARTY_ID NUMBER

Partner / VAD Organization Identifier
STATUS VARCHAR2 (1)
The status of the partner ('A', 'I')

[top of page]

PV.PV_PARTNER_PROFILES does not reference any database object

PV.PV_PARTNER_PROFILES is referenced by following:

APPS
SYNONYM - PV_PARTNER_PROFILES

[top of page]

Table: PV_PARTNER_PROGRAM_B

Description: Captures partner program, and membership details
Primary Key: PV_PARTNER_PROGRAMS_B_PK
  1. PROGRAM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PARTNER_PROGRAM_B.PREREQ_PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_PARTNER_PROGRAM_B.PROGRAM_PARENT_ID PV_PARTNER_PROGRAM_B
PV_PARTNER_PROGRAM_B.CUSTOM_SETUP_ID AMS_CUSTOM_SETUPS_B
PV_PARTNER_PROGRAM_B.USER_STATUS_ID AMS_USER_STATUSES_B
PV_PARTNER_PROGRAM_B.PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_PARTNER_PROGRAM_B.PROGRAM_TYPE_ID PV_PARTNER_PROGRAM_TYPE_B
PV_PARTNER_PROGRAM_B.CITEM_VERSION_ID IBC_CITEM_VERSIONS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_GE_RESP_MAP_RULES.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_GE_PTNR_RESPS.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PROGRAM_CONTRACTS.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_GE_CHKLST_ITEMS_B.USED_BY_ENTITY_ID PV_PARTNER_PROGRAM_B
PV_GE_HISTORY_LOG_B.HISTORY_FOR_ENTITY_ID PV_PARTNER_PROGRAM_B
PV_GE_NOTIF_RULES_B.NOTIF_FOR_ENTITY_ID PV_PARTNER_PROGRAM_B
PV_GE_PTNR_RESPS.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_GE_QSNR_ELEMENTS_B.USED_BY_ENTITY_ID PV_PARTNER_PROGRAM_B
PV_GE_RESP_MAP_RULES.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PARTNER_PROGRAM_B.PROGRAM_PARENT_ID PV_PARTNER_PROGRAM_B
PV_PARTNER_PROGRAM_TL.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PG_ELIG_PROGRAMS.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PG_ELIG_PROG_MIRR.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PG_ENRL_CHANGE_RULES.CHANGE_FROM_PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PG_ENRL_CHANGE_RULES.CHANGE_TO_PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PG_ENRL_REQUESTS.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PG_INVITE_HEADERS_B.INVITE_FOR_PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PG_MEMBERSHIPS.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PROGRAM_BENEFITS.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PROGRAM_CONTRACTS.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PROGRAM_PAYMENT_MODE.PROGRAM_ID PV_PARTNER_PROGRAM_B
Comments

PV_PARTNER_PROGRAM_B is used to store all the partner program details. Partner programs are of two kinds - Program, and Membership - which is determined by PROGRAM_LEVEL_CODE column. Partner programs follow hierarchical model. Programs are at parent level, and Memberships roll into these Programs.
Vendor creates Partner Programs in which Partner, and VAD users can enroll into. Basically, these programs determine
a) what kind of requirements partner/VAD users should have inorder to qualify for enrollment,
b) questionnaire information that needs to be filled for enrollment,
c) contracts that need to be signed for enrollment,
d) payment and eligibility details in different geographies,
e) benefits an user gets after enrollment,
f) enrollment characteristics like duration, open period for enrollment, etc.
g) program description.
Each program is for different type of partners, and PROGRAM_TYPE_ID determines it.

Indexes
Index Type Tablespace Column
PV_PARTNER_PROGRAM_B_U1 UNIQUE APPS_TS_TX_IDX PROGRAM_ID
PV_PARTNER_PROGRAM_B_U2 UNIQUE APPS_TS_TX_IDX PROCESS_RULE_ID
PV_PARTNER_PROGRAM_B_N1 NONUNIQUE APPS_TS_TX_IDX PROGRAM_PARENT_ID
PV_PARTNER_PROGRAM_B_N2 NONUNIQUE APPS_TS_TX_IDX PROGRAM_OWNER_RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
PROGRAM_ID NUMBER
Y Unique identifier for the Program
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
CUSTOM_SETUP_ID NUMBER
Y Foreign Key to AMS_CUSTOM_SETUPS_B
PROGRAM_PARENT_ID NUMBER

Hold Parent Program ID if it is a child program.
PROGRAM_OWNER_RESOURCE_ID NUMBER
Y Hold information about Program Owner. Foreign Key to JTF_PRODUCTS_RESOURCE_EXTNS.
PROGRAM_TYPE_ID NUMBER
Y Foreign Key to PV_PARTNER_PROGRAM_TYPE_B
PROGRAM_LEVEL_CODE VARCHAR2 (30) Y Hold information about Program Level, e.g. PROGRAM, MEMBERSHIP.
PROGRAM_STATUS_CODE VARCHAR2 (30) Y Hold status ( i.e. NEW, PENDING APPROVAL, REJECTED, APPROVED etc. ) of each Program. Will have foreign key to FND_LOOKUP table.
ENABLED_FLAG VARCHAR2 (1) Y Hold information about enabled/disabled status about the partner program.
PROGRAM_START_DATE DATE
Y Program Start Date
PROGRAM_END_DATE DATE
Y Program End Date
PROCESS_RULE_ID NUMBER
Y Determines linkage to the Qualification Attributes Rules module. Qualification attributes for each Program will be part of Attribute Management module. Foreign Key to PV_PROCESS_RULES_B.
USER_STATUS_ID NUMBER
Y Foreign key to AMS user statuses table to show user configurable program status
MEMBERSHIP_PERIOD_UNIT VARCHAR2 (30)
Period unit for membership valid period.
MEMBERSHIP_VALID_PERIOD NUMBER

Period for a given membership fees
SUBMIT_CHILD_NODES VARCHAR2 (1)
Flag that indicates whether all the child programs need to be submited for approval automatically when the parent program gets approved
INVENTORY_ITEM_ID NUMBER

Foreign key to INV inventory, in case of memberships, as the membership is created as inventory item for order processing
INVENTORY_ITEM_ORG_ID NUMBER (32)
Organization Id in which inventory item is created - Foreign key
BUS_USER_RESP_ID NUMBER

Business User Responsibility Id that gets associated all business user enrollees in this program - Foreign key
ADMIN_RESP_ID NUMBER

Admin User Responsibility Id that gets associated all Administrator user enrollees in this program - Foreign key
NO_FEE_FLAG VARCHAR2 (1)
Waiver flag - Yes means no fee is collected for this program enrollment
QSNR_TTL_ALL_PAGE_DSP_FLAG VARCHAR2 (1)
Indicate whether the questionnaire title should be displayed in all pages or not
QSNR_HDR_ALL_PAGE_DSP_FLAG VARCHAR2 (1)
Indicate whether the questionnaire header should be displayed in all pages or not
QSNR_FTR_ALL_PAGE_DSP_FLAG VARCHAR2 (1)
Indicate whether the questionnaire footer should be displayed in all pages or not
ALLOW_ENRL_WOUT_CHKLST_FLAG VARCHAR2 (1)
Whether enrollment can be allowed without checklist items being completely checked
ALLOW_ENRL_UNTIL_DATE DATE

Enrollment into the membership can be allowed until this date
CITEM_VERSION_ID NUMBER

Foreign key to IBC content items, that stores the program summary content
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Attribute category
ATTRIBUTE1 VARCHAR2 (240)
Attribute1
ATTRIBUTE2 VARCHAR2 (240)
Attribute2
ATTRIBUTE3 VARCHAR2 (240)
Attribute3
ATTRIBUTE4 VARCHAR2 (240)
Attribute4
ATTRIBUTE5 VARCHAR2 (240)
Attribute5
ATTRIBUTE6 VARCHAR2 (240)
Attribute6
ATTRIBUTE7 VARCHAR2 (240)
Attribute7
ATTRIBUTE8 VARCHAR2 (240)
Attribute8
ATTRIBUTE9 VARCHAR2 (240)
Attribute9
ATTRIBUTE10 VARCHAR2 (240)
Attribute10
ATTRIBUTE11 VARCHAR2 (240)
Attribute11
ATTRIBUTE12 VARCHAR2 (240)
Attribute12
ATTRIBUTE13 VARCHAR2 (240)
Attribute13
ATTRIBUTE14 VARCHAR2 (240)
Attribute14
ATTRIBUTE15 VARCHAR2 (240)
Attribute15
VAD_INVITE_ALLOW_FLAG VARCHAR2 (1)
Whether VAD can invite partners to join in this program. Y means VAD can invite
GLOBAL_MMBR_REQD_FLAG VARCHAR2 (1)
Whether global membership is required before subsidiary can enroll. Y means global membership is required
WAIVE_SUBSIDIARY_FEE_FLAG VARCHAR2 (1)
Waiver flag for subsidiary fees. Y means subsidiary need not pay
PREREQ_PROCESS_RULE_ID NUMBER

Determines linkage to the Prerequistes Qualification Attributes Rules module.

[top of page]

PV.PV_PARTNER_PROGRAM_B does not reference any database object

PV.PV_PARTNER_PROGRAM_B is referenced by following:

APPS
SYNONYM - PV_PARTNER_PROGRAM_B

[top of page]

Table: PV_PARTNER_PROGRAM_TL

Description: Partner Program - Translation table
Primary Key: PV_PARTNER_PROGRAM_TL_PK
  1. PROGRAM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PARTNER_PROGRAM_TL.PROGRAM_ID PV_PARTNER_PROGRAM_B
Comments

Table to hold translatable data of a partner program.

Indexes
Index Type Tablespace Column
PV_PARTNER_PROGRAM_TL_U1 UNIQUE APPS_TS_TX_IDX PROGRAM_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PROGRAM_ID NUMBER
Y Program id
LANGUAGE VARCHAR2 (4) Y Language
PROGRAM_NAME VARCHAR2 (60)
Program name
PROGRAM_DESCRIPTION VARCHAR2 (240)
Program description
QSNR_HEADER VARCHAR2 (2000)
Questionnaire header
QSNR_FOOTER VARCHAR2 (2000)
Questionnaire Footer
QSNR_TITLE VARCHAR2 (240)
Questionnaire title
SOURCE_LANG VARCHAR2 (4) Y Source Language
SECURITY_GROUP_ID NUMBER

Security group id
CREATED_BY NUMBER
Y Created by
CREATION_DATE DATE
Y Creation date
LAST_UPDATED_BY NUMBER
Y Last updated by
LAST_UPDATE_DATE DATE
Y Last update date
LAST_UPDATE_LOGIN NUMBER
Y Last update login

[top of page]

PV.PV_PARTNER_PROGRAM_TL does not reference any database object

PV.PV_PARTNER_PROGRAM_TL is referenced by following:

APPS
SYNONYM - PV_PARTNER_PROGRAM_TL

[top of page]

Table: PV_PARTNER_PROGRAM_TYPE_B

Description: Partner Program Type - base table
Primary Key: PV_PARTNER_PROGRAM_TYPE_B_PK
  1. PROGRAM_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_PARTNER_PROGRAM_B.PROGRAM_TYPE_ID PV_PARTNER_PROGRAM_TYPE_B
PV_PARTNER_PROGRAM_TYPE_TL.PROGRAM_TYPE_ID PV_PARTNER_PROGRAM_TYPE_B
PV_PROGRAM_PARTNER_TYPES.PROGRAM_TYPE_ID PV_PARTNER_PROGRAM_TYPE_B
Comments

Base table to hold information of a partner program type. The partner program type defines the target partners and whom the program approvers are once the vendor user submits the program for approval.

Indexes
Index Type Tablespace Column
PV_PARTNER_PROGRAM_TYPE_B_U1 UNIQUE APPS_TS_TX_IDX PROGRAM_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
PROGRAM_TYPE_ID NUMBER
Y Program type id
ACTIVE_FLAG VARCHAR2 (1) Y Active flag
ENABLED_FLAG VARCHAR2 (1) Y Enabled flag
LAST_UPDATE_DATE DATE
Y Last update date
CREATION_DATE DATE
Y Creation Date
CREATED_BY NUMBER
Y Created by
LAST_UPDATE_LOGIN NUMBER
Y Last update login
OBJECT_VERSION_NUMBER NUMBER

Object version number
SECURITY_GROUP_ID NUMBER

Security group id
LAST_UPDATED_BY NUMBER
Y Last updated by

[top of page]

PV.PV_PARTNER_PROGRAM_TYPE_B does not reference any database object

PV.PV_PARTNER_PROGRAM_TYPE_B is referenced by following:

APPS
SYNONYM - PV_PARTNER_PROGRAM_TYPE_B

[top of page]

Table: PV_PARTNER_PROGRAM_TYPE_TL

Description: Partner Program Type - translation table
Primary Key: PV_PARTNER_PROGRAM_TYPE_TL_PK
  1. PROGRAM_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PARTNER_PROGRAM_TYPE_TL.PROGRAM_TYPE_ID PV_PARTNER_PROGRAM_TYPE_B
Comments

Table to hold translatable data of a partner program type

Indexes
Index Type Tablespace Column
PV_PARTNER_PROGRAM_TYPE_TL_U1 UNIQUE APPS_TS_TX_IDX PROGRAM_TYPE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PROGRAM_TYPE_ID NUMBER
Y Program type id
PROGRAM_TYPE_NAME VARCHAR2 (60) Y Program type name
PROGRAM_TYPE_DESCRIPTION VARCHAR2 (240)
Program type description
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source Language
LAST_UPDATE_DATE DATE
Y Last update date
LAST_UPDATED_BY NUMBER
Y Last updated by
CREATION_DATE DATE
Y Creation date
CREATED_BY NUMBER
Y Created by
LAST_UPDATE_LOGIN NUMBER
Y Last update login
SECURITY_GROUP_ID NUMBER

Security group id

[top of page]

PV.PV_PARTNER_PROGRAM_TYPE_TL does not reference any database object

PV.PV_PARTNER_PROGRAM_TYPE_TL is referenced by following:

APPS
SYNONYM - PV_PARTNER_PROGRAM_TYPE_TL

[top of page]

Table: PV_PARTY_NOTIFICATIONS

Description: Party Notifications
Primary Key: PV_PARTY_NOTIFICATIONS_PK
  1. PARTY_NOTIFICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PARTY_NOTIFICATIONS.LEAD_ASSIGNMENT_ID PV_LEAD_ASSIGNMENTS
PV_PARTY_NOTIFICATIONS.USER_ID FND_USER
PV_PARTY_NOTIFICATIONS.USER_NAME FND_USER
PV_PARTY_NOTIFICATIONS.RESOURCE_ID JTF_RS_RESOURCE_EXTNS
Comments

PV_PARTY_NOTIFICATIONS Stores the status of Party notifications send through work flow notifications.

Indexes
Index Type Tablespace Column
PV_PARTY_NOTIFICATIONS_U1 UNIQUE APPS_TS_TX_IDX PARTY_NOTIFICATION_ID
PV_PARTY_NOTIFICATIONS_U2 UNIQUE APPS_TS_TX_IDX LEAD_ASSIGNMENT_ID
NOTIFICATION_TYPE
USER_ID
PV_PARTY_NOTIFICATIONS_N1 NONUNIQUE APPS_TS_TX_IDX USER_ID
PV_PARTY_NOTIFICATIONS_N2 NONUNIQUE APPS_TS_TX_IDX USER_NAME
PV_PARTY_NOTIFICATIONS_N3 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
PV_PARTY_NOTIFICATIONS_N4 NONUNIQUE APPS_TS_TX_IDX WF_ITEM_TYPE
WF_ITEM_KEY
Columns
Name Datatype Length Mandatory Comments
PARTY_NOTIFICATION_ID NUMBER (15) Y Party notification identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last date this record was updated by a concurrent program
NOTIFICATION_ID NUMBER (15)
Notification identifier
NOTIFICATION_TYPE VARCHAR2 (15) Y Type of Notification, ex: matched,rejected
LEAD_ASSIGNMENT_ID NUMBER (15) Y Lead assignment identifier - Foreign key from PV_LEAD_ASSIGNMENTS
WF_ITEM_TYPE VARCHAR2 (30)
Workflow item type
WF_ITEM_KEY VARCHAR2 (30)
Workflow item key
USER_ID NUMBER (15) Y User identifier from FND_USER
USER_NAME VARCHAR2 (230)
User name from FND_USER
RESOURCE_ID NUMBER (15) Y Resource identifier from JTF_RS_RESOURCE_EXTNS
DECISION_MAKER_FLAG VARCHAR2 (1)
Indicated whether the user has the decision making authority or not
RESOURCE_RESPONSE VARCHAR2 (30)
Resource of the party
RESPONSE_DATE DATE

Date of response
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category
ATTRIBUTE1 VARCHAR2 (150)
Attribute
ATTRIBUTE2 VARCHAR2 (150)
Attribute
ATTRIBUTE3 VARCHAR2 (150)
Attribute
ATTRIBUTE4 VARCHAR2 (150)
Attribute
ATTRIBUTE5 VARCHAR2 (150)
Attribute
ATTRIBUTE6 VARCHAR2 (150)
Attribute
ATTRIBUTE7 VARCHAR2 (150)
Attribute
ATTRIBUTE8 VARCHAR2 (150)
Attribute
ATTRIBUTE9 VARCHAR2 (150)
Attribute
ATTRIBUTE10 VARCHAR2 (150)
Attribute
ATTRIBUTE11 VARCHAR2 (150)
Attribute
ATTRIBUTE12 VARCHAR2 (150)
Attribute
ATTRIBUTE13 VARCHAR2 (150)
Attribute
ATTRIBUTE14 VARCHAR2 (150)
Attribute
ATTRIBUTE15 VARCHAR2 (150)
Attribute
SECURITY_GROUP_ID NUMBER (15)
Security group identifier

[top of page]

PV.PV_PARTY_NOTIFICATIONS does not reference any database object

PV.PV_PARTY_NOTIFICATIONS is referenced by following:

APPS
SYNONYM - PV_PARTY_NOTIFICATIONS

[top of page]

Table: PV_PG_ELIG_PROGRAMS

Description: Eligible Programs
Primary Key: PV_PG_ELIG_PROGRAMS_PK
  1. ELIG_PROGRAM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PG_ELIG_PROGRAMS.PROGRAM_ID PV_PARTNER_PROGRAM_B
Comments

Hold information for the partners and the programs which are eligible for them to enroll.

Indexes
Index Type Tablespace Column
PV_PG_ELIG_PROGRAMS_U1 UNIQUE APPS_TS_TX_IDX ELIG_PROGRAM_ID
PV_PG_ELIG_PROGRAMS_N1 NONUNIQUE APPS_TS_TX_IDX PARTNER_ID
PV_PG_ELIG_PROGRAMS_N2 NONUNIQUE APPS_TS_TX_IDX PROGRAM_ID
Columns
Name Datatype Length Mandatory Comments
ELIG_PROGRAM_ID NUMBER
Y Eligible program id
PROGRAM_ID NUMBER
Y Program Id
PARTNER_ID NUMBER
Y Partner id
ELIGIBILITY_CRIT_CODE VARCHAR2 (30) Y Eligibility criteria code
CREATED_BY NUMBER (15) Y Created by
CREATION_DATE DATE
Y Creation Date
LAST_UPDATED_BY NUMBER (15) Y Last updated by
LAST_UPDATE_DATE DATE
Y Last update date
LAST_UPDATE_LOGIN NUMBER (15) Y Last update login
OBJECT_VERSION_NUMBER NUMBER (9)
Object version number

[top of page]

PV.PV_PG_ELIG_PROGRAMS does not reference any database object

PV.PV_PG_ELIG_PROGRAMS is referenced by following:

APPS
SYNONYM - PV_PG_ELIG_PROGRAMS

[top of page]

Table: PV_PG_ELIG_PROG_MIRR

Description: Eligible Programs
Primary Key: PV_PG_ELIG_PROG_MIRR_PK
  1. ELIG_PROGRAM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PG_ELIG_PROG_MIRR.PROGRAM_ID PV_PARTNER_PROGRAM_B
Comments

Hold information for the partners and the programs which are eligible for them to enroll.

Indexes
Index Type Tablespace Column
PV_PG_ELIG_PROGRAMS_U1_M UNIQUE APPS_TS_TX_IDX ELIG_PROGRAM_ID
PV_PG_ELIG_PROGRAMS_N1_M NONUNIQUE APPS_TS_TX_IDX PARTNER_ID
PV_PG_ELIG_PROGRAMS_N2_M NONUNIQUE APPS_TS_TX_IDX PROGRAM_ID
Columns
Name Datatype Length Mandatory Comments
ELIG_PROGRAM_ID NUMBER
Y Eligible program id
PROGRAM_ID NUMBER
Y Program Id
PARTNER_ID NUMBER
Y Partner id
ELIGIBILITY_CRIT_CODE VARCHAR2 (30) Y Eligibility criteria code
CREATED_BY NUMBER (15) Y Created by
CREATION_DATE DATE
Y Creation Date
LAST_UPDATED_BY NUMBER (15) Y Last updated by
LAST_UPDATE_DATE DATE
Y Last update date
LAST_UPDATE_LOGIN NUMBER (15) Y Last update login
OBJECT_VERSION_NUMBER NUMBER (9)
Object version number

[top of page]

PV.PV_PG_ELIG_PROG_MIRR does not reference any database object

PV.PV_PG_ELIG_PROG_MIRR is referenced by following:

APPS
SYNONYM - PV_PG_ELIG_PROG_MIRR

[top of page]

Table: PV_PG_ENRL_CHANGE_RULES

Description: Container for program's enrollment upgrade/downgrade rules.
Primary Key: PV_PG_ENRL_CHANGE_RULES_PK
  1. ENRL_CHANGE_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PG_ENRL_CHANGE_RULES.CHANGE_FROM_PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PG_ENRL_CHANGE_RULES.CHANGE_TO_PROGRAM_ID PV_PARTNER_PROGRAM_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_PG_ENRQ_INIT_SOURCES.ENRL_CHANGE_RULE_ID PV_PG_ENRL_CHANGE_RULES
Comments

PV_PG_ENRLCHANGE_RULES stores the upgrade/downgrade rules to determine whether a membership can be upgraded from one program to other program.
CHANGE_DIRECTION_CODE determines the direction - Upgrade or Downgrade.
Enrollment requests can be only be transitioned for upgrade/downgrade as per these rules.

Indexes
Index Type Tablespace Column
PV_PG_ENRL_CHANGE_RULES_U1 UNIQUE APPS_TS_TX_IDX ENRL_CHANGE_RULE_ID
PV_PG_ENRL_CHANGE_RULES_N1 NONUNIQUE APPS_TS_TX_IDX CHANGE_FROM_PROGRAM_ID
Columns
Name Datatype Length Mandatory Comments
ENRL_CHANGE_RULE_ID NUMBER
Y Unique Identifier
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
CHANGE_FROM_PROGRAM_ID NUMBER
Y Foreign key reference to program Id from which membership change like upgrade/downgrade can be made.
CHANGE_TO_PROGRAM_ID NUMBER
Y Foreign key reference to program Id to which membership change like upgrade/downgrade can be made.
CHANGE_DIRECTION_CODE VARCHAR2 (30) Y Membership Direction Code that can be made like Upgrade/Downgrade
EFFECTIVE_FROM_DATE DATE
Y Upgrade/Downgrade rule effective from date
EFFECTIVE_TO_DATE DATE

Upgrade/Downgrade rule effective to date
ACTIVE_FLAG VARCHAR2 (1) Y Active Flag
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_PG_ENRL_CHANGE_RULES does not reference any database object

PV.PV_PG_ENRL_CHANGE_RULES is referenced by following:

APPS
SYNONYM - PV_PG_ENRL_CHANGE_RULES

[top of page]

Table: PV_PG_ENRL_REQUESTS

Description: Container for enrollment requests submitted for membership into programs.
Primary Key: PV_PG_ENRL_REQUESTS_PK
  1. ENRL_REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PG_ENRL_REQUESTS.ORDER_HEADER_ID OE_ORDER_HEADERS_ALL
PV_PG_ENRL_REQUESTS.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PG_ENRL_REQUESTS.PARTNER_ID HZ_PARTIES
PV_PG_ENRL_REQUESTS.REQUESTOR_RESOURCE_ID JTF_RS_RESOURCE_EXTNS
PV_PG_ENRL_REQUESTS.CONTRACT_ID OKC_K_HEADERS_B
PV_PG_ENRL_REQUESTS.INVITE_HEADER_ID PV_PG_INVITE_HEADERS_B
PV_PG_ENRL_REQUESTS.CUSTOM_SETUP_ID AMS_CUSTOM_SETUPS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_GE_PARTY_NOTIFICATIONS.NOTIF_FOR_ENTITY_ID PV_PG_ENRL_REQUESTS
PV_GE_CHKLST_RESPONSES.RESPONSE_FOR_ENTITY_ID PV_PG_ENRL_REQUESTS
PV_GE_HISTORY_LOG_B.HISTORY_FOR_ENTITY_ID PV_PG_ENRL_REQUESTS
PV_GE_TEMP_APPROVERS.APPR_FOR_ENTITY_ID PV_PG_ENRL_REQUESTS
PV_PG_ENRQ_INIT_SOURCES.ENRL_REQUEST_ID PV_PG_ENRL_REQUESTS
PV_PG_MEMBERSHIPS.ENRL_REQUEST_ID PV_PG_ENRL_REQUESTS
Comments

PV_PG_ENRL_REQUESTS stores the data related to enrollment request that is submitted by partner user for membership into various programs.
ENROLLMENT_TYPE_CODE identifies different types of enrollment requests, like New, Renewal, Upgrade, or Downgrade. REQUEST_INITIATED_BY_CODE identifies how the request is created - either by PARTNER user or by SYSTEM (used only for downgrades).
If the enrollment request is created because of invitations sent by vendor user, INVITE_HEADER_ID captures that information.
SCORE_RESULT_CODE stores the automatic scoring result(Success or Fail) after comparing the enrollment questionnarie data to program's requirements data.

Indexes
Index Type Tablespace Column
PV_PG_ENRL_REQUESTS_U1 UNIQUE APPS_TS_TX_IDX ENRL_REQUEST_ID
PV_PG_ENRL_REQUESTS_N1 NONUNIQUE APPS_TS_TX_IDX PARTNER_ID
PV_PG_ENRL_REQUESTS_N2 NONUNIQUE APPS_TS_TX_IDX PROGRAM_ID
PV_PG_ENRL_REQUESTS_N3 NONUNIQUE APPS_TS_TX_IDX REQUESTOR_RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
ENRL_REQUEST_ID NUMBER
Y Unique Identifier
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
PROGRAM_ID NUMBER
Y Foreign key to Program Id for which enrollment request is submitted for enrollment.
PARTNER_ID NUMBER
Y Foreign key to Partner Organization Relatiship Id who submitted enrollment request
CUSTOM_SETUP_ID NUMBER
Y Foreing key to Custom Setup Id that determines cuecard
REQUESTOR_RESOURCE_ID NUMBER
Y Partner User's resource id that submitted the enrollment request
REQUEST_STATUS_CODE VARCHAR2 (30) Y Enrollment Request Status - lookup
ENROLLMENT_TYPE_CODE VARCHAR2 (30) Y Enrollment Type Code - New/Upgrade/Renew/Downgrade - Lookup
REQUEST_SUBMISSION_DATE DATE

Enrollment Request submission date
ORDER_HEADER_ID NUMBER

Foreign Key to OM order header id, when payment is collected for the enrollment request through order
CONTRACT_ID NUMBER

Foreign Key to OKC contract id, that signed by partner for the program enrollment
REQUEST_INITIATED_BY_CODE VARCHAR2 (30) Y Whether the enrollment request is initiated manually, or automatically by system
INVITE_HEADER_ID NUMBER

Foreign key to Invite Header Id if enrollment request is created because of an invitation
TENTATIVE_START_DATE DATE

Tentative start date of membership at the time of creation of enrollment request
TENTATIVE_END_DATE DATE

Tentative end date of membership at the time of creation of enrollment request
CONTRACT_STATUS_CODE VARCHAR2 (30)
Contract Status Code - lookup
PAYMENT_STATUS_CODE VARCHAR2 (30)
Payment Status Code in case of orders - Lookup
SCORE_RESULT_CODE VARCHAR2 (30)
Automatic Scoring Result Code - Pass/Fail/Not Evaluated - Lookup
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
MEMBERSHIP_FEE NUMBER

Membership fee
TRANS_CURR_CODE VARCHAR2 (15)
Transaction currency code.
DEPENDENT_PROGRAM_ID NUMBER

Dependent program ID.
CONTRACT_BINDING_CONTACT_ID NUMBER

Id of the contact who signed the contract
CONTRACT_SIGNED_DATE DATE

Date when the enrollment contact was signed
TRXN_EXTENSION_ID NUMBER

Reference to credit card payment details
ATTRIBUTE1 VARCHAR2 (240)
Attribute
ATTRIBUTE2 VARCHAR2 (240)
Attribute
ATTRIBUTE3 VARCHAR2 (240)
Attribute
ATTRIBUTE4 VARCHAR2 (240)
Attribute
ATTRIBUTE5 VARCHAR2 (240)
Attribute
ATTRIBUTE6 VARCHAR2 (240)
Attribute
ATTRIBUTE7 VARCHAR2 (240)
Attribute
ATTRIBUTE8 VARCHAR2 (240)
Attribute
ATTRIBUTE9 VARCHAR2 (240)
Attribute
ATTRIBUTE10 VARCHAR2 (240)
Attribute
ATTRIBUTE11 VARCHAR2 (240)
Attribute
ATTRIBUTE12 VARCHAR2 (240)
Attribute
ATTRIBUTE13 VARCHAR2 (240)
Attribute
ATTRIBUTE14 VARCHAR2 (240)
Attribute
ATTRIBUTE15 VARCHAR2 (240)
Attribute

[top of page]

PV.PV_PG_ENRL_REQUESTS does not reference any database object

PV.PV_PG_ENRL_REQUESTS is referenced by following:

APPS
SYNONYM - PV_PG_ENRL_REQUESTS

[top of page]

Table: PV_PG_ENRQ_INIT_SOURCES

Description: Container to store iniation source details for enrollment request when it is upgraded or downgraded.
Primary Key: PV_PG_ENRQ_INIT_SOURCES_PK
  1. INITIATION_SOURCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PG_ENRQ_INIT_SOURCES.ENRL_CHANGE_RULE_ID PV_PG_ENRL_CHANGE_RULES
PV_PG_ENRQ_INIT_SOURCES.ENRL_REQUEST_ID PV_PG_ENRL_REQUESTS
PV_PG_ENRQ_INIT_SOURCES.PREV_MEMBERSHIP_ID PV_PG_MEMBERSHIPS
PV_PG_ENRQ_INIT_SOURCES.ENRL_CHANGE_RULE_ID %
Comments

PV_PG_ENRQ_INIT_SOURCES stores which upgrade/downgrade rule caused the enrollment request, and from which membership this request is initiated.

Indexes
Index Type Tablespace Column
PV_PG_ENRQ_INIT_SOURCES_N1 NONUNIQUE APPS_TS_TX_IDX ENRL_REQUEST_ID
PV_PG_ENRQ_INIT_SOURCES_N2 NONUNIQUE APPS_TS_TX_IDX PREV_MEMBERSHIP_ID
PV_PG_ENRQ_INIT_SOURCES_U1 NONUNIQUE APPS_TS_TX_IDX INITIATION_SOURCE_ID
Columns
Name Datatype Length Mandatory Comments
INITIATION_SOURCE_ID NUMBER
Y Unique Identififier
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
ENRL_REQUEST_ID NUMBER
Y Foreign key reference to Enrollment Request Id which is initiated throu this source.
PREV_MEMBERSHIP_ID NUMBER
Y Foreign key reference to Previous Membership Id from which this enrollment request is initiated.
ENRL_CHANGE_RULE_ID NUMBER

Foreign key reference to Enrollment Change Rule Id which is being used for the enrollment request to upgrade to or downgrade from.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_PG_ENRQ_INIT_SOURCES does not reference any database object

PV.PV_PG_ENRQ_INIT_SOURCES is referenced by following:

APPS
SYNONYM - PV_PG_ENRQ_INIT_SOURCES

[top of page]

Table: PV_PG_INVITE_HEADERS_B

Description: Container for storing invitations sent to partners for enrollment into programs.
Primary Key: PV_PG_INVITE_HEADERS_B_PK
  1. INVITE_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PG_INVITE_HEADERS_B.QP_LIST_HEADER_ID AMS_OFFERS
PV_PG_INVITE_HEADERS_B.INVITE_FOR_PROGRAM_ID PV_PARTNER_PROGRAM_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_GE_PARTY_NOTIFICATIONS.NOTIF_FOR_ENTITY_ID PV_PG_INVITE_HEADERS_B
PV_PG_ENRL_REQUESTS.INVITE_HEADER_ID PV_PG_INVITE_HEADERS_B
PV_PG_INVITE_HEADERS_TL.INVITE_HEADER_ID PV_PG_INVITE_HEADERS_B
Comments

PV_PG_INVITE_HEADERS_B table stores the invitation details sent by vendor user to partner users inviting them to either enroll in or renew or upgrade the membership.
INVITE_TYPE_CODE identifies type of invitation - like New, Renew, or Upgrade.
Vendor can chose to offer discount in program enrollment fee in invitations. These discount offeres are created in Advanced Pricing(QP) via Trade Management product.

Indexes
Index Type Tablespace Column
PV_PG_ENRL_INVITE_HEADERS_B_U1 UNIQUE APPS_TS_TX_IDX INVITE_HEADER_ID
PV_PG_ENRL_INVITE_HEADERS_B_U2 NONUNIQUE APPS_TS_TX_IDX QP_LIST_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
INVITE_HEADER_ID NUMBER
Y Unique Identifier
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
QP_LIST_HEADER_ID VARCHAR2 (30)
Foreign key reference to QP Price List Header Id that is being created during offer creation process.
INVITE_TYPE_CODE VARCHAR2 (30)
Invitation type like New, or Upgrade, or Downgrade.
INVITE_FOR_PROGRAM_ID NUMBER
Y Foreign key reference to Program Id for which invitation is being sent.
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
PARTNER_ID NUMBER
Y The partner id of the partner who received the invitation
INVITE_END_DATE DATE

The date till the invite offer is valid.
ORDER_HEADER_ID NUMBER

Foreign Key to OM order header id. This column holds associated order header id for vad invitations.
INVITED_BY_PARTNER_ID NUMBER

Invitations can be sent out by Value Added Distributors( VAD's). This column stores the partner id of the VAD who sent the invite.
TRXN_EXTENSION_ID NUMBER

Reference to the credit card payment information

[top of page]

PV.PV_PG_INVITE_HEADERS_B does not reference any database object

PV.PV_PG_INVITE_HEADERS_B is referenced by following:

APPS
SYNONYM - PV_PG_INVITE_HEADERS_B

[top of page]

Table: PV_PG_INVITE_HEADERS_TL

Description: Contrainer for translatable data for invitation header.
Primary Key: PV_PG_INVITE_HEADERS_TL_PK
  1. INVITE_HEADER_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PG_INVITE_HEADERS_TL.INVITE_HEADER_ID PV_PG_INVITE_HEADERS_B
Comments

PV_PG_INVITE_HEADERS_TL stores translatable notification content for invitations.

Indexes
Index Type Tablespace Column
PV_PG_INVITE_HEADERS_TL_U1 NONUNIQUE APPS_TS_TX_IDX LANGUAGE
INVITE_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
INVITE_HEADER_ID NUMBER
Y Foreign key to Invite Heder Id for which translatable data is being captured.
LANGUAGE VARCHAR2 (240) Y Language being translated to.
SOURCE_LANG VARCHAR2 (240) Y Source Language.
EMAIL_CONTENT VARCHAR2 (2000)
Notification content that is being sent in invitation
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_PG_INVITE_HEADERS_TL does not reference any database object

PV.PV_PG_INVITE_HEADERS_TL is referenced by following:

APPS
SYNONYM - PV_PG_INVITE_HEADERS_TL

[top of page]

Table: PV_PG_MEMBERSHIPS

Description: Container for partner's program membership details.
Primary Key: PV_PG_MEMBERSHIPS_PK
  1. MEMBERSHIP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PG_MEMBERSHIPS.ENRL_REQUEST_ID PV_PG_ENRL_REQUESTS
PV_PG_MEMBERSHIPS.PARTNER_ID HZ_PARTIES
PV_PG_MEMBERSHIPS.PROGRAM_ID PV_PARTNER_PROGRAM_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_GE_PARTY_NOTIFICATIONS.NOTIF_FOR_ENTITY_ID PV_PG_MEMBERSHIPS
PV_PG_ENRQ_INIT_SOURCES.PREV_MEMBERSHIP_ID PV_PG_MEMBERSHIPS
PV_PG_MMBR_TRANSITIONS.FROM_MEMBERSHIP_ID PV_PG_MEMBERSHIPS
PV_PG_MMBR_TRANSITIONS.TO_MEMBERSHIP_ID PV_PG_MEMBERSHIPS
Comments

PV_PG_MEMBERSHIPS table stores partner's program membership details. Once the enrollment request is approved by vendor, it gets converted to membership.
This table captures the membership specific data, like membership's active duration, and whether membership is still active or not.

Indexes
Index Type Tablespace Column
PV_PG_MEMBERSHIPS_U1 UNIQUE APPS_TS_TX_IDX MEMBERSHIP_ID
PV_PG_MEMBERSHIPS_U2 UNIQUE APPS_TS_TX_IDX ENRL_REQUEST_ID
PV_PG_MEMBERSHIPS_N1 NONUNIQUE APPS_TS_TX_IDX PARTNER_ID
PROGRAM_ID
START_DATE
ACTUAL_END_DATE
PV_PG_MEMBERSHIPS_N2 NONUNIQUE APPS_TS_TX_IDX ORIGINAL_END_DATE
PV_PG_MEMBERSHIPS_N3 NONUNIQUE APPS_TS_TX_IDX PROGRAM_ID
Columns
Name Datatype Length Mandatory Comments
MEMBERSHIP_ID NUMBER
Y Unique Identifier
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
PARTNER_ID NUMBER
Y Foreign key to Partner Organization Relatiship Id for which membership is created
PROGRAM_ID NUMBER
Y Foreign key to Program Id in which partner's membership is created.
START_DATE DATE
Y Membership start date.
ORIGINAL_END_DATE DATE

Membership end date at the time of creation of membership
ACTUAL_END_DATE DATE

Membership actual end date
MEMBERSHIP_STATUS_CODE VARCHAR2 (30) Y Membership Status - Lookup
STATUS_REASON_CODE VARCHAR2 (30)
Reason why membership status is changed - Lookup code
ENRL_REQUEST_ID NUMBER
Y Foreign key to Enrollment Request Id that converted into membership
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
ATTRIBUTE1 VARCHAR2 (240)
Attribute
ATTRIBUTE2 VARCHAR2 (240)
Attribute
ATTRIBUTE3 VARCHAR2 (240)
Attribute
ATTRIBUTE4 VARCHAR2 (240)
Attribute
ATTRIBUTE5 VARCHAR2 (240)
Attribute
ATTRIBUTE6 VARCHAR2 (240)
Attribute
ATTRIBUTE7 VARCHAR2 (240)
Attribute
ATTRIBUTE8 VARCHAR2 (240)
Attribute
ATTRIBUTE9 VARCHAR2 (240)
Attribute
ATTRIBUTE10 VARCHAR2 (240)
Attribute
ATTRIBUTE11 VARCHAR2 (240)
Attribute
ATTRIBUTE12 VARCHAR2 (240)
Attribute
ATTRIBUTE13 VARCHAR2 (240)
Attribute
ATTRIBUTE14 VARCHAR2 (240)
Attribute
ATTRIBUTE15 VARCHAR2 (240)
Attribute

[top of page]

PV.PV_PG_MEMBERSHIPS does not reference any database object

PV.PV_PG_MEMBERSHIPS is referenced by following:

APPS
SYNONYM - PV_PG_MEMBERSHIPS

[top of page]

Table: PV_PG_MMBR_TRANSITIONS

Description: Contrainer for linking membership transitions
Primary Key: PV_PG_MMBR_TRANSITIONS_PK1
  1. MMBR_TRANSITION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PG_MMBR_TRANSITIONS.FROM_MEMBERSHIP_ID PV_PG_MEMBERSHIPS
PV_PG_MMBR_TRANSITIONS.TO_MEMBERSHIP_ID PV_PG_MEMBERSHIPS
Comments

PV_PG_MMBR_TRANSITIONS links different memberships when they are trasitioned into other memberships on upgrade, downgrade, or renewals.

Indexes
Index Type Tablespace Column
PV_PG_MMBR_TRANSITIONS_U1 UNIQUE APPS_TS_TX_IDX MMBR_TRANSITION_ID
PV_PG_MMBR_TRANSITIONS_U2 UNIQUE APPS_TS_TX_IDX FROM_MEMBERSHIP_ID
TO_MEMBERSHIP_ID
Columns
Name Datatype Length Mandatory Comments
MMBR_TRANSITION_ID NUMBER
Y Unique Identifier
FROM_MEMBERSHIP_ID NUMBER
Y Foreign key to Membership Id from which this membership is transitioned from during renewal, upgrade, or downgrade
OBJECT_VERSION_NUMBER NUMBER (9) Y This column is used for locking purposes
TO_MEMBERSHIP_ID NUMBER
Y Foreign key to Membership Id to which this membership is transitioned to during renewal, upgrade, or downgrade
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column

[top of page]

PV.PV_PG_MMBR_TRANSITIONS does not reference any database object

PV.PV_PG_MMBR_TRANSITIONS is referenced by following:

APPS
SYNONYM - PV_PG_MMBR_TRANSITIONS

[top of page]

Table: PV_PRD_BIN_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PARENT_RESOURCE_ID NUMBER

CATEGORY_ID NUMBER

CNT NUMBER

LINE_AMOUNT NUMBER

WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
PERIOD_TYPE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y
CURRENCY_CODE VARCHAR2 (15)
LEAD_LINE_ID NUMBER

[top of page]

APPS.PV_PRD_BIN_MV does not reference any database object

APPS.PV_PRD_BIN_MV is not referenced by any database object

[top of page]

Table: PV_PRD_BIN_SUM_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PARENT_RESOURCE_ID NUMBER

CATEGORY_ID NUMBER

LCNT NUMBER

TOTAL_AMOUNT NUMBER

WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
PERIOD_TYPE VARCHAR2 (15) Y
PERIOD_NAME VARCHAR2 (15) Y
CURRENCY_CODE VARCHAR2 (15)

[top of page]

APPS.PV_PRD_BIN_SUM_MV does not reference any database object

APPS.PV_PRD_BIN_SUM_MV is not referenced by any database object

[top of page]

Table: PV_PROCESS_RULES_B

Description: Process Rules
Primary Key: PV_PROCESS_RULES_B_PK
  1. PROCESS_RULE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_ENTITY_RULES_APPLIED.PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_ENTITY_RULES_APPLIED.PARENT_PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_ENTITY_ATTR_MAPPINGS.PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_PARTNER_PROGRAM_B.PREREQ_PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_ENTITY_ROUTINGS.PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_ENTY_SELECT_CRITERIA.PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_PARTNER_PROGRAM_B.PROCESS_RULE_ID PV_PROCESS_RULES_B
PV_PROCESS_RULES_TL.PROCESS_RULE_ID PV_PROCESS_RULES_B
Comments

PV_PROCESS_RULES_B Stores matching rules information

Indexes
Index Type Tablespace Column
PV_PROCESS_RULES_B_U1 UNIQUE APPS_TS_TX_IDX PROCESS_RULE_ID
PV_PROCESS_RULES_B_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_RULE_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_RULE_ID NUMBER
Y Process rule identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER

Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last date this record was updated by a concurrent program
PARENT_RULE_ID NUMBER

Parent rule identfier
PROCESS_TYPE VARCHAR2 (30) Y Process Type, the value are partner matching, lead rating etc. Lookup type = 'PV_PROCESS_TYPE'
RANK NUMBER

Rank for a rule
STATUS_CODE VARCHAR2 (30)
Rule Status code, Lookup type = 'PV_RULE_STATUS_CODE'
START_DATE DATE

Start date for a rule
END_DATE DATE

End date for a rule
ACTION VARCHAR2 (500)
The update statement that gets executed when a condition matches.
ACTION_VALUE VARCHAR2 (15)
This is a bind variable to the update statement stored in the action column.
OWNER_RESOURCE_ID NUMBER

Owner resource identifier, value stored here is from jtf_rs_resource_extns.
CURRENCY_CODE VARCHAR2 (15)
Currency code defined for a rule
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield structure definition
SECURITY_GROUP_ID NUMBER

Security Group Identifier

[top of page]

PV.PV_PROCESS_RULES_B does not reference any database object

PV.PV_PROCESS_RULES_B is referenced by following:

APPS
SYNONYM - PV_PROCESS_RULES_B

[top of page]

Table: PV_PROCESS_RULES_TL

Description: Process rule name and description
Primary Key: PV_PROCESS_RULES_TL_PK
  1. PROCESS_RULE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PROCESS_RULES_TL.PROCESS_RULE_ID PV_PROCESS_RULES_B
Comments

PV_PROCESS_RULES_TL stores the name and description of the attributes codes with a multilingal support.

Indexes
Index Type Tablespace Column
PV_PROCESS_RULES_TL_U1 UNIQUE APPS_TS_TX_IDX PROCESS_RULE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PROCESS_RULE_ID NUMBER
Y Process rule identifier, foreign key from PV_PROCESS_RULES_B.PROCESS_RULE_ID
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
PROCESS_RULE_NAME VARCHAR2 (100) Y Process rule name
DESCRIPTION VARCHAR2 (500)
Process Description
LANGUAGE VARCHAR2 (4) Y Language being translated to
SOURCE_LANG VARCHAR2 (4)
Source Language
SECURITY_GROUP_ID NUMBER

Security Group Identifier

[top of page]

PV.PV_PROCESS_RULES_TL does not reference any database object

PV.PV_PROCESS_RULES_TL is referenced by following:

APPS
SYNONYM - PV_PROCESS_RULES_TL

[top of page]

Table: PV_PROGRAM_BENEFITS

Description: Program benefits
Primary Key: PV_PROGRAM_BENEFITS_PK
  1. PROGRAM_BENEFITS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PROGRAM_BENEFITS.BENEFIT_ID PV_GE_BENEFITS_B
PV_PROGRAM_BENEFITS.PROGRAM_ID PV_PARTNER_PROGRAM_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_GE_PTNR_RESPS.SOURCE_RESP_MAP_RULE_ID PV_PROGRAM_BENEFITS
Comments

Holds information about benefits associated with each partner program and are available to partners after they join the program. The benefits information is stored in FND_LOOKUP.

Indexes
Index Type Tablespace Column
PV_PROGRAM_BENEFITS_U1 UNIQUE APPS_TS_TX_IDX PROGRAM_BENEFITS_ID
PV_PROGRAM_BENEFITS_N1 NONUNIQUE APPS_TS_TX_IDX PROGRAM_ID
Columns
Name Datatype Length Mandatory Comments
PROGRAM_BENEFITS_ID NUMBER
Y Program benefits id
PROGRAM_ID NUMBER
Y Program id
BENEFIT_CODE VARCHAR2 (30)
Benefit code
LAST_UPDATE_DATE DATE
Y Last update date
LAST_UPDATED_BY NUMBER
Y Last updated by
CREATION_DATE DATE
Y Creation date
CREATED_BY NUMBER
Y Created by
LAST_UPDATE_LOGIN NUMBER
Y Last update login
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
SECURITY_GROUP_ID NUMBER

Security group id
BENEFIT_ID NUMBER
Y Benefit ID.
BENEFIT_TYPE_CODE VARCHAR2 (30) Y Benefit type code. It comes from PV_GE_BENEFITS_B and PV_GE_BENEFITS_TL.
DELETE_FLAG VARCHAR2 (1) Y Indicate whether the corresponding program benefit has been soft deleted

[top of page]

PV.PV_PROGRAM_BENEFITS does not reference any database object

PV.PV_PROGRAM_BENEFITS is referenced by following:

APPS
SYNONYM - PV_PROGRAM_BENEFITS

[top of page]

Table: PV_PROGRAM_CONTRACTS

Description: Program contracts
Primary Key: PV_PROGRAM_CONTRACTS_PK
  1. PROGRAM_CONTRACTS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PROGRAM_CONTRACTS.PROGRAM_ID PV_PARTNER_PROGRAM_B
PV_PROGRAM_CONTRACTS.PROGRAM_ID PV_PARTNER_PROGRAM_B
Comments

This table holds information about the Contracts that are associated with each partner program. The actual contract is stored in the contracts module but the association with a partner program is stored here.

Indexes
Index Type Tablespace Column
PV_PROGRAM_CONTRACTS_U1 UNIQUE APPS_TS_TX_IDX PROGRAM_CONTRACTS_ID
PV_PROGRAM_CONTRACTS_U2 UNIQUE APPS_TS_TX_IDX PROGRAM_ID
GEO_HIERARCHY_ID
MEMBER_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
PROGRAM_CONTRACTS_ID NUMBER
Y Program contracts id
PROGRAM_ID NUMBER
Y Program id
GEO_HIERARCHY_ID NUMBER
Y Geographic hierarchy id
CONTRACT_ID NUMBER
Y Contract id
DEFAULT_CONTRACT_FLAG VARCHAR2 (1)
LAST_UPDATE_DATE DATE
Y Last update date
LAST_UPDATED_BY NUMBER
Y Last updated by
CREATION_DATE DATE
Y Creation date
CREATED_BY NUMBER
Y Created by
LAST_UPDATE_LOGIN NUMBER
Y Last update login
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
MEMBER_TYPE_CODE VARCHAR2 (30) Y Partner member type code.

[top of page]

PV.PV_PROGRAM_CONTRACTS does not reference any database object

PV.PV_PROGRAM_CONTRACTS is referenced by following:

APPS
SYNONYM - PV_PROGRAM_CONTRACTS

[top of page]

Table: PV_PROGRAM_PARTNER_TYPES

Description: Program Partner Types
Primary Key: PV_PROGRAM_PARTNER_TYPES_PK
  1. PROGRAM_PARTNER_TYPES_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PROGRAM_PARTNER_TYPES.PROGRAM_TYPE_ID PV_PARTNER_PROGRAM_TYPE_B
Comments

Table to hold information about the partner types that are targets of each partner program

Indexes
Index Type Tablespace Column
PV_PROGRAM_PARTNER_TYPES_U1 UNIQUE APPS_TS_TX_IDX PROGRAM_PARTNER_TYPES_ID
PV_PROGRAM_PARTNER_TYPES_U2 UNIQUE APPS_TS_TX_IDX PROGRAM_TYPE_ID
PARTNER_TYPE
Columns
Name Datatype Length Mandatory Comments
PROGRAM_PARTNER_TYPES_ID NUMBER
Y Program partner types id
PROGRAM_TYPE_ID NUMBER
Y Program type id
PARTNER_TYPE VARCHAR2 (30) Y Partner type
LAST_UPDATE_DATE DATE
Y Last update date
LAST_UPDATED_BY NUMBER
Y Last updated by
CREATION_DATE DATE
Y Creation date
CREATED_BY NUMBER
Y Created by
LAST_UPDATE_LOGIN NUMBER
Y Last update login
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
SECURITY_GROUP_ID NUMBER

Security group id

[top of page]

PV.PV_PROGRAM_PARTNER_TYPES does not reference any database object

PV.PV_PROGRAM_PARTNER_TYPES is referenced by following:

APPS
SYNONYM - PV_PROGRAM_PARTNER_TYPES

[top of page]

Table: PV_PROGRAM_PAYMENT_MODE

Description: Partner Program - payment mode
Primary Key: PV_PROGRAM_PAYMENT_MODE_PK
  1. PROGRAM_PAYMENT_MODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_PROGRAM_PAYMENT_MODE.PROGRAM_ID PV_PARTNER_PROGRAM_B
Comments

Table to hold information about valid payment mode for each country.

Indexes
Index Type Tablespace Column
PV_PROGRAM_PAYMENT_MODE_U1 UNIQUE APPS_TS_TX_IDX PROGRAM_PAYMENT_MODE_ID
PV_PROGRAM_PAYMENT_MODE_N1 NONUNIQUE APPS_TS_TX_IDX PROGRAM_ID
GEO_HIERARCHY_ID
Columns
Name Datatype Length Mandatory Comments
PROGRAM_PAYMENT_MODE_ID NUMBER
Y Program payment mode id
PROGRAM_ID NUMBER

Program id
GEO_HIERARCHY_ID NUMBER
Y Geo hierarchy id
MODE_OF_PAYMENT VARCHAR2 (15) Y Mode of payment
LAST_UPDATE_DATE DATE
Y Last update date
LAST_UPDATED_BY NUMBER
Y Last updated by
CREATION_DATE DATE
Y Creation date
CREATED_BY NUMBER
Y Created by
LAST_UPDATE_LOGIN NUMBER
Y Last update login
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
SECURITY_GROUP_ID NUMBER

Security Group id
MODE_TYPE VARCHAR2 (15)
Type of mode

[top of page]

PV.PV_PROGRAM_PAYMENT_MODE does not reference any database object

PV.PV_PROGRAM_PAYMENT_MODE is referenced by following:

APPS
SYNONYM - PV_PROGRAM_PAYMENT_MODE

[top of page]

Table: PV_REFERRALS_B

Description: Referrals base table
Primary Key: PV_REFERRALS_B_PK
  1. REFERRAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_REFERRALS_B.PARTNER_CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
PV_REFERRALS_B.ENTITY_ID_LINKED_TO AS_LEADS_ALL
PV_REFERRALS_B.BENEFIT_ID PV_GE_BENEFITS_B
PV_REFERRALS_B.PARTNER_CONTACT_RESOURCE_ID JTF_RS_RESOURCE_EXTNS
PV_REFERRALS_B.ENTITY_ID_LINKED_TO AS_SALES_LEADS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PV_GE_QSNR_ELEMENTS_B.USED_BY_ENTITY_ID PV_REFERRALS_B
PV_REFERRALS_TL.REFERRAL_ID PV_REFERRALS_B
PV_REFERRED_PRODUCTS.REFERRAL_ID PV_REFERRALS_B
Comments

This table stores referral information for a partner.

Indexes
Index Type Tablespace Column
PV_REFERRALS_B_U2 UNIQUE APPS_TS_TX_IDX REFERRAL_CODE
PV_REFERRALS_B_N1 NONUNIQUE APPS_TS_TX_IDX CLAIM_ID
PV_REFERRALS_B_N2 NONUNIQUE APPS_TS_TX_IDX ORDER_ID
PV_REFERRALS_B_N3 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_PARTY_ID
PV_REFERRALS_B_N4 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_CONTACT_PARTY_ID
PV_REFERRALS_B_N5 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_ORG_CONTACT_ID
PV_REFERRALS_B_N6 NONUNIQUE APPS_TS_TX_IDX CUSTOMER_PARTY_SITE_ID
PV_REFERRALS_B_N7 NONUNIQUE APPS_TS_TX_IDX PARTNER_ID
PV_REFERRALS_B_N8 NONUNIQUE APPS_TS_TX_IDX PARTNER_CUST_ACCOUNT_ID
PV_REFERRALS_B_U1 NONUNIQUE APPS_TS_TX_IDX REFERRAL_ID
Columns
Name Datatype Length Mandatory Comments
REFERRAL_ID NUMBER
Y Referral identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
BENEFIT_ID NUMBER
Y Benefit identifier
REFERRAL_CODE VARCHAR2 (50) Y Referral code
REFERRAL_STATUS VARCHAR2 (30) Y Referral status
PARTNER_ID NUMBER
Y Partner identifier
PARTNER_CONTACT_RESOURCE_ID NUMBER
Y 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) Y 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) Y 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) Y BEnefit Type Code
STATUS_CHANGE_DATE DATE
Y Status Change Date
DUPLICATE_CUSTOMER_FLAG VARCHAR2 (1)
Duplicate customer flag
ORG_ID NUMBER

Organization identifer
PARTNER_CUST_ACCOUNT_ID NUMBER (15) Y 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

[top of page]

PV.PV_REFERRALS_B does not reference any database object

PV.PV_REFERRALS_B is referenced by following:

APPS
SYNONYM - PV_REFERRALS_B

[top of page]

Table: PV_REFERRALS_TL

Description: Referrals translated table
Primary Key: PV_REFERRALS_TL
  1. REFERRAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_REFERRALS_TL.REFERRAL_ID PV_REFERRALS_B
Comments

This table stores referral information for a partner.

Indexes
Index Type Tablespace Column
PV_REFERRALS_TL_U1 NONUNIQUE APPS_TS_TX_IDX REFERRAL_ID
Columns
Name Datatype Length Mandatory Comments
REFERRAL_ID NUMBER
Y Referral identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
REFERRAL_NAME VARCHAR2 (100) Y Referral name
DESCRIPTION VARCHAR2 (500) Y Referral description
LANGUAGE VARCHAR2 (4) Y Language translated to
SOURCE_LANG VARCHAR2 (4)
Source language
SECURITY_GROUP_ID NUMBER

Security group identifier

[top of page]

PV.PV_REFERRALS_TL does not reference any database object

PV.PV_REFERRALS_TL is referenced by following:

APPS
SYNONYM - PV_REFERRALS_TL

[top of page]

Table: PV_REFERRAL_STATUS_MAPS

Description: Referral status map
Primary Key: PV_REFERRAL_STATUS_MAPS_PK
  1. REFERRAL_STATUS_MAP_ID
Comments

This table stores referral status code mapping.

Indexes
Index Type Tablespace Column
PV_REFERRAL_STATUS_MAPS_U1 UNIQUE APPS_TS_TX_IDX REFERRAL_STATUS_MAP_ID
Columns
Name Datatype Length Mandatory Comments
REFERRAL_STATUS_MAP_ID NUMBER
Y Referral status map identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
BENEFIT_TYPE VARCHAR2 (30)
Benefit type
STATUS_CODE VARCHAR2 (100)
Status code
MAP_STATUS_CODE VARCHAR2 (100)
Map status code
SECURITY_GROUP_ID NUMBER

Security group identifier

[top of page]

PV.PV_REFERRAL_STATUS_MAPS does not reference any database object

PV.PV_REFERRAL_STATUS_MAPS is referenced by following:

APPS
SYNONYM - PV_REFERRAL_STATUS_MAPS

[top of page]

Table: PV_REFERRED_PRODUCTS

Description: Referred products
Primary Key: PV_REFERRED_PRODUCTS_PK
  1. REFERRED_PRODUCT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_REFERRED_PRODUCTS.REFERRAL_ID PV_REFERRALS_B
Comments

This table stores the product categories used by the referral. The product categories selected here are restricted to the product categories and their children in the product hierarchy specified in the benefit to which this referral is created from. The benefit's product categories are stored in pv_benft_products.

Indexes
Index Type Tablespace Column
PV_REFERRED_PRODUCTS_N1 NONUNIQUE APPS_TS_TX_IDX REFERRAL_ID
PV_REFERRED_PRODUCTS_U1 NONUNIQUE APPS_TS_TX_IDX REFERRED_PRODUCT_ID
Columns
Name Datatype Length Mandatory Comments
REFERRED_PRODUCT_ID NUMBER
Y Referred products identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
QUANTITY NUMBER

Quantity
AMOUNT NUMBER

Amount
REFERRAL_ID NUMBER
Y Referral identifier
SECURITY_GROUP_ID NUMBER

Security group identifier
PRODUCT_CATEGORY_ID NUMBER
Y Product category identifier
PRODUCT_CATEGORY_SET_ID NUMBER
Y Product category set identifier
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

[top of page]

PV.PV_REFERRED_PRODUCTS does not reference any database object

PV.PV_REFERRED_PRODUCTS is referenced by following:

APPS
SYNONYM - PV_REFERRED_PRODUCTS

[top of page]

Table: PV_RELATIONSHIPS

Description: Supplier to Partner relationship
Primary Key: PV_RELATIONSHIPS_PK
  1. RELATIONSHIP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_RELATIONSHIPS.SUBJECT_ID JTF_RS_RESOURCE_EXTNS
PV_RELATIONSHIPS.OBJECT_ID HZ_PARTIES
Comments
Indexes
Index Type Tablespace Column
PV_RELATIONSHIPS_U1 UNIQUE APPS_TS_TX_IDX RELATIONSHIP_ID
PV_RELATIONSHIPS_N1 NONUNIQUE APPS_TS_TX_IDX SUBJECT_ID
PV_RELATIONSHIPS_N2 NONUNIQUE APPS_TS_TX_IDX OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
RELATIONSHIP_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y
SUBJECT_ID NUMBER (15) Y
SUBJECT_TYPE VARCHAR2 (30)
OBJECT_ID NUMBER (15)
OBJECT_TYPE VARCHAR2 (30)
RELATIONSHIP_TYPE VARCHAR2 (30)
SECURITY_GROUP_ID NUMBER (15)

[top of page]

PV.PV_RELATIONSHIPS does not reference any database object

PV.PV_RELATIONSHIPS is referenced by following:

APPS
SYNONYM - PV_RELATIONSHIPS

[top of page]

Table: PV_ROLLUP_MGR_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
MANAGER_PERSON_ID NUMBER

PARENT_RESOURCE_ID NUMBER

PERSON_ID NUMBER

RESOURCE_ID NUMBER
Y
GROUP_ID NUMBER
Y
EXCNT NUMBER

[top of page]

APPS.PV_ROLLUP_MGR_MV does not reference any database object

APPS.PV_ROLLUP_MGR_MV is not referenced by any database object

[top of page]

Table: PV_SEARCH_ATTR_MIRROR

Description: Partner Attribute Text
Primary Key: PV_SEARCH_ATTR_MIRROR_PK
  1. SEARCH_ATTR_VALUES_ID
Comments

The mirror table of pv_search_attr_values.

Indexes
Index Type Tablespace Column
PV_SEARCH_ATTR_VALUES_U1_M UNIQUE APPS_TS_TX_IDX SEARCH_ATTR_VALUES_ID
PV_SEARCH_ATTR_VALUES_U2_M UNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
SYS_NC00014$
ATTR_VALUE
PARTY_ID
PV_SEARCH_ATTR_VALUES_U3_M UNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
ATTR_VALUE
SYS_NC00014$
PARTY_ID
PV_SEARCH_ATTR_VALUES_N4_M NONUNIQUE APPS_TS_TX_IDX PARTY_ID
ATTRIBUTE_ID
Columns
Name Datatype Length Mandatory Comments
SEARCH_ATTR_VALUES_ID NUMBER
Y Attribute Value Identifier
PARTY_ID NUMBER
Y Party Identifier
SHORT_NAME VARCHAR2 (60)
Attribute short name
ATTR_TEXT VARCHAR2 (2000)
Partner Attributes
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
SECURITY_GROUP_ID NUMBER

Standard Who column
ATTRIBUTE_ID NUMBER
Y Attribute identifier, foreign key to pv_attributes_vl.attribute_id
ATTR_VALUE NUMBER

Attribute value

[top of page]

PV.PV_SEARCH_ATTR_MIRROR does not reference any database object

PV.PV_SEARCH_ATTR_MIRROR is referenced by following:

APPS
SYNONYM - PV_SEARCH_ATTR_MIRROR

[top of page]

Table: PV_SEARCH_ATTR_VALUES

Description: Partner Attribute Text
Primary Key: PV_SEARCH_ATTR_VALUES_PK
  1. SEARCH_ATTR_VALUES_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_SEARCH_ATTR_VALUES.PARTY_ID HZ_PARTIES
PV_SEARCH_ATTR_VALUES.ATTRIBUTE_ID PV_ATTRIBUTES_B
Comments

PV_SEARCH_ATTR_VALUES stores the Partner Attributes used for Matching of Opportunities to the Partners

Indexes
Index Type Tablespace Column
PV_SEARCH_ATTR_VALUES_U1 UNIQUE APPS_TS_TX_IDX SEARCH_ATTR_VALUES_ID
PV_SEARCH_ATTR_VALUES_U2 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
SYS_NC00014$
ATTR_VALUE
PARTY_ID
PV_SEARCH_ATTR_VALUES_U3 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
ATTR_VALUE
SYS_NC00014$
PARTY_ID
PV_SEARCH_ATTR_VALUES_N4 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
ATTRIBUTE_ID
Columns
Name Datatype Length Mandatory Comments
SEARCH_ATTR_VALUES_ID NUMBER
Y Attribute Value Identifier
PARTY_ID NUMBER
Y Party Identifier
SHORT_NAME VARCHAR2 (60)
Attribute short name
ATTR_TEXT VARCHAR2 (2000)
Partner Attributes
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
SECURITY_GROUP_ID NUMBER

Standard Who column
ATTRIBUTE_ID NUMBER (15) Y Attribute identifier, foreign key to pv_attributes_vl.attribute_id
ATTR_VALUE NUMBER

Attribute value

[top of page]

PV.PV_SEARCH_ATTR_VALUES does not reference any database object

PV.PV_SEARCH_ATTR_VALUES is referenced by following:

APPS
SYNONYM - PV_SEARCH_ATTR_VALUES

[top of page]

Table: PV_SELECTED_ATTR_VALUES

Description: Attribute values defined for mapping
Primary Key: PV_SELECTED_ATTR_VALUES_PK
  1. ATTR_VALUE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PV_SELECTED_ATTR_VALUES.SELECTION_CRITERIA_ID PV_ENTY_SELECT_CRITERIA
Comments

PV_SELECTED_ATTR_VALUES Stores attribute values for attributes defined in pv_enty_select_criteria

Indexes
Index Type Tablespace Column
PV_SELECTED_ATTR_VALUES_U1 UNIQUE APPS_TS_TX_IDX ATTR_VALUE_ID
PV_SELECTED_ATTR_VALUES_N1 NONUNIQUE APPS_TS_TX_IDX SELECTION_CRITERIA_ID
Columns
Name Datatype Length Mandatory Comments
ATTR_VALUE_ID NUMBER
Y Attribute value identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER

Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last date this record was updated by a concurrent program
SELECTION_CRITERIA_ID NUMBER
Y Selection criteria identifier, Foreign key to pv_enty_select_criteria.selection_criteria_id
ATTRIBUTE_VALUE VARCHAR2 (2000)
Attribute value
ATTRIBUTE_TO_VALUE VARCHAR2 (500)
Used for attribute values that return NUMBER or DATE only when the operator is BETWEEN.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield structure definition
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield structure definition
SECURITY_GROUP_ID NUMBER

Security Group Identifier
SCORE NUMBER

This is used in interaction selection rule.

[top of page]

PV.PV_SELECTED_ATTR_VALUES does not reference any database object

PV.PV_SELECTED_ATTR_VALUES is referenced by following:

APPS
SYNONYM - PV_SELECTED_ATTR_VALUES

[top of page]

Table: PV_SINGLE_PROD_H_MAPPINGS

Description: Single product hierarchy temporary mapping table
Primary Key: PV_SINGLE_PROD_H_MAPPINGS_PK
  1. ENTY_ATTR_VAL_ID
Comments

Stores the mappings of Sales Product Hierachy and Single Product Hierarchy for pv_enty_attr_values.

Indexes
Index Type Tablespace Column
PV_SINGLE_PROD_H_MAPPINGS_U1 UNIQUE APPS_TS_INTERFACE ENTY_ATTR_VAL_ID
Columns
Name Datatype Length Mandatory Comments
ENTY_ATTR_VAL_ID NUMBER (15) Y Entity identifier
NEW_VALUE NUMBER
Y Attribute identifier
OLD_VALUE VARCHAR2 (500) Y Type of entity (ex: partner,lead)

[top of page]

PV.PV_SINGLE_PROD_H_MAPPINGS does not reference any database object

PV.PV_SINGLE_PROD_H_MAPPINGS is referenced by following:

APPS
SYNONYM - PV_SINGLE_PROD_H_MAPPINGS

[top of page]

Table: PV_SINGLE_PROD_H_MAPPINGS2

Description: Single product hierarchy temporary mapping table
Primary Key: PV_SINGLE_PROD_H_MAPPINGS2_PK
  1. ATTR_VALUE_ID
Comments

Stores the mappings of Sales Product Hierachy and Single Product Hierarchy for pv_selected_attr_values.

Indexes
Index Type Tablespace Column
PV_SINGLE_PROD_H_MAPPINGS2_U1 UNIQUE APPS_TS_INTERFACE ATTR_VALUE_ID
Columns
Name Datatype Length Mandatory Comments
ATTR_VALUE_ID NUMBER
Y Entity identifier
NEW_VALUE NUMBER
Y Attribute identifier
OLD_VALUE VARCHAR2 (500) Y Type of entity (ex: partner,lead)

[top of page]

PV.PV_SINGLE_PROD_H_MAPPINGS2 does not reference any database object

PV.PV_SINGLE_PROD_H_MAPPINGS2 is referenced by following:

APPS
SYNONYM - PV_SINGLE_PROD_H_MAPPINGS2

[top of page]

Table: PV_SLBINAMT_SUM_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PARENT_RESOURCE_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
TOTAL_AMOUNT NUMBER

CURRENCY_CODE VARCHAR2 (15)
LCNT NUMBER

[top of page]

APPS.PV_SLBINAMT_SUM_MV does not reference any database object

APPS.PV_SLBINAMT_SUM_MV is not referenced by any database object

[top of page]

Table: PV_SL_BIN_MV

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
PARENT_RESOURCE_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Y
PERIOD_TYPE VARCHAR2 (15) Y
CURRENCY_CODE VARCHAR2 (15)
TOTAL_AMOUNT NUMBER

LEAD_ID NUMBER
Y
CHANNEL_CODE VARCHAR2 (30)
CUSTOMER_ID NUMBER
Y
LINE_AMOUNT NUMBER

LEAD_LINE_ID NUMBER

SOURCE_PROMOTION_ID NUMBER

PARTY_NAME VARCHAR2 (360) Y
PARTY_ID NUMBER (15) Y
DESCRIPTION VARCHAR2 (240)
CATEGORY_ID NUMBER

OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
WIN_LOSS_INDICATOR VARCHAR2 (1)
PARTNER_ID NUMBER (15) Y
ROUTING_STATUS VARCHAR2 (30)
STATUS VARCHAR2 (30) Y

[top of page]

APPS.PV_SL_BIN_MV does not reference any database object

APPS.PV_SL_BIN_MV is not referenced by any database object

[top of page]

Table: PV_STATUS_NOTIFICATIONS

Description: Status Notifications to Patners,CM's,AM,s
Primary Key: PV_STATUS_NOTIFICATIONS_PK
  1. STATUS_NOTIFICATION_ID
Comments

PV_STATUS_NOTIFICATIONS stores the Opportunity Statuses and Assignment Statuses used for sending the notifications to the Partners,Channel Managers and Account Managers.

Indexes
Index Type Tablespace Column
PV_STATUS_NOTIFICATIONS_U1 UNIQUE APPS_TS_TX_IDX STATUS_NOTIFICATION_ID
PV_STATUS_NOTIFICATIONS_U2 UNIQUE APPS_TS_TX_IDX STATUS_TYPE
STATUS_CODE
PV_STATUS_NOTIFICATIONS_N1 NONUNIQUE APPS_TS_TX_IDX STATUS_CODE
Columns
Name Datatype Length Mandatory Comments
STATUS_NOTIFICATION_ID NUMBER (15) Y Status notification identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y Object version number
STATUS_TYPE VARCHAR2 (60) Y Type of status, ex: Assignment,Opportunity
STATUS_CODE VARCHAR2 (30) Y Status code, ex: CM_APPROVED
SECURITY_GROUP_ID NUMBER (15)
Security group identifier
ENABLED_FLAG VARCHAR2 (1) Y Indicates whether the record is enabled or not
NOTIFY_PT_FLAG VARCHAR2 (1)
Partner notification flag, Y - if the partner is notified
NOTIFY_CM_FLAG VARCHAR2 (1)
Channel Manager notification flag, Y - if the Channel Manager is notified
NOTIFY_AM_FLAG VARCHAR2 (1)
Account manager notification flag, Y - if the Account manager is notified
NOTIFY_OTHERS_FLAG VARCHAR2 (1)
Set to Y, if the notfication is sent the member of the sales team to whom the notification was not yet sent

[top of page]

PV.PV_STATUS_NOTIFICATIONS does not reference any database object

PV.PV_STATUS_NOTIFICATIONS is referenced by following:

APPS
SYNONYM - PV_STATUS_NOTIFICATIONS

[top of page]

Table: PV_TAP_ACCESS_TERRS

Description: Holds territory definitions
Primary Key: PV_TAP_ACCESS_TERRS_PK
  1. PARTNER_ACCESS_ID
  2. TERR_ID
Comments

PV_TAP_ACCESS_TERRS stores the definition of the territories qualified
based on the partner qualifiers.

Indexes
Index Type Tablespace Column
PV_TAP_ACCESS_TERRS_U1 UNIQUE APPS_TS_TX_IDX PARTNER_ACCESS_ID
TERR_ID
Columns
Name Datatype Length Mandatory Comments
PARTNER_ACCESS_ID NUMBER
Y Unique Identifier for the Channel Team Member
TERR_ID NUMBER
Y Unique Identifier of the Territory
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Program Application Id
PROGRAM_ID NUMBER

Program Id
PROGRAM_UPDATE_DATE DATE

Program Update Date
SECURITY_GROUP_ID NUMBER

Security Group Id

[top of page]

PV.PV_TAP_ACCESS_TERRS does not reference any database object

PV.PV_TAP_ACCESS_TERRS is referenced by following:

APPS
SYNONYM - PV_TAP_ACCESS_TERRS

[top of page]

Table: PV_TAP_BATCH_CHG_PARTNERS

Description: Holds the updated partner information
Primary Key: PV_TAP_BATCH_CHG_PARTNERS_PK
  1. PARTNER_ID
Comments

Holds the updated partner information when either 'PV_TERRITORY_ASSIGNMENT_ONLINE' profile is set to'No' or if there is an update in the partner information from an Application (Other than PRM).

Indexes
Index Type Tablespace Column
PV_TAP_BATCH_CHG_PARTNERS_U1 UNIQUE APPS_TS_TX_IDX PARTNER_ID
PV_TAP_BATCH_CHG_PARTNERS_N1 NONUNIQUE APPS_TS_TX_IDX PROCESSED_FLAG
Columns
Name Datatype Length Mandatory Comments
PARTNER_ID NUMBER
Y Partner Id
VAD_PARTNER_ID NUMBER

Party_ID for the relationship between Partner of type VAD and Vendor
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_BY NUMBER
Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
CREATED_BY NUMBER
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER
Y Standard WHO column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Program Application Id
PROGRAM_ID NUMBER

Program Id
PROGRAM_UPDATE_DATE DATE

Program Update date
SECURITY_GROUP_ID NUMBER

Security Group Id
PROCESSED_FLAG VARCHAR2 (1)
Process Flag

[top of page]

PV.PV_TAP_BATCH_CHG_PARTNERS does not reference any database object

PV.PV_TAP_BATCH_CHG_PARTNERS is referenced by following:

APPS
SYNONYM - PV_TAP_BATCH_CHG_PARTNERS

[top of page]

Table: PV_USER_CUSTOM_ENTRIES

Description:
Comments

Table holds custom attributes for channel manager dashboard users

Indexes
Index Type Tablespace Column
PV_USER_CUSTOM_ENTRIES_U1 UNIQUE APPS_TS_TX_IDX ATTRIBUTE_ID
RESPONSIBILITY_ID
USER_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER

Holds USER_ID of user logged onto CM Dashbaord
DISPLAY_SEQUENCE NUMBER

Holds display sequence number of key Metric on CMDashboard
RESPONSIBILITY_ID NUMBER

Holds responsibility_id user logged onto CM Dashbaord
FUNCTION_ID NUMBER

ID of Function associated with the key metric
ATTRIBUTE_ID NUMBER

ID of Key meteric attribute
SECURITY_GROUP_ID NUMBER

Security Group Id
CREATED_BY NUMBER

Standard WHO Column
CREATION_DATE DATE

Standard WHO Column
LAST_UPDATED_BY NUMBER

Standard WHO Column
LAST_UPDATE_DATE DATE

Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column

[top of page]

PV.PV_USER_CUSTOM_ENTRIES does not reference any database object

PV.PV_USER_CUSTOM_ENTRIES is referenced by following:

APPS
SYNONYM - PV_USER_CUSTOM_ENTRIES

[top of page]

View: PV_ATTRIBUTES_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y who columns
LAST_UPDATED_BY NUMBER (15) Y who columns
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y
ENABLED_FLAG VARCHAR2 (1) Y
NAME VARCHAR2 (60)
DESCRIPTION VARCHAR2 (240)
SHORT_NAME VARCHAR2 (60)
ATTRIBUTE_TYPE VARCHAR2 (30)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
SEEDED_FLAG VARCHAR2 (1)
LOV_FUNCTION_NAME VARCHAR2 (30)
RETURN_TYPE VARCHAR2 (30)
MAX_VALUE_FLAG VARCHAR2 (1)
DISPLAY_STYLE VARCHAR2 (30)
EXPOSE_TO_PARTNER_FLAG VARCHAR2 (1)
CHARACTER_WIDTH NUMBER

DECIMAL_POINTS NUMBER

NO_OF_LINES NUMBER

VALUE_EXTN_RETURN_TYPE VARCHAR2 (30)
ENABLE_MATCHING_FLAG VARCHAR2 (1)
PERFORMANCE_FLAG VARCHAR2 (1)
ADDITIVE_FLAG VARCHAR2 (1)
SEQUENCE_NUMBER NUMBER

[top of page]

APPS.PV_ATTRIBUTES_VL references the following:

APPS
SYNONYM - PV_ATTRIBUTES_B
SYNONYM - PV_ATTRIBUTES_TL
APPS.PV_ATTRIBUTES_VL is referenced by following:

APPS
PACKAGE BODY - AML_LEAD_DEDUPE_PVT
PACKAGE BODY - PV_ATTRIBUTE_CODE_PVT
PACKAGE BODY - PV_ATTRIBUTE_PVT
PACKAGE BODY - PV_ATTRIBUTE_UTIL
PACKAGE BODY - PV_ATTR_VALIDATION_PUB
PACKAGE BODY - PV_CHECK_MATCH_PUB
PACKAGE BODY - PV_CMDASHBOARD_UTIL
PACKAGE BODY - PV_CONTEXT_VALUES
PACKAGE BODY - PV_ENRL_PREREQ_BINS_PUB
PACKAGE BODY - PV_ENTITY_ATTRIBUTE_PVT
VIEW - PV_ENTITY_ATTR_VAL_V
PACKAGE BODY - PV_ENTY_ATTR_VALUE_PUB
PACKAGE BODY - PV_ENTY_ATTR_VALUE_PVT
PACKAGE BODY - PV_MATCH_PARTNER
PACKAGE BODY - PV_MATCH_V3_PUB
PACKAGE BODY - PV_OPP_MATCH_PUB
PACKAGE BODY - PV_SELCRIT_PVT

[top of page]

View: PV_ATTRIBUTE_CODES_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ATTR_CODE_ID NUMBER (15) Y
ATTR_CODE VARCHAR2 (30) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER
Y
DESCRIPTION VARCHAR2 (240) Y
ATTRIBUTE_ID NUMBER
Y
ENABLED_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

AUTO_ASSIGN_FLAG VARCHAR2 (1)

[top of page]

APPS.PV_ATTRIBUTE_CODES_VL references the following:

APPS
SYNONYM - PV_ATTRIBUTE_CODES_B
SYNONYM - PV_ATTRIBUTE_CODES_TL
APPS.PV_ATTRIBUTE_CODES_VL is referenced by following:

APPS
VIEW - AST_PTR_RELATION_DETAILS_V
VIEW - AST_SALES_TEAM_PTR_V
PACKAGE BODY - PV_ATTRIBUTE_CODE_PVT
PACKAGE BODY - PV_ATTRIBUTE_PVT
PACKAGE BODY - PV_CHECK_MATCH_PUB
PACKAGE BODY - PV_MATCH_V3_PUB
PACKAGE BODY - PV_PG_MEMBERSHIPS_PVT
PACKAGE BODY - PV_PTR_MEMBER_TYPE_PVT
PACKAGE BODY - PV_TERR_ASSIGN_PUB

[top of page]

View: PV_ATTRIBUTE_USAGES_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_USAGE_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

OBJECT_VERSION_NUMBER NUMBER
Y
ATTRIBUTE_USAGE_TYPE VARCHAR2 (30) Y
ATTRIBUTE_USAGE_CODE VARCHAR2 (30) Y
ATTRIBUTE_ID NUMBER (15) Y
ENABLED_FLAG VARCHAR2 (1) Y

[top of page]

APPS.PV_ATTRIBUTE_USAGES_V references the following:

APPS
SYNONYM - PV_ATTRIBUTE_USAGES

APPS.PV_ATTRIBUTE_USAGES_V is not referenced by any database object

[top of page]

View: PV_ENTITY_ATTRS_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
ENTITY_ATTR_ID NUMBER (15) Y Entity identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y
ATTRIBUTE_ID NUMBER (15) Y Attribute identifier
ENTITY VARCHAR2 (30) Y Type of entity (ex: partner,lead)
SQL_TEXT VARCHAR2 (2000)
Contains a sql text that returns values associated with a lead or partner
ATTR_DATA_TYPE VARCHAR2 (30)
Data source from which the entity is defined
LOV_STRING VARCHAR2 (2000)
Contains a sql text that is used in displaying LOV on mannual matching screens
ENABLED_FLAG VARCHAR2 (1) Y The entity-attributes row is enabled or not
ITEM_STYLE VARCHAR2 (30)
Item style to be used while rendering the attribute
SELECTION_TYPE VARCHAR2 (1)
Item style to be used while rendering the attribute
DISPLAY_FLAG VARCHAR2 (1) Y Flag to restrict the contents based on the roles
LOCATOR_FLAG VARCHAR2 (1)
ENTITY_TYPE VARCHAR2 (30)

[top of page]

APPS.PV_ENTITY_ATTRS_V references the following:

APPS
SYNONYM - PV_ENTITY_ATTRS

APPS.PV_ENTITY_ATTRS_V is not referenced by any database object

[top of page]

View: PV_ENTITY_ATTR_VAL_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
ENTY_ATTR_VAL_ID NUMBER (15) Y Entity attribute values identifier
ENTITY VARCHAR2 (50) Y Entity type
ENTITY_ID NUMBER (15) Y Could be either partner or lead depends on the entity type
ATTRIBUTE_ID NUMBER (15) Y Attribute identifier
ATTR_NAME VARCHAR2 (60)
Attribute Name
ATTR_DESCRIPTION VARCHAR2 (240)
Attribute Description
ENABLED_FLAG VARCHAR2 (1) Y Enabled Flag to indicate whether the attribute is enabled or not
SCORE VARCHAR2 (30)
Score for the partner experties
ATTR_VALUE VARCHAR2 (2000)
Partner experties

[top of page]

APPS.PV_ENTITY_ATTR_VAL_V references the following:

APPS
VIEW - PV_ATTRIBUTES_VL
SYNONYM - PV_ENTY_ATTR_VALUES

APPS.PV_ENTITY_ATTR_VAL_V is not referenced by any database object

[top of page]

View: PV_ENTY_ATTR_VALUES_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
ENTY_ATTR_VAL_ID NUMBER (15) Y Entity attribute values identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
ENTITY VARCHAR2 (50) Y Entity type
ATTRIBUTE_ID NUMBER (15) Y Attribute identifier
PARTY_ID NUMBER (15)
Party/Partner identifier
ATTR_VALUE VARCHAR2 (2000)
Partner experties
SCORE VARCHAR2 (30)
Score to measure the partner experties
ENABLED_FLAG VARCHAR2 (1) Y Flag indicates whether the partner attribute values are enabled or not
ENTITY_ID NUMBER (15) Y Could be either partner or lead depends on the entity type

[top of page]

APPS.PV_ENTY_ATTR_VALUES_V references the following:

APPS
SYNONYM - PV_ENTY_ATTR_VALUES

APPS.PV_ENTY_ATTR_VALUES_V is not referenced by any database object

[top of page]

View: PV_GE_BENEFITS_VL

Comments
View Type

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

View for PV_GE_BENEFITS_B and TL table

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id
BENEFIT_ID NUMBER
Y Benefit Id
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
BENEFIT_TYPE_CODE VARCHAR2 (30) Y Benefit Type Code
BENEFIT_STATUS_CODE VARCHAR2 (30) Y Benefit Status Code
BENEFIT_CODE VARCHAR2 (30)
Benefit Code
DELETE_FLAG VARCHAR2 (1) Y Delete Flag for benefit
ADDITIONAL_INFO_1 NUMBER (15)
Additional Info 1
ADDITIONAL_INFO_2 VARCHAR2 (240)
Additional Info 2
CREATED_BY NUMBER (15) Y Standard WHO column
CREATION_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Attribute category
ATTRIBUTE1 VARCHAR2 (240)
Attribute1
ATTRIBUTE2 VARCHAR2 (240)
Attribute2
ATTRIBUTE3 VARCHAR2 (240)
Attribute3
ATTRIBUTE4 VARCHAR2 (240)
Attribute4
ATTRIBUTE5 VARCHAR2 (240)
Attribute5
ATTRIBUTE6 VARCHAR2 (240)
Attribute6
ATTRIBUTE7 VARCHAR2 (240)
Attribute7
ATTRIBUTE8 VARCHAR2 (240)
Attribute8
ATTRIBUTE9 VARCHAR2 (240)
Attribute9
ATTRIBUTE10 VARCHAR2 (240)
Attribute10
ATTRIBUTE11 VARCHAR2 (240)
Attribute11
ATTRIBUTE12 VARCHAR2 (240)
Attribute12
ATTRIBUTE13 VARCHAR2 (240)
Attribute13
ATTRIBUTE14 VARCHAR2 (240)
Attribute14
ATTRIBUTE15 VARCHAR2 (240)
Attribute15
BENEFIT_NAME VARCHAR2 (2000)
Benefit Name
DESCRIPTION VARCHAR2 (2000)
Benefit Description

[top of page]

APPS.PV_GE_BENEFITS_VL references the following:

APPS
SYNONYM - PV_GE_BENEFITS_B
SYNONYM - PV_GE_BENEFITS_TL
APPS.PV_GE_BENEFITS_VL is referenced by following:

APPS
PACKAGE BODY - OZF_NET_ACCRUAL_ENGINE_PVT
PACKAGE BODY - PV_GE_BENEFITS_PKG
PACKAGE BODY - PV_REFERRAL_COMP_PUB
PACKAGE BODY - PV_REFERRAL_GENERAL_PUB

[top of page]

View: PV_GE_CHKLST_ITEMS_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CHECKLIST_ITEM_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
ARC_USED_BY_ENTITY_CODE VARCHAR2 (30) Y
USED_BY_ENTITY_ID NUMBER
Y
SEQUENCE_NUM NUMBER
Y
IS_REQUIRED_FLAG VARCHAR2 (1) Y
ENABLED_FLAG VARCHAR2 (1) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
CHECKLIST_ITEM_NAME VARCHAR2 (2000) Y

[top of page]

APPS.PV_GE_CHKLST_ITEMS_VL references the following:

APPS
SYNONYM - PV_GE_CHKLST_ITEMS_B
SYNONYM - PV_GE_CHKLST_ITEMS_TL
APPS.PV_GE_CHKLST_ITEMS_VL is referenced by following:

APPS
PACKAGE BODY - PV_GE_CHKLST_PVT

[top of page]

View: PV_GE_HISTORY_LOG_VL

Comments
View Type

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

Standard Multi-language View.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ENTITY_HISTORY_LOG_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
ARC_HISTORY_FOR_ENTITY_CODE VARCHAR2 (30) Y
HISTORY_FOR_ENTITY_ID NUMBER
Y
MESSAGE_CODE VARCHAR2 (30) Y Will contain NULL for DEBUG messages
HISTORY_CATEGORY_CODE VARCHAR2 (30)
PARTNER_ID NUMBER
Y
ACCESS_LEVEL_FLAG VARCHAR2 (1) Y
INTERACTION_LEVEL NUMBER
Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
COMMENTS VARCHAR2 (2000)

[top of page]

APPS.PV_GE_HISTORY_LOG_VL references the following:

APPS
SYNONYM - PV_GE_HISTORY_LOG_B
SYNONYM - PV_GE_HISTORY_LOG_TL
APPS.PV_GE_HISTORY_LOG_VL is referenced by following:

APPS
PACKAGE BODY - PV_BENFT_STATUS_CHANGE

[top of page]

View: PV_GE_NOTIF_RULES_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
NOTIF_RULE_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
ARC_NOTIF_FOR_ENTITY_CODE VARCHAR2 (30) Y
NOTIF_FOR_ENTITY_ID NUMBER
Y
WF_ITEM_TYPE_CODE VARCHAR2 (30)
NOTIF_TYPE_CODE VARCHAR2 (30) Y
ACTIVE_FLAG VARCHAR2 (1) Y
REPEAT_FREQ_UNIT VARCHAR2 (30)
REPEAT_FREQ_VALUE NUMBER

SEND_NOTIF_BEFORE_UNIT VARCHAR2 (30)
SEND_NOTIF_BEFORE_VALUE NUMBER

SEND_NOTIF_AFTER_UNIT VARCHAR2 (30)
SEND_NOTIF_AFTER_VALUE NUMBER

REPEAT_UNTIL_UNIT VARCHAR2 (30)
REPEAT_UNTIL_VALUE NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
NOTIF_NAME VARCHAR2 (240) Y
NOTIF_CONTENT VARCHAR2 (2000) Y
NOTIF_DESC VARCHAR2 (2000)

[top of page]

APPS.PV_GE_NOTIF_RULES_VL references the following:

APPS
SYNONYM - PV_GE_NOTIF_RULES_B
SYNONYM - PV_GE_NOTIF_RULES_TL
APPS.PV_GE_NOTIF_RULES_VL is referenced by following:

APPS
PACKAGE BODY - PV_PG_NOTIF_UTILITY_PVT

[top of page]

View: PV_GE_QSNR_ELEMENTS_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
QSNR_ELEMENT_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
ARC_USED_BY_ENTITY_CODE VARCHAR2 (30) Y
USED_BY_ENTITY_ID NUMBER
Y
ENTITY_ATTR_ID NUMBER

QSNR_ELMT_SEQ_NUM NUMBER (9) Y
QSNR_ELMT_TYPE VARCHAR2 (30) Y
QSNR_ELMT_PAGE_NUM NUMBER (9) Y
IS_REQUIRED_FLAG VARCHAR2 (1) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
ELMT_CONTENT VARCHAR2 (2000)

[top of page]

APPS.PV_GE_QSNR_ELEMENTS_VL references the following:

APPS
SYNONYM - PV_GE_QSNR_ELEMENTS_B
SYNONYM - PV_GE_QSNR_ELEMENTS_TL
APPS.PV_GE_QSNR_ELEMENTS_VL is referenced by following:

APPS
PACKAGE BODY - PV_GQ_ELEMENTS_PVT

[top of page]

View: PV_LEAD_PSS_LINES_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
LEAD_PSS_LINE_ID NUMBER (15) Y Partner solutions or/and services lead identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Y
REQUEST_ID NUMBER (15)
Standard Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update record
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

Last date concurrent program updated record
ATTR_CODE_ID NUMBER (15) Y Attribute code identifier
LEAD_ID NUMBER (15)
Lead or sales lead identifier
UOM_CODE VARCHAR2 (3)
Units of measurements
QUANTITY NUMBER

Partner solutions or/and service quantity
AMOUNT NUMBER

Partner solutions or/and service amount
OBJECT_NAME VARCHAR2 (30) Y Identifies whether it is a lead or an opportunity
ATTR_CODE VARCHAR2 (30) Y Attribute code
DESCRIPTION VARCHAR2 (240) Y Attribute code Description
ATTRIBUTE_ID NUMBER
Y Attribute identifier
ENABLED_FLAG VARCHAR2 (1) Y Flag to indicate whether the attribute code is in use or not
START_DATE_ACTIVE DATE

Date from which the attribute code is active
END_DATE_ACTIVE DATE

Date up to which the code remains active
AUTO_ASSIGN_FLAG VARCHAR2 (1)
Flag indicates whether the attribute is enabled for automatic matching
OBJECT_ID NUMBER

PARTNER_ID NUMBER

[top of page]

APPS.PV_LEAD_PSS_LINES_V references the following:

APPS
SYNONYM - PV_ATTRIBUTE_CODES_B
SYNONYM - PV_ATTRIBUTE_CODES_TL
SYNONYM - PV_LEAD_PSS_LINES

APPS.PV_LEAD_PSS_LINES_V is not referenced by any database object

[top of page]

View: PV_LOOKUPS

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Y QuickCode lookup type
LOOKUP_CODE VARCHAR2 (30) Y QuickCode code
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
MEANING VARCHAR2 (80) Y QuickCode meaning
ENABLED_FLAG VARCHAR2 (1) Y Enabled flag
START_DATE_ACTIVE DATE

The date when the QuickCode becomes active
END_DATE_ACTIVE DATE

The date when the QuickCode becomes inactive
DESCRIPTION VARCHAR2 (240)
Description
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute category
ATTRIBUTE1 VARCHAR2 (150)
Attribute
ATTRIBUTE2 VARCHAR2 (150)
Attribute
ATTRIBUTE3 VARCHAR2 (150)
Attribute
ATTRIBUTE4 VARCHAR2 (150)
Attribute
ATTRIBUTE5 VARCHAR2 (150)
Attribute
ATTRIBUTE6 VARCHAR2 (150)
Attribute
ATTRIBUTE7 VARCHAR2 (150)
Attribute
ATTRIBUTE8 VARCHAR2 (150)
Attribute
ATTRIBUTE9 VARCHAR2 (150)
Attribute
ATTRIBUTE10 VARCHAR2 (150)
Attribute
ATTRIBUTE11 VARCHAR2 (150)
Attribute
ATTRIBUTE12 VARCHAR2 (150)
Attribute
ATTRIBUTE13 VARCHAR2 (150)
Attribute
ATTRIBUTE14 VARCHAR2 (150)
Attribute
ATTRIBUTE15 VARCHAR2 (150)
Attribute
TAG VARCHAR2 (150)
Optional additional category for lookup values

[top of page]

APPS.PV_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_TYPES
SYNONYM - FND_LOOKUP_VALUES
APPS.PV_LOOKUPS is referenced by following:

APPS
PACKAGE BODY - PVX_UTILITY_PVT
PACKAGE BODY - PV_ASSIGNMENT_PUB
PACKAGE BODY - PV_ASSIGNMENT_PVT
PACKAGE BODY - PV_ATTRIBUTE_CODE_PVT
PACKAGE BODY - PV_ATTRIBUTE_PVT
PACKAGE BODY - PV_ENRL_REQUEST_ORDER_PUB
PACKAGE BODY - PV_ENTITY_ATTRIBUTE_PVT
PACKAGE BODY - PV_ENTY_ATTR_VALUE_PUB
PACKAGE BODY - PV_ENTY_ATTR_VALUE_PVT
PACKAGE BODY - PV_MATCH_V3_PUB
PACKAGE BODY - PV_OPPTY_ROUTING_LOG
PACKAGE BODY - PV_ORDER_MGMT_PVT
PACKAGE BODY - PV_PARTNER_CONTRACTS_PVT
PACKAGE BODY - PV_PRGM_PMT_MODE_PVT
PACKAGE BODY - PV_PRTNR_PMNT_TYPES_PVT
PACKAGE BODY - PV_RULE_EVALUATION_PUB
PACKAGE BODY - PV_SELCRIT_PVT
PACKAGE BODY - PV_SQL_UTILITY

[top of page]

View: PV_PARTNERS_ALL_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
INTERNAL_PARTY_ID NUMBER (15) Y Party identifier
INTERNAL_PARTY_NAME VARCHAR2 (360) Y Name of this party
PARTNER_PARTY_ID NUMBER (15) Y Partner identifier
PARTNER_PARTY_NAME VARCHAR2 (360) Y 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) Y Partner ralationship identifier
RELATIONSHIP_TYPE VARCHAR2 (30) Y 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

[top of page]

APPS.PV_PARTNERS_ALL_V references the following:

APPS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - PV_PARTNER_PROFILES

APPS.PV_PARTNERS_ALL_V is not referenced by any database object

[top of page]

View: PV_PARTNERS_LOV_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER (15) Y Party identifier
ID2 CHAR (1)
DESCRIPTION VARCHAR2 (30) Y
PARTY_NUMBER VARCHAR2 (30) Y
NAME VARCHAR2 (360)
PARTY_TYPE VARCHAR2 (30)
B_STATUS VARCHAR2 (1) Y
STATUS VARCHAR2 (1) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

COUNTRY VARCHAR2 (60)
ADDRESS1 VARCHAR2 (240)
ADDRESS2 VARCHAR2 (240)
ADDRESS3 VARCHAR2 (240)
ADDRESS4 VARCHAR2 (240)
CITY VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
STATE VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
COUNTY VARCHAR2 (60)

[top of page]

APPS.PV_PARTNERS_LOV_V references the following:

APPS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - PV_PARTNER_PROFILES

APPS.PV_PARTNERS_LOV_V is not referenced by any database object

[top of page]

View: PV_PARTNERS_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
INTERNAL_PARTY_ID NUMBER (15) Y Party identifier
INTERNAL_PARTY_NAME VARCHAR2 (360) Y Name of this party
PARTNER_PARTY_ID NUMBER (15) Y Party identifier
PARTNER_PARTY_NAME VARCHAR2 (360) Y 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) Y The unique identifier of a relationship
RELATIONSHIP_TYPE VARCHAR2 (30) Y Either a forward or a backward relationship code
PARTNER_PROFILE_ID NUMBER
Y Partner profile identifier
PRF_LAST_UPDATE_DATE DATE
Y Standard Who column
PRF_CREATION_DATE DATE
Y Standard Who column
PRF_OBJECT_VERSION_NUMBER NUMBER
Y Object version number
PARTNER_ID NUMBER
Y 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) Y 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) Y
PARTNER_STATUS VARCHAR2 (1) Y
RELATIONSHIP_STATUS VARCHAR2 (1) Y
RELATIONSHIP_DIRECTION VARCHAR2 (1) Y
PARTNER_INTERNAL_FLAG VARCHAR2 (1)
PARTNER_ORG_ID NUMBER

VAD_FLAG VARCHAR2 (1)

[top of page]

APPS.PV_PARTNERS_V references the following:

APPS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - PV_ENTY_ATTR_VALUES
SYNONYM - PV_PARTNER_PROFILES
APPS.PV_PARTNERS_V is referenced by following:

APPS
PACKAGE BODY - AMS_ACTPARTNER_PVT
PACKAGE BODY - AS_SALES_LEAD_OPP_PVT

[top of page]

View: PV_PARTNER_BUSINESS_USERS_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER

User Id from FND_USER
USER_NAME VARCHAR2 (100)
USer Name from FND USER for a Resource.
PARTNER_ID NUMBER
Y Partner identifier
RESOURCE_ID NUMBER
Y Resource Identifier

[top of page]

APPS.PV_PARTNER_BUSINESS_USERS_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - JTF_AUTH_DOMAINS_B
SYNONYM - JTF_AUTH_PERMISSIONS_B
SYNONYM - JTF_AUTH_PRINCIPALS_B
SYNONYM - JTF_AUTH_PRINCIPAL_MAPS
SYNONYM - JTF_AUTH_ROLE_PERMS
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - PV_PARTNER_PROFILES
APPS.PV_PARTNER_BUSINESS_USERS_V is referenced by following:

APPS
PACKAGE BODY - PV_USER_RESP_PVT

[top of page]

View: PV_PARTNER_CONTACTS_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER (15)
Party identifier
ID2 CHAR (1)
B_STATUS VARCHAR2 (1)
STATUS VARCHAR2 (1)
PARTY_ID NUMBER (15) Y
PARTY_ID2 CHAR (1)
PARTY_NUMBER VARCHAR2 (30) Y
NAME VARCHAR2 (360) Y
DESCRIPTION VARCHAR2 (360) Y
PARTY_TYPE VARCHAR2 (30) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

PARTNER_PARTY_ID NUMBER

[top of page]

APPS.PV_PARTNER_CONTACTS_V references the following:

APPS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - PV_PARTNER_PROFILES

APPS.PV_PARTNER_CONTACTS_V is not referenced by any database object

[top of page]

View: PV_PARTNER_LOV_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
PARTY_NAME VARCHAR2 (360) Y Party name
PARTY_NUMBER VARCHAR2 (30) Y Party number
PARTY_ID NUMBER (15) Y Party identifier
LOCATION_ID NUMBER (15)
Location identifier
SITE_ID NUMBER (15)
Site identifier
SITE_USE_ID NUMBER (15)
Site in use identifier
ADDRESS1 VARCHAR2 (240)
First line for address
ADDRESS2 VARCHAR2 (240)
Second line for address
ADDRESS3 VARCHAR2 (240)
Third line for address
ADDRESS4 VARCHAR2 (240)
Fourth line for address
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
POSTAL_CODE VARCHAR2 (60)
Postal code
COUNTY VARCHAR2 (60)
County
COUNTRY VARCHAR2 (60)
Country
SITE_USE_TYPE VARCHAR2 (30)
Site use type
IDENTIFYING_ADDRESS_FLAG VARCHAR2 (1)
Indicates if this is the identifying address for the party. Y for the indentifying, N for sites that are not the indentifying site
STATUS VARCHAR2 (1)
Party site status flag.
PARTY_TYPE VARCHAR2 (30) Y The party type can only be Person, Organization, Group or Relationship.

[top of page]

APPS.PV_PARTNER_LOV_V references the following:

APPS
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - HZ_PARTY_SITE_USES

APPS.PV_PARTNER_LOV_V is not referenced by any database object

[top of page]

View: PV_PARTNER_PRIMARY_USERS_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER

User Id from FND_USER
USER_NAME VARCHAR2 (100)
USer Name from FND USER for a Resource.
PARTNER_ID NUMBER
Y Partner identifier
RESOURCE_ID NUMBER
Y Resource Identifier

[top of page]

APPS.PV_PARTNER_PRIMARY_USERS_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - JTF_AUTH_DOMAINS_B
SYNONYM - JTF_AUTH_PERMISSIONS_B
SYNONYM - JTF_AUTH_PRINCIPALS_B
SYNONYM - JTF_AUTH_PRINCIPAL_MAPS
SYNONYM - JTF_AUTH_ROLE_PERMS
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - PV_PARTNER_PROFILES
APPS.PV_PARTNER_PRIMARY_USERS_V is referenced by following:

APPS
PACKAGE BODY - PV_PG_NOTIF_UTILITY_PVT
PACKAGE BODY - PV_PRGM_APPROVAL_PVT
PACKAGE BODY - PV_USER_RESP_PVT

[top of page]

View: PV_PARTNER_PROGRAM_TYPE_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROGRAM_TYPE_ID NUMBER
Y
ACTIVE_FLAG VARCHAR2 (1) Y
ENABLED_FLAG VARCHAR2 (1) Y
OBJECT_VERSION_NUMBER NUMBER

CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_LOGIN NUMBER
Y
PROGRAM_TYPE_NAME VARCHAR2 (60) Y
PROGRAM_TYPE_DESCRIPTION VARCHAR2 (240)

[top of page]

APPS.PV_PARTNER_PROGRAM_TYPE_VL references the following:

APPS
SYNONYM - PV_PARTNER_PROGRAM_TYPE_B
SYNONYM - PV_PARTNER_PROGRAM_TYPE_TL
APPS.PV_PARTNER_PROGRAM_TYPE_VL is referenced by following:

APPS
PACKAGE BODY - PV_PARTNER_PGM_TYPE_PVT
PACKAGE BODY - PV_PRGM_APPROVAL_PVT

[top of page]

View: PV_PARTNER_PROGRAM_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROGRAM_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
PROGRAM_PARENT_ID NUMBER

CUSTOM_SETUP_ID NUMBER
Y
PROGRAM_OWNER_RESOURCE_ID NUMBER
Y
PROGRAM_TYPE_ID NUMBER
Y
PROGRAM_LEVEL_CODE VARCHAR2 (30) Y
PROGRAM_STATUS_CODE VARCHAR2 (30) Y
ENABLED_FLAG VARCHAR2 (1) Y
PROGRAM_START_DATE DATE
Y
PROGRAM_END_DATE DATE
Y
PROCESS_RULE_ID NUMBER
Y
USER_STATUS_ID NUMBER
Y
MEMBERSHIP_PERIOD_UNIT VARCHAR2 (30)
MEMBERSHIP_VALID_PERIOD NUMBER

SUBMIT_CHILD_NODES VARCHAR2 (1)
INVENTORY_ITEM_ID NUMBER

INVENTORY_ITEM_ORG_ID NUMBER (32)
ADMIN_RESP_ID NUMBER

BUS_USER_RESP_ID NUMBER

NO_FEE_FLAG VARCHAR2 (1)
QSNR_TTL_ALL_PAGE_DSP_FLAG VARCHAR2 (1)
QSNR_HDR_ALL_PAGE_DSP_FLAG VARCHAR2 (1)
QSNR_FTR_ALL_PAGE_DSP_FLAG VARCHAR2 (1)
ALLOW_ENRL_WOUT_CHKLST_FLAG VARCHAR2 (1)
ALLOW_ENRL_UNTIL_DATE DATE

VAD_INVITE_ALLOW_FLAG NUMBER

CITEM_VERSION_ID VARCHAR2 (1)
GLOBAL_MMBR_REQD_FLAG VARCHAR2 (1)
WAIVE_SUBSIDIARY_FEE_FLAG VARCHAR2 (1)
ATTRIBUTE_CATEGORY NUMBER

PREREQ_PROCESS_RULE_ID VARCHAR2 (240)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
PROGRAM_NAME VARCHAR2 (60)
PROGRAM_DESCRIPTION VARCHAR2 (240)
QSNR_TITLE VARCHAR2 (240)
QSNR_HEADER VARCHAR2 (2000)
QSNR_FOOTER VARCHAR2 (2000)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
ID1 NUMBER
Y
ID2 CHAR (1)
DESCRIPTION VARCHAR2 (240)
NAME VARCHAR2 (60)
START_DATE_ACTIVE DATE
Y
END_DATE_ACTIVE DATE
Y

[top of page]

APPS.PV_PARTNER_PROGRAM_V references the following:

APPS
SYNONYM - PV_PARTNER_PROGRAM_B
SYNONYM - PV_PARTNER_PROGRAM_TL

APPS.PV_PARTNER_PROGRAM_V is not referenced by any database object

[top of page]

View: PV_PARTNER_PROGRAM_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROGRAM_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
CUSTOM_SETUP_ID NUMBER
Y
PROGRAM_PARENT_ID NUMBER

PROGRAM_OWNER_RESOURCE_ID NUMBER
Y
PROGRAM_TYPE_ID NUMBER
Y
PROGRAM_LEVEL_CODE VARCHAR2 (30) Y
PROGRAM_STATUS_CODE VARCHAR2 (30) Y
ENABLED_FLAG VARCHAR2 (1) Y
PROGRAM_START_DATE DATE
Y
PROGRAM_END_DATE DATE
Y
PROCESS_RULE_ID NUMBER
Y
USER_STATUS_ID NUMBER
Y
MEMBERSHIP_PERIOD_UNIT VARCHAR2 (30)
MEMBERSHIP_VALID_PERIOD NUMBER

SUBMIT_CHILD_NODES VARCHAR2 (1)
INVENTORY_ITEM_ID NUMBER

INVENTORY_ITEM_ORG_ID NUMBER (32)
BUS_USER_RESP_ID NUMBER

ADMIN_RESP_ID NUMBER

NO_FEE_FLAG VARCHAR2 (1)
QSNR_TTL_ALL_PAGE_DSP_FLAG VARCHAR2 (1)
QSNR_HDR_ALL_PAGE_DSP_FLAG VARCHAR2 (1)
QSNR_FTR_ALL_PAGE_DSP_FLAG VARCHAR2 (1)
ALLOW_ENRL_WOUT_CHKLST_FLAG VARCHAR2 (1)
ALLOW_ENRL_UNTIL_DATE DATE

CITEM_VERSION_ID NUMBER

VAD_INVITE_ALLOW_FLAG VARCHAR2 (1)
GLOBAL_MMBR_REQD_FLAG VARCHAR2 (1)
WAIVE_SUBSIDIARY_FEE_FLAG VARCHAR2 (1)
PREREQ_PROCESS_RULE_ID NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Attribute category
ATTRIBUTE1 VARCHAR2 (240)
Attribute1
ATTRIBUTE2 VARCHAR2 (240)
Attribute2
ATTRIBUTE3 VARCHAR2 (240)
Attribute3
ATTRIBUTE4 VARCHAR2 (240)
Attribute4
ATTRIBUTE5 VARCHAR2 (240)
Attribute5
ATTRIBUTE6 VARCHAR2 (240)
Attribute6
ATTRIBUTE7 VARCHAR2 (240)
Attribute7
ATTRIBUTE8 VARCHAR2 (240)
Attribute8
ATTRIBUTE9 VARCHAR2 (240)
Attribute9
ATTRIBUTE10 VARCHAR2 (240)
Attribute10
ATTRIBUTE11 VARCHAR2 (240)
Attribute11
ATTRIBUTE12 VARCHAR2 (240)
Attribute12
ATTRIBUTE13 VARCHAR2 (240)
Attribute13
ATTRIBUTE14 VARCHAR2 (240)
Attribute14
ATTRIBUTE15 VARCHAR2 (240)
Attribute15
PROGRAM_NAME VARCHAR2 (60)
Program name
PROGRAM_DESCRIPTION VARCHAR2 (240)
Program description
QSNR_TITLE VARCHAR2 (240)
QSNR_HEADER VARCHAR2 (2000)
QSNR_FOOTER VARCHAR2 (2000)

[top of page]

APPS.PV_PARTNER_PROGRAM_VL references the following:

APPS
SYNONYM - PV_PARTNER_PROGRAM_B
SYNONYM - PV_PARTNER_PROGRAM_TL
APPS.PV_PARTNER_PROGRAM_VL is referenced by following:

APPS
PACKAGE BODY - PV_ATTRIBUTE_CODE_PVT
PACKAGE BODY - PV_ENRQ_BINS_PVT
PACKAGE BODY - PV_ENTITY_ATTRIBUTE_PVT
PACKAGE BODY - PV_PARTNER_PROGRAM_PVT
PACKAGE BODY - PV_PG_MEMBERSHIPS_PVT
PACKAGE BODY - PV_PG_NOTIF_UTILITY_PVT
PACKAGE BODY - PV_PRGM_APPROVAL_PVT
PACKAGE BODY - PV_PRICE_PVT

[top of page]

View: PV_PARTNER_VENDORS_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER (15) Y Party identifier
ID2 CHAR (1)
DESCRIPTION VARCHAR2 (30) Y
PARTY_NUMBER VARCHAR2 (30) Y
NAME VARCHAR2 (360) Y
PARTY_TYPE VARCHAR2 (30) Y
B_STATUS VARCHAR2 (1) Y
STATUS VARCHAR2 (1) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

[top of page]

APPS.PV_PARTNER_VENDORS_V references the following:

APPS
SYNONYM - HZ_ORGANIZATION_PROFILES
SYNONYM - HZ_PARTIES

APPS.PV_PARTNER_VENDORS_V is not referenced by any database object

[top of page]

View: PV_PG_INVITE_HEADERS_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
INVITE_HEADER_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
QP_LIST_HEADER_ID VARCHAR2 (30)
INVITE_TYPE_CODE VARCHAR2 (30)
INVITE_FOR_PROGRAM_ID NUMBER
Y
INVITED_BY_PARTNER_ID NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
EMAIL_CONTENT VARCHAR2 (2000)
TRXN_EXTENSION_ID NUMBER

[top of page]

APPS.PV_PG_INVITE_HEADERS_VL references the following:

APPS
SYNONYM - PV_PG_INVITE_HEADERS_B
SYNONYM - PV_PG_INVITE_HEADERS_TL

APPS.PV_PG_INVITE_HEADERS_VL is not referenced by any database object

[top of page]

View: PV_PROCESS_RULES_VL

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
PROCESS_RULE_ID NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER
Y
LAST_UPDATE_LOGIN NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER
Y
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PARENT_RULE_ID NUMBER

PROCESS_TYPE VARCHAR2 (30) Y
RANK NUMBER

STATUS_CODE VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

ACTION VARCHAR2 (500)
ACTION_VALUE VARCHAR2 (15)
OWNER_RESOURCE_ID NUMBER

DESCRIPTION VARCHAR2 (500)
CURRENCY_CODE VARCHAR2 (15)
PROCESS_RULE_NAME VARCHAR2 (100) Y

[top of page]

APPS.PV_PROCESS_RULES_VL references the following:

APPS
SYNONYM - PV_PROCESS_RULES_B
SYNONYM - PV_PROCESS_RULES_TL
APPS.PV_PROCESS_RULES_VL is referenced by following:

APPS
VIEW - AML_LEAD_PROCESS_REPT_V
PACKAGE BODY - PV_ATTRIBUTE_CODE_PVT
PACKAGE BODY - PV_ATTRIBUTE_PVT
PACKAGE BODY - PV_BG_PARTNER_MATCHING_PUB
PACKAGE BODY - PV_MATCH_V3_PUB
PACKAGE BODY - PV_OPP_MATCH_PUB
PACKAGE BODY - PV_PARTNER_PROGRAM_PVT
PACKAGE BODY - PV_PROCESS_RULE_PVT
PACKAGE BODY - PV_RULE_EVALUATION_PUB
PACKAGE BODY - PV_SELCRIT_PVT

[top of page]

View: PV_PRTNR_SALES_TEAM_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE
Y Standard Who column
CONTACT_PARTY_ID NUMBER (15)
Party identifier
TEAM_LEADER_FLAG VARCHAR2 (1) Y Indicates whether the contact is a team lead or not
FREEZE_FLAG VARCHAR2 (1) Y 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
Y Customer/prospect identifier
SALESFORCE_ID NUMBER
Y 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
Y 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) Y Party name
PARTNER_ORG_PARTY_ID NUMBER (15) Y Party identifier
PARTNER_ORG_NAME VARCHAR2 (360) Y
JOB_TITLE_CODE VARCHAR2 (30)
Job Title code
PERSON_PARTY_ID NUMBER (15) Y Person identifier

[top of page]

APPS.PV_PRTNR_SALES_TEAM_V references the following:

APPS
VIEW - AS_ACCESSES_ALL
SYNONYM - FND_USER
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - HZ_RELATIONSHIPS
VIEW - JTF_RS_GROUPS_VL
SYNONYM - JTF_RS_RESOURCE_EXTNS

APPS.PV_PRTNR_SALES_TEAM_V is not referenced by any database object

[top of page]

View: PV_REFERRALS_VL

Comments
View Type

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

Standard Multi-language View.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Standard column used by OA Framework entity object
REFERRAL_ID NUMBER
Y Referral identifier
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER
Y Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Y Object version number
REFERRAL_NAME VARCHAR2 (100) Y Referral name
DESCRIPTION VARCHAR2 (500) Y Referral description
BENEFIT_ID NUMBER
Y Benefit identifier
REFERRAL_CODE VARCHAR2 (50) Y Referral code
REFERRAL_STATUS VARCHAR2 (30) Y Referral status
PARTNER_ID NUMBER
Y Partner identifier
PARTNER_CONTACT_RESOURCE_ID NUMBER
Y 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) Y 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) Y 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) Y Benefit type code (Referral or Deal Registration)
STATUS_CHANGE_DATE DATE
Y 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) Y 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

[top of page]

APPS.PV_REFERRALS_VL references the following:

APPS
SYNONYM - PV_REFERRALS_B
SYNONYM - PV_REFERRALS_TL
APPS.PV_REFERRALS_VL is referenced by following:

APPS
PACKAGE BODY - PV_REFERRAL_COMP_PUB
PACKAGE BODY - PV_REFERRAL_GENERAL_PUB

[top of page]

View: PV_RESOURCE_INFO_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
RSC_USER_ID NUMBER

User identifier from FND_USER
RSC_RESOURCE_ID NUMBER
Y Resource Identifier
RSC_CONTACT_ID NUMBER

Contact identifier - foreign key to HZ_ORG_CONTACTS.
RSC_CATEGORY_ID VARCHAR2 (30) Y Category of Resource. Validating from JTF_OBJECTS_VL. Allowed values: EMPLOYEE, PARTNER, PARTY, SUPPLIER_CONTACT, OTHER
RSC_RELATIONSHIP VARCHAR2 (30) Y The relationship type name. For example, CUSTOMER_SUPPLIER
RSC_PARTY_ID NUMBER (15) Y Party identifier
RSC_PARTY_NAME VARCHAR2 (360) Y Party name
PARTNER_PARTY_ID NUMBER (15) Y Partner identifier
PARTNER_PARTY_NAME VARCHAR2 (360) Y Partner name

[top of page]

APPS.PV_RESOURCE_INFO_V references the following:

APPS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - JTF_RS_RESOURCE_EXTNS
APPS.PV_RESOURCE_INFO_V is referenced by following:

APPS
PACKAGE BODY - OZF_BUDGETAPPROVAL_PVT

[top of page]

View: PV_ROUTING_HISTORY_V

Comments
***** 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

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER

Assignment identifier
ROUTING_EVENT VARCHAR2 (30)
Routing event (e.g. ACTIVE, ABANDONED, OFFERED, MATCHED, etc)
EVENT_DATE DATE

Event date
PARTNER_ID NUMBER

Partner identifier
CATEGORY VARCHAR2 (30)
Category (e.g. PARTY, EMPLOYEE)
LEAD_ID NUMBER (15)
Opportunity identifier
REASON_CODE VARCHAR2 (30)
Reason code
RESOURCE_NAME VARCHAR2 (0)
Resource name
LEAD_WF_ID NUMBER (15)
Lead workflow identifer
LAST_UPDATE_DATE DATE

Last update date
ORG_NAME VARCHAR2 (0)
Organization name
LAST_UPDATE_BY NUMBER (15)
Last update by
NOTIFICATION_CODE VARCHAR2 (2)
Notification code (e.g. CM, PT)
RESPONSE_CODE VARCHAR2 (30)
Response code
RESOURCE_ID NUMBER

Resouce identifier
ROUTING_STATUS VARCHAR2 (30)
Routing status
RESPONSE_MEANING VARCHAR2 (0)
Response code meaning
RESPONSE_DATE DATE

Response date
LATEST_ROUTING_FLAG VARCHAR2 (1)
Indicates whether the current record is the latest routing for the opportunity
ROUTING_TYPE VARCHAR2 (30)
Routing type (e.g. SINGLE, SERIAL)
BYPASS_CM_OK_FLAG VARCHAR2 (1)
Bypass channel manager approval flag

[top of page]

APPS.PV_ROUTING_HISTORY_V references the following:

APPS
SYNONYM - JTF_RS_RESOURCE_EXTNS
SYNONYM - PV_ASSIGNMENT_LOGS
SYNONYM - PV_LEAD_ASSIGNMENTS
SYNONYM - PV_LEAD_WORKFLOWS
SYNONYM - PV_PARTY_NOTIFICATIONS

APPS.PV_ROUTING_HISTORY_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract