APPS.WMS_TASK_SKIPPED SQL Statements

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

Line: 11

   select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;

Line: 45

     l_last_updated_by   wms_dispatched_tasks.last_updated_by%TYPE;

Line: 63

   l_last_updated_by := FND_GLOBAL.user_id; ---*************** AFSCGBLS.pls

Line: 69

      mydebug('WMSSKIPB: value of last_ypdated_by '||  l_last_updated_by );

Line: 75

	SELECT wms_exceptions_s.NEXTVAL INTO l_sequence from dual;

Line: 83

        SELECT t.inventory_item_id, w.created_by
			INTO l_inventory_item_id, l_created_by
			FROM wms_dispatched_tasks w ,
				(SELECT mmtt.transaction_temp_id task_id,  mmtt.wms_task_type wms_task_type_id,
				mmtt.inventory_item_id
				FROM mtl_material_transactions_temp mmtt
            WHERE mmtt.transaction_temp_id =  l_task_id
			AND mmtt.wms_task_type IS NOT NULL AND mmtt.transaction_status = 2
        UNION ALL
            SELECT mcce.cycle_count_entry_id task_id, 3 wms_task_type_id,mcce.inventory_item_id
            FROM mtl_cycle_count_entries mcce
			WHERE mcce.cycle_count_entry_id=l_task_id
			AND entry_status_code IN (1,3)  AND NVL(export_flag, 2) = 2 ) t
			WHERE t.task_id =  l_task_id
			AND t.wms_task_type_id = p_wms_task_type
			AND t.task_id = w.transaction_temp_id
			AND t.wms_task_type_id = w.task_type;

Line: 112

			mydebug('Before inserting into WMS_exception');

Line: 115

	INSERT INTO wms_exceptions(
         TASK_ID,
         SEQUENCE_NUMBER,
         ORGANIZATION_ID,
         INVENTORY_ITEM_ID,
         PERSON_ID,
         EFFECTIVE_START_DATE,
         EFFECTIVE_END_DATE  ,
         DISCREPANCY_TYPE,
         LOT_NUMBER,
         LAST_UPDATE_DATE,
         LAST_UPDATED_BY,
         CREATION_DATE,
         created_by,
         wms_task_type
         )
     VALUES( l_task_id,
      l_sequence,
      l_org_id,
      l_inventory_item_id,
      l_emp_id,
      Sysdate,
      Sysdate,
      1,
      -999,
      Sysdate,
      l_last_updated_by,
      Sysdate,
      l_created_by,
      p_wms_task_type
      );

Line: 148

			mydebug('After inserting into WMS_exception');

Line: 153

			mydebug('Before  inserting into WMS_skip_task_exceptions');

Line: 156

   INSERT INTO wms_skip_task_exceptions(
     TASK_ID,
     SEQUENCE_NUMBER,
     ORGANIZATION_ID,
     INVENTORY_ITEM_ID,
     PERSON_ID,
     EFFECTIVE_START_DATE,
     EFFECTIVE_END_DATE  ,
     DISCREPANCY_TYPE,
     LOT_NUMBER,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     CREATION_DATE,
     created_by,
     wms_task_type
     )
     VALUES( l_task_id,
      l_sequence,
      l_org_id,
      l_inventory_item_id,
      l_emp_id,
      Sysdate,
      Sysdate,
      3,
      -999,
      Sysdate,
      l_last_updated_by,
      Sysdate,
      l_created_by,
      p_wms_task_type
      );

Line: 189

      mydebug('After  inserting into WMS_skip_task_exceptions');

Line: 194

   DELETE FROM wms_dispatched_tasks
		WHERE transaction_temp_id = l_task_id AND
		task_type = p_wms_task_type;

Line: 210

		select item_lot_control_code, item_serial_control_code, NVL(serial_allocated_flag , 'N')
		into l_lot_control_code, l_serial_control_code, l_serial_allocated_flag
		from mtl_material_transactions_temp
		where transaction_temp_id = l_task_id and organization_id = l_org_id;

Line: 215

		select serial_transaction_temp_id
		into l_serial_transaction_temp_id
		from mtl_transaction_lots_temp
		where transaction_temp_id = l_task_id;

Line: 233

            UPDATE  MTL_SERIAL_NUMBERS
            SET  group_mark_id   = null
                 ,last_update_date= SYSDATE
                 ,last_updated_by = l_last_updated_by
            WHERE serial_number IN
				(SELECT  serial_number
					FROM mtl_serial_numbers msn
						,mtl_serial_numbers_temp msnt
            WHERE  msn.serial_number = msnt.fm_serial_number
            AND  msnt.transaction_temp_id in (l_task_id, l_serial_transaction_temp_id))
			and current_organization_id = l_org_id;

Line: 251

				delete mtl_serial_numbers_temp
				where transaction_temp_id in (l_task_id, l_serial_transaction_temp_id);

Line: 256

					mydebug('wms_task_skipped:: No MSNT found to delete anything');