APPS.WIP_PREFERENCES_PKG SQL Statements

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

Line: 22

  select preference_type
  from   wip_preference_definitions
  where  preference_id = cl_pref_id;

Line: 29

  select decode( (select count(v.attribute_value_code)
                  from   wip_preference_values v,
                         wip_preference_levels l
                  where  v.PREFERENCE_ID = p_preference_id
                    and  v.LEVEL_ID = l.LEVEL_ID
                    and  nvl(l.resp_key,'NULL') = nvl(cl_resp_key, 'NULL')
                    and  nvl(l.organization_id, -99) = nvl(cl_org_id, -99)
                    and  nvl(l.department_id, -99) = nvl(cl_dept_id, -99)
                  ),
                  0, 'INHERIT',
                  1, (select v.attribute_value_code
                      from   wip_preference_values v,
                             wip_preference_levels l
                      where  v.PREFERENCE_ID = p_preference_id
                        and  v.LEVEL_ID = l.LEVEL_ID
                        and  nvl(l.resp_key,'NULL') = nvl(cl_resp_key, 'NULL')
                        and  nvl(l.organization_id, -99) = nvl(cl_org_id, -99)
                        and  nvl(l.department_id, -99) = nvl(cl_dept_id, -99)),
                  'INHERIT') AS single_value_code
    from dual;

Line: 52

  select count(v.attribute_value_code) as multi_value_count
  from   wip_preference_values v,
         wip_preference_levels l
  where  v.PREFERENCE_ID = p_preference_id
    and  v.LEVEL_ID = l.LEVEL_ID
    and  nvl(l.resp_key,'NULL') = nvl(cl_resp_key, 'NULL')
    and  nvl(l.organization_id, -99) = nvl(cl_org_id, -99)
    and  nvl(l.department_id, -99) = nvl(cl_dept_id, -99);

Line: 108

    select decode(wip_preferences_pkg.get_row_count
                  (p_preference_id,
                   cl_level_code,
                   p_resp_key ,
                   p_org_id ,
                   p_dept_id),
                   1, -- single value
                   v.attribute_value_code,
                   0, -- no setup at this level
                   decode(cl_level_code, 0, null, 'INHERIT'),
                   'ENTERED')
    from wip_preference_values v;

Line: 160

    select ml.meaning
    from mfg_lookups ml
    where ml.lookup_code = to_number(cl_value_code) and
    ml.lookup_type = (select wp.preference_value_lookup_type
                   from wip_preference_definitions wp
                   where wp.preference_id = p_preference_id);

Line: 198

    select count(v.preference_value_id)
    from wip_preference_values v,
    wip_preference_levels l
    where l.level_id = v.level_id and
    l.level_code = 0 and
    v.preference_id = p_pref_id;

Line: 206

    select count(v.preference_value_id)
    from wip_preference_values v,
    wip_preference_levels l
    where l.level_id = v.level_id and
    l.level_code = 1 and
    l.resp_key = p_resp_key and
    v.preference_id = p_pref_id;

Line: 215

    select count(v.preference_value_id)
    from wip_preference_values v,
    wip_preference_levels l
    where l.level_id = v.level_id and
    l.level_code = 2 and
    l.resp_key = p_resp_key and
    l.organization_id = p_org_id and
    v.preference_id = p_pref_id;

Line: 225

    select count(v.preference_value_id)
    from wip_preference_values v,
    wip_preference_levels l
    where l.level_id = v.level_id and
    l.level_code = 3 and
    l.resp_key = p_resp_key and
    l.organization_id = p_org_id and
    l.department_id = p_dept_id and
    v.preference_id = p_pref_id;

Line: 405

    select level_code
    from wip_preference_levels
    where level_id = p_level_id;

Line: 452

    select l.meaning levelCode
    from mfg_lookups l
    where l.lookup_type = 'WIP_WS_PREF_LEVELS' and
    l.lookup_code = p_level_code;

Line: 474

    select r.responsibility_name responsibility
    from fnd_responsibility_vl r
    where r.responsibility_key = p_resp_key;

Line: 495

    select mp.organization_code organization
    from mtl_parameters mp
    where mp.organization_id = p_org_id;

Line: 516

    select bd.department_code department
    from bom_departments bd
    where bd.department_id = p_dept_id;