APPS.GR_VALIDATE SQL Statements

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

Line: 25

     SELECT inventory_item_id
       FROM mtl_system_items_kfv
      WHERE concatenated_segments = p_item and
            organization_id = p_organization_id;

Line: 84

     SELECT inventory_item_id, concatenated_segments
        FROM  mtl_system_items_kfv
        WHERE  cas_number = p_cas_number and
               organization_id = p_organization_id;

Line: 134

SELECT 1
FROM   fnd_lookup_values
WHERE LANGUAGE = USERENV('LANG')
  AND view_application_id BETWEEN 550 AND 559
  AND security_group_id = 0
  AND lookup_code = p_document_code
  AND    lookup_type = 'GR_DOCUMENT_CODE';

Line: 186

SELECT 1
FROM   gr_disclosures
WHERE  disclosure_code = p_disclosure_code;

Line: 234

SELECT 1
FROM   fnd_lookup_values
WHERE LANGUAGE = USERENV('LANG')
  AND view_application_id BETWEEN 550 AND 559
  AND security_group_id = 0
  AND lookup_code = p_dispatch_method_code
  AND lookup_type = 'GR_DISPATCH_METHOD_CODE';

Line: 286

SELECT 1
FROM   hz_parties
WHERE  party_id = p_recipient_id;

Line: 334

SELECT 1
FROM   hz_party_sites
WHERE  party_id = p_recipient_id and
party_site_id   = p_recipient_site_id;