VIEW: APPS.CSL_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 FROM CSI_I_EXTENDED_ATTRIBS attr, CSI_IEA_VALUES attrval, CSL_CSI_ITEM_ATTR_ACC acc WHERE attr.attribute_id = attrval.attribute_id AND attrval.attribute_value_id = acc.attribute_value_id AND acc.resource_id = ASG_BASE.GET_RESOURCE_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
FROM CSI_I_EXTENDED_ATTRIBS ATTR
, CSI_IEA_VALUES ATTRVAL
, CSL_CSI_ITEM_ATTR_ACC ACC
WHERE ATTR.ATTRIBUTE_ID = ATTRVAL.ATTRIBUTE_ID
AND ATTRVAL.ATTRIBUTE_VALUE_ID = ACC.ATTRIBUTE_VALUE_ID
AND ACC.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID