Product: | PV - Partner Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PV_ATTRIBUTES_VL |
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')