VIEW: APPS.OE_DISCOUNT_BY_V

Source

View Text - Preformatted

SELECT vl.name , attr.attribute_id , attr.attribute_code from oe_ak_obj_attr_ext attr, ak_object_attributes_vl vl WHERE attr.attribute_code = vl.attribute_code and attr.database_object_name = vl.database_object_name and attr.attribute_application_id = vl.attribute_application_id and attr.discounts_enabled_flag = 'Y'

View Text - HTML Formatted

SELECT VL.NAME
, ATTR.ATTRIBUTE_ID
, ATTR.ATTRIBUTE_CODE
FROM OE_AK_OBJ_ATTR_EXT ATTR
, AK_OBJECT_ATTRIBUTES_VL VL
WHERE ATTR.ATTRIBUTE_CODE = VL.ATTRIBUTE_CODE
AND ATTR.DATABASE_OBJECT_NAME = VL.DATABASE_OBJECT_NAME
AND ATTR.ATTRIBUTE_APPLICATION_ID = VL.ATTRIBUTE_APPLICATION_ID
AND ATTR.DISCOUNTS_ENABLED_FLAG = 'Y'