View: HZ_ATTRIBUTE_TRANS_V

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

View Text

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

Columns