VIEW: APPS.HZ_TRANSFORMATION_ATTRIBUTES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)