PRP Tables (28)
PRP - Proposals — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
PRP_COMPONENTS_B |
24 | This table contains the information about the components. |
PRP_COMPONENTS_TL |
10 | This table contains the translated information about the components. |
PRP_COMPONENT_STYLES_B |
27 | This table contains the information about the component styles. |
PRP_COMPONENT_STYLES_TL |
9 | This table contains the translated information about the component styles. |
PRP_COMP_STYLE_CTNTVERS |
15 | This table contains the associations between component style and physical document file in a given language. |
PRP_EMAIL_HISTORY |
19 | This table contains the history of all the eMail sent to customers with proposal document as attachment. |
PRP_EMAIL_RECIPIENTS |
16 | This table stores the information about the recipients of the email. Email can be sent to the contacts of the party of type 'ORGANIZATION' o |
PRP_GROUPS_B |
24 | This table contains information about the groups that are used to categorize tokens. |
PRP_GROUPS_TL |
11 | This table contains translated information about the groups that are used to categorize tokens. |
PRP_GROUP_TOKENS |
10 | This table contains the associations between tokens and groups. |
PRP_MIGRATION_HISTORY |
8 | This table stores the data migration history for Oracle Proposals |
PRP_MIGRATION_LOGS |
11 | This table stores the data migration logs for Oracle Proposals |
PRP_PERZ_FILES |
12 | This table represents the personalized files added by the sales representatives to the proposal |
PRP_PROPOSALS |
37 | This table contains the information about the proposals. |
PRP_PROPOSAL_CTNTVERS |
21 | This table contains the association between the proposal and the physical document file. |
PRP_PROPOSAL_OBJECTS |
12 | This table contains the association between the proposal and native objects like Quote, etc. |
PRP_PROPOSAL_TOKENS |
12 | This table contains the tokens that are used in proposal and their corresponding values. The tokens stored in this table are only "User Defi |
PRP_PROP_STYLE_CTNTVERS |
21 | This table represents the structure of the proposal. It contains the template components and files that are used in a proposal. Sales repres |
PRP_STYLE_CTNTVER_TOKENS |
10 | This table contains the tokens that are referenced by a component style document. This table is populated when the component document file i |
PRP_TEMPLATES_B |
26 | This table contains the information about the templates. |
PRP_TEMPLATES_TL |
10 | This table contains the translated information about the templates. |
PRP_TEMPLATE_CATGS_B |
24 | This table contains the base information about the template categories. |
PRP_TEMPLATE_CATGS_TL |
10 | This table contains the translated information about the template categories. |
PRP_TEMPLATE_COMPONENTS |
12 | This table contains the list of components associated with a template. |
PRP_TEMPLATE_LANG_ATTRS |
10 | This table contains the language related attributes for the template. |
PRP_TOKENS_B |
33 | This table contains the base information about the tokens. |
PRP_TOKENS_TL |
12 | This table contains the translated information about the tokens. |
PRP_TOKEN_VALUES_TL |
11 | This table contains the values for the "User Defined" tokens of type "List of Values". This table stores the list of values for each token i |