APPS.OE_6PC6_HDRADJS_DISSUR SQL Statements

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

Line: 17

   SELECT count(*) 
   FROM OE_AK_HEADER_PRCADJS_V a 
   WHERE a.LIST_LINE_TYPE_CODE <> 'FREIGHT_CHARGE'
   AND   (  a.PRICE_ADJUSTMENT_ID ) IN  
                 ( SELECT  b.PRICE_ADJUSTMENT_ID
   FROM OE_AK_HEADER_PRCADJS_V b 
   WHERE   b.HEADER_ID =  OE_HEADER_ADJ_SECURITY.g_record.HEADER_ID
                  );

Line: 27

   SELECT count(*) 
   FROM OE_AK_HEADER_PRCADJS_V b 
   WHERE   b.HEADER_ID =  OE_HEADER_ADJ_SECURITY.g_record.HEADER_ID
;