[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_BROKERAGE_CATEGORIES

Object Details

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

XTR_BROKERAGE_CATEGORIES contains brokerage category information. Each row in this table corresponds to one brokerage category and contains a description of that category. Brokerage categories are used for grouping the calculation methods and rates. You can assign a brokerage category to one or more counterparties. When you assign a brokerage category, it becomes the default brokerage category for the counterparty during deal input.
This table corresponds to the Categories region of the Categories tabbed region of the Brokerage Schedule and Details window.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Query Text

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

SELECT BROKERAGE_CATEGORY
,      DESCRIPTION
FROM XTR.XTR_BROKERAGE_CATEGORIES;

Dependencies

[top of page]

XTR.XTR_BROKERAGE_CATEGORIES does not reference any database object

XTR.XTR_BROKERAGE_CATEGORIES is referenced by following:

XTR

XTR_BROKERAGE_CATEGORIES#