APPS.OE_2PC2_CONFIG_ISOL SQL Statements

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

Line: 17

   SELECT count(*) 
   FROM OE_AK_ORDER_LINES_V a 
   WHERE a.SOURCE_DOCUMENT_TYPE_ID = 10
   AND   (  a.LINE_ID ) IN  
                 ( SELECT  b.LINE_ID
   FROM OE_AK_ORDER_LINES_V b 
   WHERE   b.HEADER_ID =  OE_LINE_SECURITY.g_record.HEADER_ID
   AND     b.TOP_MODEL_LINE_ID =  OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_ID
                  );

Line: 28

   SELECT count(*) 
   FROM OE_AK_ORDER_LINES_V b 
   WHERE   b.HEADER_ID =  OE_LINE_SECURITY.g_record.HEADER_ID
   AND     b.TOP_MODEL_LINE_ID =  OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_ID
;