DBA Data[Home] [Help]

VIEW: APPS.FND_DATA_GROUPS_STANDARD_VIEW

Source

View Text - Preformatted

SELECT DG.DATA_GROUP_ID , DG.DEFAULT_GROUP_FLAG , DG.DESCRIPTION , DECODE(DG.DATA_GROUP_ID,0,L.MEANING,DG.DATA_GROUP_NAME) DATA_GROUP_NAME FROM FND_DATA_GROUPS DG, FND_LOOKUPS L WHERE L.LOOKUP_TYPE = 'FND_STANDARD' AND L.LOOKUP_CODE = 'STANDARD'
View Text - HTML Formatted

SELECT DG.DATA_GROUP_ID
, DG.DEFAULT_GROUP_FLAG
, DG.DESCRIPTION
, DECODE(DG.DATA_GROUP_ID
, 0
, L.MEANING
, DG.DATA_GROUP_NAME) DATA_GROUP_NAME
FROM FND_DATA_GROUPS DG
, FND_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'FND_STANDARD'
AND L.LOOKUP_CODE = 'STANDARD'