[Home] [Help] [Dependency Information]
Object Name: | OE_AK_OBJ_ATTR_EXT |
---|---|
Object Type: | TABLE |
Owner: | ONT |
FND Design Data: | ONT.OE_AK_OBJ_ATTR_EXT |
Subobject Name: | |
Status: | VALID |
Extension table to AK Object Attributes. Used to store additional data, (eg. can the attribute be defaulted /constrained , security / clear dependent APIs) for the defaulting or constraints framework.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OE_AK_OBJ_ATTR_EXT_U1 | NORMAL | UNIQUE | APPS_TS_SEED | ATTRIBUTE_ID |
OE_AK_OBJ_ATTR_EXT_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
DATABASE_OBJECT_NAME
ATTRIBUTE_CODE ATTRIBUTE_APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Yes | Database object in AK for this attribute |
ATTRIBUTE_ID | NUMBER | Yes | Descriptive Flex-field segment | |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | Descriptive Flex-field segment |
ATTRIBUTE_APPLICATION_ID | NUMBER | Yes | Descriptive Flex-field segment | |
DEFAULTING_SEQUENCE | NUMBER | Yes | Sequence in which this attribute is defaulted | |
DEFAULTING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Y if defaulting rules can be defined for this attribute |
DEFAULTING_CONDN_REF_FLAG | VARCHAR2 | (1) | Yes | Y if this attribute can be used in building defaulting conditions |
DEFAULTING_SOURCE_FLAG | VARCHAR2 | (1) | Yes | Y if this attribute can be used as a defaulting source |
CONSTRAINTS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Y if constraints can be setup for this attribute |
CONSTRAINT_CONDN_REF_FLAG | VARCHAR2 | (1) | Yes | Y if this attribute can be used in constraints validation templates |
PRICING_RULE_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Obsolete Column |
DISCOUNTS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Used to indicate that the column can be used in applying discounts |
HOLDS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | If Y this attribute can be used in creating hold sources. |
NOTES_ENABLED_FLAG | VARCHAR2 | (1) | Yes | If Y this attribute can be used in building attachment addition rules |
COLUMN_TYPE_CODE | VARCHAR2 | (30) | Obsolete Column | |
DEPENDENT_API_PKG | VARCHAR2 | (30) | Database package that clears the dependent attributes for this attribute | |
DEPENDENT_API_PROC | VARCHAR2 | (30) | Procedure to clear dependent attributes for this attribute | |
SECURITY_API_PKG | VARCHAR2 | (30) | Database package to check security constraints on this attribute | |
SECURITY_API_PROC | VARCHAR2 | (30) | Procedure to check security constraints on this attribute | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who column | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
STATE_ATTRIBUTE_FLAG | VARCHAR2 | (1) | If Y this attribute represents a status column i.e. it stores information on what is the workflow state of the order or line. (e.g. BOOKED_FLAG) | |
ATTACHMENTS_ENABLED_FLAG | VARCHAR2 | (1) | Yes | if Y this attribute can be used in building attachment rules |
Cut, paste (and edit) the following text to query this object:
SELECT DATABASE_OBJECT_NAME
, ATTRIBUTE_ID
, ATTRIBUTE_CODE
, ATTRIBUTE_APPLICATION_ID
, DEFAULTING_SEQUENCE
, DEFAULTING_ENABLED_FLAG
, DEFAULTING_CONDN_REF_FLAG
, DEFAULTING_SOURCE_FLAG
, CONSTRAINTS_ENABLED_FLAG
, CONSTRAINT_CONDN_REF_FLAG
, PRICING_RULE_ENABLED_FLAG
, DISCOUNTS_ENABLED_FLAG
, HOLDS_ENABLED_FLAG
, NOTES_ENABLED_FLAG
, COLUMN_TYPE_CODE
, DEPENDENT_API_PKG
, DEPENDENT_API_PROC
, SECURITY_API_PKG
, SECURITY_API_PROC
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, STATE_ATTRIBUTE_FLAG
, ATTACHMENTS_ENABLED_FLAG
FROM ONT.OE_AK_OBJ_ATTR_EXT;
ONT.OE_AK_OBJ_ATTR_EXT does not reference any database object
ONT.OE_AK_OBJ_ATTR_EXT is referenced by following:
|
|
|