[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_GROUP_LIMITS |
|---|---|
| Object Type: | TABLE |
| Owner: | XTR |
| FND Design Data: |  XTR.XTR_GROUP_LIMITS
|
| Subobject Name: | |
| Status: | VALID |
XTR_GROUP_LIMITS contains group limit information. Each row corresponds to a limit placed on a company against a counterparty group for a limit type. Currently, three limit types are derived from the FX_INVEST_FUND_TYPE column in the XTR_LIMIT_TYPES table: F or fund, I or invest and X or foreign exchange, are derived from the. The fourth limit type is XI, or foreign exchange and invest.
This table corresponds to the Group Limits tabbed region in the Limits window.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
| AUTHORISED | VARCHAR2 | (1) | Flag to indicate if the limit is authorized (Y), or not (N) | |
| COMPANY_CODE | VARCHAR2 | (7) | Yes | Company code |
| CPARTY_CODE | VARCHAR2 | (7) | Yes | Counterparty code |
| CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
| CREATED_ON | DATE | Yes | Date this record was created | |
| EXPIRY_DATE | DATE | Expiration date for the limit | ||
| LIMIT_AMOUNT | NUMBER | Maximum amount allowed by the limit | ||
| LIMIT_TYPE | VARCHAR2 | (2) | Yes | Limit categories to which the group limit belongs (F, I, X or XI) |
| UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
| UPDATED_ON | DATE | Date this record was last updated | ||
| UTILISED_AMOUNT | NUMBER | Total amount that deal transactions have applied to the limit |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_INDICATOR
, AUTHORISED
, COMPANY_CODE
, CPARTY_CODE
, CREATED_BY
, CREATED_ON
, EXPIRY_DATE
, LIMIT_AMOUNT
, LIMIT_TYPE
, UPDATED_BY
, UPDATED_ON
, UTILISED_AMOUNT
FROM XTR.XTR_GROUP_LIMITS;
XTR.XTR_GROUP_LIMITS does not reference any database object
XTR.XTR_GROUP_LIMITS is referenced by following:
XTR
XTR_GROUP_LIMITS#
|
|
|
|