[Home] [Help] [Dependency Information]
Object Name: | IES_SVY_RESOURCES |
---|---|
Object Type: | TABLE |
Owner: | IES |
FND Design Data: | IES.IES_SVY_RESOURCES |
Subobject Name: | |
Status: | VALID |
This table contains all the resouces defined to be used as header, error or final pages in the survey. The resources are defined under Resource sub tab in
main Survey tab. When creating a survey, the lookups for Header, Error and Final Pages will be based on a query on this table
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IES_SVY_RESOURCES_N1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SURVEY_RESOURCE_ID |
SYS_IL0000133770C00030$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SURVEY_RESOURCE_ID | NUMBER | Yes | Unique identifier for Resources defined for a survey | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version number required for HTML interfaces |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard who column |
LANGUAGE_ID | NUMBER | Language ID from FND_LANGUAGES table | ||
LOGICAL_NAME | VARCHAR2 | (80) | Logical name for a resources | |
PHYSICAL_NAME | VARCHAR2 | (1000) | Yes | Name of the actual file eg. myheader.jsp |
DESCRIPTION | VARCHAR2 | (240) | Description of Resource | |
F_DELETEDFLAG | VARCHAR2 | (1) | Used by AOM for soft Delete | |
SECURITY_GROUP_ID | NUMBER | (15) | Used for Hosted Environment | |
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 | |
FILE_CONTENT | CLOB | (4000) | Static HTML content loaded as CLOB | |
RESOURCE_TYPE | VARCHAR2 | (30) | Resource Type to distinguish between the different Resources (JSP, URL or File Name) |
Cut, paste (and edit) the following text to query this object:
SELECT SURVEY_RESOURCE_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LANGUAGE_ID
, LOGICAL_NAME
, PHYSICAL_NAME
, DESCRIPTION
, F_DELETEDFLAG
, SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, FILE_CONTENT
, RESOURCE_TYPE
FROM IES.IES_SVY_RESOURCES;
IES.IES_SVY_RESOURCES does not reference any database object
IES.IES_SVY_RESOURCES is referenced by following:
|
|
|