APPS.AR_TRANSFER_DOCUMENT SQL Statements

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

Line: 6

      select 'x' from ra_customer_trx where customer_trx_id = p_doc_rec.source_id;

Line: 33

      select 'x' from hz_party_sites where party_site_id = p_doc_rec.tp_source_id;

Line: 60

      select 'x' from wf_events where name = p_doc_rec.event_name and status = 'ENABLED' and type = 'EVENT';

Line: 87

      select 'x'
      from ecx_transactions trx,
           ecx_ext_processes proc,
           ecx_tp_headers tph,
           ecx_tp_details tpd
      where trx.transaction_type = p_doc_rec.ecx_trx_type and
            trx.transaction_subtype = p_doc_rec.ecx_trx_subtype and
            trx.party_type = p_doc_rec.ecx_party_type and
            proc.direction = 'OUT' and
            trx.transaction_id = proc.transaction_id and
            tph.tp_header_id = tpd.tp_header_id and
            tpd.ext_process_id = proc.ext_process_id and
	    tph.party_type = p_doc_rec.ecx_party_type and
	    ( tph.party_site_id,tph.party_id ) in
	    ( select /* cardinality( sites 1) */
	             sites.party_site_id,
	             sites.party_id
              from hz_party_sites sites
	      where sites.party_site_id = p_doc_rec.tp_source_id
	    );

Line: 178

    select 'FND_RESP1:'||to_char(responsibility_id) role_name
    from fnd_responsibility_tl
    where application_id = 1;

Line: 239

      select * from ar_document_transfers where status = 'WAITING';

Line: 242

      select distinct exception_type from ar_document_transfers
      where status = 'FAILED'
      --bug 6667346
      and request_id = fnd_global.conc_request_id;

Line: 274

            ar_document_transfer_pkg.updateRow(doc_rec);

Line: 276

        ar_document_transfer_pkg.updateRow(doc_rec);

Line: 322

    select exception_message from ar_document_transfers
    where exception_type = l_exception_type;

Line: 359

    select exception_message from ar_document_transfers
    --where exception_type = l_exception_type;