eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: XTR.XTR_STOCK_ISSUES

Object Details

Object Name:	XTR_STOCK_ISSUES
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_STOCK_ISSUES
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_STOCK_ISSUES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	STOCK_ISSUE_CODE
XTR_STOCK_ISSUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY

Columns

Name	Datatype	Length	Mandatory	Comments
STOCK_ISSUE_CODE	VARCHAR2	(30)	Yes	Stock issue code defined by user
AUTHORIZED	VARCHAR2	(1)		To specify if stock issue is authorized
DESCRIPTION	VARCHAR2	(240)		Description of stock issue
STOCK_ISSUER	VARCHAR2	(7)	Yes	Issuer of the stock
CURRENCY	VARCHAR2	(15)	Yes	Currency of the stock issue
TICKER_SYMBOL	VARCHAR2	(15)		Ticker symbol of the stock issue defined in the market
SECURITY_ID	VARCHAR2	(15)		Security ID
EXCHANGE	VARCHAR2	(15)		The exchange market
ISSUE_DATE	DATE			Issue date
SECTOR	VARCHAR2	(30)		The business sector which the stock issue belong to
PRODUCT_TYPE	VARCHAR2	(10)		User defined product type
MARKET_DATA_SET	VARCHAR2	(30)		Market data set of the stock issue
PRICING_MODEL	VARCHAR2	(30)		Pricing model used for Revaluations
RIC_CODE	VARCHAR2	(20)		Reference rate defined in Current System Rates form
CREATED_BY	NUMBER			Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield

Query Text

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


SELECT STOCK_ISSUE_CODE
,      AUTHORIZED
,      DESCRIPTION
,      STOCK_ISSUER
,      CURRENCY
,      TICKER_SYMBOL
,      SECURITY_ID
,      EXCHANGE
,      ISSUE_DATE
,      SECTOR
,      PRODUCT_TYPE
,      MARKET_DATA_SET
,      PRICING_MODEL
,      RIC_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM XTR.XTR_STOCK_ISSUES;

Dependencies

[top of page]

XTR.XTR_STOCK_ISSUES does not reference any database object

XTR.XTR_STOCK_ISSUES is referenced by following:

XTR: XTR_STOCK_ISSUES#