APPS.OE_OE_INLINE_ADDRESS SQL Statements

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

Line: 16

        SELECT meaning
          from ar_lookups
          where lookup_type = in_lookup_type
            and lookup_code = in_lookup_code;

Line: 161

       select hz_party_number_s.nextval
         into l_party_rec.party_number
         from dual;

Line: 184

        select hz_party_number_s.nextval
	    into l_org_contact_rec.party_rel_rec.party_rec.party_number
	    from dual;

Line: 200

    Select party_type
    Into l_org_contact_rec.party_rel_rec.object_type
    From HZ_PARTIES
    Where party_id = p_party_id;

Line: 207

        select hz_contact_numbers_s.nextval
		into l_org_contact_rec.contact_number
		from dual;

Line: 343

    select party_name
	 into x_contact_name
	 from hz_parties
     where party_id = x_party_id;

Line: 420

        SELECT email_address
          FROM hz_contact_points
         WHERE owner_table_id = p_contact_party_id
           AND owner_table_name = 'HZ_PARTIES'
           AND contact_point_type = 'EMAIL'
           AND primary_flag = 'Y'
           AND status       = 'A'; */

Line: 429

        SELECT email_address
          fROM hz_parties
         where party_id = p_contact_party_id;

Line: 643

    select hz_contact_points_s.nextval
      into l_contact_points_rec.contact_point_id
      from dual;

Line: 1802

       select *
         into sysparm
         from ar_system_parameters;

Line: 1823

      select territory_short_name,address_style
       into     out_default_country,out_address_style
       from     fnd_territories_vl
       where  territory_code = out_default_country_code;

Line: 2001

    select party_name
      into out_cust_name
     from hz_parties
    where party_id = x_party_id;

Line: 2010

     select party.party_id,
            party.party_name,
            acct.account_number,
            party.party_number

       into x_party_id,
            out_cust_name,
            out_cust_number,
            out_party_number
       from hz_cust_accounts acct,
            hz_parties party
      where acct.cust_account_id = in_cust_account_id
        and party.party_id = acct.party_id;

Line: 2270

        select location
          into out_ship_to_location
          from hz_cust_site_uses_all
          where site_use_id = x_site_use_id;

Line: 2332

        select location
          into out_bill_to_location
          from hz_cust_site_uses_all
          where site_use_id = x_site_use_id;

Line: 2394

        select location
          into out_deliver_to_location
          from hz_cust_site_uses_all
          where site_use_id = x_site_use_id;

Line: 2456

        select location
          into out_sold_to_location
          from hz_cust_site_uses_all
          where site_use_id = x_site_use_id;

Line: 2546

    select in_cont_last_name||
        DECODE(in_cont_first_name,NULL,NULL,', '||in_cont_first_name)||
        DECODE(in_cont_title,NULL,NULL,' '||in_cont_title)
      into out_cont_Name
      from dual;