Product: | JG - Regional Localizations |
---|---|
Description: | Business Entity Relationships information view |
Implementation/DBA Data: | APPS.JG_ZZ_ENTITY_ASSOC_V |
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