Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_COUNTRY_COMPANY_LIMITS

Object Details
Object Name: XTR_COUNTRY_COMPANY_LIMITS
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_COUNTRY_COMPANY_LIMITS
Subobject Name:
Status: VALID


XTR_COUNTRY_COMPANY_LIMITS contains the country limit information for a company. Each row corresponds to a limit placed on a country in which counterparties of the company reside.
This table corresponds to the Sovereign Limits tabbed region in the Limits window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_COUNTRY_COMP_LIMITS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPANY_CODE
ColumnCOUNTRY_CODE
Columns
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
COUNTRY_CODE VARCHAR2 (2) Yes Country code
CREATED_BY VARCHAR2 (30)
User who created this record
CREATED_ON DATE

Date this record was created
LIMIT_AMOUNT NUMBER

Maximum amount allowed by the limit
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
Query Text

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


SELECT AUDIT_INDICATOR
,      AUTHORISED
,      COMPANY_CODE
,      COUNTRY_CODE
,      CREATED_BY
,      CREATED_ON
,      LIMIT_AMOUNT
,      UPDATED_BY
,      UPDATED_ON
,      UTILISED_AMOUNT
FROM XTR.XTR_COUNTRY_COMPANY_LIMITS;

Dependencies

[top of page]

XTR.XTR_COUNTRY_COMPANY_LIMITS does not reference any database object

XTR.XTR_COUNTRY_COMPANY_LIMITS is referenced by following:

SchemaXTR
ViewXTR_COUNTRY_COMPANY_LIMITS#