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_PROP_STYLE_CTNTVERS

Object Details

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

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PRP_PROP_STYLE_CTNTVERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROP_STYLE_CTNTVER_ID
PRP_PROP_STYLE_CTNTVERS_U999	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROPOSAL_ID OBJECT_TYPE OBJECT_ID
PRP_PROP_STYLE_CTNTVERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE OBJECT_ID INCLUDE_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
PROP_STYLE_CTNTVER_ID	NUMBER		Yes	Proposal component style content version identifier. This is a primary key column.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Object Version Number
PROPOSAL_ID	NUMBER		Yes	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)	Yes	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)	Yes	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)	Yes	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		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
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

Query Text

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


SELECT PROP_STYLE_CTNTVER_ID
,      OBJECT_VERSION_NUMBER
,      PROPOSAL_ID
,      COMP_STYLE_CTNTVER_ID
,      COMPONENT_STYLE_ID
,      COMPONENT_ID
,      DISPLAY_ORDER
,      MANDATORY_FLAG
,      COMPLETE_FLAG
,      INCLUDE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      OBJECT_TYPE
,      OBJECT_ID
FROM PRP.PRP_PROP_STYLE_CTNTVERS;

Dependencies

[top of page]

PRP.PRP_PROP_STYLE_CTNTVERS does not reference any database object

PRP.PRP_PROP_STYLE_CTNTVERS is referenced by following:

APPS: PRP_PROP_STYLE_CTNTVERS