Re: Adop RUP 10 - Skip worker

Posted by satish on Feb 27, 2023; 9:50am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Adop-RUP-10-Skip-worker-tp11659p11660.html

SQL> col APPLICATION_NAME for a60
col PRODUCT_CODE for a20
SQL> SELECT a.application_name, a.product_code, DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status, patch_level
FROM apps.fnd_application_vl a, apps.fnd_product_installations b
WHERE a.application_id = b.application_id and a.product_code like 'MSD'
order by product_code asc;
SQL> 2 3 4
APPLICATION_NAME
------------------------------------------------------------
PRODUCT_CODE STATUS PATCH_LEVEL
-------------------- --------- ------------------------------
Demand Planning
MSD N/A R12.MSD.C