APPS.WMS_CYCLE_PVT SQL Statements

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

Line: 126

   SELECT unscheduled_count_entry
     INTO l_unscheduled_count_entry
     FROM mtl_cycle_count_headers
     WHERE cycle_count_header_id = l_cycle_count_header_id
     AND organization_id = p_organization_id;

Line: 143

   SELECT mtl_cc_schedule_requests_s.NEXTVAL
     INTO l_cycle_count_schedule_id
     FROM dual;

Line: 150

  /* Bug 5236299 - Selecting the zero count flag for the cycle count */

  SELECT NVL(zero_count_flag,2)
    INTO l_zero_count_flag
    FROM mtl_cycle_count_headers
   WHERE cycle_count_header_id = l_cycle_count_header_id
     AND organization_id = p_organization_id;

Line: 166

      print_debug('Inserting into table MTL_CC_SCHEDULE_REQUESTS');

Line: 168

   INSERT INTO MTL_CC_SCHEDULE_REQUESTS
     (cycle_count_schedule_id, last_update_date, last_updated_by,
      creation_date, created_by, cycle_count_header_id,
      request_source_type, zero_count_flag, schedule_date,
      schedule_status, subinventory, locator_id,
      inventory_item_id) -- BUG #2867331
     VALUES
     (l_cycle_count_schedule_id, SYSDATE, FND_GLOBAL.USER_ID,
      SYSDATE, FND_GLOBAL.USER_ID, l_cycle_count_header_id,
      2, l_zero_count_flag, SYSDATE, 1, --Bug 5236299- inserting the value of l_zero_count_flag
      p_subinventory, p_locator_id,
      p_inventory_item_id);    --BUG#2867331