FND Design Data [Home] [Help]

View: FND_DATA_GROUP_UNITS_V

Product: FND - Application Object Library
Description: Denormalized view of FND_DATA_GROUP_UNITS
Implementation/DBA Data: ViewAPPS.FND_DATA_GROUP_UNITS_V
View Text

SELECT DGU.ROWID ROW_ID
, DGU.DATA_GROUP_ID
, DGU.APPLICATION_ID
, DGU.CREATION_DATE
, DGU.CREATED_BY
, DGU.LAST_UPDATE_DATE
, DGU.LAST_UPDATED_BY
, DGU.ORACLE_ID
, DGU.LAST_UPDATE_LOGIN
, DGU.DESCRIPTION
, A.APPLICATION_NAME
, O.ORACLE_USERNAME
FROM FND_DATA_GROUP_UNITS DGU
, FND_APPLICATION_VL A
, FND_ORACLE_USERID O
WHERE DGU.APPLICATION_ID = A.APPLICATION_ID
AND DGU.ORACLE_ID = O.ORACLE_ID

Columns

Name
ROW_ID
DATA_GROUP_ID
APPLICATION_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
ORACLE_ID
LAST_UPDATE_LOGIN
DESCRIPTION
APPLICATION_NAME
ORACLE_USERNAME