PV Tables (86)
PV - Partner Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
PV_ACCESS_MIGRATION_LOG |
24 | Stores the external sales team migration rows |
PV_ALLOWED_STATUSES |
21 | This table is being obsoleted for 11.5.6 |
PV_ASSIGNMENT_LOGS |
26 | Lead assignments log |
PV_ATTRIBUTES_B |
26 | Partner attribute identifiers |
PV_ATTRIBUTES_TL |
13 | Partner attribute name and description |
PV_ATTRIBUTE_CODES_B |
15 | Partner attribute identifiers |
PV_ATTRIBUTE_CODES_TL |
12 | Partner Attribute Code name and description |
PV_ATTRIBUTE_USAGES |
16 | Attribute used for - Opportunity, Partner,Locator |
PV_ATTRIB_RESP_MAPPINGS |
14 | This table is used to store the attribute responsibility mappings. |
PV_ATTR_PRINCIPALS |
10 | This table stores association information between JTF Roles and Profile Attributes. This data is used to determine if the user has access to |
PV_BENFT_BUDGETS |
12 | Benefit Budgets |
PV_BENFT_PRODUCTS |
14 | Benefit Products |
PV_BENFT_STATUS_MAPS |
12 | Benefit status map |
PV_BENFT_THRESHOLDS |
14 | Benefit threshold |
PV_BENFT_USER_ROLE_MAPS |
12 | Benefit user role map |
PV_CHANNEL_TYPES |
32 | Channel Types (Direct/Indirect) |
PV_COUNTRY_RSBLTS |
15 | Supplier employee responsible for a country or regions in the country |
PV_COUNTRY_TIMEOUTS |
11 | Timeout periods based on the country |
PV_ENTITY_ATTRS |
31 | Entity attributes |
PV_ENTITY_ATTR_MAPPINGS |
34 | Entity attributes mapping |
PV_ENTITY_ATTR_MIRROR |
16 | Entity attributes |
PV_ENTITY_ATTR_TRENDS |
16 | Entity attributes |
PV_ENTITY_ROUTINGS |
40 | Entity Routings |
PV_ENTITY_RULES_APPLIED |
38 | Log table to store the rules applied to select the entity. Entity is an opportunity or partner. |
PV_ENTY_ATTR_VALIDATIONS |
11 | Entity Attributes table column validations |
PV_ENTY_ATTR_VALUES |
19 | Partner attribute values |
PV_ENTY_SELECT_CRITERIA |
34 | Entity selection criteria |
PV_GE_BENEFITS_B |
30 | Benfits and its status |
PV_GE_BENEFITS_TL |
11 | Translation table for Benefits |
PV_GE_CHKLST_ITEMS_B |
28 | Container for Task Items that needs to be checked. |
PV_GE_CHKLST_ITEMS_TL |
9 | Captures the translateable data for Check list items. |
PV_GE_CHKLST_RESPONSES |
11 | Container for responses to checklist items. |
PV_GE_HISTORY_LOG_B |
14 | Captures the transaction history log for a given entity. |
PV_GE_HISTORY_LOG_PARAMS |
12 | Container for token parameters of history log transaction. |
PV_GE_HISTORY_LOG_TL |
9 | Captures the translateable comments information for history log. |
PV_GE_NOTIF_RULES_B |
20 | Captures the notification rules for a given entity. |
PV_GE_NOTIF_RULES_TL |
11 | Captures the translateable information for notification rules. |
PV_GE_PARTY_NOTIFICATIONS |
13 | Container for notification details sent to a given partner. |
PV_GE_PTNR_RESPS |
13 | This table is used for storing partner responsibility mappings. |
PV_GE_QSNR_ELEMENTS_B |
14 | Container for questionnaire element details. |
PV_GE_QSNR_ELEMENTS_TL |
9 | Captures the translateable information for questionnaire elements. |
PV_GE_RESP_MAP_RULES |
12 | Table for responsibility mapping rules |
PV_GE_TEMP_APPROVERS |
13 | Container for approver related information for a given entity. |
PV_ITYPE_ATTR_MAPS |
11 | Interest type with attribute codes mapping |
PV_LEAD_ASSIGNMENTS |
25 | Lead assignments |
PV_LEAD_PSS_LINES |
36 | Partner services and solutions |
PV_LEAD_WORKFLOWS |
21 | Lead assignment notifications through workflow |
PV_MDF_OWNERS |
16 | Region allocation for a Channel Marketing Manager |
PV_NOTIFICATION_SETUPS |
13 | Notification setups |
PV_OPPTY_ROUTING_LOGS |
15 | This table is used to store the opportunity routing history |
PV_PARTNER_ACCESSES |
34 | Holds channel team member information |
PV_PARTNER_PROFILES |
38 | Partner profiles |
PV_PARTNER_PROGRAM_B |
52 | Captures partner program, and membership details |
PV_PARTNER_PROGRAM_TL |
14 | Partner Program - Translation table |
PV_PARTNER_PROGRAM_TYPE_B |
10 | Partner Program Type - base table |
PV_PARTNER_PROGRAM_TYPE_TL |
11 | Partner Program Type - translation table |
PV_PARTY_NOTIFICATIONS |
39 | Party Notifications |
PV_PG_ELIG_PROGRAMS |
10 | Eligible Programs |
PV_PG_ELIG_PROG_MIRR |
10 | Eligible Programs |
PV_PG_ENRL_CHANGE_RULES |
13 | Container for program's enrollment upgrade/downgrade rules. |
PV_PG_ENRL_REQUESTS |
44 | Container for enrollment requests submitted for membership into programs. |
PV_PG_ENRQ_INIT_SOURCES |
10 | Container to store iniation source details for enrollment request when it is upgraded or downgraded. |
PV_PG_INVITE_HEADERS_B |
15 | Container for storing invitations sent to partners for enrollment into programs. |
PV_PG_INVITE_HEADERS_TL |
9 | Contrainer for translatable data for invitation header. |
PV_PG_MEMBERSHIPS |
30 | Container for partner's program membership details. |
PV_PG_MMBR_TRANSITIONS |
9 | Contrainer for linking membership transitions |
PV_PROCESS_RULES_B |
39 | Process Rules |
PV_PROCESS_RULES_TL |
12 | Process rule name and description |
PV_PROGRAM_BENEFITS |
13 | Program benefits |
PV_PROGRAM_CONTRACTS |
12 | Program contracts |
PV_PROGRAM_PARTNER_TYPES |
10 | Program Partner Types |
PV_PROGRAM_PAYMENT_MODE |
12 | Partner Program - payment mode |
PV_REFERRALS_B |
81 | Referrals base table |
PV_REFERRALS_TL |
12 | Referrals translated table |
PV_REFERRAL_STATUS_MAPS |
12 | Referral status map |
PV_REFERRED_PRODUCTS |
38 | Referred products |
PV_RELATIONSHIPS |
13 | Supplier to Partner relationship |
PV_SEARCH_ATTR_MIRROR |
13 | Partner Attribute Text |
PV_SEARCH_ATTR_VALUES |
13 | Partner Attribute Text |
PV_SELECTED_ATTR_VALUES |
33 | Attribute values defined for mapping |
PV_SINGLE_PROD_H_MAPPINGS |
3 | Single product hierarchy temporary mapping table |
PV_SINGLE_PROD_H_MAPPINGS2 |
3 | Single product hierarchy temporary mapping table |
PV_STATUS_NOTIFICATIONS |
16 | Status Notifications to Patners,CM's,AM,s |
PV_TAP_ACCESS_TERRS |
13 | Holds territory definitions |
PV_TAP_BATCH_CHG_PARTNERS |
14 | Holds the updated partner information |
PV_USER_CUSTOM_ENTRIES |
11 | PV User - custom entries |