APPS.OE_1PC2_LINE_SERVICE 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.HEADER_ID =  OE_HEADER_SECURITY.g_record.HEADER_ID
   AND   a.ITEM_TYPE_CODE = 'SERVICE'
;

Line: 24

   SELECT count(*) 
   FROM OE_AK_ORDER_LINES_V a 
  WHERE   a.HEADER_ID =  OE_HEADER_SECURITY.g_record.HEADER_ID
;