APPS.WMS_UTILITY_PVT SQL Statements

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

Line: 28

   select rtrim(ltrim(value)) from v$parameter
   where upper(name) = 'UTL_FILE_DIR';

Line: 143

SELECT MIN(mmt.transaction_id)
INTO l_transaction_id
FROM MTL_MATERIAL_TRANSACTIONS mmt, MTL_TRANSACTION_LOT_NUMBERS mtln
WHERE  mmt.transaction_id = mtln.transaction_id (+)
AND mmt.INVENTORY_ITEM_ID = p_inventory_item_id
AND NVL(mmt.revision, '@') = NVL(p_revision, '@')
AND NVL(mtln.lot_number, '@') = NVL(p_lot_number, '@')
AND NVL(mmt.cost_group_id, -99) = NVL(p_cost_group_id, -99)
AND (mmt.CONTENT_LPN_ID = p_parent_lpn_id OR
     mmt.TRANSFER_LPN_ID = p_parent_lpn_id)
AND NOT (mmt.TRANSACTION_ACTION_ID = 50 AND mmt.CONTENT_LPN_ID IS NOT NULL)
AND mmt.TRANSACTION_ACTION_ID <> 51
AND mmt.TRANSACTION_QUANTITY > 0;

Line: 172

FUNCTION GET_UPDATE_TRX_ID (
  p_inventory_item_id IN NUMBER
, p_revision IN VARCHAR2
, p_lot_number IN VARCHAR2
, p_cost_group_id IN NUMBER
, p_parent_lpn_id IN NUMBER )
RETURN NUMBER
IS
l_transaction_id NUMBER;

Line: 184

SELECT MAX(mmt.transaction_id)
INTO l_transaction_id
FROM MTL_MATERIAL_TRANSACTIONS mmt, MTL_TRANSACTION_LOT_NUMBERS mtln
WHERE  mmt.transaction_id = mtln.transaction_id (+)
AND mmt.INVENTORY_ITEM_ID = p_inventory_item_id
AND NVL(mmt.revision, '@') = NVL(p_revision, '@')
AND NVL(mtln.lot_number, '@') = NVL(p_lot_number, '@')
AND NVL(mmt.cost_group_id, -99) = NVL(p_cost_group_id, -99)
AND (mmt.LPN_ID = p_parent_lpn_id
     OR mmt.CONTENT_LPN_ID = p_parent_lpn_id
     OR mmt.TRANSFER_LPN_ID = p_parent_lpn_id)
AND NOT (mmt.TRANSACTION_ACTION_ID IN (50, 51) AND mmt.CONTENT_LPN_ID IS NOT NULL);

Line: 204

END GET_UPDATE_TRX_ID;