[Home] [Help] [Dependency Information]
Object Name: | XTR_COMPANY_LIMITS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_COMPANY_LIMITS |
Subobject Name: | |
Status: | VALID |
XTR_COMPANY_LIMITS contains company limits information. Each limit corresponds to a limit type defined in XTR_LIMIT_TYPES. A company can have multiple limits placed on it as long as the limit code is unique for each company.
This table corresponds to the Global Limits tabbed region in the Limits window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_COMPANY_LIMITS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LIMIT_CODE
COMPANY_CODE |
XTR_COMPANY_LIMITS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LIMIT_TYPE |
XTR_COMPANY_LIMITS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COMPANY_CODE |
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 |
CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
CREATED_ON | DATE | Yes | Date this record was created | |
LIMIT_AMOUNT | NUMBER | Maximum amount allowed by the limit | ||
LIMIT_CODE | VARCHAR2 | (7) | Yes | Code for user-defined limits imposed on deals and transactions |
LIMIT_TYPE | VARCHAR2 | (2) | Yes | Limit type code (tied to one of four limit categories) |
NAME | VARCHAR2 | (20) | Yes | Limit name |
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 | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Contains descriptive flexfield context value | |
ATTRIBUTE1 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (256) | Descriptive flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_INDICATOR
, AUTHORISED
, COMPANY_CODE
, CREATED_BY
, CREATED_ON
, LIMIT_AMOUNT
, LIMIT_CODE
, LIMIT_TYPE
, NAME
, UPDATED_BY
, UPDATED_ON
, UTILISED_AMOUNT
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM XTR.XTR_COMPANY_LIMITS;
XTR.XTR_COMPANY_LIMITS does not reference any database object
XTR.XTR_COMPANY_LIMITS is referenced by following:
|
|
|