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

[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

[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:

[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:

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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:

[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:

[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

[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

[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

[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

[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

[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

[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

[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 %

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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 %

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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:

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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 %

[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

[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

[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

[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

[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:

[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:

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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:

[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

[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

[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

[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

[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

[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:

[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:

[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

[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

[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

[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:

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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