VIEW: APPS.XNB_IB_ATTRIBUTE_VALUES_V

Source

View Text - Preformatted

SELECT ATTR_INFO.ATTRIBUTE_ID ATTRIBUTE_ID, ATTR_INFO.ATTRIBUTE_LEVEL ATTRIBUTE_LEVEL, ATTR_INFO.MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID, ATTR_INFO.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ATTR_INFO.ITEM_CATEGORY_ID ITEM_CATEGORY_ID, ATTR_INFO.ATTRIBUTE_CODE ATTRIBUTE_CODE, ATTR_INFO.ATTRIBUTE_NAME ATTRIBUTE_NAME, ATTR_INFO.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTR_INFO.DESCRIPTION DESCRIPTION, ATTR_INFO.ACTIVE_START_DATE ATTR_ACTIVE_START_DATE, ATTR_INFO.ACTIVE_END_DATE ATTR_ACTIVE_END_DATE, ATTR_INFO.SECURITY_GROUP_ID SECURITY_GROUP_ID, ATTR_VAL.INSTANCE_ID INSTANCE_ID, ATTR_VAL.ATTRIBUTE_VALUE_ID ATTRIBUTE_VALUE_ID, ATTR_VAL.ATTRIBUTE_VALUE ATTRIBUTE_VALUE, ATTR_VAL.ACTIVE_START_DATE ATTR_VAL_ACTIVE_START_DATE, ATTR_VAL.ACTIVE_END_DATE ATTR_VAL_ACTIVE_END_DATE FROM CSI_I_EXTENDED_ATTRIBS ATTR_INFO, CSI_IEA_VALUES ATTR_VAL WHERE ATTR_VAL.ATTRIBUTE_ID = ATTR_INFO.ATTRIBUTE_ID

View Text - HTML Formatted

SELECT ATTR_INFO.ATTRIBUTE_ID ATTRIBUTE_ID
, ATTR_INFO.ATTRIBUTE_LEVEL ATTRIBUTE_LEVEL
, ATTR_INFO.MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID
, ATTR_INFO.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ATTR_INFO.ITEM_CATEGORY_ID ITEM_CATEGORY_ID
, ATTR_INFO.ATTRIBUTE_CODE ATTRIBUTE_CODE
, ATTR_INFO.ATTRIBUTE_NAME ATTRIBUTE_NAME
, ATTR_INFO.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTR_INFO.DESCRIPTION DESCRIPTION
, ATTR_INFO.ACTIVE_START_DATE ATTR_ACTIVE_START_DATE
, ATTR_INFO.ACTIVE_END_DATE ATTR_ACTIVE_END_DATE
, ATTR_INFO.SECURITY_GROUP_ID SECURITY_GROUP_ID
, ATTR_VAL.INSTANCE_ID INSTANCE_ID
, ATTR_VAL.ATTRIBUTE_VALUE_ID ATTRIBUTE_VALUE_ID
, ATTR_VAL.ATTRIBUTE_VALUE ATTRIBUTE_VALUE
, ATTR_VAL.ACTIVE_START_DATE ATTR_VAL_ACTIVE_START_DATE
, ATTR_VAL.ACTIVE_END_DATE ATTR_VAL_ACTIVE_END_DATE
FROM CSI_I_EXTENDED_ATTRIBS ATTR_INFO
, CSI_IEA_VALUES ATTR_VAL
WHERE ATTR_VAL.ATTRIBUTE_ID = ATTR_INFO.ATTRIBUTE_ID