DBA Data[Home] [Help]

APPS.OE_5PC1_ORDER_OFFEXP 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.HEADER_ID =  OE_HEADER_SCREDIT_SECURITY.g_record.HEADER_ID
   AND   a.FLOW_STATUS_CODE = 'OFFER_EXPIRED'
;