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'
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'
|
|
|