DBA Data[Home] [Help]

APPS.CN_CLASSIFICATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 55

     select
       NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
                         SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
       into cached_org_id
       from dual;