VIEW: APPS.JG_ZZ_ENTITY_ASSOC_V

Source

View Text - Preformatted

SELECT EA.ROWID ROW_ID, EA.ENTITY_ASSOCIATION_ID, EA.PRIMARY_ID_NUMBER, EA.ASSOCIATED_ENTITY_ID, VE.VENDOR_NAME ASSOCIATED_ENTITY_NAME, EA.ID_TYPE, LK.MEANING ID_TYPE_DSP, EA.ID_NUMBER, EA.DESCRIPTION, EA.EFFECTIVE_DATE, EA.INEFFECTIVE_DATE, EA.ATTRIBUTE_CATEGORY, EA.ATTRIBUTE1, EA.ATTRIBUTE2, EA.ATTRIBUTE3, EA.ATTRIBUTE4, EA.ATTRIBUTE5, EA.ATTRIBUTE6, EA.ATTRIBUTE7, EA.ATTRIBUTE8, EA.ATTRIBUTE9, EA.ATTRIBUTE10, EA.ATTRIBUTE11, EA.ATTRIBUTE12, EA.ATTRIBUTE13, EA.ATTRIBUTE14, EA.ATTRIBUTE15, EA.ATTRIBUTE16, EA.ATTRIBUTE17, EA.ATTRIBUTE18, EA.ATTRIBUTE19, EA.ATTRIBUTE20, EA.CREATED_BY, EA.CREATION_DATE, EA.LAST_UPDATED_BY, EA.LAST_UPDATE_DATE, EA.LAST_UPDATE_LOGIN FROM JG_ZZ_ENTITY_ASSOC EA, PO_VENDORS VE, FND_LOOKUPS LK WHERE VE.VENDOR_ID = EA.ASSOCIATED_ENTITY_ID AND LK.LOOKUP_TYPE = 'JGZZ_ENTITY_ASSOC_ID_TYPE' AND LK.LOOKUP_CODE = EA.ID_TYPE

View Text - HTML Formatted

SELECT EA.ROWID ROW_ID
, EA.ENTITY_ASSOCIATION_ID
, EA.PRIMARY_ID_NUMBER
, EA.ASSOCIATED_ENTITY_ID
, VE.VENDOR_NAME ASSOCIATED_ENTITY_NAME
, EA.ID_TYPE
, LK.MEANING ID_TYPE_DSP
, EA.ID_NUMBER
, EA.DESCRIPTION
, EA.EFFECTIVE_DATE
, EA.INEFFECTIVE_DATE
, EA.ATTRIBUTE_CATEGORY
, EA.ATTRIBUTE1
, EA.ATTRIBUTE2
, EA.ATTRIBUTE3
, EA.ATTRIBUTE4
, EA.ATTRIBUTE5
, EA.ATTRIBUTE6
, EA.ATTRIBUTE7
, EA.ATTRIBUTE8
, EA.ATTRIBUTE9
, EA.ATTRIBUTE10
, EA.ATTRIBUTE11
, EA.ATTRIBUTE12
, EA.ATTRIBUTE13
, EA.ATTRIBUTE14
, EA.ATTRIBUTE15
, EA.ATTRIBUTE16
, EA.ATTRIBUTE17
, EA.ATTRIBUTE18
, EA.ATTRIBUTE19
, EA.ATTRIBUTE20
, EA.CREATED_BY
, EA.CREATION_DATE
, EA.LAST_UPDATED_BY
, EA.LAST_UPDATE_DATE
, EA.LAST_UPDATE_LOGIN
FROM JG_ZZ_ENTITY_ASSOC EA
, PO_VENDORS VE
, FND_LOOKUPS LK
WHERE VE.VENDOR_ID = EA.ASSOCIATED_ENTITY_ID
AND LK.LOOKUP_TYPE = 'JGZZ_ENTITY_ASSOC_ID_TYPE'
AND LK.LOOKUP_CODE = EA.ID_TYPE