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

TABLE: CSL.CSL_LOBS_INQ

Object Details
Object Name: CSL_LOBS_INQ
Object Type: TABLE
Owner: CSL
Subobject Name:
Status: VALID


INQ Table for Sugnature support


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000324747C00006$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
CLID$$CS VARCHAR2 (240)
Mobile username refers to FND_USER
FILE_ID NUMBER

File Id of the Binary object
TASK_ASSIGNMENT_ID NUMBER

Task Assignment Id
DESCRIPTION VARCHAR2 (255)
Description of the file
LANGUAGE VARCHAR2 (30)
Language
FILE_DATA BLOB (4000)
Actual File contents
DMLTYPE$$ VARCHAR2 (1)
DML Type - Delete/Insert/Update
SEQNO$$ NUMBER (10)
Sequence Number
TRANID$$ NUMBER (10)
Transaction Id
VERSION$$ NUMBER (10)
Version
ENTITY_NAME VARCHAR2 (40)
no comments
PK1_VALUE VARCHAR2 (100)
no comments
PK2_VALUE VARCHAR2 (100)
no comments
SEQ_NUM NUMBER (38)
no comments
FILE_NAME VARCHAR2 (256)
no comments
FILE_CONTENT_TYPE VARCHAR2 (256)
no comments
USER_NAME VARCHAR2 (255)
no comments
Query Text

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


SELECT CLID$$CS
,      FILE_ID
,      TASK_ASSIGNMENT_ID
,      DESCRIPTION
,      LANGUAGE
,      FILE_DATA
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
,      ENTITY_NAME
,      PK1_VALUE
,      PK2_VALUE
,      SEQ_NUM
,      FILE_NAME
,      FILE_CONTENT_TYPE
,      USER_NAME
FROM CSL.CSL_LOBS_INQ;

Dependencies

[top of page]

CSL.CSL_LOBS_INQ does not reference any database object

CSL.CSL_LOBS_INQ is referenced by following:

SchemaCSL
ViewCSL_LOBS_INQ#