[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
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.
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 |
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;
APPS.XTR_STOCK_CASH_DIVIDENDS_V is not referenced by any database object
|
|
|