APPS.WIP_CFM_FILTER SQL Statements

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

Line: 18

    select nvl(cfm_routing_flag,2) as value
      from bom_operational_routings
      where assembly_item_id = p_item_id
      and organization_id = p_organization_id
      and alternate_routing_designator is null;

Line: 25

  select nvl(cfm_routing_flag,2) as value
  from bom_operational_routings
  where assembly_item_id = p_item_id
  and organization_id = p_organization_id
  and alternate_routing_designator is not null;

Line: 69

    select nvl(cfm_routing_flag,2)
      from bom_operational_routings
      where assembly_item_id = p_item_id
      and organization_id = p_organization_id
      and ((p_alternate_routing_designator is null
            and alternate_routing_designator is null)
           or
           (p_alternate_routing_designator = alternate_routing_designator)) ;