Below query can be very handy in finding out current AD and TXK code levels.
col
ABBREVIATION for a10
set
lines 1000
col
NAME for a50
col
CODELEVEL for a20
SELECT ABBREVIATION,NAME,codelevel FROM AD_TRACKABLE_ENTITIES WHERE
abbreviation in ('txk','ad');
ABBREVIATI
NAME
CODELEVEL
----------
-------------------------------------------------- ------------
ad Oracle Applications DBA C.11
txk Oracle Applications Technology
Stack C.11
Below query will include the code levels for atg also -
ReplyDeletecol ABBREVIATION for a10
set lines 1000
col NAME for a50
col CODELEVEL for a20
SELECT ABBREVIATION,NAME,codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad','atg_pf');