APPS.WMS_CYCLE_PVT SQL Statements

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

Line: 145

   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: 162

   SELECT mtl_cc_schedule_requests_s.NEXTVAL
     INTO l_cycle_count_schedule_id
     FROM dual;

Line: 169

  /* 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: 192

	   -- Insert a new record into MTL_CC_SCHEDULE_REQUESTS
	   IF (l_debug = 1) THEN
	      print_debug('Inserting into table MTL_CC_SCHEDULE_REQUESTS');

Line: 196

	   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, revision) -- BUG #2867331   --Bug8537999 Including Revision
	     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, p_revision);    --BUG#2867331   --Bug8537999 Including Revision

Line: 209

	   -- We need to commit this insert first before
	   -- we can call the concurrent programs
	   COMMIT;

Line: 248

  	   l_interface_rec.last_update_date      := SYSDATE;

Line: 249

	   l_interface_rec.last_updated_by       := MTL_CCEOI_VAR_PVT.G_UserID;

Line: 273

       SELECT COUNT(1)
          INTO l_count
          FROM MTL_CYCLE_COUNT_ENTRIES
         WHERE organization_id = p_organization_id
           AND subinventory = p_subinventory
           AND locator_id = p_locator_id
           AND inventory_item_id = p_inventory_item_id
           AND NVL(parent_lpn_id,-1) = NVL(p_lpn_id,-1)
           AND NVL(revision, '@') = NVL(p_revision, '@')
           AND entry_status_code IN (1,2,3)--Added 2 (Pending Approval) Bug# 13366585
           AND cycle_count_header_id = l_cycle_count_header_id;