Skip to content

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

TABLE: IEX.IEX_XML_QUERIES

Object Details
Object Name: IEX_XML_QUERIES
Object Type: TABLE
Owner: IEX
FND Design Data: TableIEX.IEX_XML_QUERIES
Subobject Name:
Status: VALID


This table holds the query for xml publisher template.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000402254C00015$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
IEX_XML_QUERIES_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnQUERY_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER (10) Yes Query id for xdo template
STATEMENT VARCHAR2 (4000)
sql statement for xdo template
DESCRIPTION VARCHAR2 (4000)
query description
START_DATE DATE

valid query start date
END_DATE DATE

valid query end date
ENABLED_FLAG VARCHAR2 (10)
is this query enable
OBJECT_TYPE VARCHAR2 (20)
object type of this query - where is from
QUERY_LEVEL VARCHAR2 (20)
Query Level Customer/Account/Bill_to/Delinquent
CREATED_BY NUMBER

record creation by
CREATION_DATE DATE

record creation date
LAST_UPDATE_DATE DATE

record last update date
LAST_UPDATED_BY NUMBER

record last updated by
LAST_UPDATE_LOGIN NUMBER

record last update login from
OBJECT_VERSION_NUMBER NUMBER

object version number
ADDITIONAL_QUERY CLOB (4000)
Additional sql statement for xdo template
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT QUERY_ID
,      STATEMENT
,      DESCRIPTION
,      START_DATE
,      END_DATE
,      ENABLED_FLAG
,      OBJECT_TYPE
,      QUERY_LEVEL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ADDITIONAL_QUERY
,      ZD_EDITION_NAME
FROM IEX.IEX_XML_QUERIES;

Dependencies

[top of page]

IEX.IEX_XML_QUERIES does not reference any database object

IEX.IEX_XML_QUERIES is referenced by following:

SchemaIEX
ViewIEX_XML_QUERIES#