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.
Description: | This table contains the information about the components. |
---|
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 |
This table contains the information about the components.
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$ |
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 |
PRP.PRP_COMPONENTS_B does not reference any database object
PRP.PRP_COMPONENTS_B is referenced by following:
Description: | This table contains the translated information about the components. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_COMPONENTS_TL.COMPONENT_ID | PRP_COMPONENTS_B |
This table contains the translated information about the components.
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$ |
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 |
PRP.PRP_COMPONENTS_TL does not reference any database object
PRP.PRP_COMPONENTS_TL is referenced by following:
Description: | This table contains the information about the component styles. |
---|
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 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 |
This table contains the information about the component styles.
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 |
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 |
PRP.PRP_COMPONENT_STYLES_B does not reference any database object
PRP.PRP_COMPONENT_STYLES_B is referenced by following:
Description: | This table contains the translated information about the component styles. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_COMPONENT_STYLES_TL.COMPONENT_STYLE_ID | PRP_COMPONENT_STYLES_B |
This table contains the translated information about the component styles.
Index | Type | Tablespace | Column |
---|---|---|---|
PRP_COMPONENT_STYLES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
COMPONENT_STYLE_ID
LANGUAGE |
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 |
PRP.PRP_COMPONENT_STYLES_TL does not reference any database object
PRP.PRP_COMPONENT_STYLES_TL is referenced by following:
Description: | This table contains the associations between component style and physical document file in a given language. |
---|
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 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 |
This table contains the associations between component style and physical document file in a given language.
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 |
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 |
PRP.PRP_COMP_STYLE_CTNTVERS does not reference any database object
PRP.PRP_COMP_STYLE_CTNTVERS is referenced by following:
Description: | This table contains the history of all the eMail sent to customers with proposal document as attachment. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_EMAIL_HISTORY.SENT_BY_USER_ID | FND_USER |
PRP_EMAIL_HISTORY.PROPOSAL_CTNTVER_ID | PRP_PROPOSAL_CTNTVERS |
Foreign Key Column | Foreign Table |
---|---|
PRP_EMAIL_RECIPIENTS.EMAIL_HISTORY_ID | PRP_EMAIL_HISTORY |
This table contains the history of all the eMail sent to customers with proposal document as attachment.
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 |
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 |
PRP.PRP_EMAIL_HISTORY does not reference any database object
PRP.PRP_EMAIL_HISTORY is referenced by following:
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 |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_EMAIL_RECIPIENTS.EMAIL_HISTORY_ID | PRP_EMAIL_HISTORY |
PRP_EMAIL_RECIPIENTS.PARTY_ID | HZ_PARTIES |
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.
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 |
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. |
PRP.PRP_EMAIL_RECIPIENTS does not reference any database object
PRP.PRP_EMAIL_RECIPIENTS is referenced by following:
Description: | This table contains information about the groups that are used to categorize tokens. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_GROUPS_TL.GROUP_ID | PRP_GROUPS_B |
PRP_GROUP_TOKENS.GROUP_ID | PRP_GROUPS_B |
This table contains information about the groups that are used to categorize tokens.
Index | Type | Tablespace | Column |
---|---|---|---|
PRP_GROUPS_B_U1 | UNIQUE | APPS_TS_TX_IDX | GROUP_ID |
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 |
PRP.PRP_GROUPS_B does not reference any database object
PRP.PRP_GROUPS_B is referenced by following:
Description: | This table contains translated information about the groups that are used to categorize tokens. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_GROUPS_TL.GROUP_ID | PRP_GROUPS_B |
This table contains translated information about the groups that are used to categorize tokens.
Index | Type | Tablespace | Column |
---|---|---|---|
PRP_GROUPS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
GROUP_ID
LANGUAGE |
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 |
PRP.PRP_GROUPS_TL does not reference any database object
PRP.PRP_GROUPS_TL is referenced by following:
Description: | This table contains the associations between tokens and groups. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_GROUP_TOKENS.GROUP_ID | PRP_GROUPS_B |
PRP_GROUP_TOKENS.TOKEN_ID | % |
This table contains the associations between tokens and groups.
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 |
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 |
PRP.PRP_GROUP_TOKENS does not reference any database object
PRP.PRP_GROUP_TOKENS is referenced by following:
Description: | This table stores the data migration history for Oracle Proposals |
---|
This table stores the data migration history for Oracle Proposals
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 |
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 |
PRP.PRP_MIGRATION_HISTORY does not reference any database object
PRP.PRP_MIGRATION_HISTORY is referenced by following:
Description: | This table stores the data migration logs for Oracle Proposals |
---|
This table stores the data migration logs for Oracle Proposals
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 |
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 |
PRP.PRP_MIGRATION_LOGS does not reference any database object
PRP.PRP_MIGRATION_LOGS is referenced by following:
Description: | This table represents the personalized files added by the sales representatives to the proposal |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_PERZ_FILES.FILE_ID | FND_LOBS |
PRP_PERZ_FILES.CITEM_VERSION_ID | IBC_CITEM_VERSIONS_B |
This table represents the personalized files added by the sales representatives to the proposal
Index | Type | Tablespace | Column |
---|---|---|---|
PRP_PERZ_FILES_U1 | UNIQUE | APPS_TS_TX_IDX | PERZ_FILE_ID |
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 |
PRP.PRP_PERZ_FILES does not reference any database object
PRP.PRP_PERZ_FILES is referenced by following:
Description: | This table contains the information about the proposals. |
---|
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 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 |
This table contains the information about the proposals.
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 |
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 |
PRP.PRP_PROPOSALS does not reference any database object
PRP.PRP_PROPOSALS is referenced by following:
Description: | This table contains the association between the proposal and the physical document file. |
---|
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 Key Column | Foreign Table |
---|---|
PRP_EMAIL_HISTORY.PROPOSAL_CTNTVER_ID | PRP_PROPOSAL_CTNTVERS |
This table contains the association between the proposal and the physical document file.
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 |
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 |
PRP.PRP_PROPOSAL_CTNTVERS does not reference any database object
PRP.PRP_PROPOSAL_CTNTVERS is referenced by following:
Description: | This table contains the association between the proposal and native objects like Quote, etc. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_PROPOSAL_OBJECTS.PROPOSAL_ID | PRP_PROPOSALS |
PRP_PROPOSAL_OBJECTS.OBJECT_ID | ASO_QUOTE_HEADERS_ALL |
This table contains the association between the proposal and native objects like Quote, etc.
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 |
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. |
PRP.PRP_PROPOSAL_OBJECTS does not reference any database object
PRP.PRP_PROPOSAL_OBJECTS is referenced by following:
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". |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_PROPOSAL_TOKENS.PROPOSAL_ID | PRP_PROPOSALS |
PRP_PROPOSAL_TOKENS.TOKEN_ID | % |
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".
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 |
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" |
PRP.PRP_PROPOSAL_TOKENS does not reference any database object
PRP.PRP_PROPOSAL_TOKENS is referenced by following:
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 |
---|
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 | % |
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.
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 |
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 |
PRP.PRP_PROP_STYLE_CTNTVERS does not reference any database object
PRP.PRP_PROP_STYLE_CTNTVERS is referenced by following:
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. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_STYLE_CTNTVER_TOKENS.COMP_STYLE_CTNTVER_ID | PRP_COMP_STYLE_CTNTVERS |
PRP_STYLE_CTNTVER_TOKENS.TOKEN_ID | % |
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.
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 |
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 |
PRP.PRP_STYLE_CTNTVER_TOKENS does not reference any database object
PRP.PRP_STYLE_CTNTVER_TOKENS is referenced by following:
Description: | This table contains the information about the templates. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_TEMPLATES_B.TEMPLATE_CATG_ID | % |
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 |
This table contains the information about the templates.
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 |
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 |
PRP.PRP_TEMPLATES_B does not reference any database object
PRP.PRP_TEMPLATES_B is referenced by following:
Description: | This table contains the translated information about the templates. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_TEMPLATES_TL.TEMPLATE_ID | PRP_TEMPLATES_B |
This table contains the translated information about the templates.
Index | Type | Tablespace | Column |
---|---|---|---|
PRP_TEMPLATES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
TEMPLATE_ID
LANGUAGE |
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 |
PRP.PRP_TEMPLATES_TL does not reference any database object
PRP.PRP_TEMPLATES_TL is referenced by following:
Description: | This table contains the base information about the template categories. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_TEMPLATE_CATGS_TL.TEMPLATE_CATG_ID | PRP_TEMPLATE_CATGS_B |
This table contains the base information about the template categories.
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 |
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 |
PRP.PRP_TEMPLATE_CATGS_B does not reference any database object
PRP.PRP_TEMPLATE_CATGS_B is referenced by following:
Description: | This table contains the translated information about the template categories. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_TEMPLATE_CATGS_TL.TEMPLATE_CATG_ID | PRP_TEMPLATE_CATGS_B |
This table contains the translated information about the template categories.
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 |
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 |
PRP.PRP_TEMPLATE_CATGS_TL does not reference any database object
PRP.PRP_TEMPLATE_CATGS_TL is referenced by following:
Description: | This table contains the list of components associated with a template. |
---|
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 |
This table contains the list of components associated with a template.
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 |
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 |
PRP.PRP_TEMPLATE_COMPONENTS does not reference any database object
PRP.PRP_TEMPLATE_COMPONENTS is referenced by following:
Description: | This table contains the language related attributes for the template. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_TEMPLATE_LANG_ATTRS.TEMPLATE_ID | PRP_TEMPLATES_B |
PRP_TEMPLATE_LANG_ATTRS.LANGUAGE | FND_LANGUAGES |
This table contains the language related attributes for the template.
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 |
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 |
PRP.PRP_TEMPLATE_LANG_ATTRS does not reference any database object
PRP.PRP_TEMPLATE_LANG_ATTRS is referenced by following:
Description: | This table contains the base information about the tokens. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_TOKENS_TL.TOKEN_ID | PRP_TOKENS_B |
PRP_TOKEN_VALUES_TL.TOKEN_ID | PRP_TOKENS_B |
This table contains the base information about the tokens.
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 |
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 |
PRP.PRP_TOKENS_B does not reference any database object
PRP.PRP_TOKENS_B is referenced by following:
Description: | This table contains the translated information about the tokens. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_TOKENS_TL.TOKEN_ID | PRP_TOKENS_B |
This table contains the translated information about the tokens.
Index | Type | Tablespace | Column |
---|---|---|---|
PRP_TOKENS_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
TOKEN_ID
LANGUAGE |
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 |
PRP.PRP_TOKENS_TL does not reference any database object
PRP.PRP_TOKENS_TL is referenced by following:
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. |
---|
Foreign Key Column | Foreign Table |
---|---|
PRP_TOKEN_VALUES_TL.TOKEN_ID | PRP_TOKENS_B |
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.
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 |
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 |
PRP.PRP_TOKEN_VALUES_TL does not reference any database object
PRP.PRP_TOKEN_VALUES_TL is referenced by following:
MultiLingual view (a language resolved view of the data.)
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) |
APPS.PRP_COMPONENTS_VL is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
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) |
MultiLingual view (a language resolved view of the data.)
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) |
APPS.PRP_GROUPS_VL is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
APPS.PRP_PROP_CUSTOMERS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
MultiLingual view (a language resolved view of the data.)
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) |
MultiLingual view (a language resolved view of the data.)
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) |
APPS.PRP_TEMPLATE_CATGS_VL is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
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) |
APPS.PRP_TOKENS_VL is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
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 |
APPS.PRP_TOKEN_VALUES_VL is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |