DBA Data[Home] [Help]

APPS.INV_TRANSFER_ORDER_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 3592: FROM mtl_secondary_inventories

3588: ELSE
3589: -- Bug 9146725
3590: SELECT reservable_type
3591: INTO l_reservable_type
3592: FROM mtl_secondary_inventories
3593: WHERE organization_id = l_mmtt_rec.organization_id
3594: AND secondary_inventory_name = to_char(l_mmtt_rec.transfer_subinventory);
3595: g_is_sub_reservable(l_hash_value).reservable_type := l_reservable_type;
3596: g_is_sub_reservable(l_hash_value).org_id := l_mmtt_rec.organization_id;

Line 5707: FROM mtl_secondary_inventories

5703: l_reservable_type := g_is_sub_reservable(l_hash_value).reservable_type;
5704: ELSE
5705: SELECT reservable_type
5706: INTO l_reservable_type
5707: FROM mtl_secondary_inventories
5708: WHERE organization_id = l_mmtt_rec.organization_id
5709: AND secondary_inventory_name = l_mmtt_rec.transfer_subinventory;
5710: g_is_sub_reservable(l_hash_value).reservable_type := l_reservable_type;
5711: g_is_sub_reservable(l_hash_value).org_id := l_mmtt_rec.organization_id;