DBA Data[Home] [Help]

APPS.XNP_SV_ORDERS$SOA_EVENTS SQL Statements

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

Line: 158

      I_QUERY := 'SELECT count(*)' ||
                 substr(ZONE_SQL, I_FROM_POS);
Line: 204

      ZONE_SQL := 'SELECT SEY.SV_EVENT_HISTORY_ID,
                         SEY.EVENT_CODE,
                         SEY.EVENT_TYPE,
                         SEY.EVENT_TIMESTAMP,
                         SEY.EVENT_CAUSE_CODE
                  FROM   XNP_SV_EVENT_HISTORY SEY';