APPS.WMS_CONTAINER_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 9475: l_concatenated_segments mtl_system_items_b_kfv.concatenated_segments%TYPE;

9471: IS
9472: l_api_name CONSTANT VARCHAR2(30) := 'get_item_from_lpn';
9473: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9474: l_lpn_context NUMBER;
9475: l_concatenated_segments mtl_system_items_b_kfv.concatenated_segments%TYPE;
9476: BEGIN
9477:
9478: IF (l_debug = 1) THEN
9479: mdebug(' p_org : ' || p_org || ' p_lpn_id : ' || p_lpn_id || ' p_lpn_context : ' || p_lpn_context, G_INFO);

Line 9496: mtl_system_items_b_kfv msikfv

9492: IF l_lpn_context = 8 THEN
9493: SELECT msikfv.concatenated_segments
9494: INTO l_concatenated_segments
9495: FROM mtl_material_transactions_temp mmtt,
9496: mtl_system_items_b_kfv msikfv
9497: WHERE transfer_lpn_id IN
9498: (SELECT lpn_id
9499: FROM wms_license_plate_numbers
9500: START WITH lpn_id = p_lpn_id

Line 9511: mtl_system_items_b_kfv msikfv

9507: ELSE
9508: SELECT msikfv.concatenated_segments
9509: INTO l_concatenated_segments
9510: FROM WMS_LPN_CONTENTS wlc,
9511: mtl_system_items_b_kfv msikfv
9512: WHERE wlc.parent_lpn_id IN
9513: (SELECT lpn_id
9514: FROM wms_license_plate_numbers
9515: START WITH lpn_id = p_lpn_id