Search Results prp_proposal_ctntvers




Overview
Explore in AI Chat

Overview

The PRP_PROPOSAL_CTNTVERS table is a core data object within the Oracle E-Business Suite Proposals (PRP) module, present in both the 12.1.1 and 12.2.2 releases. Its primary function is to manage the critical association between a business proposal and its corresponding physical document files. This table serves as the central repository for tracking different versions of a proposal's document content, enabling a complete audit trail of document revisions throughout the proposal lifecycle. By linking the logical proposal entity to the physical file storage system (FND_LOBS) and the content item management system (IBC), it provides the foundational data integrity necessary for document version control, distribution, and historical reporting within the Proposals application.

Key Information Stored

The table's structure is designed to enforce unique versioning for each proposal and to link to related storage entities. The primary identifier is the system-generated PROPOSAL_CTNTVER_ID. The table's unique key, composed of PROPOSAL_ID and VERSION_NUMBER, ensures that each version of a proposal's document is distinctly recorded. The most critical foreign key columns establish the document's physical and logical connections: FILE_ID points to the actual binary file data stored in the FND_LOBS table, while CITEM_VERSION_ID links to the content item version in the IBC_CITEM_VERSIONS_B table, which manages structured content and attributes. This design separates the proposal metadata from the physical file storage, following standard EBS architectural patterns.

Common Use Cases and Queries

A primary use case is retrieving the latest or a specific version of a proposal document for review or download. Support and implementation teams often query this table to diagnose missing files or to understand the version history of a proposal. Common reporting needs include listing all document versions for a set of proposals or identifying proposals associated with a specific content item. Sample SQL patterns include fetching document details for a proposal:

  • SELECT proposal_id, version_number, file_id FROM prp_proposal_ctntvers WHERE proposal_id = <id> ORDER BY version_number DESC;

Or joining to the proposals table to get descriptive context:

  • SELECT pp.proposal_number, ppct.version_number, ppct.file_id FROM prp_proposals pp, prp_proposal_ctntvers ppct WHERE pp.proposal_id = ppct.proposal_id AND pp.proposal_number LIKE 'PROP-2024%';

Related Objects

The PRP_PROPOSAL_CTNTVERS table is a central hub with defined relationships to several key EBS tables, as documented in the provided metadata. Its foreign key dependencies and referencing objects are:

  • PRP_PROPOSALS: The parent table. The PROPOSAL_ID column in PRP_PROPOSAL_CTNTVERS references PRP_PROPOSALS.PROPOSAL_ID, linking each document version to its master proposal record.
  • IBC_CITEM_VERSIONS_B: The CITEM_VERSION_ID foreign key links to this table, associating the proposal document version with the Oracle Interaction Center's content item management system.
  • FND_LOBS: The FILE_ID foreign key references this table, providing the connection to the physical BLOB (Binary Large Object) data of the document file stored in the database.
  • PRP_EMAIL_HISTORY: This table references PRP_PROPOSAL_CTNTVERS via its PROPOSAL_CTNTVER_ID column, logging which specific document version was attached or referenced in outbound proposal-related emails.
  • Table: PRP_PROPOSAL_CTNTVERS 12.1.1

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_PROPOSAL_CTNTVERS,  object_name:PRP_PROPOSAL_CTNTVERS,  status:VALID,  product: PRP - Proposals ,  description: This table contains the association between the proposal and the physical document file. ,  implementation_dba_data: PRP.PRP_PROPOSAL_CTNTVERS , 

  • Table: PRP_PROPOSAL_CTNTVERS 12.2.2

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_PROPOSAL_CTNTVERS,  object_name:PRP_PROPOSAL_CTNTVERS,  status:VALID,  product: PRP - Proposals ,  description: This table contains the association between the proposal and the physical document file. ,  implementation_dba_data: PRP.PRP_PROPOSAL_CTNTVERS , 

  • Table: PRP_PROPOSALS 12.1.1

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_PROPOSALS,  object_name:PRP_PROPOSALS,  status:VALID,  product: PRP - Proposals ,  description: This table contains the information about the proposals. ,  implementation_dba_data: PRP.PRP_PROPOSALS , 

  • Table: PRP_EMAIL_HISTORY 12.1.1

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_EMAIL_HISTORY,  object_name:PRP_EMAIL_HISTORY,  status:VALID,  product: PRP - Proposals ,  description: This table contains the history of all the eMail sent to customers with proposal document as attachment. ,  implementation_dba_data: PRP.PRP_EMAIL_HISTORY , 

  • Table: PRP_EMAIL_HISTORY 12.2.2

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_EMAIL_HISTORY,  object_name:PRP_EMAIL_HISTORY,  status:VALID,  product: PRP - Proposals ,  description: This table contains the history of all the eMail sent to customers with proposal document as attachment. ,  implementation_dba_data: PRP.PRP_EMAIL_HISTORY , 

  • Table: PRP_PROPOSALS 12.2.2

    owner:PRP,  object_type:TABLE,  fnd_design_data:PRP.PRP_PROPOSALS,  object_name:PRP_PROPOSALS,  status:VALID,  product: PRP - Proposals ,  description: This table contains the information about the proposals. ,  implementation_dba_data: PRP.PRP_PROPOSALS , 

  • View: PRP_PROP_CUSTOMERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PRP.PRP_PROP_CUSTOMERS_V,  object_name:PRP_PROP_CUSTOMERS_V,  status:VALID,  product: PRP - Proposals ,  description: This View Provides proposal and proposal version details. ,  implementation_dba_data: APPS.PRP_PROP_CUSTOMERS_V , 

  • View: PRP_PROP_CUSTOMERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PRP.PRP_PROP_CUSTOMERS_V,  object_name:PRP_PROP_CUSTOMERS_V,  status:VALID,  product: PRP - Proposals ,  description: This View Provides proposal and proposal version details. ,  implementation_dba_data: APPS.PRP_PROP_CUSTOMERS_V , 

  • View: PRP_PROP_OBJECTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PRP.PRP_PROP_OBJECTS_V,  object_name:PRP_PROP_OBJECTS_V,  status:VALID,  product: PRP - Proposals ,  description: This View Provides proposal and proposal objects details. ,  implementation_dba_data: APPS.PRP_PROP_OBJECTS_V , 

  • View: PRP_PROP_OBJECTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PRP.PRP_PROP_OBJECTS_V,  object_name:PRP_PROP_OBJECTS_V,  status:VALID,  product: PRP - Proposals ,  description: This View Provides proposal and proposal objects details. ,  implementation_dba_data: APPS.PRP_PROP_OBJECTS_V ,