VIEW: APPS.PSA_BC_APPLICATION_V

Source

View Text - Preformatted

SELECT fa.application_short_name, fa.application_id, fat.application_name FROM FND_APPLICATION fa, FND_APPLICATION_TL fat WHERE fa.Application_Short_Name in('FV', 'IGI', 'IGC', 'PO', 'SQLAP', 'SQLGL', 'XLA', 'GMS', 'PA', 'PSA', 'PSB', 'LNS','CST') and (fa.application_id = fat.application_id) and (fat.language='US') order by application_short_name

View Text - HTML Formatted

SELECT FA.APPLICATION_SHORT_NAME
, FA.APPLICATION_ID
, FAT.APPLICATION_NAME
FROM FND_APPLICATION FA
, FND_APPLICATION_TL FAT
WHERE FA.APPLICATION_SHORT_NAME IN('FV'
, 'IGI'
, 'IGC'
, 'PO'
, 'SQLAP'
, 'SQLGL'
, 'XLA'
, 'GMS'
, 'PA'
, 'PSA'
, 'PSB'
, 'LNS'
, 'CST')
AND (FA.APPLICATION_ID = FAT.APPLICATION_ID)
AND (FAT.LANGUAGE='US') ORDER BY APPLICATION_SHORT_NAME