DBA Data[Home] [Help]

APPS.XNP_SV_ORDERS$SOA_ORDERS SQL Statements

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

Line: 124

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

      ZONE_SQL := 'SELECT SOG.SV_ORDER_MAPPING_ID,
                         SOG.ORDER_ID,
                         SOG.WORKITEM_INSTANCE_ID
                  FROM   XNP_SV_ORDER_MAPPINGS SOG';