R12 Patchset Level, R12 Apps code Level

How to determine R12 Patchset Level (or Module code level) , and module is installed/implemented or not (Doc ID 443699.1)

1. As applmgr or OS environment owner
(a) source environment
(b) login as apps
(c) SQL> @$AD_TOP/sql/adutconf.sql

The adutconf.sql script will create a text file adutconf.lst containing version information and product top information.  There is a section->”Product Installation Status, Version Info and Patch Level”, e.g.
     Product    Appl Status    Version    Patchset Level
     AD           Shared           12.0.0      R12.AD.B.3         
     FND         Installed         12.0.0      R12.FND.B.3       <-- call this "FND code level" also

• Implemented product has status Installed.
• Not installed Product has the Status Inactive.
• Products with status Shared are not fully implemented - only partially installed for dependent Product(s).

  Note： there are exceptions. e.g. WebEDI module (BNE) may be used even its status is Inactive.
           AD = Applications DBA,  FND = Application Object Library (AOL, i.e. Foundation tables). 

2.  Doc ID 550654.1 (for R12.1)
Login to OAM. Choose menu “OAM Support Cart” in upper right hand corner
Navigate to :
(a) Support Cart –> Applications Signature –> Collect –> Check “Product Information” box
(b) Click on “View” (eyeglasses) to get the patchset level report

3.  Script (similar to the one for 11i in Doc ID 443699.1)
SELECT a.application_name, a.application_short_name, a.product_code,  b.patch_level, DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'Not Installed - N/A') status, b.last_update_date, b.tablespace
FROM  apps.fnd_product_installations b, apps.fnd_application_vl a,
WHERE a.application_id = b.application_id
-- and b.status=’I’
order by a.application_short_name asc;

--  Not sure what is in this table
SELECT app_short_name, MAX(patch_level)
FROM apps.ad_patch_driver_minipks
GROUP BY app_short_name order by app_short_name; 

Applications code level?

SQL> select release_name from apps.fnd_product_groups;
12.1.3