Tuesday, December 18, 2018

EBS 12,2 code level check

SQL> l
  1  select
  2    substr(abbreviation,1,10)
  3  ,substr(codelevel,1,10)
  4  from
  5    ad_trackable_entities
  6  where
  7    abbreviation in( 'ad','txk','fnd','fwk','atg_pf','icx' )
  8  order by
  9*   abbreviation
SQL> /

SUBSTR(ABB SUBSTR(COD
---------- ----------
ad         C.10
atg_pf     C.7
fnd        C.7
fwk        C.7
icx        D.3
txk        C.10

6 rows selected.

No comments: