+================================================================================+
Product Installation Status, Version Info and Patch Level
+================================================================================+
col apps format a8 heading "Product"
col apps_name format a60 heading "Product Name"
col product_version format a15 heading "Version"
SELECT decode(nvl(a.application_short_name, 'Not Found'),
'SQLAP',
'AP',
'SQLGL',
'GL',
'OFA',
'FA',
'Not Found',
'id ' || to_char(fpi.application_id),
a.application_short_name) apps,
application_name apps_name,
decode(fpi.status,
'I',
'Installed',
'S',
'Shared',
'N',
'Inactive',
fpi.status) status,
fpi.product_version,
nvl(fpi.patch_level, '-- Not Available --') patchset,
to_char(fpi.last_update_date, 'dd-Mon-RRRR') "Update Date"
FROM fnd_oracle_userid o,
fnd_application_all_view a,
fnd_product_installations fpi
WHERE fpi.application_id = a.application_id(+)
AND fpi.oracle_id = o.oracle_id(+)
Product Installation Status, Version Info and Patch Level
+================================================================================+
col apps format a8 heading "Product"
col apps_name format a60 heading "Product Name"
col product_version format a15 heading "Version"
SELECT decode(nvl(a.application_short_name, 'Not Found'),
'SQLAP',
'AP',
'SQLGL',
'GL',
'OFA',
'FA',
'Not Found',
'id ' || to_char(fpi.application_id),
a.application_short_name) apps,
application_name apps_name,
decode(fpi.status,
'I',
'Installed',
'S',
'Shared',
'N',
'Inactive',
fpi.status) status,
fpi.product_version,
nvl(fpi.patch_level, '-- Not Available --') patchset,
to_char(fpi.last_update_date, 'dd-Mon-RRRR') "Update Date"
FROM fnd_oracle_userid o,
fnd_application_all_view a,
fnd_product_installations fpi
WHERE fpi.application_id = a.application_id(+)
AND fpi.oracle_id = o.oracle_id(+)
ORDER BY 1, 2 ;
/
检查已安装模块版本:
SELECT app.application_short_name, app.application_name, pi.patch_level
FROM fnd_product_installations pi, fnd_application_vl app
WHERE app.application_id = pi.application_id;