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 - PRP Tables and Views

TABLE - PRP.PRP_COMPONENTS_B
TABLE - PRP.PRP_COMPONENTS_TL
TABLE - PRP.PRP_COMPONENT_STYLES_B
TABLE - PRP.PRP_COMPONENT_STYLES_TL
TABLE - PRP.PRP_COMP_STYLE_CTNTVERS
TABLE - PRP.PRP_EMAIL_HISTORY
TABLE - PRP.PRP_EMAIL_RECIPIENTS
TABLE - PRP.PRP_GROUPS_B
TABLE - PRP.PRP_GROUPS_TL
TABLE - PRP.PRP_GROUP_TOKENS
TABLE - PRP.PRP_MIGRATION_HISTORY
TABLE - PRP.PRP_MIGRATION_LOGS
TABLE - PRP.PRP_PERZ_FILES
TABLE - PRP.PRP_PROPOSALS
TABLE - PRP.PRP_PROPOSAL_CTNTVERS
TABLE - PRP.PRP_PROPOSAL_OBJECTS
TABLE - PRP.PRP_PROPOSAL_TOKENS
TABLE - PRP.PRP_PROP_STYLE_CTNTVERS
TABLE - PRP.PRP_STYLE_CTNTVER_TOKENS
TABLE - PRP.PRP_TEMPLATES_B
TABLE - PRP.PRP_TEMPLATES_TL
TABLE - PRP.PRP_TEMPLATE_CATGS_B
TABLE - PRP.PRP_TEMPLATE_CATGS_TL
TABLE - PRP.PRP_TEMPLATE_COMPONENTS
TABLE - PRP.PRP_TEMPLATE_LANG_ATTRS
TABLE - PRP.PRP_TOKENS_B
TABLE - PRP.PRP_TOKENS_TL
TABLE - PRP.PRP_TOKEN_VALUES_TL
VIEW - APPS.PRP_COMPONENTS_VL
VIEW - APPS.PRP_COMPONENT_STYLES_VL
VIEW - APPS.PRP_GROUPS_VL
VIEW - APPS.PRP_PROP_CUSTOMERS_V
VIEW - APPS.PRP_PROP_OBJECTS_V
VIEW - APPS.PRP_TEMPLATES_VL
VIEW - APPS.PRP_TEMPLATE_CATGS_VL
VIEW - APPS.PRP_TOKENS_VL
VIEW - APPS.PRP_TOKEN_VALUES_VL

Table: PRP_COMPONENTS_B

Description: This table contains the information about the components.
Primary Key: PRP_COMPONENTS_B_PK
  1. COMPONENT_ID
Primary Key: PRP_COMPONENTS_B_UK1
  1. COMPONENT_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
PRP_COMPONENTS_TL.COMPONENT_ID PRP_COMPONENTS_B
PRP_COMPONENT_STYLES_B.COMPONENT_ID PRP_COMPONENTS_B
PRP_COMP_STYLE_CTNTVERS.COMPONENT_ID PRP_COMPONENTS_B
PRP_TEMPLATE_COMPONENTS.COMPONENT_ID PRP_COMPONENTS_B
Comments

This table contains the information about the components.

Indexes
Index Type Tablespace Column
PRP_COMPONENTS_B_U1 UNIQUE APPS_TS_TX_IDX COMPONENT_ID
PRP_COMPONENTS_B_U2 UNIQUE APPS_TS_TX_IDX COMPONENT_CODE
PRP_COMPONENTS_B_U999 UNIQUE APPS_TS_TX_IDX SYS_NC00025$
Columns
Name Datatype Length Mandatory Comments
COMPONENT_ID NUMBER
Y Component identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
COMPONENT_CODE VARCHAR2 (30) Y Component code
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield

[top of page]

PRP.PRP_COMPONENTS_B does not reference any database object

PRP.PRP_COMPONENTS_B is referenced by following:

APPS
SYNONYM - PRP_COMPONENTS_B

[top of page]

Table: PRP_COMPONENTS_TL

Description: This table contains the translated information about the components.
Primary Key: PRP_COMPONENTS_TL_PK
  1. COMPONENT_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_COMPONENTS_TL.COMPONENT_ID PRP_COMPONENTS_B
Comments

This table contains the translated information about the components.

Indexes
Index Type Tablespace Column
PRP_COMPONENTS_TL_U1 UNIQUE APPS_TS_TX_IDX COMPONENT_ID
LANGUAGE
PRP_COMPONENTS_TL_N999 NONUNIQUE APPS_TS_TX_IDX SYS_NC00011$
Columns
Name Datatype Length Mandatory Comments
COMPONENT_ID NUMBER
Y Component identifier
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source language
COMPONENT_NAME VARCHAR2 (240) Y Component name
COMPONENT_DESC VARCHAR2 (2000)
Component description
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_COMPONENTS_TL does not reference any database object

PRP.PRP_COMPONENTS_TL is referenced by following:

APPS
SYNONYM - PRP_COMPONENTS_TL

[top of page]

Table: PRP_COMPONENT_STYLES_B

Description: This table contains the information about the component styles.
Primary Key: PRP_COMPONENT_STYLES_B_PK
  1. COMPONENT_STYLE_ID
Primary Key: PRP_COMPONENT_STYLES_B_UK1
  1. COMPONENT_STYLE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_COMPONENT_STYLES_B.COMPONENT_ID PRP_COMPONENTS_B
PRP_COMPONENT_STYLES_B.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PRP_COMPONENT_STYLES_TL.COMPONENT_STYLE_ID PRP_COMPONENT_STYLES_B
PRP_COMP_STYLE_CTNTVERS.COMPONENT_STYLE_ID PRP_COMPONENT_STYLES_B
PRP_TEMPLATE_COMPONENTS.DEFAULT_COMP_STYLE_ID PRP_COMPONENT_STYLES_B
Comments

This table contains the information about the component styles.

Indexes
Index Type Tablespace Column
PRP_COMPONENT_STYLES_B_U1 UNIQUE APPS_TS_TX_IDX COMPONENT_STYLE_ID
PRP_COMPONENT_STYLES_B_U2 UNIQUE APPS_TS_TX_IDX COMPONENT_STYLE_CODE
PRP_COMPONENT_STYLES_B_N1 NONUNIQUE APPS_TS_TX_IDX COMPONENT_ID
Columns
Name Datatype Length Mandatory Comments
COMPONENT_STYLE_ID NUMBER
Y Component style identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
COMPONENT_ID NUMBER
Y Component to which component style belongs to
COMPONENT_STYLE_CODE VARCHAR2 (30)
Component style code
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
CONTENT_NODE_TYPE VARCHAR2 (10) Y Content Node Type -- 'HIDDEN' or 'SHARED'
CONTENT_ITEM_ID NUMBER

Content Item Identifier

[top of page]

PRP.PRP_COMPONENT_STYLES_B does not reference any database object

PRP.PRP_COMPONENT_STYLES_B is referenced by following:

APPS
SYNONYM - PRP_COMPONENT_STYLES_B

[top of page]

Table: PRP_COMPONENT_STYLES_TL

Description: This table contains the translated information about the component styles.
Primary Key: PRP_COMPONENT_STYLES_TL_PK
  1. COMPONENT_STYLE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_COMPONENT_STYLES_TL.COMPONENT_STYLE_ID PRP_COMPONENT_STYLES_B
Comments

This table contains the translated information about the component styles.

Indexes
Index Type Tablespace Column
PRP_COMPONENT_STYLES_TL_U1 UNIQUE APPS_TS_TX_IDX COMPONENT_STYLE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
COMPONENT_STYLE_ID NUMBER
Y Component style identifier
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source language
COMPONENT_STYLE_NAME VARCHAR2 (240)
Component style name
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_COMPONENT_STYLES_TL does not reference any database object

PRP.PRP_COMPONENT_STYLES_TL is referenced by following:

APPS
SYNONYM - PRP_COMPONENT_STYLES_TL

[top of page]

Table: PRP_COMP_STYLE_CTNTVERS

Description: This table contains the associations between component style and physical document file in a given language.
Primary Key: PRP_COMP_STYLE_CTNTVERS_PK
  1. COMP_STYLE_CTNTVER_ID
Primary Key: PRP_COMP_STYLE_CTNTVERS_UK1
  1. COMPONENT_STYLE_ID
  2. LANGUAGE
  3. VERSION_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_COMP_STYLE_CTNTVERS.COMPONENT_STYLE_ID PRP_COMPONENT_STYLES_B
PRP_COMP_STYLE_CTNTVERS.LANGUAGE FND_LANGUAGES
PRP_COMP_STYLE_CTNTVERS.FILE_ID FND_LOBS
PRP_COMP_STYLE_CTNTVERS.COMPONENT_ID PRP_COMPONENTS_B
PRP_COMP_STYLE_CTNTVERS.CITEM_VERSION_ID
PRP_COMP_STYLE_CTNTVERS.LANGUAGE
IBC_CITEM_VERSIONS_TL
Foreign Keys to this table:
Foreign Key Column Foreign Table
PRP_PROP_STYLE_CTNTVERS.OBJECT_ID PRP_COMP_STYLE_CTNTVERS
PRP_STYLE_CTNTVER_TOKENS.COMP_STYLE_CTNTVER_ID PRP_COMP_STYLE_CTNTVERS
Comments

This table contains the associations between component style and physical document file in a given language.

Indexes
Index Type Tablespace Column
PRP_COMP_STYLE_CTNTVERS_U1 UNIQUE APPS_TS_TX_IDX COMP_STYLE_CTNTVER_ID
PRP_COMP_STYLE_CTNTVERS_U2 UNIQUE APPS_TS_TX_IDX COMPONENT_STYLE_ID
LANGUAGE
VERSION_NUMBER
PRP_COMP_STYLE_CTNTVERS_N1 NONUNIQUE APPS_TS_TX_IDX COMPONENT_ID
Columns
Name Datatype Length Mandatory Comments
COMP_STYLE_CTNTVER_ID NUMBER
Y Component style content version identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
COMPONENT_STYLE_ID NUMBER
Y Component style identifier
LANGUAGE VARCHAR2 (4) Y Language
FILE_ID NUMBER
Y File identifier. This column is a foreign key to FND_LOBS table that stores the physical document for the component style.
FILE_NAME VARCHAR2 (256)
Obsoleted column. Use FILE_NAME column from FND_LOBS table. File name of the physical document
VERSION_NUMBER NUMBER
Y Version number of the physical document file for the component style in the language
MAX_VERSION_FLAG VARCHAR2 (1) Y Indicates if the physical document file for the component style has the maximum version number for the language
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
COMPONENT_ID NUMBER

Component identifier for the component style
CITEM_VERSION_ID NUMBER

Content Item Version Identifier

[top of page]

PRP.PRP_COMP_STYLE_CTNTVERS does not reference any database object

PRP.PRP_COMP_STYLE_CTNTVERS is referenced by following:

APPS
SYNONYM - PRP_COMP_STYLE_CTNTVERS

[top of page]

Table: PRP_EMAIL_HISTORY

Description: This table contains the history of all the eMail sent to customers with proposal document as attachment.
Primary Key: PRP_EMAIL_HISTORY_PK
  1. EMAIL_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_EMAIL_HISTORY.SENT_BY_USER_ID FND_USER
PRP_EMAIL_HISTORY.PROPOSAL_CTNTVER_ID PRP_PROPOSAL_CTNTVERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PRP_EMAIL_RECIPIENTS.EMAIL_HISTORY_ID PRP_EMAIL_HISTORY
Comments

This table contains the history of all the eMail sent to customers with proposal document as attachment.

Indexes
Index Type Tablespace Column
PRP_EMAIL_HISTORY_U1 UNIQUE APPS_TS_TX_IDX EMAIL_HISTORY_ID
SYS_IL0000244414C00019$$ UNIQUE APPS_TS_TX_DATA
PRP_EMAIL_HISTORY_N1 NONUNIQUE APPS_TS_TX_IDX PROPOSAL_CTNTVER_ID
Columns
Name Datatype Length Mandatory Comments
EMAIL_HISTORY_ID NUMBER
Y Email history identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
SENT_DATE DATE
Y Sent date. Date and time when the email was sent.
SENT_BY_USER_ID NUMBER
Y User identifier of the person sending the email
SUBJECT VARCHAR2 (240)
Subject of the email
EMAIL_BODY VARCHAR2 (2000)
Obsolete column. Use column "Body" instead.
PROPOSAL_CTNTVER_ID NUMBER

This column is obsoleted. Please use OBJECT_ID column. Proposal content version identifier. It represents the proposal output document that was sent as an attachment in the email.
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
COPY_SELF_FLAG VARCHAR2 (1)
This flag indicates if the sender of the email copied to self when sending the email.
OBJECT_TYPE VARCHAR2 (30)
Type of object associated with the email history. This column is based on the lookup type "PRP_EMAIL_OBJECT_TYPE" of FND lookups.
OBJECT_ID NUMBER

Object identifier of the object associated with the email history
PARTY_ID NUMBER

This column represents the party identifier of the customer, where customer can be of type "PERSON" or "ORGANIZATION".
RESOURCE_ID NUMBER

Resource Identifier.
DIRECTION VARCHAR2 (30)
Email Direction. Can be one of "INBOUND" or "OUTBOUND"
BODY CLOB (4000)
Email Body Text

[top of page]

PRP.PRP_EMAIL_HISTORY does not reference any database object

PRP.PRP_EMAIL_HISTORY is referenced by following:

APPS
SYNONYM - PRP_EMAIL_HISTORY

[top of page]

Table: PRP_EMAIL_RECIPIENTS

Description: This table stores the information about the recipients of the email. Email can be sent to the contacts of the party of type 'ORGANIZATION' or to the party itself in case of party of type 'PERSON'. This table also stores the information of t
Primary Key: PRP_EMAIL_RECIPIENTS_PK
  1. EMAIL_RECIPIENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_EMAIL_RECIPIENTS.EMAIL_HISTORY_ID PRP_EMAIL_HISTORY
PRP_EMAIL_RECIPIENTS.PARTY_ID HZ_PARTIES
Comments

This table stores the information about the recipients of the email. Email can be sent to the contacts of the party of type 'ORGANIZATION' or to the party itself in case of party of type 'PERSON'. This table also stores the information of the recipients for whom the email was specified in a free-form manner, that is, the recipients are not recognized by the application as party or some other entity.

Indexes
Index Type Tablespace Column
PRP_EMAIL_RECIPIENTS_U1 UNIQUE APPS_TS_TX_IDX EMAIL_RECIPIENT_ID
PRP_EMAIL_RECIPIENTS_N1 NONUNIQUE APPS_TS_TX_IDX EMAIL_HISTORY_ID
Columns
Name Datatype Length Mandatory Comments
EMAIL_RECIPIENT_ID NUMBER
Y Email recipient identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object version number
EMAIL_HISTORY_ID NUMBER
Y Email History Identifier
PARTY_ID NUMBER

This column is obsoleted. Uses CONTACT_POINT_ID to identify the email address of the party.
ADDRESSED_AS VARCHAR2 (30) Y This field identifies how the recipient was addressed as in the email.
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_ID NUMBER

Concurrent Program Standard Who column
PROGRAM_LOGIN_ID NUMBER

Concurrent Program Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program Standard Who column
REQUEST_ID NUMBER

Concurrent Program Standard Who column
EMAIL_ADDRESS VARCHAR2 (2000)
This column stores the email address of the recipients to whom email was sent in a free-form manner. In case of email sent to party, this column stores NULL value, that is, it does not store the email address of the party.
CONTACT_POINT_ID NUMBER

Contact Point Identifier.

[top of page]

PRP.PRP_EMAIL_RECIPIENTS does not reference any database object

PRP.PRP_EMAIL_RECIPIENTS is referenced by following:

APPS
SYNONYM - PRP_EMAIL_RECIPIENTS

[top of page]

Table: PRP_GROUPS_B

Description: This table contains information about the groups that are used to categorize tokens.
Primary Key: PRP_GROUPS_B_PK
  1. GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PRP_GROUPS_TL.GROUP_ID PRP_GROUPS_B
PRP_GROUP_TOKENS.GROUP_ID PRP_GROUPS_B
Comments

This table contains information about the groups that are used to categorize tokens.

Indexes
Index Type Tablespace Column
PRP_GROUPS_B_U1 UNIQUE APPS_TS_TX_IDX GROUP_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER
Y Group identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield

[top of page]

PRP.PRP_GROUPS_B does not reference any database object

PRP.PRP_GROUPS_B is referenced by following:

APPS
SYNONYM - PRP_GROUPS_B

[top of page]

Table: PRP_GROUPS_TL

Description: This table contains translated information about the groups that are used to categorize tokens.
Primary Key: PRP_GROUPS_TL_PK
  1. GROUP_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_GROUPS_TL.GROUP_ID PRP_GROUPS_B
Comments

This table contains translated information about the groups that are used to categorize tokens.

Indexes
Index Type Tablespace Column
PRP_GROUPS_TL_U1 UNIQUE APPS_TS_TX_IDX GROUP_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER
Y Group identifier
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source language
GROUP_NAME VARCHAR2 (240) Y Group name
GROUP_DESC VARCHAR2 (2000)
Group description
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_GROUPS_TL does not reference any database object

PRP.PRP_GROUPS_TL is referenced by following:

APPS
SYNONYM - PRP_GROUPS_TL

[top of page]

Table: PRP_GROUP_TOKENS

Description: This table contains the associations between tokens and groups.
Primary Key: PRP_GROUP_TOKENS_PK
  1. GROUP_TOKEN_ID
Primary Key: PRP_GROUP_TOKENS_UK1
  1. TOKEN_ID
  2. GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_GROUP_TOKENS.GROUP_ID PRP_GROUPS_B
PRP_GROUP_TOKENS.TOKEN_ID %
Comments

This table contains the associations between tokens and groups.

Indexes
Index Type Tablespace Column
PRP_GROUP_TOKENS_U1 UNIQUE APPS_TS_TX_IDX GROUP_TOKEN_ID
PRP_GROUP_TOKENS_U2 UNIQUE APPS_TS_TX_IDX TOKEN_ID
GROUP_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_TOKEN_ID NUMBER
Y Group token identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
GROUP_ID NUMBER
Y Group identifier
TOKEN_ID NUMBER
Y Token identifier
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_GROUP_TOKENS does not reference any database object

PRP.PRP_GROUP_TOKENS is referenced by following:

APPS
SYNONYM - PRP_GROUP_TOKENS

[top of page]

Table: PRP_MIGRATION_HISTORY

Description: This table stores the data migration history for Oracle Proposals
Primary Key: PRP_MIGRATION_HISTORY_PK
  1. MIGRATION_HISTORY_ID
Primary Key: PRP_MIGRATION_HISTORY_UK1
  1. MIGRATION_CODE
Comments

This table stores the data migration history for Oracle Proposals

Indexes
Index Type Tablespace Column
PRP_MIGRATION_HISTORY_U1 UNIQUE APPS_TS_TX_IDX MIGRATION_HISTORY_ID
PRP_MIGRATION_HISTORY_U2 UNIQUE APPS_TS_TX_IDX MIGRATION_CODE
Columns
Name Datatype Length Mandatory Comments
MIGRATION_HISTORY_ID NUMBER
Y Migration history identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
MIGRATION_CODE VARCHAR2 (30) Y This column represents migration code identifying the type of migration performed.
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_MIGRATION_HISTORY does not reference any database object

PRP.PRP_MIGRATION_HISTORY is referenced by following:

APPS
SYNONYM - PRP_MIGRATION_HISTORY

[top of page]

Table: PRP_MIGRATION_LOGS

Description: This table stores the data migration logs for Oracle Proposals
Primary Key: PRP_MIGRATION_LOGS_PK
  1. MIGRATION_LOG_ID
Comments

This table stores the data migration logs for Oracle Proposals

Indexes
Index Type Tablespace Column
PRP_MIGRATION_LOGS_U1 UNIQUE APPS_TS_TX_IDX MIGRATION_LOG_ID
PRP_MIGRATION_LOGS_N1 NONUNIQUE APPS_TS_TX_IDX MIGRATION_CODE
Columns
Name Datatype Length Mandatory Comments
MIGRATION_LOG_ID NUMBER
Y Migration log identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
MODULE_NAME VARCHAR2 (256) Y Module name logging the messages
LOG_LEVEL VARCHAR2 (30) Y Level of the log message. The value would be based on the lookup values from FND_LOOKS of lookup type PRP_MIG_LOG_LEVEL_TYPE.
MESSAGE_TEXT VARCHAR2 (2000)
Message text
MIGRATION_CODE VARCHAR2 (30)
This column represents the migration code identifying the type of the migration performed.
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_MIGRATION_LOGS does not reference any database object

PRP.PRP_MIGRATION_LOGS is referenced by following:

APPS
SYNONYM - PRP_MIGRATION_LOGS

[top of page]

Table: PRP_PERZ_FILES

Description: This table represents the personalized files added by the sales representatives to the proposal
Primary Key: PRP_PERZ_FILES_PK
  1. PERZ_FILE_ID
Primary Key: PRP_PERZ_FILES_UK1
  1. FILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_PERZ_FILES.FILE_ID FND_LOBS
PRP_PERZ_FILES.CITEM_VERSION_ID IBC_CITEM_VERSIONS_B
Comments

This table represents the personalized files added by the sales representatives to the proposal

Indexes
Index Type Tablespace Column
PRP_PERZ_FILES_U1 UNIQUE APPS_TS_TX_IDX PERZ_FILE_ID
Columns
Name Datatype Length Mandatory Comments
PERZ_FILE_ID NUMBER
Y Personalized file identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
FILE_ID NUMBER
Y This column represents the identifier of the file referenced. This column is foreign key to FND_LOBS table.
PERZ_FILE_NAME VARCHAR2 (240)
User friendly file name
PERZ_FILE_DESC VARCHAR2 (2000)
User friendly file description
CITEM_VERSION_ID NUMBER
Y Content Item Version Identifier.
CONTENT_NODE_TYPE VARCHAR2 (240) Y Content Node Type - 'HIDDEN' or 'SHARED'
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_PERZ_FILES does not reference any database object

PRP.PRP_PERZ_FILES is referenced by following:

APPS
SYNONYM - PRP_PERZ_FILES

[top of page]

Table: PRP_PROPOSALS

Description: This table contains the information about the proposals.
Primary Key: PRP_PROPOSALS_PK
  1. PROPOSAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_PROPOSALS.USER_ID FND_USER
PRP_PROPOSALS.PROPOSAL_LANGUAGE FND_LANGUAGES
PRP_PROPOSALS.TEMPLATE_ID %
PRP_PROPOSALS.PARTY_ID HZ_PARTIES
PRP_PROPOSALS.CONTACT_PARTY_ID HZ_PARTIES
PRP_PROPOSALS.CONTENT_ITEM_ID IBC_CONTENT_ITEMS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PRP_PROPOSAL_CTNTVERS.PROPOSAL_ID PRP_PROPOSALS
PRP_PROPOSAL_OBJECTS.PROPOSAL_ID PRP_PROPOSALS
PRP_PROPOSAL_TOKENS.PROPOSAL_ID PRP_PROPOSALS
PRP_PROP_STYLE_CTNTVERS.PROPOSAL_ID PRP_PROPOSALS
Comments

This table contains the information about the proposals.

Indexes
Index Type Tablespace Column
PRP_PROPOSALS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
PRP_PROPOSALS_N1 NONUNIQUE APPS_TS_TX_IDX USER_ID
PRP_PROPOSALS_N2 NONUNIQUE APPS_TS_TX_IDX PARTY_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER
Y Proposal identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
PROPOSAL_NAME VARCHAR2 (240) Y Proposal name
PROPOSAL_DESC VARCHAR2 (2000)
Proposal description
USER_ID NUMBER
Y User identifier. The user who created the proposal. This column is foreign key to FND_USER.
PROPOSAL_LANGUAGE VARCHAR2 (4) Y Language of the proposal
PROPOSAL_STATUS VARCHAR2 (30) Y Proposal status. It indicates if the proposal is in draft or complete.
TEMPLATE_ID NUMBER

Identifier of the template that is used to generate the proposal
DUE_DATE DATE

Date by which the prosposal is due
PARTY_ID NUMBER
Y This column represents the party identifier of the customer, where customer can be of type "PERSON" or "ORGANIZATION".
CONTACT_PARTY_ID NUMBER

Contact party identifier
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_ID NUMBER

Concurrent Program Standard Who column
PROGRAM_LOGIN_ID NUMBER

Concurrent Program Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program Standard Who column
REQUEST_ID NUMBER

Concurrent Program Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
CONTENT_ITEM_ID NUMBER

Content Item Identifier

[top of page]

PRP.PRP_PROPOSALS does not reference any database object

PRP.PRP_PROPOSALS is referenced by following:

APPS
SYNONYM - PRP_PROPOSALS

[top of page]

Table: PRP_PROPOSAL_CTNTVERS

Description: This table contains the association between the proposal and the physical document file.
Primary Key: PRP_PROPOSAL_CTNTVERS_PK
  1. PROPOSAL_CTNTVER_ID
Primary Key: PRP_PROPOSAL_CTNTVERS_UK1
  1. PROPOSAL_ID
  2. VERSION_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_PROPOSAL_CTNTVERS.PROPOSAL_ID PRP_PROPOSALS
PRP_PROPOSAL_CTNTVERS.CITEM_VERSION_ID IBC_CITEM_VERSIONS_B
PRP_PROPOSAL_CTNTVERS.FILE_ID FND_LOBS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PRP_EMAIL_HISTORY.PROPOSAL_CTNTVER_ID PRP_PROPOSAL_CTNTVERS
Comments

This table contains the association between the proposal and the physical document file.

Indexes
Index Type Tablespace Column
PRP_PROPOSAL_CTNTVERS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_CTNTVER_ID
PRP_PROPOSAL_CTNTVERS_U2 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
VERSION_NUMBER
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_CTNTVER_ID NUMBER
Y Proposal content version identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
PROPOSAL_ID NUMBER
Y Proposal identifier
LANGUAGE VARCHAR2 (4)
Obsoleted column. Use PROPOSAL_LANGUAGE column from PRP_PROPOSALS table. Language
FILE_ID NUMBER

File identifier. This column is a foreign key to FND_LOBS table that stores the physical document for the proposal. This column will be specified only when the creation process is "GENERATED" or "UPLOADED".
FILE_NAME VARCHAR2 (256)
Obsoleted column. Use FILE_NAME column from FND_LOBS table. File name of the physical document
VERSION_NUMBER NUMBER
Y Version number of the physical document file associated with the proposal
CONTENT_VERSION_STATUS VARCHAR2 (30)
Status of the document associated with the proposal. It indicates if it is in draft or final.
CREATION_PROCESS VARCHAR2 (30) Y This column is used to determine the state of the proposal document in the creation process.
REMARKS VARCHAR2 (2000)
Remarks associated with the proposal document
MAX_VERSION_FLAG VARCHAR2 (1) Y Indicates if the physical document file for the proposal has the maximum version number.
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_ID NUMBER

Concurrent Program Standard Who column
PROGRAM_LOGIN_ID NUMBER

Concurrent Program Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program Standard Who column
REQUEST_ID NUMBER

Concurrent Program Standard Who column
CITEM_VERSION_ID NUMBER

Content Item Version Identifier

[top of page]

PRP.PRP_PROPOSAL_CTNTVERS does not reference any database object

PRP.PRP_PROPOSAL_CTNTVERS is referenced by following:

APPS
SYNONYM - PRP_PROPOSAL_CTNTVERS

[top of page]

Table: PRP_PROPOSAL_OBJECTS

Description: This table contains the association between the proposal and native objects like Quote, etc.
Primary Key: PRP_PROPOSAL_OBJECTS_PK
  1. PROPOSAL_OBJECT_ID
Primary Key: PRP_PROPOSAL_OBJECTS_UK1
  1. PROPOSAL_ID
  2. OBJECT_TYPE
  3. OBJECT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_PROPOSAL_OBJECTS.PROPOSAL_ID PRP_PROPOSALS
PRP_PROPOSAL_OBJECTS.OBJECT_ID ASO_QUOTE_HEADERS_ALL
Comments

This table contains the association between the proposal and native objects like Quote, etc.

Indexes
Index Type Tablespace Column
PRP_PROPOSAL_OBJECTS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_OBJECT_ID
PRP_PROPOSAL_OBJECTS_U2 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
OBJECT_TYPE
OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_OBJECT_ID NUMBER
Y Proposal object identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
PROPOSAL_ID NUMBER
Y Proposal identifier
OBJECT_TYPE VARCHAR2 (30) Y Type of the object associated to the proposal
OBJECT_ID NUMBER
Y Identifier of the object associated to the proposal
PRIMARY_FLAG VARCHAR2 (1)
Obsolete Column in R12 -- Indicates if the object associated with proposal is primary or not. Object is primary if the value is 'Y', else the value is 'N'.
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
DISPLAY_ORDER NUMBER

Display Order. Specifies the order in which the data from object will appear in the generated document.

[top of page]

PRP.PRP_PROPOSAL_OBJECTS does not reference any database object

PRP.PRP_PROPOSAL_OBJECTS is referenced by following:

APPS
SYNONYM - PRP_PROPOSAL_OBJECTS

[top of page]

Table: PRP_PROPOSAL_TOKENS

Description: This table contains the tokens that are used in proposal and their corresponding values. The tokens stored in this table are only "User Defined" tokens that are of type "Text" or "List of Values".
Primary Key: PRP_PROPOSAL_TOKENS_PK
  1. PROPOSAL_TOKEN_ID
Primary Key: PRP_PROPOSAL_TOKENS_UK1
  1. PROPOSAL_ID
  2. TOKEN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_PROPOSAL_TOKENS.PROPOSAL_ID PRP_PROPOSALS
PRP_PROPOSAL_TOKENS.TOKEN_ID %
Comments

This table contains the tokens that are used in proposal and their corresponding values. The tokens stored in this table are only "User Defined" tokens that are of type "Text" or "List of Values".

Indexes
Index Type Tablespace Column
PRP_PROPOSAL_TOKENS_U1 UNIQUE APPS_TS_TX_IDX PROPOSAL_TOKEN_ID
PRP_PROPOSAL_TOKENS_U2 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
TOKEN_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_TOKEN_ID NUMBER
Y Proposal token identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
PROPOSAL_ID NUMBER
Y Proposal identifier
TOKEN_ID NUMBER
Y Token identifier
TOKEN_VALUE VARCHAR2 (2000)
This column stores the value of the token, if the token is of type "Text"
TOKEN_VALUE_ID NUMBER

This column stores the token value identifier for the token, if the token is of type "List of Values"
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CITEM_VERSION_ID NUMBER

This column stores the content item version identifier for the token, if the token is of type "Image"

[top of page]

PRP.PRP_PROPOSAL_TOKENS does not reference any database object

PRP.PRP_PROPOSAL_TOKENS is referenced by following:

APPS
SYNONYM - PRP_PROPOSAL_TOKENS

[top of page]

Table: PRP_PROP_STYLE_CTNTVERS

Description: This table represents the structure of the proposal. It contains the template components and files that are used in a proposal. Sales representatives can select the components and files, and the order in which they appear in the generated p
Primary Key: PRP_PROP_STYLE_CTNTVERS_PK
  1. PROP_STYLE_CTNTVER_ID
Primary Key: PRP_PROP_STYLE_CTNTVERS_UK1
  1. PROPOSAL_ID
  2. OBJECT_TYPE
  3. OBJECT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_PROP_STYLE_CTNTVERS.PROPOSAL_ID PRP_PROPOSALS
PRP_PROP_STYLE_CTNTVERS.OBJECT_ID PRP_COMP_STYLE_CTNTVERS
PRP_PROP_STYLE_CTNTVERS.OBJECT_ID %
Comments

This table represents the structure of the proposal. It contains the template components and files that are used in a proposal. Sales representatives can select the components and files, and the order in which they appear in the generated proposal.

Indexes
Index Type Tablespace Column
PRP_PROP_STYLE_CTNTVERS_U1 UNIQUE APPS_TS_TX_IDX PROP_STYLE_CTNTVER_ID
PRP_PROP_STYLE_CTNTVERS_U999 UNIQUE APPS_TS_TX_IDX PROPOSAL_ID
OBJECT_TYPE
OBJECT_ID
PRP_PROP_STYLE_CTNTVERS_N1 NONUNIQUE APPS_TS_TX_IDX OBJECT_TYPE
OBJECT_ID
INCLUDE_FLAG
Columns
Name Datatype Length Mandatory Comments
PROP_STYLE_CTNTVER_ID NUMBER
Y Proposal component style content version identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
PROPOSAL_ID NUMBER
Y Proposal identifier
COMP_STYLE_CTNTVER_ID NUMBER

Obsoleted column. Component style content version identifier associated with the proposal. Use OBJECT_ID column from this table instead.
COMPONENT_STYLE_ID NUMBER

Obsoleted column. Component style identifier for the component style document associated with the proposal. This column is no longer denormalized.
COMPONENT_ID NUMBER

Obsoleted column. Component identifier for the component style document associated with the proposal. This column is no longer denormalized.
DISPLAY_ORDER NUMBER

Order of the component style document within the proposal
MANDATORY_FLAG VARCHAR2 (1) Y Indicates if the component style document is mandatory for the proposal. If the value of the flag is 'Y', then it is mandatory.
COMPLETE_FLAG VARCHAR2 (1) Y Indicates if the component in the proposal is complete, that is, if all the tokens in the component style document have a value specified for them for the proposal. If the value of the flag is 'Y', then it is complete.
INCLUDE_FLAG VARCHAR2 (1) Y Indicates if the component style document is included in the proposal. If the value of the flag is 'Y', then it is included. If the value is 'N', then it is excluded.
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_ID NUMBER

Concurrent Program Standard Who column
PROGRAM_LOGIN_ID NUMBER

Concurrent Program Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program Standard Who column
REQUEST_ID NUMBER

Concurrent Program Standard Who column
OBJECT_TYPE VARCHAR2 (30)
Type of object associated with the proposal structure. This column is based on the lookup type 'PRP_PROP_STRUCT_OBJ_TYPE' of FND lookups.
OBJECT_ID NUMBER

Object identifier of the object associated with the proposal structure

[top of page]

PRP.PRP_PROP_STYLE_CTNTVERS does not reference any database object

PRP.PRP_PROP_STYLE_CTNTVERS is referenced by following:

APPS
SYNONYM - PRP_PROP_STYLE_CTNTVERS

[top of page]

Table: PRP_STYLE_CTNTVER_TOKENS

Description: This table contains the tokens that are referenced by a component style document. This table is populated when the component document file is uploaded and parsed for tokens.
Primary Key: PRP_STYLE_CTNTVER_TOKENS_PK
  1. STYLE_CTNTVER_TOKEN_ID
Primary Key: PRP_STYLE_CTNTVER_TOKENS_UK1
  1. COMP_STYLE_CTNTVER_ID
  2. TOKEN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_STYLE_CTNTVER_TOKENS.COMP_STYLE_CTNTVER_ID PRP_COMP_STYLE_CTNTVERS
PRP_STYLE_CTNTVER_TOKENS.TOKEN_ID %
Comments

This table contains the tokens that are referenced by a component style document. This table is populated when the component document file is uploaded and parsed for tokens.

Indexes
Index Type Tablespace Column
PRP_STYLE_CTNTVER_TOKENS_U1 UNIQUE APPS_TS_TX_IDX STYLE_CTNTVER_TOKEN_ID
PRP_STYLE_CTNTVER_TOKENS_U2 UNIQUE APPS_TS_TX_IDX COMP_STYLE_CTNTVER_ID
TOKEN_ID
PRP_STYLE_CTNTVER_TOKENS_N1 NONUNIQUE APPS_TS_TX_IDX TOKEN_ID
Columns
Name Datatype Length Mandatory Comments
STYLE_CTNTVER_TOKEN_ID NUMBER
Y Component style content version token identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
COMP_STYLE_CTNTVER_ID NUMBER
Y Component style content version identifier
TOKEN_ID NUMBER
Y Token identifier
DISPLAY_ORDER NUMBER
Y Order in which the token appears within the component style document. This will also be the order in which user will be prompted to enter the values while creating a proposal.
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_STYLE_CTNTVER_TOKENS does not reference any database object

PRP.PRP_STYLE_CTNTVER_TOKENS is referenced by following:

APPS
SYNONYM - PRP_STYLE_CTNTVER_TOKENS

[top of page]

Table: PRP_TEMPLATES_B

Description: This table contains the information about the templates.
Primary Key: PRP_TEMPLATES_B_PK
  1. TEMPLATE_ID
Primary Key: PRP_TEMPLATES_B_UK1
  1. TEMPLATE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_TEMPLATES_B.TEMPLATE_CATG_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
PRP_TEMPLATES_TL.TEMPLATE_ID PRP_TEMPLATES_B
PRP_TEMPLATE_COMPONENTS.TEMPLATE_ID PRP_TEMPLATES_B
PRP_TEMPLATE_LANG_ATTRS.TEMPLATE_ID PRP_TEMPLATES_B
Comments

This table contains the information about the templates.

Indexes
Index Type Tablespace Column
PRP_TEMPLATES_B_U1 UNIQUE APPS_TS_TX_IDX TEMPLATE_ID
PRP_TEMPLATES_B_U2 UNIQUE APPS_TS_TX_IDX TEMPLATE_CODE
PRP_TEMPLATES_B_N1 NONUNIQUE APPS_TS_TX_IDX TEMPLATE_CATG_ID
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER
Y Template identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
TEMPLATE_CODE VARCHAR2 (30) Y Template code
TEMPLATE_CATG_ID NUMBER
Y Template category identifier
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
ADD_FILE_FLAG VARCHAR2 (1)
This column specifies if the template allows addition of files to the proposal structure

[top of page]

PRP.PRP_TEMPLATES_B does not reference any database object

PRP.PRP_TEMPLATES_B is referenced by following:

APPS
SYNONYM - PRP_TEMPLATES_B

[top of page]

Table: PRP_TEMPLATES_TL

Description: This table contains the translated information about the templates.
Primary Key: PRP_TEMPLATES_TL_PK
  1. TEMPLATE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_TEMPLATES_TL.TEMPLATE_ID PRP_TEMPLATES_B
Comments

This table contains the translated information about the templates.

Indexes
Index Type Tablespace Column
PRP_TEMPLATES_TL_U1 UNIQUE APPS_TS_TX_IDX TEMPLATE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER
Y Template identifier
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source language
TEMPLATE_NAME VARCHAR2 (240) Y Template name
TEMPLATE_DESC VARCHAR2 (2000)
Template description
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_TEMPLATES_TL does not reference any database object

PRP.PRP_TEMPLATES_TL is referenced by following:

APPS
SYNONYM - PRP_TEMPLATES_TL

[top of page]

Table: PRP_TEMPLATE_CATGS_B

Description: This table contains the base information about the template categories.
Primary Key: PRP_TEMPLATE_CATGS_B_PK
  1. TEMPLATE_CATG_ID
Primary Key: PRP_TEMPLATE_CATGS_B_UK1
  1. TEMPLATE_CATG_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
PRP_TEMPLATE_CATGS_TL.TEMPLATE_CATG_ID PRP_TEMPLATE_CATGS_B
Comments

This table contains the base information about the template categories.

Indexes
Index Type Tablespace Column
PRP_TEMPLATE_CATGS_B_U1 UNIQUE APPS_TS_TX_IDX TEMPLATE_CATG_ID
PRP_TEMPLATE_CATGS_B_U2 UNIQUE APPS_TS_TX_IDX TEMPLATE_CATG_CODE
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_CATG_ID NUMBER
Y Template category identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
TEMPLATE_CATG_CODE VARCHAR2 (30) Y Template category code
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield

[top of page]

PRP.PRP_TEMPLATE_CATGS_B does not reference any database object

PRP.PRP_TEMPLATE_CATGS_B is referenced by following:

APPS
SYNONYM - PRP_TEMPLATE_CATGS_B

[top of page]

Table: PRP_TEMPLATE_CATGS_TL

Description: This table contains the translated information about the template categories.
Primary Key: PRP_TEMPLATE_CATGS_TL_PK
  1. TEMPLATE_CATG_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_TEMPLATE_CATGS_TL.TEMPLATE_CATG_ID PRP_TEMPLATE_CATGS_B
Comments

This table contains the translated information about the template categories.

Indexes
Index Type Tablespace Column
PRP_TEMPLATE_CATGS_TL_U1 UNIQUE APPS_TS_TX_IDX TEMPLATE_CATG_ID
LANGUAGE
PRP_TEMPLATE_CATGS_TL_U999 UNIQUE APPS_TS_TX_IDX TEMPLATE_CATG_NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_CATG_ID NUMBER
Y Template category identifier
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source language
TEMPLATE_CATG_NAME VARCHAR2 (240) Y Template category name
TEMPLATE_CATG_DESC VARCHAR2 (2000)
Template category description
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_TEMPLATE_CATGS_TL does not reference any database object

PRP.PRP_TEMPLATE_CATGS_TL is referenced by following:

APPS
SYNONYM - PRP_TEMPLATE_CATGS_TL

[top of page]

Table: PRP_TEMPLATE_COMPONENTS

Description: This table contains the list of components associated with a template.
Primary Key: PRP_TEMPLATE_COMPONENTS_PK
  1. TEMPLATE_COMPONENT_ID
Primary Key: PRP_TEMPLATE_COMPONENTS_UK1
  1. TEMPLATE_ID
  2. COMPONENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_TEMPLATE_COMPONENTS.TEMPLATE_ID PRP_TEMPLATES_B
PRP_TEMPLATE_COMPONENTS.COMPONENT_ID PRP_COMPONENTS_B
PRP_TEMPLATE_COMPONENTS.DEFAULT_COMP_STYLE_ID PRP_COMPONENT_STYLES_B
Comments

This table contains the list of components associated with a template.

Indexes
Index Type Tablespace Column
PRP_TEMPLATE_COMPONENTS_U1 UNIQUE APPS_TS_TX_IDX TEMPLATE_COMPONENT_ID
PRP_TEMPLATE_COMPONENTS_U2 UNIQUE APPS_TS_TX_IDX TEMPLATE_ID
COMPONENT_ID
PRP_TEMPLATE_COMPONENTS_N1 NONUNIQUE APPS_TS_TX_IDX DEFAULT_COMP_STYLE_ID
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_COMPONENT_ID NUMBER
Y Template component identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
TEMPLATE_ID NUMBER
Y Template identifier
COMPONENT_ID NUMBER
Y Component identifier
DISPLAY_ORDER NUMBER
Y Order of the component within the template
MANDATORY_FLAG VARCHAR2 (1) Y Indicates if the component is mandatory in the template. If the value is 'Y', then it is mandatory.
DEFAULT_COMP_STYLE_ID NUMBER
Y Default component style for the component in the template
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_TEMPLATE_COMPONENTS does not reference any database object

PRP.PRP_TEMPLATE_COMPONENTS is referenced by following:

APPS
SYNONYM - PRP_TEMPLATE_COMPONENTS

[top of page]

Table: PRP_TEMPLATE_LANG_ATTRS

Description: This table contains the language related attributes for the template.
Primary Key: PRP_TEMPLATE_LANG_ATTRS_PK
  1. TEMPLATE_LANG_ATTR_ID
Primary Key: PRP_TEMPLATE_LANG_ATTRS_UK1
  1. TEMPLATE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_TEMPLATE_LANG_ATTRS.TEMPLATE_ID PRP_TEMPLATES_B
PRP_TEMPLATE_LANG_ATTRS.LANGUAGE FND_LANGUAGES
Comments

This table contains the language related attributes for the template.

Indexes
Index Type Tablespace Column
PRP_TEMPLATE_LANG_ATTRS_U1 UNIQUE APPS_TS_TX_IDX TEMPLATE_LANG_ATTR_ID
PRP_TEMPLATE_LANG_ATTRS_U2 UNIQUE APPS_TS_TX_IDX TEMPLATE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_LANG_ATTR_ID NUMBER
Y Template language attribute identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
TEMPLATE_ID NUMBER
Y Template identifier
LANGUAGE VARCHAR2 (4) Y Language
TEMPLATE_LANG_STATUS VARCHAR2 (30) Y Status of the template in the specified language. It indicates if the template is published or unpublished in the specified language.
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_TEMPLATE_LANG_ATTRS does not reference any database object

PRP.PRP_TEMPLATE_LANG_ATTRS is referenced by following:

APPS
SYNONYM - PRP_TEMPLATE_LANG_ATTRS

[top of page]

Table: PRP_TOKENS_B

Description: This table contains the base information about the tokens.
Primary Key: PRP_TOKENS_B_PK
  1. TOKEN_ID
Primary Key: PRP_TOKENS_B_UK1
  1. TOKEN_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
PRP_TOKENS_TL.TOKEN_ID PRP_TOKENS_B
PRP_TOKEN_VALUES_TL.TOKEN_ID PRP_TOKENS_B
Comments

This table contains the base information about the tokens.

Indexes
Index Type Tablespace Column
PRP_TOKENS_B_U1 UNIQUE APPS_TS_TX_IDX TOKEN_ID
PRP_TOKENS_B_U2 UNIQUE APPS_TS_TX_IDX TOKEN_CODE
PRP_TOKENS_B_N1 NONUNIQUE APPS_TS_TX_IDX TOKEN_TYPE
NATIVE_OBJECT_TYPE
Columns
Name Datatype Length Mandatory Comments
TOKEN_ID NUMBER
Y Token identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
TOKEN_CODE VARCHAR2 (30) Y Token code
TOKEN_TYPE VARCHAR2 (30) Y Token type. A token can of type "User Defined" or "Native".
NATIVE_OBJECT_TYPE VARCHAR2 (30)
Native object type. For tokens of type "Native", this coulmn specifies the type of the native object. Currently "QUOTE" native object type is supported. For "User Defined" tokens, the value of this column will be NULL.
USER_DEFINED_OPTIONS VARCHAR2 (30)
This column specifies the token options for "User Defined" tokens. It can have one of the following values: "Text", "List of Values" or "Java Program". For "Native" tokens, the value of this column will be NULL.
JAVA_PROGRAM_NAME VARCHAR2 (240)
Java program name. This column stores the concatenated string of package name, class name and method name.
DATA_TYPE VARCHAR2 (30)
Type of the data for user defined tokens of type "Text". It can have one of the following values: "Character", "Number" and "Date".
DISPLAY_LENGTH NUMBER

Maximum length of the user defined text character tokens.
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
START_DATE_ACTIVE DATE

Start Date Active
END_DATE_ACTIVE DATE

End Date Active

[top of page]

PRP.PRP_TOKENS_B does not reference any database object

PRP.PRP_TOKENS_B is referenced by following:

APPS
SYNONYM - PRP_TOKENS_B

[top of page]

Table: PRP_TOKENS_TL

Description: This table contains the translated information about the tokens.
Primary Key: PRP_TOKENS_TL_PK
  1. TOKEN_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_TOKENS_TL.TOKEN_ID PRP_TOKENS_B
Comments

This table contains the translated information about the tokens.

Indexes
Index Type Tablespace Column
PRP_TOKENS_TL_U1 UNIQUE APPS_TS_TX_IDX TOKEN_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TOKEN_ID NUMBER
Y Token identifier
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source language
TOKEN_NAME VARCHAR2 (240) Y Token name
TOKEN_PROMPT VARCHAR2 (240) Y Token prompt
TOKEN_DESC VARCHAR2 (2000)
Token description
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_TOKENS_TL does not reference any database object

PRP.PRP_TOKENS_TL is referenced by following:

APPS
SYNONYM - PRP_TOKENS_TL

[top of page]

Table: PRP_TOKEN_VALUES_TL

Description: 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 in each installed language.
Primary Key: PRP_TOKEN_VALUES_TL_PK
  1. TOKEN_VALUE_ID
  2. LANGUAGE
Primary Key: PRP_TOKEN_VALUES_TL_UK1
  1. TOKEN_ID
  2. LANGUAGE
  3. TOKEN_VALUE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PRP_TOKEN_VALUES_TL.TOKEN_ID PRP_TOKENS_B
Comments

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 in each installed language.

Indexes
Index Type Tablespace Column
PRP_TOKEN_VALUES_TL_U1 UNIQUE APPS_TS_TX_IDX TOKEN_VALUE_ID
LANGUAGE
PRP_TOKEN_VALUES_TL_N1 NONUNIQUE APPS_TS_TX_IDX TOKEN_ID
LANGUAGE
TOKEN_VALUE
Columns
Name Datatype Length Mandatory Comments
TOKEN_VALUE_ID NUMBER
Y Token value identifier
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y Source language
TOKEN_ID NUMBER
Y Token identifier
TOKEN_VALUE VARCHAR2 (240) Y Token value
CREATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

PRP.PRP_TOKEN_VALUES_TL does not reference any database object

PRP.PRP_TOKEN_VALUES_TL is referenced by following:

APPS
SYNONYM - PRP_TOKEN_VALUES_TL

[top of page]

View: PRP_COMPONENTS_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
COMPONENT_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
COMPONENT_CODE VARCHAR2 (30) Y
CREATED_BY NUMBER
Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
COMPONENT_NAME VARCHAR2 (240) Y
COMPONENT_DESC VARCHAR2 (2000)

[top of page]

APPS.PRP_COMPONENTS_VL references the following:

APPS
SYNONYM - PRP_COMPONENTS_B
SYNONYM - PRP_COMPONENTS_TL

APPS.PRP_COMPONENTS_VL is not referenced by any database object

[top of page]

View: PRP_COMPONENT_STYLES_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
COMPONENT_STYLE_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
COMPONENT_ID NUMBER
Y
COMPONENT_STYLE_CODE VARCHAR2 (30)
CONTENT_NODE_TYPE VARCHAR2 (10) Y
CONTENT_ITEM_ID NUMBER

CREATED_BY NUMBER
Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
COMPONENT_STYLE_NAME VARCHAR2 (240)

[top of page]

APPS.PRP_COMPONENT_STYLES_VL references the following:

APPS
SYNONYM - PRP_COMPONENT_STYLES_B
SYNONYM - PRP_COMPONENT_STYLES_TL
APPS.PRP_COMPONENT_STYLES_VL is referenced by following:

APPS
PACKAGE BODY - PRP_IBC_INT_PVT

[top of page]

View: PRP_GROUPS_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
GROUP_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
CREATED_BY NUMBER
Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
GROUP_NAME VARCHAR2 (240) Y
GROUP_DESC VARCHAR2 (2000)

[top of page]

APPS.PRP_GROUPS_VL references the following:

APPS
SYNONYM - PRP_GROUPS_B
SYNONYM - PRP_GROUPS_TL

APPS.PRP_GROUPS_VL is not referenced by any database object

[top of page]

View: PRP_PROP_CUSTOMERS_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
PROPOSAL_ID NUMBER
Y
OWNER_USER_ID NUMBER
Y
PARTY_ID NUMBER
Y
CONTACT_PARTY_ID NUMBER

OWNER_NAME VARCHAR2 (360)
PROPOSAL_NAME VARCHAR2 (240) Y
PROPOSAL_DESC VARCHAR2 (2000)
PROPOSAL_STATUS_CODE VARCHAR2 (30) Y
PROPOSAL_STATUS VARCHAR2 (80) Y
DUE_DATE DATE

UPDATE_FLAG VARCHAR2 (1)
FILE_ID NUMBER

FILE_FORMAT VARCHAR2 (30)
CITEM_VERSION_ID VARCHAR2 (0)
CONTENT_ITEM_ID VARCHAR2 (0)
PROPOSAL_LANGUAGE VARCHAR2 (4) Y

[top of page]

APPS.PRP_PROP_CUSTOMERS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
VIEW - JTF_RS_RESOURCE_EXTNS_VL
SYNONYM - PRP_PROPOSALS
SYNONYM - PRP_PROPOSAL_ACCESSES
SYNONYM - PRP_PROPOSAL_CTNTVERS
SYNONYM - PRP_PROP_CTNTVER_FORMATS

APPS.PRP_PROP_CUSTOMERS_V is not referenced by any database object

[top of page]

View: PRP_PROP_OBJECTS_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
PROPOSAL_ID NUMBER
Y
OWNER_USER_ID NUMBER
Y
PARTY_ID NUMBER
Y
CONTACT_PARTY_ID NUMBER

OBJECT_ID NUMBER
Y
OBJECT_TYPE VARCHAR2 (30) Y
OWNER_NAME VARCHAR2 (360)
PROPOSAL_NAME VARCHAR2 (240) Y
PROPOSAL_DESC VARCHAR2 (2000)
PROPOSAL_STATUS_CODE VARCHAR2 (30) Y
PROPOSAL_STATUS VARCHAR2 (80) Y
DUE_DATE DATE

UPDATE_FLAG VARCHAR2 (1)
FILE_ID NUMBER

FILE_FORMAT VARCHAR2 (30)
CITEM_VERSION_ID VARCHAR2 (0)
CONTENT_ITEM_ID VARCHAR2 (0)
PROPOSAL_LANGUAGE VARCHAR2 (4) Y

[top of page]

APPS.PRP_PROP_OBJECTS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
VIEW - JTF_RS_RESOURCE_EXTNS_VL
SYNONYM - PRP_PROPOSALS
SYNONYM - PRP_PROPOSAL_ACCESSES
SYNONYM - PRP_PROPOSAL_CTNTVERS
SYNONYM - PRP_PROPOSAL_OBJECTS
SYNONYM - PRP_PROP_CTNTVER_FORMATS
APPS.PRP_PROP_OBJECTS_V is referenced by following:

APPS
PACKAGE BODY - AST_UWQ_OLIST_WORK_ACTION

[top of page]

View: PRP_TEMPLATES_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TEMPLATE_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
TEMPLATE_CODE VARCHAR2 (30) Y
TEMPLATE_CATG_ID NUMBER
Y
ADD_FILE_FLAG VARCHAR2 (1)
CREATED_BY NUMBER
Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
TEMPLATE_NAME VARCHAR2 (240) Y
TEMPLATE_DESC VARCHAR2 (2000)

[top of page]

APPS.PRP_TEMPLATES_VL references the following:

APPS
SYNONYM - PRP_TEMPLATES_B
SYNONYM - PRP_TEMPLATES_TL
APPS.PRP_TEMPLATES_VL is referenced by following:

APPS
PACKAGE BODY - AMS_COLLAB_ASSOC_PVT

[top of page]

View: PRP_TEMPLATE_CATGS_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TEMPLATE_CATG_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
TEMPLATE_CATG_CODE VARCHAR2 (30) Y
CREATED_BY NUMBER
Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
TEMPLATE_CATG_NAME VARCHAR2 (240) Y
TEMPLATE_CATG_DESC VARCHAR2 (2000)

[top of page]

APPS.PRP_TEMPLATE_CATGS_VL references the following:

APPS
SYNONYM - PRP_TEMPLATE_CATGS_B
SYNONYM - PRP_TEMPLATE_CATGS_TL

APPS.PRP_TEMPLATE_CATGS_VL is not referenced by any database object

[top of page]

View: PRP_TOKENS_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TOKEN_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
TOKEN_CODE VARCHAR2 (30) Y
TOKEN_TYPE VARCHAR2 (30) Y
NATIVE_OBJECT_TYPE VARCHAR2 (30)
USER_DEFINED_OPTIONS VARCHAR2 (30)
JAVA_PROGRAM_NAME VARCHAR2 (240)
DATA_TYPE VARCHAR2 (30)
DISPLAY_LENGTH NUMBER

CREATED_BY NUMBER
Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
TOKEN_NAME VARCHAR2 (240) Y
TOKEN_PROMPT VARCHAR2 (240) Y
TOKEN_DESC VARCHAR2 (2000)

[top of page]

APPS.PRP_TOKENS_VL references the following:

APPS
SYNONYM - PRP_TOKENS_B
SYNONYM - PRP_TOKENS_TL

APPS.PRP_TOKENS_VL is not referenced by any database object

[top of page]

View: PRP_TOKEN_VALUES_VL

Comments
View Type

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

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TOKEN_VALUE_ID NUMBER
Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
TOKEN_ID NUMBER
Y
CREATED_BY NUMBER
Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER
Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER

TOKEN_VALUE VARCHAR2 (240) Y

[top of page]

APPS.PRP_TOKEN_VALUES_VL references the following:

APPS
SYNONYM - PRP_TOKEN_VALUES_TL

APPS.PRP_TOKEN_VALUES_VL is not referenced by any database object

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract