APPS.ASP_ORDER_ALERT_AGENT SQL Statements

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

Line: 77

    SELECT party.party_id as customer_id
    FROM oe_blanket_headers_all oobha,
         hz_parties party,
         hz_cust_accounts_all cust_acct
    WHERE oobha.header_id = c_blanket_header_id
      and oobha.sold_to_org_id = cust_acct.cust_account_id(+)
      and cust_acct.party_id = party.party_id(+)
      and oobha.sales_document_type_code = 'B'
      and rownum < 2;