APPS.QA_FLEX_UTIL SQL Statements

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

Line: 15

            SELECT concatenated_segments
            FROM   mtl_system_items_kfv
            WHERE  inventory_item_id = p_item_id AND
                   organization_id = p_org_id;

Line: 43

            SELECT concatenated_segments
            FROM   mtl_item_locations_kfv
            WHERE  inventory_location_id = p_locator_id and
                   organization_id = p_org_id;

Line: 67

        select concatenated_segments
        from mtl_system_items_kfv
        where inventory_item_id = c_item_id
        and organization_id = c_org_id
	and rownum=1
         UNION ALL
        select concatenated_segments
        from mtl_system_items_kfv msikfv,mtl_parameters mp
        where msikfv.inventory_item_id = c_item_id
        and msikfv.organization_id = mp.organization_id
        and mp.maint_organization_id = c_org_id
        and rownum=1;

Line: 115

        select inventory_item_id into id
        from mtl_system_items_kfv
        where concatenated_segments = x_item
        and organization_id = x_org_id
        and rownum = 1;

Line: 175

        select  mck.concatenated_segments,
                mck.category_id
        from    mtl_item_categories mic, mtl_categories_kfv mck
        where   mic.organization_id = p_org_id
        and     mic.category_id = mck.category_id
        and     mic.inventory_item_id =p_item_id
        and     mic.category_set_id = p_category_set_id;

Line: 228

            SELECT wip_entity_name
            FROM wip_entities
            WHERE wip_entity_id = x_work_order_id
                AND organization_id = x_org_id;

Line: 234

            SELECT wip_entity_name
            FROM wip_eam_work_order_dtls_v
            WHERE wip_entity_id = x_work_order_id
            AND organization_id = x_org_id;

Line: 265

        select concatenated_segments into locator_name
        from mtl_item_locations_kfv
        where  INVENTORY_LOCATION_ID  = x_locator_id
              and organization_id = x_org_id
              and rownum=1;

Line: 296

        select inventory_location_id into id
        from mtl_item_locations_kfv
        where concatenated_segments = x_locator
        and organization_id = x_org_id
        and rownum = 1;

Line: 362

            SELECT project_number
            FROM   pjm_projects_all_v
            WHERE  project_id = x_id;

Line: 411

            SELECT segment1 order_number
            FROM   mtl_sales_orders
            WHERE  sales_order_id = x_id;

Line: 449

            SELECT order_number
            FROM   oe_order_headers_all
            WHERE  header_id = x_id;

Line: 483

        SELECT k_number
        FROM   oke_k_headers_lov_v
        WHERE  k_header_id = x_id;

Line: 506

        SELECT line_number
        FROM   oke_k_lines_full_v
        WHERE  k_line_id = x_id;

Line: 529

        SELECT deliverable_num
        FROM   oke_k_deliverables_vl
        WHERE  deliverable_id = x_id;

Line: 559

                SELECT result_column_name, values_exist_flag
                FROM   qa_plan_chars
                WHERE  plan_id = x_plan_id AND
                       char_id = x_char_id;

Line: 621

            SELECT plan_id
            FROM   qa_criteria_headers
            WHERE  criteria_id = x_criteria_id;

Line: 644

            SELECT description
            FROM   mtl_categories_kfv
            WHERE  category_id = x_category_id;

Line: 752

       SELECT vendor_site_id
       FROM   po_vendor_sites_all
       WHERE  vendor_site_code = p_vendor_site;

Line: 782

            SELECT project_id
            FROM   pjm_projects_v
            WHERE  project_number = p_project_number;

Line: 806

            SELECT task_id
            FROM   mtl_task_v
            WHERE  project_id = p_project_id
            AND    task_number = p_task_number;

Line: 836

          SELECT subinventory_code
          FROM   wms_license_plate_numbers
          WHERE  lpn_id = p_lpn_id;

Line: 863

          SELECT locator_id
          FROM   wms_license_plate_numbers
          WHERE  lpn_id = p_lpn_id;

Line: 885

        SELECT msikfv.concatenated_segments
        FROM mtl_system_items_b_kfv msikfv, mtl_parameters mp
        WHERE msikfv.organization_id = mp.organization_id
        and msikfv.eam_item_type in (1,3)
        and mp.maint_organization_id = o_id
        and msikfv.inventory_item_id = asset_group_id
        and rownum=1;

Line: 920

      SELECT meaning
      FROM   qa_lookups
      WHERE  lookup_type = p_lookup_type
      AND lookup_code = p_lookup_code;

Line: 947

     SELECT instance_number
        FROM CSI_ITEM_INSTANCES
      WHERE INSTANCE_id = p_asset_instance_number;