[Home] [Help] [Dependency Information]
Object Name: | BISM_OBJECTS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.BISM_OBJECTS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BISM_OBJECTS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | OBJECT_ID |
BISM_OBJECTS_UK1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FOLDER_ID
OBJECT_NAME USER_VISIBLE |
BISM_OBJECTS_UK2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
OBJECT_ID
FOLDER_ID |
BISM_OBJECTS_UK3 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FOLDER_ID
OBJECT_ID |
SYS_IL0000359098C00017$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000359098C00023$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
BISM_OBJECTS_CID | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CONTAINER_ID |
BISM_OBJECTS_FID | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FOLDER_ID |
BISM_OBJECTS_K4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FOLDER_ID
OBJECT_TYPE_ID USER_VISIBLE |
Table | |
Foreign Table | Foreign Key Column | BISM_OBJECTS | BISM_OBJECTS | BISM_OBJECTS FOLDER_ID | BISM_OBJECTS | BISM_OBJECTS | BISM_OBJECTS CONTAINER_ID | BISM_OBJECTS | BISM_OBJECT_TYPES | BISM_OBJECTS OBJECT_TYPE_ID | BISM_OBJECTS | BISM_SUBJECTS | BISM_OBJECTS LAST_MODIFIED_BY | BISM_OBJECTS | BISM_SUBJECTS | BISM_OBJECTS CREATED_BY | BISM_AGGREGATES | BISM_OBJECTS | BISM_AGGREGATES CONTAINEE_ID | BISM_AGGREGATES | BISM_OBJECTS | BISM_AGGREGATES CONTAINER_ID | BISM_ASSOCIATES | BISM_OBJECTS | BISM_ASSOCIATES SOURCE_ID | BISM_ASSOCIATES | BISM_OBJECTS | BISM_ASSOCIATES TARGET_ID | BISM_OBJECTS | BISM_OBJECTS | BISM_OBJECTS CONTAINER_ID | BISM_OBJECTS | BISM_OBJECTS | BISM_OBJECTS FOLDER_ID | BISM_PERMISSIONS | BISM_OBJECTS | BISM_PERMISSIONS OBJECT_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_VISIBLE | VARCHAR2 | (1) | ||
OBJECT_TYPE_ID | NUMBER | (5) | Yes | |
VERSION | NUMBER | (6) | ||
TIME_DATE_CREATED | DATE | |||
TIME_DATE_MODIFIED | DATE | |||
OBJECT_ID | RAW | (16) | Yes | |
CONTAINER_ID | RAW | (16) | ||
FOLDER_ID | RAW | (16) | Yes | |
CREATED_BY | RAW | (16) | Yes | |
LAST_MODIFIED_BY | RAW | (16) | Yes | |
OBJECT_NAME | VARCHAR2 | (256) | Yes | |
TITLE | VARCHAR2 | (128) | ||
APPLICATION | VARCHAR2 | (256) | ||
DATABASE | VARCHAR2 | (256) | ||
DESCRIPTION | VARCHAR2 | (1333) | ||
KEYWORDS | VARCHAR2 | (1333) | ||
XML | CLOB | (4000) | ||
APPLICATION_SUBTYPE1 | VARCHAR2 | (32) | ||
COMP_SUBTYPE1 | VARCHAR2 | (256) | ||
COMP_SUBTYPE2 | VARCHAR2 | (512) | ||
COMP_SUBTYPE3 | VARCHAR2 | (1333) | ||
EXTENSIBLE_ATTRIBUTES | XMLTYPE | (2000) | ||
TIME_DATE_LAST_ACCESSED | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT USER_VISIBLE
, OBJECT_TYPE_ID
, VERSION
, TIME_DATE_CREATED
, TIME_DATE_MODIFIED
, OBJECT_ID
, CONTAINER_ID
, FOLDER_ID
, CREATED_BY
, LAST_MODIFIED_BY
, OBJECT_NAME
, TITLE
, APPLICATION
, DATABASE
, DESCRIPTION
, KEYWORDS
, XML
, APPLICATION_SUBTYPE1
, COMP_SUBTYPE1
, COMP_SUBTYPE2
, COMP_SUBTYPE3
, EXTENSIBLE_ATTRIBUTES
, TIME_DATE_LAST_ACCESSED
FROM APPLSYS.BISM_OBJECTS;
|
|
|