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_TAX_BROKERAGE_DETAILS_V

Object Details

Object Name:	XTR_TAX_BROKERAGE_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_TAX_BROKERAGE_DETAILS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

XTR_TAX_BROKERAGE_DETAILS_V contains information on the withholding tax and brokerage fee settlement amounts that are due. Rows where TAX_BKGE= ?B? correspond to a brokerage fee. Rows where TAX_BKGE=?T? correspond to a withholding tax.
This view corresponds to the Tax and Brokerage Settlements window.

[View Source]

Columns

Name	Datatype	Length	Comments
DEAL_NUM	NUMBER		Unique number assigned to each deal
TRANS_NUM	NUMBER		Unique reference number assigned to a transaction
CPARTY_CODE	VARCHAR2	(7)	Counterparty code
CLIENT_CODE	VARCHAR2	(7)	Client for which the deal is made
COMPANY_CODE	VARCHAR2	(7)	Company code
TAX_PAYEE	VARCHAR2	(7)	Party to whom the tax is paid
BROKERAGE_PAYEE	VARCHAR2	(7)	Party to whom the brokerage fee is paid
DEAL_TYPE	VARCHAR2	(7)	Code for high level deals
USER_DEAL_TYPE	VARCHAR2	(7)	User-defined deal type code
DEAL_SUBTYPE	VARCHAR2	(7)	Code for deal executions permissible within a deal type
USER_DEAL_SUBTYPE	VARCHAR2	(7)	User-defined deal subtype code
PRODUCT_TYPE	VARCHAR2	(10)	Code for products used in a deal type
BROKERAGE_AMOUNT	NUMBER		Brokerage settlement reference number (all transactions with the same reference number were settled together in one settle action)
TAX_AMOUNT	NUMBER		Tax amount
DEAL_DATE	DATE		Date the deal is made
CURRENCY	VARCHAR2	(15)	Currency code
BROKERAGE_CODE	VARCHAR2	(7)	Brokerage code
TAX_CODE	VARCHAR2	(7)	Tax code
TAX_SETTLED_REFERENCE	NUMBER		Reference number of the tax settlement of the transaction
BKGE_SETTLED_REFERENCE	NUMBER		Brokerage settlement reference number (all transactions with the same reference number were settled together in one settle action)

Query Text

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


SELECT DEAL_NUM
,      TRANS_NUM
,      CPARTY_CODE
,      CLIENT_CODE
,      COMPANY_CODE
,      TAX_PAYEE
,      BROKERAGE_PAYEE
,      DEAL_TYPE
,      USER_DEAL_TYPE
,      DEAL_SUBTYPE
,      USER_DEAL_SUBTYPE
,      PRODUCT_TYPE
,      BROKERAGE_AMOUNT
,      TAX_AMOUNT
,      DEAL_DATE
,      CURRENCY
,      BROKERAGE_CODE
,      TAX_CODE
,      TAX_SETTLED_REFERENCE
,      BKGE_SETTLED_REFERENCE
FROM APPS.XTR_TAX_BROKERAGE_DETAILS_V;

Dependencies

[top of page]

APPS.XTR_TAX_BROKERAGE_DETAILS_V references the following:

APPS: XTR_DEALS_V; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES; XTR_ROLLOVER_TRANSACTIONS_V; XTR_TAX_BROKERAGE_SETUP; XTR_USER_ACCESS - show dependent code

APPS.XTR_TAX_BROKERAGE_DETAILS_V is not referenced by any database object