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]

VIEW: APPS.XTR_STOCK_CASH_DIVIDENDS_V

Object Details

Object Name:	XTR_STOCK_CASH_DIVIDENDS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_STOCK_CASH_DIVIDENDS_V
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.

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DEAL_NUMBER	NUMBER		Yes	Unique number assigned to each deal
TRANSACTION_NUMBER	NUMBER		Yes	Unique reference number assigned to a transaction
STOCK_ISSUE_CODE	VARCHAR2	(30)	Yes	Stock issue code
COMPANY_CODE	VARCHAR2	(7)		Company code
CPARTY_CODE	VARCHAR2	(7)		Counterparty code
CLIENT_CODE	VARCHAR2	(7)		Client for which the deal is made
CURRENCY	VARCHAR2	(15)	Yes	Currency code
PORTFOLIO_CODE	VARCHAR2	(7)		Code for grouping deals under a single portfolio
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type
QUANTITY	NUMBER			Number of stock shares
DIVIDEND_PER_SHARE	NUMBER		Yes	Cash dividend per stock share
TOTAL_DIVIDENDS	NUMBER			Interest amount
TAX_RATE	NUMBER
TAX_AMOUNT	NUMBER			Tax amount
AFTER_TAX	NUMBER
DECLARE_DATE	DATE
RECORD_DATE	DATE
PAYMENT_DATE	DATE

Query Text

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


SELECT DEAL_NUMBER
,      TRANSACTION_NUMBER
,      STOCK_ISSUE_CODE
,      COMPANY_CODE
,      CPARTY_CODE
,      CLIENT_CODE
,      CURRENCY
,      PORTFOLIO_CODE
,      PRODUCT_TYPE
,      QUANTITY
,      DIVIDEND_PER_SHARE
,      TOTAL_DIVIDENDS
,      TAX_RATE
,      TAX_AMOUNT
,      AFTER_TAX
,      DECLARE_DATE
,      RECORD_DATE
,      PAYMENT_DATE
FROM APPS.XTR_STOCK_CASH_DIVIDENDS_V;

Dependencies

[top of page]

APPS.XTR_STOCK_CASH_DIVIDENDS_V references the following:

APPS: XTR_ROLLOVER_TRANSACTIONS; XTR_STOCK_CASH_DIVIDENDS

APPS.XTR_STOCK_CASH_DIVIDENDS_V is not referenced by any database object