APPS.FLM_SCHEDULE_REPORT SQL Statements

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

Line: 39

    select component_item_id, assembly_item_id, top_item_id
    into l_comp_id, l_parent_id, l_top_id
    from bom_explosions
    where top_bill_sequence_id = p_top_bill_seq_id
      and sort_order = p_sort_order
      and explosion_type = 'ALL';

Line: 46

    select item_type
    into l_comp_type
    from mtl_system_items
    where inventory_item_id = l_comp_id
      and organization_id = p_org_id;

Line: 52

    select item_type
    into l_parent_type
    from mtl_system_items
    where inventory_item_id = l_parent_id
      and organization_id = p_org_id;