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

TABLE: APPLSYS.FND_IREP_CLASS_DATASOURCES

Object Details
Object Name: FND_IREP_CLASS_DATASOURCES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_IREP_CLASS_DATASOURCES
Subobject Name:
Status: VALID

Stores metadata about data sources exposed on a Service

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: FND_IREP_CLASS_DATASOURCES_PK
  1. ColumnCLASS_ID
  2. ColumnDATASOURCE_NAME
Indexes
Index Type Uniqueness Tablespace Column
FND_IREP_CLASS_DATASOURCES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLASS_ID
ColumnDATASOURCE_NAME
Columns
Name Datatype Length Mandatory Comments
CLASS_ID NUMBER (15) Yes Service Class ID
DATASOURCE_NAME VARCHAR2 (120) Yes Service Data Source name
DEF_CLASS VARCHAR2 (400) Yes Service View Object definition name
QUERYABLE VARCHAR2 (1) Yes Indicates if the data source can be queried. (Y/N)
UPDATEABLE VARCHAR2 (1) Yes Indicates if you can update records in the data source. (Y/N)
INSERTABLE VARCHAR2 (1) Yes Indicates if you can insert records in the data source.(Y/N)
MERGEABLE VARCHAR2 (1) Yes Indicates if you can merge records in the data source. (Y/N)
DELETEABLE VARCHAR2 (1) Yes Indicates if you can update records in the data source. (Y/N)
PROCESS_CTRLPROP_QNAME VARCHAR2 (120)
QUERY_CTRLPROP_QNAME VARCHAR2 (120)
Query Text

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


SELECT CLASS_ID
,      DATASOURCE_NAME
,      DEF_CLASS
,      QUERYABLE
,      UPDATEABLE
,      INSERTABLE
,      MERGEABLE
,      DELETEABLE
,      PROCESS_CTRLPROP_QNAME
,      QUERY_CTRLPROP_QNAME
FROM APPLSYS.FND_IREP_CLASS_DATASOURCES;

Dependencies

[top of page]

APPLSYS.FND_IREP_CLASS_DATASOURCES does not reference any database object

APPLSYS.FND_IREP_CLASS_DATASOURCES is referenced by following:

SchemaAPPS
SynonymFND_IREP_CLASS_DATASOURCES