APPS.INV_EBI_UTIL SQL Statements

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

Line: 59

    SELECT master_organization_id INTO l_master_org
    FROM mtl_parameters
    WHERE organization_id = p_organization_id;

Line: 83

        SELECT COUNT(1) INTO l_master_org
        FROM mtl_parameters
        WHERE organization_id = master_organization_id
        AND organization_code = p_organization_code;

Line: 109

   SELECT master_organization_id INTO l_master_org
   FROM mtl_parameters
   WHERE organization_id = p_organization_id;

Line: 210

    SELECT attr_group_id INTO l_attr_group_id
    FROM ego_fnd_dsc_flx_ctx_ext
    WHERE
      descriptive_flex_context_code = p_attr_group_short_name AND
      application_id = p_attr_group_app_id AND
      descriptive_flexfield_name = p_attr_group_type;

Line: 237

   SELECT application_id INTO l_app_id
   FROM fnd_application
   WHERE
   application_short_name = p_application_short_name;