VIEW: APPS.HZ_ATTRIBUTE_TRANS_V

Source

View Text - Preformatted

SELECT FND_LOOKUP_VALUES_VL.ATTRIBUTE1, FND_LOOKUP_VALUES_VL.ATTRIBUTE2, FND_LOOKUP_VALUES_VL.ATTRIBUTE3, FND_LOOKUP_VALUES_VL.ATTRIBUTE4, FND_LOOKUP_VALUES_VL.LOOKUP_TYPE, FND_LOOKUP_VALUES_VL.LOOKUP_CODE, FND_LOOKUP_VALUES_VL.ENABLED_FLAG, FND_LOOKUP_VALUES_VL.START_DATE_ACTIVE, FND_LOOKUP_VALUES_VL.END_DATE_ACTIVE, FND_LOOKUP_VALUES_VL.LAST_UPDATED_BY, FND_LOOKUP_VALUES_VL.LAST_UPDATE_LOGIN, FND_LOOKUP_VALUES_VL.LAST_UPDATE_DATE, FND_LOOKUP_VALUES_VL.SECURITY_GROUP_ID, FND_LOOKUP_VALUES_VL.VIEW_APPLICATION_ID, FND_LOOKUP_VALUES_VL.TAG, FND_LOOKUP_VALUES_VL.MEANING, FND_LOOKUP_VALUES_VL.DESCRIPTION, HZ_TRANS_ATTRIBUTES_VL.ATTRIBUTE_ID, HZ_TRANS_ATTRIBUTES_VL.ENTITY_NAME, HZ_TRANS_ATTRIBUTES_VL.ATTRIBUTE_NAME, HZ_TRANS_ATTRIBUTES_VL.USER_DEFINED_ATTRIBUTE_NAME, HZ_TRANS_ATTRIBUTES_VL.CUSTOM_ATTRIBUTE_PROCEDURE, HZ_TRANS_ATTRIBUTES_VL.SOURCE_TABLE, HZ_TRANS_ATTRIBUTES_VL.CREATED_BY, HZ_TRANS_ATTRIBUTES_VL.CREATION_DATE, HZ_TRANS_ATTRIBUTES_VL.OBJECT_VERSION_NUMBER, HZ_TRANS_ATTRIBUTES_VL.DENORM_FLAG FROM HZ_TRANS_ATTRIBUTES_VL, FND_LOOKUP_VALUES_VL WHERE UPPER(FND_LOOKUP_VALUES_VL.LOOKUP_TYPE) = UPPER(decode(HZ_TRANS_ATTRIBUTES_VL.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 FND_LOOKUP_VALUES_VL.LOOKUP_CODE = HZ_TRANS_ATTRIBUTES_VL.ATTRIBUTE_NAME

View Text - HTML Formatted

SELECT FND_LOOKUP_VALUES_VL.ATTRIBUTE1
, FND_LOOKUP_VALUES_VL.ATTRIBUTE2
, FND_LOOKUP_VALUES_VL.ATTRIBUTE3
, FND_LOOKUP_VALUES_VL.ATTRIBUTE4
, FND_LOOKUP_VALUES_VL.LOOKUP_TYPE
, FND_LOOKUP_VALUES_VL.LOOKUP_CODE
, FND_LOOKUP_VALUES_VL.ENABLED_FLAG
, FND_LOOKUP_VALUES_VL.START_DATE_ACTIVE
, FND_LOOKUP_VALUES_VL.END_DATE_ACTIVE
, FND_LOOKUP_VALUES_VL.LAST_UPDATED_BY
, FND_LOOKUP_VALUES_VL.LAST_UPDATE_LOGIN
, FND_LOOKUP_VALUES_VL.LAST_UPDATE_DATE
, FND_LOOKUP_VALUES_VL.SECURITY_GROUP_ID
, FND_LOOKUP_VALUES_VL.VIEW_APPLICATION_ID
, FND_LOOKUP_VALUES_VL.TAG
, FND_LOOKUP_VALUES_VL.MEANING
, FND_LOOKUP_VALUES_VL.DESCRIPTION
, HZ_TRANS_ATTRIBUTES_VL.ATTRIBUTE_ID
, HZ_TRANS_ATTRIBUTES_VL.ENTITY_NAME
, HZ_TRANS_ATTRIBUTES_VL.ATTRIBUTE_NAME
, HZ_TRANS_ATTRIBUTES_VL.USER_DEFINED_ATTRIBUTE_NAME
, HZ_TRANS_ATTRIBUTES_VL.CUSTOM_ATTRIBUTE_PROCEDURE
, HZ_TRANS_ATTRIBUTES_VL.SOURCE_TABLE
, HZ_TRANS_ATTRIBUTES_VL.CREATED_BY
, HZ_TRANS_ATTRIBUTES_VL.CREATION_DATE
, HZ_TRANS_ATTRIBUTES_VL.OBJECT_VERSION_NUMBER
, HZ_TRANS_ATTRIBUTES_VL.DENORM_FLAG
FROM HZ_TRANS_ATTRIBUTES_VL
, FND_LOOKUP_VALUES_VL
WHERE UPPER(FND_LOOKUP_VALUES_VL.LOOKUP_TYPE) = UPPER(DECODE(HZ_TRANS_ATTRIBUTES_VL.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 FND_LOOKUP_VALUES_VL.LOOKUP_CODE = HZ_TRANS_ATTRIBUTES_VL.ATTRIBUTE_NAME