Product: | FND - Application Object Library |
---|---|
Description: | View of FND_DOCUMENT_ENTITIES for translation purposes |
Implementation/DBA Data: | APPS.FND_DOCUMENT_ENTITIES_VL |
SELECT FDE.ROWID
, FDE.DOCUMENT_ENTITY_ID
, FDE.DATA_OBJECT_CODE
, FDE.TABLE_NAME
, FDE.APPLICATION_ID
, FATL.APPLICATION_NAME
, TL.USER_ENTITY_NAME
, TL.USER_ENTITY_PROMPT
, FDE.CREATION_DATE
, FDE.CREATED_BY
, FDE.LAST_UPDATE_DATE
, FDE.LAST_UPDATED_BY
, FDE.LAST_UPDATE_LOGIN
, FDE.PK1_COLUMN
, FDE.PK2_COLUMN
, FDE.PK3_COLUMN
, FDE.PK4_COLUMN
, FDE.PK5_COLUMN
FROM FND_APPLICATION_TL FATL
, FND_DOCUMENT_ENTITIES_TL TL
, FND_DOCUMENT_ENTITIES FDE
WHERE FDE.DATA_OBJECT_CODE = TL.DATA_OBJECT_CODE
AND TL.LANGUAGE = USERENV('LANG')
AND FDE.APPLICATION_ID = FATL.APPLICATION_ID
AND FATL.LANGUAGE = USERENV('LANG')