APPS.INV_EBI_CZ_PUB SQL Statements

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

Line: 30

      SELECT bom_item_type ,concatenated_segments
      INTO l_bom_item_type_code ,l_item_number
      FROM mtl_system_items_kfv
      WHERE
        inventory_item_id = p_inventory_item_id AND
        organization_id   = p_organization_id;

Line: 50

      SELECT fpov.PROFILE_OPTION_VALUE  INTO x_profile_value
      FROM FND_PROFILE_OPTION_VALUES fpov,FND_PROFILE_OPTIONS fpo
      WHERE fpov.PROFILE_OPTION_ID = fpo.PROFILE_OPTION_ID
        AND fpo.PROFILE_OPTION_NAME = p_profile_name;

Line: 59

    select instance_name INTO x_system_id from v$instance;