APPS.OKL_XMLGEN_PVT SQL Statements

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

Line: 14

      SELECT tp.tp_header_id, tp.party_site_id, tp.party_type
        FROM ecx_tp_headers tp
           , hz_parties p
       WHERE tp.party_id = p.party_id
         AND p.party_name = 'SuperTrump';

Line: 21

      SELECT t.ext_subtype, m.map_code, o.object_type
        FROM ecx_tp_details_v t
           , ecx_mappings m
           , ecx_objects o
           , okl_stream_interfaces si
       WHERE t.transaction_type = 'OKL_ST'
         AND t.transaction_subtype = si.deal_type
         AND m.map_id = t.map_id
         AND o.map_id = m.map_id
         AND o.object_id = m.object_id_target
         AND si.transaction_number = b_transaction_number;