DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on MTL_SECONDARY_INVENTORIES

Line 3901: l_description mtl_secondary_inventories.description%TYPE;

3897: l_to_subinventory_code VARCHAR2(10);
3898: l_locator_type NUMBER;
3899: l_to_locator_id NUMBER;
3900: l_to_locator mtl_item_locations_kfv.concatenated_segments%TYPE;
3901: l_description mtl_secondary_inventories.description%TYPE;
3902: l_asset_inventory mtl_secondary_inventories.asset_inventory%TYPE;
3903: l_lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE;
3904: l_enable_locator_alias mtl_secondary_inventories.enable_locator_alias%TYPE;
3905:

Line 3902: l_asset_inventory mtl_secondary_inventories.asset_inventory%TYPE;

3898: l_locator_type NUMBER;
3899: l_to_locator_id NUMBER;
3900: l_to_locator mtl_item_locations_kfv.concatenated_segments%TYPE;
3901: l_description mtl_secondary_inventories.description%TYPE;
3902: l_asset_inventory mtl_secondary_inventories.asset_inventory%TYPE;
3903: l_lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE;
3904: l_enable_locator_alias mtl_secondary_inventories.enable_locator_alias%TYPE;
3905:
3906: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 3903: l_lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE;

3899: l_to_locator_id NUMBER;
3900: l_to_locator mtl_item_locations_kfv.concatenated_segments%TYPE;
3901: l_description mtl_secondary_inventories.description%TYPE;
3902: l_asset_inventory mtl_secondary_inventories.asset_inventory%TYPE;
3903: l_lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE;
3904: l_enable_locator_alias mtl_secondary_inventories.enable_locator_alias%TYPE;
3905:
3906: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3907: BEGIN

Line 3904: l_enable_locator_alias mtl_secondary_inventories.enable_locator_alias%TYPE;

3900: l_to_locator mtl_item_locations_kfv.concatenated_segments%TYPE;
3901: l_description mtl_secondary_inventories.description%TYPE;
3902: l_asset_inventory mtl_secondary_inventories.asset_inventory%TYPE;
3903: l_lpn_controlled_flag mtl_secondary_inventories.lpn_controlled_flag%TYPE;
3904: l_enable_locator_alias mtl_secondary_inventories.enable_locator_alias%TYPE;
3905:
3906: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3907: BEGIN
3908: x_serial_processed := 'NO'; -- No processing has been done