VIEW: APPS.CSM_CSI_ITEM_ATTR_V

Source

View Text - Preformatted

SELECT acc.access_id, attrval.attribute_value_id, attr.attribute_id, attr.attribute_level, attr.master_organization_id, attr.inventory_item_id, attrval.instance_id, attr.attribute_code, attr.attribute_name, attr.description, attrval.attribute_value, attr.active_start_date, attr.active_end_date FROM CSI_I_EXTENDED_ATTRIBS attr, CSI_IEA_VALUES attrval, CSM_CSI_ITEM_ATTR_ACC acc WHERE attr.attribute_id = attrval.attribute_id AND attrval.attribute_value_id = acc.attribute_value_id AND acc.user_id = asg_base.get_user_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ATTRVAL.ATTRIBUTE_VALUE_ID
, ATTR.ATTRIBUTE_ID
, ATTR.ATTRIBUTE_LEVEL
, ATTR.MASTER_ORGANIZATION_ID
, ATTR.INVENTORY_ITEM_ID
, ATTRVAL.INSTANCE_ID
, ATTR.ATTRIBUTE_CODE
, ATTR.ATTRIBUTE_NAME
, ATTR.DESCRIPTION
, ATTRVAL.ATTRIBUTE_VALUE
, ATTR.ACTIVE_START_DATE
, ATTR.ACTIVE_END_DATE
FROM CSI_I_EXTENDED_ATTRIBS ATTR
, CSI_IEA_VALUES ATTRVAL
, CSM_CSI_ITEM_ATTR_ACC ACC
WHERE ATTR.ATTRIBUTE_ID = ATTRVAL.ATTRIBUTE_ID
AND ATTRVAL.ATTRIBUTE_VALUE_ID = ACC.ATTRIBUTE_VALUE_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID