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

TABLE: IMC.IMC_THREE_SIXTY_SSM_QUERY

Object Details
Object Name: IMC_THREE_SIXTY_SSM_QUERY
Object Type: TABLE
Owner: IMC
FND Design Data: TableIMC.IMC_THREE_SIXTY_SSM_QUERY
Subobject Name:
Status: VALID


The IMC_THREE_SIXTY_SSM_QUERY table stores queries to external source systems for transaction information. The stored query string runs against the data source and returns a value, which can be bound to the main transaction query. The main query information is used, for example, to render the summary view, which shows specific transaction types, as well as the detail view, which shows specific transactions within a type depending on filter attribute values.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IMC_THREE_SIXTY_SSM_QUERY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSSM_QUERY_ID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
SSM_QUERY_ID NUMBER (15) Yes External query identifier
SSM_QUERY_STRING VARCHAR2 (2000) Yes Query string
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15)
Version number of the record
APPLICATION_ID NUMBER (15)
IMC who column
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT SSM_QUERY_ID
,      SSM_QUERY_STRING
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      OBJECT_VERSION_NUMBER
,      APPLICATION_ID
,      ZD_EDITION_NAME
FROM IMC.IMC_THREE_SIXTY_SSM_QUERY;

Dependencies

[top of page]

IMC.IMC_THREE_SIXTY_SSM_QUERY does not reference any database object

IMC.IMC_THREE_SIXTY_SSM_QUERY is referenced by following:

SchemaIMC
ViewIMC_THREE_SIXTY_SSM_QUERY#