APPS.INV_KANBAN_LOVS SQL Statements

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

Line: 22

      SELECT kanban_card_number,kanban_card_id, 1
      FROM mtl_kanban_cards
      WHERE organization_Id = p_Organization_Id AND
            kanban_card_type = 1 AND
            card_status = 1 AND
            inv_KANBAN_PKG.status_check(supply_status, 4) = 2 AND
            kanban_card_number like (p_Kanban_number)
      order by kanban_card_number;

Line: 37

      SELECT kanban_card_number,kanban_card_id, 1
      FROM mtl_kanban_cards
      WHERE organization_Id = p_Organization_Id AND
            kanban_card_number like (p_Kanban_number)
      order by kanban_card_number;

Line: 48

      select meaning, description ,to_char(lookup_code)
      from mfg_lookups
      where lookup_type = 'MTL_KANBAN_SOURCE_TYPE'
      order by meaning;

Line: 58

    select vendor_name, segment1, decode(hold_flag,'Y','*',null), hold_flag,
           vendor_id, num_1099, vat_registration_num
    from po_vendors
    where vendor_name like (p_supplier_name)
    order by upper(vendor_name);

Line: 70

    select vendor_site_code, vendor_site_id
    from mtl_supplier_sites_v
    where vendor_id = p_Organization_Id
          and organization_id = p_supplier_id
    order by upper(vendor_site_code);

Line: 82

      select line_code, description, line_id
      from wip_lines
      where organization_id =  p_Organization_Id
            and line_code like (p_line_code)
      order by line_code;