VIEW: APPS.PV_ATTRIBUTES_VL

Source

View Text - Preformatted

SELECT pv_attributes_b.attribute_id ,pv_attributes_b.last_update_date ,pv_attributes_b.last_updated_by ,pv_attributes_b.creation_date ,pv_attributes_b.created_by ,pv_attributes_b.last_update_login ,pv_attributes_b.object_version_number ,pv_attributes_b.enabled_flag ,pv_attributes_tl.name ,pv_attributes_tl.description ,pv_attributes_tl.short_name ,pv_attributes_b.attribute_type ,pv_attributes_b.attribute_category ,pv_attributes_b.seeded_flag ,pv_attributes_b.lov_function_name ,pv_attributes_b.return_type ,pv_attributes_b.max_value_flag ,pv_attributes_b.display_style ,pv_attributes_b.expose_to_partner_flag ,pv_attributes_b.character_width ,pv_attributes_b.decimal_points ,pv_attributes_b.no_of_lines ,pv_attributes_b.value_extn_return_type ,pv_attributes_b.enable_matching_flag ,pv_attributes_b.performance_flag ,pv_attributes_b.additive_flag ,pv_attributes_b.sequence_number FROM PV_ATTRIBUTES_B ,PV_ATTRIBUTES_TL WHERE PV_ATTRIBUTES_B.ATTRIBUTE_ID = PV_ATTRIBUTES_TL.ATTRIBUTE_ID AND PV_ATTRIBUTES_TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT PV_ATTRIBUTES_B.ATTRIBUTE_ID
, PV_ATTRIBUTES_B.LAST_UPDATE_DATE
, PV_ATTRIBUTES_B.LAST_UPDATED_BY
, PV_ATTRIBUTES_B.CREATION_DATE
, PV_ATTRIBUTES_B.CREATED_BY
, PV_ATTRIBUTES_B.LAST_UPDATE_LOGIN
, PV_ATTRIBUTES_B.OBJECT_VERSION_NUMBER
, PV_ATTRIBUTES_B.ENABLED_FLAG
, PV_ATTRIBUTES_TL.NAME
, PV_ATTRIBUTES_TL.DESCRIPTION
, PV_ATTRIBUTES_TL.SHORT_NAME
, PV_ATTRIBUTES_B.ATTRIBUTE_TYPE
, PV_ATTRIBUTES_B.ATTRIBUTE_CATEGORY
, PV_ATTRIBUTES_B.SEEDED_FLAG
, PV_ATTRIBUTES_B.LOV_FUNCTION_NAME
, PV_ATTRIBUTES_B.RETURN_TYPE
, PV_ATTRIBUTES_B.MAX_VALUE_FLAG
, PV_ATTRIBUTES_B.DISPLAY_STYLE
, PV_ATTRIBUTES_B.EXPOSE_TO_PARTNER_FLAG
, PV_ATTRIBUTES_B.CHARACTER_WIDTH
, PV_ATTRIBUTES_B.DECIMAL_POINTS
, PV_ATTRIBUTES_B.NO_OF_LINES
, PV_ATTRIBUTES_B.VALUE_EXTN_RETURN_TYPE
, PV_ATTRIBUTES_B.ENABLE_MATCHING_FLAG
, PV_ATTRIBUTES_B.PERFORMANCE_FLAG
, PV_ATTRIBUTES_B.ADDITIVE_FLAG
, PV_ATTRIBUTES_B.SEQUENCE_NUMBER
FROM PV_ATTRIBUTES_B
, PV_ATTRIBUTES_TL
WHERE PV_ATTRIBUTES_B.ATTRIBUTE_ID = PV_ATTRIBUTES_TL.ATTRIBUTE_ID
AND PV_ATTRIBUTES_TL.LANGUAGE = USERENV('LANG')