SELECT ACC.ACCESS_ID , b.APPLICATION_ID , b.APPLICATION_SHORT_NAME , b.BASEPATH , t.APPLICATION_NAME , t.DESCRIPTION FROM FND_APPLICATION b , FND_APPLICATION_TL t , CSM_FND_APPLICATION_ACC ACC WHERE ACC.APPLICATION_ID = t.APPLICATION_ID AND B.APPLICATION_ID = t.APPLICATION_ID AND t.LANGUAGE = ASG_BASE.GET_LANGUAGE
SELECT ACC.ACCESS_ID
, B.APPLICATION_ID
, B.APPLICATION_SHORT_NAME
, B.BASEPATH
, T.APPLICATION_NAME
, T.DESCRIPTION
FROM FND_APPLICATION B
, FND_APPLICATION_TL T
, CSM_FND_APPLICATION_ACC ACC
WHERE ACC.APPLICATION_ID = T.APPLICATION_ID
AND B.APPLICATION_ID = T.APPLICATION_ID
AND T.LANGUAGE = ASG_BASE.GET_LANGUAGE
|
|
|