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

TABLE: PRP.PRP_PROPOSALS

Object Details
Object Name: PRP_PROPOSALS
Object Type: TABLE
Owner: PRP
FND Design Data: TablePRP.PRP_PROPOSALS
Subobject Name:
Status: VALID


This table contains the information about the proposals.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PRP_PROPOSALS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROPOSAL_ID
PRP_PROPOSALS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_ID
PRP_PROPOSALS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
Columns
Name Datatype Length Mandatory Comments
PROPOSAL_ID NUMBER
Yes Proposal identifier. This is a primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object Version Number
PROPOSAL_NAME VARCHAR2 (240) Yes Proposal name
PROPOSAL_DESC VARCHAR2 (2000)
Proposal description
USER_ID NUMBER
Yes User identifier. The user who created the proposal. This column is foreign key to FND_USER.
PROPOSAL_LANGUAGE VARCHAR2 (4) Yes Language of the proposal
PROPOSAL_STATUS VARCHAR2 (30) Yes 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
Yes 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
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
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
Query Text

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


SELECT PROPOSAL_ID
,      OBJECT_VERSION_NUMBER
,      PROPOSAL_NAME
,      PROPOSAL_DESC
,      USER_ID
,      PROPOSAL_LANGUAGE
,      PROPOSAL_STATUS
,      TEMPLATE_ID
,      DUE_DATE
,      PARTY_ID
,      CONTACT_PARTY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTENT_ITEM_ID
FROM PRP.PRP_PROPOSALS;

Dependencies

[top of page]

PRP.PRP_PROPOSALS does not reference any database object

PRP.PRP_PROPOSALS is referenced by following:

SchemaAPPS
SynonymPRP_PROPOSALS