View: HZ_TRANSFORMATION_ATTRIBUTES_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_TRANSFORMATION_ATTRIBUTES_V

View Text

SELECT B.ROWID ROW_ID
, B.ATTRIBUTE_ID
, B.ENTITY_NAME
, B.ATTRIBUTE_NAME
, TL.USER_DEFINED_ATTRIBUTE_NAME
, B.SOURCE_TABLE
, B.CUSTOM_ATTRIBUTE_PROCEDURE
, B.DENORM_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, LV.LOOKUP_CODE
, LV.LOOKUP_TYPE
, LV.MEANING
, LV.TAG
, B.OBJECT_VERSION_NUMBER
FROM HZ_TRANS_ATTRIBUTES_B B
, HZ_TRANS_ATTRIBUTES_TL TL
, FND_LOOKUP_VALUES LV
WHERE B.ATTRIBUTE_NAME = LV.LOOKUP_CODE
AND B.ATTRIBUTE_ID = TL.ATTRIBUTE_ID
AND TL.LANGUAGE = USERENV('LANG')
AND LOOKUP_TYPE = DECODE(ENTITY_NAME
, 'PARTY'
, 'PARTY_LOGICAL_ATTRIBUTE_LIST'
, 'PARTY_SITES'
, 'PARTY_SITE_LOGICAL_ATTRIB_LIST'
, 'CONTACTS'
, 'CONTACT_LOGICAL_ATTRIB_LIST'
, 'CONTACT_POINTS'
, 'CONTACT_PT_LOGICAL_ATTRIB_LIST')
AND LV.LANGUAGE = USERENV('LANG')
AND LV.VIEW_APPLICATION_ID = 222
AND LV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LV.LOOKUP_TYPE
, LV.VIEW_APPLICATION_ID)

Columns