APPS.OE_7PC2_LINE_PRCONF 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.LINE_ID =  OE_LINE_SCREDIT_SECURITY.g_record.LINE_ID
   AND   a.SHIPPED_QUANTITY IS NOT NULL 
   AND   a.SOURCE_TYPE_CODE = 'EXTERNAL'
;