APPS.CSP_REPAIR_ORDER_PKG SQL Statements

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

Line: 36

       select misl.organization_id
       from MRP_ITEM_SOURCING_LEVELS_V  misl, csp_planning_parameters cpp
       where cpp.organization_type = 'W'
       and misl.organization_id = cpp.organization_id
       and misl.assignment_set_id =cpp.defective_assignment_set_id
       and misl.source_organization_id = l_org_id
       and misl.inventory_item_id = l_item_id
       and SOURCE_TYPE       in (1,3)
       and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V
                             where organization_id = cpp.organization_id
                             and assignment_set_id = cpp.defective_assignment_set_id
                             and inventory_item_id = misl.inventory_item_id
                             and sourcing_level not in (2,9))
       order by misl.rank;

Line: 52

       select misl.source_type, misl.source_organization_id, misl.vendor_id
       from MRP_ITEM_SOURCING_LEVELS_V  misl, csp_planning_parameters cpp
       where cpp.organization_id = l_dest_org_id
       and misl.organization_id = cpp.organization_id
       and misl.assignment_set_id =cpp.repair_assignment_set_id
       and inventory_item_id = l_item_id
       and SOURCE_TYPE       in (1,3)
       and sourcing_level = (select min(sourcing_level) from MRP_ITEM_SOURCING_LEVELS_V
                             where organization_id = l_dest_org_id
                             and assignment_set_id =  cpp.repair_assignment_set_id
                             and inventory_item_id = l_item_id
                             and sourcing_level not in (2,9))
       order by misl.rank;

Line: 82

             select serv_req_enabled_code
             into l_Serviceable
             from mtl_system_items
             where inventory_item_id = l_item_id
             and organization_id = rsc.source_organization_id;

Line: 105

               select name
               into l_supplier_name
               from hr_all_organization_units
               where organization_id = l_Repair_supplier_id;

Line: 110

               select vendor_name
               into l_supplier_name
               from po_vendors
               where vendor_id = l_Repair_Supplier_id;

Line: 116

             select meaning into l_Supplier_type
             from fnd_lookups
             where lookup_type = 'CSP_NOTIF_DTL_SRC_TYPE'
             and  lookup_code = l_source_type;

Line: 127

       select l_supplier_type,l_source_type,l_supplier_name,l_repair_supplier_id,l_dest_org_id,l_item_number,l_qty,l_uom,l_subinv_code,l_item_id,l_org_id
       from DUAL;

Line: 184

          select order_number
          into l_order_number
          from oe_order_headers_all
          where header_id = l_header_rec.order_header_id;

Line: 197

     SELECT X_ORDER_NUMBER,X_RET_STATUS,X_MSG FROM DUAL;