SELECT B.APPLICATION_ID,
B.APPLICATION_SHORT_NAME,
B.BASEPATH APPLICATION_TOP,
T.APPLICATION_NAME,
T.DESCRIPTION,
B.PRODUCT_CODE
FROM FND_APPLICATION_TL T
,FND_APPLICATION B
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND T.APPLICATION_NAME = :KNOW_APPLICATION_NAME
B.APPLICATION_SHORT_NAME,
B.BASEPATH APPLICATION_TOP,
T.APPLICATION_NAME,
T.DESCRIPTION,
B.PRODUCT_CODE
FROM FND_APPLICATION_TL T
,FND_APPLICATION B
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND T.APPLICATION_NAME = :KNOW_APPLICATION_NAME