eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PRP.PRP_PROPOSAL_CTNTVERS

Object Details

Object Name:	PRP_PROPOSAL_CTNTVERS
Object Type:	TABLE
Owner:	PRP
FND Design Data:	PRP.PRP_PROPOSAL_CTNTVERS
Subobject Name:
Status:	VALID

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PRP_PROPOSAL_CTNTVERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROPOSAL_CTNTVER_ID
PRP_PROPOSAL_CTNTVERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROPOSAL_ID VERSION_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
PROPOSAL_CTNTVER_ID	NUMBER		Yes	Proposal content version identifier. This is a primary key column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number
PROPOSAL_ID	NUMBER		Yes	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		Yes	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)	Yes	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)	Yes	Indicates if the physical document file for the proposal has the maximum version number.
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROPOSAL_CTNTVER_ID
,      OBJECT_VERSION_NUMBER
,      PROPOSAL_ID
,      LANGUAGE
,      FILE_ID
,      FILE_NAME
,      VERSION_NUMBER
,      CONTENT_VERSION_STATUS
,      CREATION_PROCESS
,      REMARKS
,      MAX_VERSION_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      CITEM_VERSION_ID
FROM PRP.PRP_PROPOSAL_CTNTVERS;

Dependencies

[top of page]

PRP.PRP_PROPOSAL_CTNTVERS does not reference any database object

PRP.PRP_PROPOSAL_CTNTVERS is referenced by following:

APPS: PRP_PROPOSAL_CTNTVERS