APPS.PO_ITEMS_SV1 SQL Statements

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

Line: 21

   SELECT count(*)
     INTO x_temp
     FROM mtl_system_items
    WHERE inventory_item_id = x_item_id
      AND organization_id = x_organization_id
      AND enabled_flag = 'Y'
      AND purchasing_item_flag = 'Y'
      AND purchasing_enabled_flag = 'Y'
      AND outside_operation_flag = x_outside_operation_flag
      AND TRUNC(nvl(start_date_active, sysdate)) <= TRUNC(sysdate)
      AND TRUNC(nvl(end_date_active, sysdate)) >= TRUNC(sysdate);

Line: 68

      SELECT inventory_item_id
        INTO X_inventory_item_id_v
        FROM mtl_system_items_kfv
       WHERE concatenated_segments = X_item_number
         AND organization_id = X_organization_id;

Line: 78

         SELECT distinct b.item_id
           INTO X_inventory_item_id_v
           FROM po_headers a, po_lines b
          WHERE a.po_header_id = b.po_header_id
            AND b.vendor_product_num = X_vendor_product_num
            AND a.vendor_id = X_vendor_id
	    AND b.item_id is not NULL;