[Home] [Help] [Dependency Information]
Object Name: | XNB_IB_ATTRIBUTE_VALUES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_ID | NUMBER | Yes | Attribute Id | |
ATTRIBUTE_LEVEL | VARCHAR2 | (15) | Yes | Attribute Level |
MASTER_ORGANIZATION_ID | NUMBER | Master Organization Id | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item Id | ||
ITEM_CATEGORY_ID | NUMBER | Item Category Id | ||
ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | Attribute Code |
ATTRIBUTE_NAME | VARCHAR2 | (50) | Yes | Attribute Name |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Attribute category | |
DESCRIPTION | VARCHAR2 | (240) | Description | |
ATTR_ACTIVE_START_DATE | DATE | Attribute Active Start Date | ||
ATTR_ACTIVE_END_DATE | DATE | Attribute Active End Date | ||
SECURITY_GROUP_ID | NUMBER | Security Group Id | ||
INSTANCE_ID | NUMBER | Yes | Instance Id | |
ATTRIBUTE_VALUE_ID | NUMBER | Yes | Attribute Value Id | |
ATTRIBUTE_VALUE | VARCHAR2 | (240) | Attribute Value | |
ATTR_VAL_ACTIVE_START_DATE | DATE | Attribute Value Active Start Date | ||
ATTR_VAL_ACTIVE_END_DATE | DATE | Attribute Value Active End Date |
Cut, paste (and edit) the following text to query this object:
SELECT ATTRIBUTE_ID
, ATTRIBUTE_LEVEL
, MASTER_ORGANIZATION_ID
, INVENTORY_ITEM_ID
, ITEM_CATEGORY_ID
, ATTRIBUTE_CODE
, ATTRIBUTE_NAME
, ATTRIBUTE_CATEGORY
, DESCRIPTION
, ATTR_ACTIVE_START_DATE
, ATTR_ACTIVE_END_DATE
, SECURITY_GROUP_ID
, INSTANCE_ID
, ATTRIBUTE_VALUE_ID
, ATTRIBUTE_VALUE
, ATTR_VAL_ACTIVE_START_DATE
, ATTR_VAL_ACTIVE_END_DATE
FROM APPS.XNB_IB_ATTRIBUTE_VALUES_V;
APPS.XNB_IB_ATTRIBUTE_VALUES_V is not referenced by any database object
|
|
|