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

TABLE: FUN.FUN_CONTACTUS_REQUEST_DATA

Object Details
Object Name: FUN_CONTACTUS_REQUEST_DATA
Object Type: TABLE
Owner: FUN
FND Design Data: TableFUN.FUN_CONTACTUS_REQUEST_DATA
Subobject Name:
Status: VALID

This table contains information about the question or problem submitted by the end user that is stored in a prompt-value pair format.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FUN_CONTACTUS_REQUEST_DATA_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDATA_ID
FUN_CONTACTUS_REQUEST_DATA_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
DATA_ID NUMBER (15) Yes Unique identifier for the request data
REQUEST_ID NUMBER (15) Yes Unique identifier for question or problem submitted by the end user
PROMPT_CODE VARCHAR2 (150) Yes Prompt; Lookup code for the FUN_CONTACTUS_REQUEST_PROMPT lookup type
DATA VARCHAR2 (150)
Data for the corresponding prompt
CREATION_DATE DATE

Standard WHO Column
CREATED_BY NUMBER (15)
Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
Query Text

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


SELECT DATA_ID
,      REQUEST_ID
,      PROMPT_CODE
,      DATA
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM FUN.FUN_CONTACTUS_REQUEST_DATA;

Dependencies

[top of page]

FUN.FUN_CONTACTUS_REQUEST_DATA does not reference any database object

FUN.FUN_CONTACTUS_REQUEST_DATA is referenced by following:

SchemaAPPS
SynonymFUN_CONTACTUS_REQUEST_DATA