|
SELECT FPI.STATUS,
FPI.INDUSTRY,
FPI.PRODUCT_VERSION,
FOU.ORACLE_USERNAME,
FA.APPLICATION_ID,
FA.APPLICATION_SHORT_NAME
FROM FND_PRODUCT_INSTALLATIONS FPI,
FND_ORACLE_USERID FOU,
FND_APPLICATION FA
WHERE FPI.APPLICATION_ID = FA.APPLICATION_ID
AND FPI.ORACLE_ID = FOU.ORACLE_ID
AND FA.APPLICATION_SHORT_NAME in ('INV', 'WIP', 'BOM', 'RCV', 'AR', 'GL', 'AP', 'PO', 'OM', 'FA', 'CE',
'HR'); |
|