[Home] [Help] [Dependency Information]
Object Name: | AHL_UNIT_THRESHOLDS |
---|---|
Object Type: | TABLE |
Owner: | AHL |
FND Design Data: | AHL.AHL_UNIT_THRESHOLDS |
Subobject Name: | |
Status: | VALID |
This will store the item instance's threshold values, i.e Due at counter values, provided by Production or in cases where previous accomplishment data not available on the component and initial setup values are defined through Initialization.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AHL_UNIT_THRESHOLDS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | UNIT_THRESHOLD_ID |
AHL_UNIT_THRESHOLDS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
UNIT_DEFERRAL_ID
COUNTER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_THRESHOLD_ID | NUMBER | Yes | Primary Key, unique identifier of due at counters. | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Stores locking sequence number | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
UNIT_EFFECTIVITY_ID | NUMBER | Obsolete 11.5.10 onwards. | ||
COUNTER_ID | NUMBER | Yes | FK to CS_COUNTERS. | |
COUNTER_VALUE | NUMBER | Yes | Due at counter value either setup at initialization or "deferred" counter value provided by Production. | |
SECURITY_GROUP_ID | NUMBER | Used in application hosting | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
UNIT_DEFERRAL_ID | NUMBER | Yes | Foreign key to table ahl_unit_deferrals. | |
CTR_VALUE_TYPE_CODE | VARCHAR2 | (30) | Denotes Defer To or Defer By type for counter value |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_THRESHOLD_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, UNIT_EFFECTIVITY_ID
, COUNTER_ID
, COUNTER_VALUE
, SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, UNIT_DEFERRAL_ID
, CTR_VALUE_TYPE_CODE
FROM AHL.AHL_UNIT_THRESHOLDS;
AHL.AHL_UNIT_THRESHOLDS does not reference any database object
AHL.AHL_UNIT_THRESHOLDS is referenced by following:
|
|
|