DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on MTL_SECONDARY_INVENTORIES

Line 3622: l_description mtl_secondary_inventories.description%TYPE;

3618: l_to_subinventory_code VARCHAR2(10);
3619: l_locator_type NUMBER;
3620: l_to_locator_id NUMBER;
3621: l_to_locator mtl_item_locations_kfv.concatenated_segments%TYPE;
3622: l_description mtl_secondary_inventories.description%TYPE;
3623: l_asset_inventory mtl_secondary_inventories.asset_inventory%TYPE;
3624: l_lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE;
3625: l_enable_locator_alias mtl_secondary_inventories.enable_locator_alias%TYPE;
3626:

Line 3623: l_asset_inventory mtl_secondary_inventories.asset_inventory%TYPE;

3619: l_locator_type NUMBER;
3620: l_to_locator_id NUMBER;
3621: l_to_locator mtl_item_locations_kfv.concatenated_segments%TYPE;
3622: l_description mtl_secondary_inventories.description%TYPE;
3623: l_asset_inventory mtl_secondary_inventories.asset_inventory%TYPE;
3624: l_lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE;
3625: l_enable_locator_alias mtl_secondary_inventories.enable_locator_alias%TYPE;
3626:
3627: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 3624: l_lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE;

3620: l_to_locator_id NUMBER;
3621: l_to_locator mtl_item_locations_kfv.concatenated_segments%TYPE;
3622: l_description mtl_secondary_inventories.description%TYPE;
3623: l_asset_inventory mtl_secondary_inventories.asset_inventory%TYPE;
3624: l_lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE;
3625: l_enable_locator_alias mtl_secondary_inventories.enable_locator_alias%TYPE;
3626:
3627: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3628: BEGIN

Line 3625: l_enable_locator_alias mtl_secondary_inventories.enable_locator_alias%TYPE;

3621: l_to_locator mtl_item_locations_kfv.concatenated_segments%TYPE;
3622: l_description mtl_secondary_inventories.description%TYPE;
3623: l_asset_inventory mtl_secondary_inventories.asset_inventory%TYPE;
3624: l_lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE;
3625: l_enable_locator_alias mtl_secondary_inventories.enable_locator_alias%TYPE;
3626:
3627: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3628: BEGIN
3629: x_serial_processed := 'NO'; -- No processing has been done