VIEW: APPS.ASO_EXTENDED_ATTRIBS_BALI_V

Source

View Text - Preformatted

SELECT a.instance_id, c.attribute_name , a.attribute_value FROM csi_iea_values a, csi_i_extended_attribs c, csi_item_instances b WHERE c.attribute_id = a.attribute_id and b.instance_id = a.instance_id and NVL(a.active_end_date, SYSDATE) >= SYSDATE

View Text - HTML Formatted

SELECT A.INSTANCE_ID
, C.ATTRIBUTE_NAME
, A.ATTRIBUTE_VALUE
FROM CSI_IEA_VALUES A
, CSI_I_EXTENDED_ATTRIBS C
, CSI_ITEM_INSTANCES B
WHERE C.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND B.INSTANCE_ID = A.INSTANCE_ID
AND NVL(A.ACTIVE_END_DATE
, SYSDATE) >= SYSDATE