APPS.WMS_EXPRESS_PICK_TASK SQL Statements

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

Line: 51

      SELECT TRANSACTION_TYPE_ID,
             TRANSACTION_SOURCE_TYPE_ID
      INTO   L_TRANSACTION_TYPE_ID,
             L_TRANSACTION_SOURCE_TYPE_ID
      FROM   MTL_MATERIAL_TRANSACTIONS_TEMP
      WHERE  TRANSACTION_TEMP_ID = P_TEMP_ID;

Line: 129

         SELECT 1
         INTO   L_DUMMY
         FROM   WMS_DISPATCHED_TASKS
         WHERE  PERSON_ID       = P_USER_ID
         AND    ORGANIZATION_ID = P_ORG_ID
         AND    TASK_TYPE IN (1, 3, 4)
         AND    STATUS <= 3
         AND    IS_EXPRESS_PICK_TASK(TASK_ID) = 'S'
         AND    ROWNUM < 2;

Line: 177

      SELECT IS_EXPRESS_PICK_TASK_ELIGIBLE(WDT.TRANSACTION_TEMP_ID)
      INTO   X_RETURN_STATUS
      FROM   WMS_DISPATCHED_TASKS WDT
      WHERE  WDT.TASK_ID = P_TASK_ID;

Line: 256

	 SELECT NVL(MSI.SERIAL_NUMBER_CONTROL_CODE,1),
	   NVL(MSI.LOT_CONTROL_CODE,1),
	   mmtt.allocated_lpn_id,
	   Nvl(sub.lpn_controlled_flag, 1),   -- bug 2675498
	   mmtt.inventory_item_id,
	   mmtt.subinventory_code,
	   mmtt.locator_id,
	   mmtt.organization_id
	   INTO   L_SERIAL_CODE,
	   L_LOT_CODE,
	   l_allocated_lpn_id,
	   l_sub_lpn_controlled_flag,   -- bug 2675498
	   l_inventory_item_id,
	   l_subinventory_code,
	   l_locator_id,
	   l_organization_id
	   FROM   MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
	   MTL_SYSTEM_ITEMS_B msi,
	   mtl_secondary_inventories sub   -- bug 2675498
	   WHERE  MMTT.TRANSACTION_TEMP_ID = P_TRANSACTION_TEMP_ID
	   AND    MMTT.ORGANIZATION_ID     = MSI.ORGANIZATION_ID
           AND    sub.ORGANIZATION_ID      = MSI.ORGANIZATION_ID -- Bug #2722444
	   AND    MMTT.INVENTORY_ITEM_ID   = MSI.inventory_item_id
	   AND    mmtt.subinventory_code = sub.secondary_inventory_name   -- bug 2675498
	   ;

Line: 325

            SELECT 1
            INTO   L_DUMMY
            FROM   MTL_TRANSACTION_LOTS_TEMP MTLT
            WHERE  MTLT.TRANSACTION_TEMP_ID = P_TRANSACTION_TEMP_ID;

Line: 347

         SELECT 1
         INTO   L_IS_BULK_PICK
         FROM   MTL_MATERIAL_TRANSACTIONS_TEMP
         WHERE  PARENT_LINE_ID =  P_TRANSACTION_TEMP_ID
         AND    ROWNUM < 2;

Line: 376

  SELECT
		MMTT.ORGANIZATION_ID,
		MMTT.INVENTORY_ITEM_ID,
		MSI.REVISION_QTY_CONTROL_CODE,
		MSI.LOT_CONTROL_CODE,
		MMTT.REVISION,
		MTLT.LOT_NUMBER,
		MMTT.TRANSACTION_QUANTITY,
		MMTT.TRANSACTION_UOM,
		MMTT.SUBINVENTORY_CODE,
		MMTT.LOCATOR_ID,
		MMTT.TRANSFER_SUBINVENTORY
	INTO	L_ORGANIZATION_ID,
		L_INVENTORY_ITEM_ID,
		L_REVISION_CONTROL_CODE,
		L_LOT_CONTROL_CODE,
		L_REVISION,
		L_LOT_NUMBER,
		L_TRANSACTION_QUANTITY,
		L_TRANSACTION_UOM,
		L_SUBINVENTORY_CODE,
		L_LOCATOR_ID,
		L_TRANSFER_SUBINVENTORY


	FROM   MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
		,MTL_SYSTEM_ITEMS_B MSI
		,MTL_TRANSACTION_LOTS_TEMP MTLT
	WHERE   MMTT.ORGANIZATION_ID      =  MSI.ORGANIZATION_ID
	AND 	MMTT.INVENTORY_ITEM_ID    =  MSI.INVENTORY_ITEM_ID
	AND 	MMTT.TRANSACTION_TEMP_ID  =   P_TRANSACTION_TEMP_ID
	AND     MMTT.TRANSACTION_TEMP_ID  =  MTLT.transaction_temp_id(+);

Line: 523

      L_MMTT_TO_UPDATE VARCHAR2(100) := '';

Line: 534

         SELECT LPN_ID
         INTO   L_LPN_ID
         FROM   WMS_LICENSE_PLATE_NUMBERS
         WHERE  LICENSE_PLATE_NUMBER = P_TO_LPN
         AND    ORGANIZATION_ID = P_ORG_ID;

Line: 681

    UPDATE mtl_material_transactions_temp
    SET    transfer_lpn_id = l_lpn_id,
           last_update_date = SYSDATE,
           last_updated_by = p_user_id
    WHERE transaction_temp_id = l_temp_id;

Line: 688

       mydebug('Updated MTTT row count: ' || SQL%ROWCOUNT);

Line: 692

    UPDATE wms_dispatched_tasks
    SET    status = 4,
           loaded_time = SYSDATE,
           last_update_date = SYSDATE,
           last_updated_by = p_user_id
    WHERE  transaction_temp_id = l_temp_id;

Line: 700

       mydebug('Updated WDT row count: ' || SQL%ROWCOUNT);

Line: 760

     SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
     INTO   L_TXN_HDR_ID
     FROM   DUAL;