APPS.EGO_ITEM_ASSOCIATIONS_UTIL SQL Statements

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

Line: 10

  G_LOGIN_ID       fnd_user.last_update_login%TYPE;

Line: 43

      SELECT party_id
        INTO G_PARTY_ID
        FROM ego_user_v
       WHERE USER_ID = G_USER_ID;

Line: 49

        SELECT party_id, user_id
          INTO G_PARTY_ID, G_USER_ID
          FROM ego_user_v
         WHERE USER_NAME = FND_GLOBAL.USER_NAME;

Line: 71

    SELECT 'T'
      INTO l_vendor_contact
      FROM dual
     WHERE EXISTS
           (
          SELECT 1
            FROM ap_supplier_contacts ascs
         WHERE ascs.per_party_id = G_PARTY_ID
         );

Line: 99

    INSERT INTO ARASAN_TEMP
         VALUES (p_msg);

Line: 159

    l_insert_clause VARCHAR2(2000);

Line: 160

    l_select_clause VARCHAR2(2000);

Line: 164

    l_suppl_insert_clause VARCHAR2(2000);

Line: 165

    l_suppl_select_clause VARCHAR2(2000);

Line: 195

      SELECT ego_massupdate_s.NEXTVAL
        INTO p_batch_id
        FROM dual;

Line: 201

    l_insert_clause := ' INSERT INTO ego_suppliersite_tmp ( created_by, creation_date, last_updated_by, last_update_date, select_flag, batch_id, supplier_id, supplier_number, supplier_name, duns_number, tax_payer_id, tax_registration_num ';

Line: 202

    l_suppl_insert_clause := ' INSERT INTO ego_suppliersite_tmp ( created_by, creation_date, last_updated_by, last_update_date, select_flag, batch_id, supplier_id, supplier_number, supplier_name, duns_number, tax_payer_id, tax_registration_num ) ';

Line: 203

    l_select_clause := ' SELECT fnd_global.USER_ID, sysdate, fnd_global.USER_ID, sysdate, ''Y'', :batch_id, aas.vendor_id, aas.segment1, aas.vendor_name, hp.duns_number_c, aas.num_1099, aas.vat_registration_num ';

Line: 204

    l_suppl_select_clause := ' SELECT fnd_global.USER_ID, sysdate, fnd_global.USER_ID, sysdate, ''Y'', :batch_id, aas.vendor_id, aas.segment1, aas.vendor_name, hp.duns_number_c, aas.num_1099, aas.vat_registration_num ';

Line: 212

      l_insert_clause := l_insert_clause || ', supplier_site_id, supplier_site_name, city, state, country ';

Line: 213

      l_select_clause := l_select_clause || ', asa.vendor_site_id, asa.vendor_site_code, asa.city, asa.state, asa.country ';

Line: 217

    l_insert_clause := l_insert_clause || ' ) ';

Line: 247

                   ' AND EXISTS ( SELECT 1 FROM ego_item_associations eia1 ' ||
                   ' WHERE eia1.inventory_item_id = :b_item_id AND eia1.data_level_id = 43103 ' ||
                   ' AND eia1.pk1_value = aas.vendor_id AND eia1.organization_id = :b_master_org_id ) ';

Line: 253

                        ' AND EXISTS ( SELECT 1 FROM ego_item_associations eia2 ' ||
                        ' WHERE eia2.data_level_id = 43104  AND eia2.pk2_value = asa.vendor_site_id ' ||
                        ' AND eia2.inventory_item_id = :b_item_id AND eia2.organization_id = :b_master_org_id )';

Line: 264

                  ' AND NOT EXISTS ( SELECT 1 FROM ego_item_associations eia4 ' ||
                  ' WHERE eia4.inventory_item_id = :b_item_id AND eia4.data_level_id = 43104 ' ||
                  ' AND eia4.pk2_value = asa.vendor_site_id AND eia4.organization_id = :b_master_org_id )';

Line: 283

    g_search_stmt := l_insert_clause || l_select_clause || l_from_clause || l_where_clause;

Line: 287

                                '    SELECT 1 ' ||
                                '      FROM ego_vendor_v evv ' ||
                                '     WHERE evv.vendor_id = aas.vendor_id ' ||
                              '       AND evv.user_id = :b_user_id '||
                                  ' )';

Line: 342

      l_suppl_where_clause := l_suppl_where_clause || ' AND EXISTS ( SELECT 1 FROM ap_supplier_sites_all assa WHERE assa.vendor_id = aas.vendor_id AND assa.org_id = fnd_profile.value(''ORG_ID'') and nvl(assa.inactive_date,SYSDATE + 1)>SYSDATE ) ';

Line: 345

                   ' AND NOT EXISTS ( SELECT 1 FROM ego_item_associations eia3 ' ||
                   ' WHERE eia3.inventory_item_id = :b_item_id AND eia3.data_level_id = 43103 ' ||
                   ' AND eia3.pk1_value = aas.vendor_id AND eia3.organization_id = :b_master_org_id )';

Line: 349

      g_search_stmt := l_suppl_insert_clause || l_suppl_select_clause || l_suppl_from_clause || l_suppl_where_clause;

Line: 355

                                '    SELECT 1 ' ||
                                '      FROM ego_vendor_v evv ' ||
                                '     WHERE evv.vendor_id = aas.vendor_id ' ||
                              '       AND evv.user_id = :b_user_id '||
                                  ' )';