DBA Data[Home] [Help]

APPS.OE_1018PC1_ORDER_BOOKED SQL Statements

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

Line: 17

   SELECT count(*) 
   FROM OE_AK_ORDER_HEADERS_V a 
  WHERE   a.BLANKET_NUMBER =  OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER
   AND   a.BOOKED_FLAG = 'Y'
;
Line: 24

   SELECT count(*) 
   FROM OE_AK_ORDER_HEADERS_V a 
  WHERE   a.BLANKET_NUMBER =  OE_BLANKET_HEADER_SECURITY.g_record.ORDER_NUMBER
;